狂神说mybatis笔记及代码

package com.kuang.dao; import com.kuang.pojo.User; import com.kuang.utils.MybatisUtils; import org.apache.ibatis.session.SqlSession; import org.junit.Test; import java.util.HashMap; import java.util.List; import java.util.Map; public class UserDaoTest { @Test public void test() { //第一步：获取SqlSession对象 SqlSession sqlSession = MybatisUtils.getSqlSession(); //方式一：getMapper UserMapper userMapper = sqlSession.getMapper(UserMapper.class); List<User> userList = userMapper.getUserList(); //方式二： //List<User> userList = sqlSession.selectList("com.kuang.dao.UserDao.getUserList"); for (User user : userList) { System.out.println(user); } //关闭SQLSession sqlSession.close(); } @Test public void getUserLike(){ SqlSession sqlSession = MybatisUtils.getSqlSession(); UserMapper mapper = sqlSession.getMapper(UserMapper.class); List<User> userList=mapper.getUserLike("张"); for (User user : userList) { System.out.println(user); } sqlSession.close(); } @Test public void getUserById() { //第一步：获取SqlSession对象 SqlSession sqlSession = MybatisUtils.getSqlSession(); //获取接口 UserMapper mapper = sqlSession.getMapper(UserMapper.class); User userById = mapper.getUserById(1); System.out.println(userById); //关闭SQLSession sqlSession.close(); } @Test public void getUserByIdT() { SqlSession sqlSession = MybatisUtils.getSqlSession(); UserMapper mapper = sqlSession.getMapper(UserMapper.class); Map<String, Object> map = new HashMap<String, Object>(); map.put("id", 1); map.put("name", "狂神"); mapper.addUserT(map); sqlSession.close(); } @Test public void addUser() { //获取SqlSeesion对象 SqlSession sqlSession = MybatisUtils.getSqlSession(); //增删改需要提交事务 UserMapper mapper = sqlSession.getMapper(UserMapper.class); int res = mapper.addUser(new User(4, "haha", "1231412")); if (res > 0) { System.out.println("增加成功"); } sqlSession.commit(); sqlSession.close(); } @Test public void addUserT() { SqlSession sqlSession = MybatisUtils.getSqlSession(); UserMapper mapper = sqlSession.getMapper(UserMapper.class); Map<String, Object> map = new HashMap<String, Object>(); map.put("userid", 5); map.put("username", "hello"); map.put("password", "1231231"); mapper.addUserT(map); sqlSession.commit(); sqlSession.close(); } @Test public void updateUser() { //获取SqlSeesion对象 SqlSession sqlSession = MybatisUtils.getSqlSession(); //增删改需要提交事务 UserMapper mapper = sqlSession.getMapper(UserMapper.class); int res = mapper.updateUser(new User(4, "呵呵", "1231412")); if (res > 0) { System.out.println("修改成功"); } sqlSession.commit(); sqlSession.close(); } @Test public void deleteUser() { SqlSession sqlSession = MybatisUtils.getSqlSession(); UserMapper mapper = sqlSession.getMapper(UserMapper.class); mapper.deleteUser(4); sqlSession.commit(); sqlSession.close(); } }