Test2.java
PackageCom.mycom.mybatis_1.crud;Importjava.util.List;Importorg.apache.ibatis.session.SqlSession;Importorg.apache.ibatis.session.SqlSessionFactory;Importorg.junit.Test;ImportCom.mycom.mybatis_1.bean. User;ImportCom.mycom.mybatis_1.util. Mybatisutils; Public classTest2 {@Test Public voidTestadd () {Sqlsessionfactory factory=mybatisutils.getfactory (); //The default is manually submittedsqlsession session =factory.opensession (); String Statement= "Com.mycom.mybatis_1.bean.userMapper.addUser"; intINS = Session.insert (statement,NewUser ( -1, "KK", 23, "male"))); //SubmitSession.commit (); Session.close (); SYSTEM.OUT.PRINTLN (INS); } @Test Public voidtestupd () {Sqlsessionfactory factory=mybatisutils.getfactory (); //The default is manually submitted//sqlsession session = Factory.opensession ();// //String statement = "Com.mycom.mybatis_1.bean.userMapper.updUser";//int ins = session.update (statement, New User (4, "KK444", +));// //Submit//Session.commit (); //default is auto-commitsqlsession session = Factory.opensession (true); String Statement= "Com.mycom.mybatis_1.bean.userMapper.updUser"; intUPD = session.update (statement,NewUser (4, "KK444", 28, "male"))); Session.close (); System.out.println (UPD); } @Test Public voidTestdel () {Sqlsessionfactory factory=mybatisutils.getfactory (); //default is auto-commitsqlsession session = Factory.opensession (true); String Statement= "Com.mycom.mybatis_1.bean.userMapper.delUser"; intdel = session.delete (statement, 4); Session.close (); System.out.println (DEL); } @Test Public voidTestgetuser () {Sqlsessionfactory factory=mybatisutils.getfactory (); //default is auto-commitsqlsession session = Factory.opensession (true); String Statement= "Com.mycom.mybatis_1.bean.userMapper.getUser"; User User= Session.selectone (statement, 1); Session.close (); SYSTEM.OUT.PRINTLN (user); } @Test Public voidTestgetall () {Sqlsessionfactory factory=mybatisutils.getfactory (); //default is auto-commitsqlsession session = Factory.opensession (true); String Statement= "Com.mycom.mybatis_1.bean.userMapper.getAllUsers"; List<User> list =session.selectlist (statement); Session.close (); SYSTEM.OUT.PRINTLN (list); }}
mybatisutils. java
PackageCom.mycom.mybatis_1.util;ImportJava.io.InputStream;Importorg.apache.ibatis.session.SqlSessionFactory;ImportOrg.apache.ibatis.session.SqlSessionFactoryBuilder;ImportCom.mycom.mybatis_1.select. Test1; Public classMybatisutils { Public Staticsqlsessionfactory getfactory () {String resource= "Conf.xml"; InputStream is= Test1.class. getClassLoader (). getResourceAsStream (Resource); Sqlsessionfactory Factory=NewSqlsessionfactorybuilder (). Build (IS); returnFactory; }}
MyBatis CRUD Operations