Mybatis中输入输出映射与动态Sql图文详解

package cn.mybatis.po;

public class UserPoJo extends User{
 private User user;

 public void setUser(User user) {
 this.user = user;
 }

 public User getUser() {
 return user;
 }
}

UserPOJO

package cn.mybatis.po;

public class UserVo {
 private UserPoJo userPoJo;

 public UserPoJo getUserPoJo() {
 return userPoJo;
 }

 public void setUserPoJo(UserPoJo userPoJo) {
 this.userPoJo = userPoJo;
 }
}

UserVo

//测试包装类型的查询
 public List findUserList(UserVo userVo) throws Exception;

@Test
 public void testFindUserList() throws Exception {
 SqlSession sqlSession = sqlSessionFactory.openSession();
 UserMapper userMapper = sqlSession.getMapper(UserMapper.class);

 UserPoJo userPoJo = new UserPoJo();
 UserVo userVo = new UserVo();
 userPoJo.setSex("男");
 userPoJo.setUsername("u");
 userVo.setUserPoJo(userPoJo);

 List userPoJoList = userMapper.findUserList(userVo);

 System.out.println(userPoJoList);
 }

SELECT COUNT(*) FROM t_user

SELECT username FROM t_user WHERE id = 2

<?xml version="1.0" encoding="UTF-8" ?>



 
 
 
 
 
 
 
 
 
 

 
 SELECT id _id, username _username, PASSWORD _password, address _address, sex _sex FROM t_user WHERE id = #{id}
 

 //测试resultMap
 public User findUserById_resultMap(int id) throws Exception;

@Test
 public void testFindUserById_resultMap() throws Exception {
 SqlSession sqlSession = sqlSessionFactory.openSession();
 UserMapper userMapper = sqlSession.getMapper(UserMapper.class);

 User user = userMapper.findUserById_resultMap(2);

 System.out.println(user);
 }

 SELECT * FROM t_user
 
  
  
   AND sex = #{userPoJo.sex}
  
  
   AND username LIKE '%${userPoJo.username}%'
  
  
 
 

 
 
  
  AND sex = #{userPoJo.sex}
  
  
  AND username LIKE '%${userPoJo.username}%'
  
 
 

 SELECT * FROM t_user
 
  
 
 

 
  
  
  id=#{item_id}
  
 
 

 
 SELECT * FROM t_user