模糊查询
思考:模糊查询该怎么写?
- 在接口中写一个方法
//模糊查询
List<User> getUserLike(String value);
//Map查询用户
- 接口
<!--模糊查询-->
<select id="getUserLike" resultType="com.cloud.pojo.User">
select * from mybatis.user where name like #{value};
</select>
- 测试
//模糊查询
@Test
public void UserList2(){
SqlSession sqlSession = MybatisUtils.getSqlSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
List<User> userLike = mapper.getUserLike("%赵%");
for (User user : userLike) {
System.out.println(user);
}
sqlSession.close();
}
- Java代码执行的是惠普,传递通配符%%
List<User> userLike = mapper.getUserLike("%赵%");
- 在sql拼接中使用通配符!
select * from mybatis.user where name like "%#{value}%";