5、模糊查询拓展

模糊查询怎么写？
传送门：MySQL的模糊查询
在Java代码查询执行的时候，传递通配符% %

接口类

public interface UserMapper {
    //模糊查询一个用户
    List<User> getUserLike(String value);
}

接口实现类

 <!--模糊查询用户信息-->
    <select id="getUserLike" resultType="xleixz.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
        sqlSession.close();
    }