Mybatis-多条件查询

Mybatis-多条件查询

例如现在有一个需求是根据id和user那么查询user表

方式一：

使用 #{arg0}-#{argn} 或者 #{param1}-#{paramn} 获取参数
UserMapper接口

public interface UserMapper {
  public List<User> findByIdAndUsername1(Integer id, String username);
 
}

UserMapper.xml

<mapper namespace="com.lagou.mapper.UserMapper">
 
  <select id="findByIdAndUsername1" resultType="user">
   <!-- select * from user where id = #{arg0} and username = #{arg1} -->
   select * from user where id = #{param1} and username = #{param2}
  </select>
 
</mapper>

测试

@Test
public void testFindByIdAndUsername() throws Exception {
  UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
  List<User> list = userMapper.findByIdAndUsername1(1 , "fff");
  System.out.println(list);
}

方式二：

使用注解，引入 @Param() 注解获取参数
UserMapper接口

public interface UserMapper {
  public List<User> findByIdAndUsername2(@Param("id") Integer id,@Param("username") String username);
 
}

UserMapper.xml

<mapper namespace="com.lagou.mapper.UserMapper">
 
  <select id="findByIdAndUsername2" resultType="user">
   select * from user where id = #{id} and username = #{username}
  </select>
 
</mapper>

测试

@Test
public void testFindByIdAndUsername() throws Exception {
  UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
  List<User> list = userMapper.findByIdAndUsername2(1, "fff");
  System.out.println(list);
}

方式三（常用）：

使用pojo对象传递参数
UserMapper接口

public interface UserMapper {
  public List<User> findByIdAndUsername3(User user);
 
}

UserMapper.xml

<mapper namespace="com.lagou.mapper.UserMapper">
 
  <select id="findByIdAndUsername3" parameterType="com.lagou.domain.User"
resultType="com.lagou.domain.User">
   select * from user where id = #{id} and username = #{username}
  </select>
 
</mapper>

测试

@Test
public void testFindByIdAndUsername() throws Exception {
  UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
  User param = new User();
  param.setId(1);
  param.setUsername("子慕");
  List<User> list = userMapper.findByIdAndUsername3(param);
  System.out.println(list);
 
}