Mybatis-lesson4-模糊查询 项目中会使用-2023-3-10

接口类

//模糊查询
 List <User> getUserLike(String value);

第二步：UserMapper.xml

<!--模糊查询-->
<select id="getUserLike" resultType="com.feijian.pojo.User">
    select * from mybatis.user where name like #{value}
</select>

第三步：测试 模糊查询 % %

//模糊查询
@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();
}