Mybatis 模糊查询

模糊查询

mapper

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

Mapper.xml

<!--模糊查询 方式一-->
    <select id="getUserLike" resultType="com.xiong.pojo.User">
        select * from user where name like #{value};
    </select>
<!--模糊查询 方式二-->
    <select id="getUserLike" resultType="com.xiong.pojo.User">
        select * from user where name like "%"#{value}"%";
    </select>

测试类

 //模糊查询
    @Test
    public void getUserLike(){
        SqlSession sqlSqlSession = MybatisUtils.getSqlSqlSession();
        UserMapper mapper = sqlSqlSession.getMapper(UserMapper.class);
    	 List<User> a = mapper.getUserLike("%张%");//方式一 与xml的方式一相对应
    	 List<User> a = mapper.getUserLike("张");//方式二与xml的方式二相对应
        for (User user:a)
            System.out.println(user);
        sqlSqlSession.close();
    }
}