Mybatis模糊查询

Mapper.xml中

对应的测试

在这里插入代码片@Test
    public void getUserListLike(){

        SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserDao mapper = sqlSession.getMapper(UserDao.class);
        List<User> list = mapper.getUserListLike("%李%");

        for (User user : list) {
            System.out.println(user);
        }

        sqlSession.close();
    }

   @Test
    public void getUserListLike01(){

       SqlSession sqlSession = MybatisUtils.getSqlSession();
       UserDao mapper = sqlSession.getMapper(UserDao.class);
       List<User> list = mapper.getUserListLike01("李");

       for (User user : list) {
           System.out.println(user);
       }

       sqlSession.close();
   }

第二种方式可以防止用户输入其他符号，固定用户输入格式

查询结构相同