第mybatis項(xiàng)目CRUD步驟實(shí)例詳解7.編寫測試類test，進(jìn)行測試

1.UserTest

packagecom.wyc.dao;

importcom.wyc.pojo.User;

importcom.wyc.utils.MybayisUtils;

importorg.apache.ibatis.session.SqlSession;

importorg.junit.Test;

importjava.util.HashMap;

importjava.util.List;

importjava.util.Map;

publicclassUserDaoTest{

@Test

//查詢所有用戶

publicvoidtest(){

//第一步：獲得SqlSession對象

SqlSessionsqlSession=MybayisUtils.getSqlSession();

//執(zhí)行sql方式一：getMapper

UserMappermapper=sqlSession.getMapper(UserMapper.class);

ListUseruserList=mapper.getUserList();

for(Useruser:userList){

System.out.println(user);

@Test

publicvoidtestlike(){

SqlSessionsqlSession=MybayisUtils.getSqlSession();

UserMappermapper=sqlSession.getMapper(UserMapper.class);

ListUseruserLike=mapper.getUserLike("zhang%");//%最好在sql中拼接

for(Useruser:userLike){

System.out.println("______________________");

System.out.println(user);

@Test

//根據(jù)id查詢

publicvoidtest1(){

SqlSessionsqlSession=MybayisUtils.getSqlSession();

UserMappermapper=sqlSession.getMapper(UserMapper.class);

UseruserById=mapper.getUserById(1);

System.out.println(userById);

@Test

//添加用戶增刪改查需要提交事物

publicvoidtest2(){

SqlSessionsqlSession=MybayisUtils.getSqlSession();

UserMappermapper=sqlSession.getMapper(UserMapper.class);

intaddUser=mapper.addUser(newUser(5,"HH","123"));

sqlSmit();

@Test

publicvoidadd(){

SqlSessionsqlSession=MybayisUtils.getSqlSession();

UserMappermapper=sqlSession.getMapper(UserMapper.class);

MapString,Objectmap=newHashMapString,Object

map.put("userid",7);

map.put("username","zhangsan");

mapper.addUser2(map);

sqlSmit();

@Test

//修改用戶

publicvoidtest3(){

SqlSessionsqlSession=MybayisUtils.getSqlSession();

UserMappermapper=sqlSession.getMapper(UserMapper.class);

intupdate=mapper.update(newUser(3,"rr","1234"));

sqlSmit();

@Test

//刪除用戶

publicvoidtest4(){

SqlSessionsqlSession=MybayisUtils.getSqlSession();

UserMappermapper=sqlSession.getMapper(UserMapper.class);

intuser=mapper.deleteUser(2);

sqlSmit();

2.BlogTest

importcom.wyc.dao.BlogMapper;

importcom.wyc.dao.UserMapper;

importcom.wyc.pojo.Blog;

importcom.wyc.pojo.User;

importcom.wyc.utils.IDutils;

importcom.wyc.utils.MybayisUtils;

importorg.apache.ibatis.session.SqlSession;

importorg.junit.Test;

importjava.util.ArrayList;

importjava.util.Date;

importjava.util.HashMap;

importjava.util.List;

publicclassMyTest{

@Test

publicvoidtest(){

SqlSessionsqlSession=MybayisUtils.getSqlSession();

BlogMappermapper=sqlSession.getMapper(BlogMapper.class);

Blogblog=newBlog();

blog.setId(IDutils.getId());

blog.setTitle("mybatis如此簡單");

blog.setAuthor("狂神說");

blog.setCreateTime(newDate());

blog.setViews(9999);

mapper.addBlog(blog);

blog.setId(IDutils.getId());

blog.setTitle("java如此簡單");

mapper.addBlog(blog);

blog.setId(IDutils.getId());

blog.setTitle("spring如此簡單");

mapper.addBlog(blog);

blog.setId(IDutils.getId());

blog.setTitle("微服務(wù)如此簡單");

mapper.addBlog(blog);

sqlSmit();

@Test

publicvoidtest2(){

SqlSessionsqlSession=MybayisUtils.getSqlSession();

BlogMappermapper=sqlSession.getMapper(BlogMapper.class);

HashMapmap=newHashMap();

map.put("author","狂神說");

ListBlogblogs=mapper.queryBlogIf(map);

for(Blogblog:blogs){

System.out.println(blog);

@Test

publicvoidtest3(){

SqlSessionsqlSession=MybayisUtils.getSqlSession();

BlogMappermapper=sqlSession.getMapper(BlogMapper.class);

HashMapmap=newHashMap();

map.put("views",9999);

ListBlogblogs=mapper.queryBlogChoose(map);

for(Blogblog:blogs){

System.out.println(blog);

@Test

publicvoidtest4(){

SqlSessionsqlSession=MybayisUtils.getSqlSession();

BlogMappermapper=sqlSession.getMapper(BlogMapper.class);

HashMapmap=newHashMap();

//map.put("views",9999);

map.put("id","aaee3fee53d041ef93f51ff42d432d");

map.put("author","超哥說");

map.put("title","編程如此簡單");

mapper.updateBlog(map);

sqlSmit();

@Test

publicvoidtest5(){

SqlSessionsqlSession=MybayisUtils.getSqlSession();

BlogMappermapper=sqlSession.getMapper(BlogMapper.class);

HashMapmap=newHashMap();

ArrayListIntegerids=newArrayListInteger

ids.add(1);

map.put("ids",ids);

ListBlogblogs=mapper.queryBlogForeach(map);

for(Blogblog:blogs){

System.out.println(blog);

sqlSmit();

@Test

publicvoidqueryUserById(){

SqlSessionsqlSession=MybayisUtils.getSqlSession();

SqlSessionsqlSession2=MybayisUtils.getSqlSession();

UserMappermapper=sqlSession.ge