mysql+json+ciud_Mybatis学习（二） - CRUD操作(增删改查操作)

packagecom.mybatis.service;importjava.util.List;importorg.apache.ibatis.session.SqlSession;importorg.apache.ibatis.session.SqlSessionFactory;importorg.junit.Test;importcom.mybatis.bean.User;importcom.mybatis.util.GetFactory;public classtest {

@Testpublic voidUnitTest_ADD(){

SqlSessionFactory factory=GetFactory.getFactory();

SqlSession session=factory.openSession();

String statment= "com.mybatis.bean.UserMapper.addUser";

User user= new User(-1,"新增",32);int insert =session.insert(statment,user);

session.commit();

session.close();

System.out.println(insert);

}

@Testpublic voidUnitTest_UPDATE(){

SqlSessionFactory factory=GetFactory.getFactory();

SqlSession session=factory.openSession();

String statment= "com.mybatis.bean.UserMapper.updateUser";

User user= new User(1,"更新",22);int insert =session.update(statment,user);

session.commit();

session.close();

System.out.println(insert);

}

@Testpublic voidUnitTest_DELETE(){

SqlSessionFactory factory=GetFactory.getFactory();

SqlSession session=factory.openSession();

String statment= "com.mybatis.bean.UserMapper.deleteUser";int delete = session.delete(statment, 2);

session.commit();

session.close();

System.out.println(delete);

}

@Testpublic voidUnitTest_SELECT_ALL(){

SqlSessionFactory factory=GetFactory.getFactory();

SqlSession session=factory.openSession();

String statment= "com.mybatis.bean.UserMapper.selectAllUsers";

List list=session.selectList(statment);

session.close();

System.out.println(list);

}

}