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

一、mybatis处理模糊查询

1、方式一

 <select id="selectLikeUser" resultType="com.cjc.mybatis.entity.User">
        select * from  t_user where username like '%${name}%'
    </select>

2、方式二

<select id="selectLikeUser" resultType="com.cjc.mybatis.entity.User">
        select * from  t_user where username like concat('%',#{name},'%')
    </select>

3、方式三（推荐使用）

User selectLikeUser(String name);

<select id="selectLikeUser" resultType="com.cjc.mybatis.entity.User">
        select * from  t_user where username like "%"#{name}"%"
    </select>

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