mybatis实现模糊查询

接口

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

UserMapper.xml

    
        select * from caijing where word like "%"#{value}"%"
    

测试类：

    @Test
    public void getCloudLike(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();

        UserDao mapper = sqlSession.getMapper(UserDao.class);

        List list = mapper.getUserLike("我");

        for (Cloud cloud : list) {
            System.out.println(cloud);
        }

        sqlSession.close();
    }

参数我也可写成%我%这样在sql中就不用写%了