mybatis的模糊查询

模糊查询
1、Java代码执行时，传递通配符% %

    @Test
    public void test6(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        List<User> uesrList = mapper.getUserLike("%李%");
        for (User user : uesrList) {
            System.out.println(user);
        }
        sqlSession.close();
    }

UserMapper.xml文件中sql语句的写法如下：

<mapper namespace="com.wen.dao.UserMapper">

<!--    模糊查询-->
    <select id="getUserLike" resultType="com.wen.pojo.User">
        select * from mybatis.user where name like #{value}
    </select>

 </mapper>

2、在sql拼接中使用通配符（防止sql注入）

 @Test
    public void test6(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        List<User> uesrList = mapper.getUserLike("%李%");
        for (User user : uesrList) {
            System.out.println(user);
        }
        sqlSession.close();
    }

UserMapper.xml文件中sql语句的写法如下：

<!--    模糊查询-->
    <select id="getUserLike" resultType="com.wen.pojo.User">
        select * from mybatis.user where name like "%"#{value}"%"
    </select>