模糊查询

1. Dao接口；

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

2. 接口实现类(由原来的UserDaoImpl转变为一个Mapper.xml配置文件)；

   <select id="getUserLike" resultType="com.beyond.pojo.User">
           select * from user where name like #{value}
       </select>
   

3. 测试

   @Test
       public void getUserLike(){
           //1、获得SqlSession对象
           SqlSession sqlSession= MyBatisUtil.getSqlSession();
           //2、执行SQL
           UserDao userDao=sqlSession.getMapper(UserDao.class);
   
           List<User> userList=userDao.getUserLike("%李%");
           for (User user:userList) {
               System.out.println(user);
           }
           //关闭SqlSession
           sqlSession.close();
       }