代码顺序--------del---- update---one---select all
package db.test2; import java.util.List; importorg.Apache.ibatis.session.SQL session; importorg.Apache.ibatis.session.sqlsessionfactory; import org.junit.Test; import db.utils.MybatisUtils; import jdbc.bean.User; public class test2{ @ testpublicvoidtestadd () sqlsessionfactoryfactory=mybatisutils.getfactory ); sqlsessionsession=factory.open session (true; string statement=' db.test2. user mapper.insertuser '; int insert=session.insert (statement,newuser(-1,' newlx ',21 ) ); //session.commit (; system.out.println(insert: ) insert; }@Testpublic void testDel () sqlsessionfactoryfactory=mybatisutils.getfactory ); sqlsessionsession=factory.open session (true; string statement=' db.test2. user mapper.deleteuser '; int del=session.delete (statement,29 ); //session.commit (; system.out.println(del: ) del; }@Testpublic void testUpdate () sqlsessionfactoryfactory=mybatisutils.getfactory ); sqlsessionsession=factory.open session (true; string statement=' db.test2. user mapper.update user '; int update=session.update (statement,newuser(4,' change ',11 ) ); //session.commit (; system.out.println(update: ) update; }@Testpublic void testSelect () sqlsessionfactoryfactory=mybatisutils.getfactory ); sqlsessionsession=factory.open session (; string statement=' db.test2. user mapper.select user '; useruser=session.selectone (statement,2 ); system.out.println(one: ) user; }@Testpublic void testSelectAll () sqlsessionfactoryfactory=mybatisutils.getfactory ); sqlsessionsession=factory.open session (; string statement=' db.test2. user mapper.selextallusers '; 列表用户=session.select list (statement; system.out.println(all: ) user; }