Java学习 --- mybatis处理模糊查询的三种方式

 
        select * from  t_user where username like '%${name}%'
    

        select * from  t_user where username like concat('%',#{name},'%')
     
3、方式三（推荐使用） 
User selectLikeUser(String name);
 

        select * from  t_user where username like "%"#{name}"%"
    

@Test
    public void test15() {
        SqlSession sqlSession = SqlSessionUtils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        User user = mapper.selectLikeUser("小");
        System.out.println("user = " + user);
    }