mybatis项目CRUD步骤实例详解

第mybatis项目CRUD步骤实例详解7.编写测试类test，进行测试

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();

//执行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

//根据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("微服务如此简单");

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