第一种

接口方法

//根据map查询用户
    List getUserByID2(Map map);

编写Mapper.xml配置

 
    
        select * from user where name like #{name}
    

实现

   public void getUserByID2(){
        SqlSession sqlSession = sqlSessionFactory.getsqlSession();
        userMapper mapper = sqlSession.getMapper(userMapper.class);
        Map map = new HashMap<>();
        map.put("name","%李%");
        List userByID2 = mapper.getUserByID2(map);
        for (User user : userByID2) {
            System.out.println(user);
        }
        sqlSession.close();
    }

第二种

接口方法

//根据map查询用户
    List getUserByID2(Map map);

编写Mapper.xml配置

 
    
        select * from user where name like "%" #{name} "%"
    

实现

   public void getUserByID2(){
        SqlSession sqlSession = sqlSessionFactory.getsqlSession();
        userMapper mapper = sqlSession.getMapper(userMapper.class);
        Map map = new HashMap<>();
        map.put("name","李");
        List userByID2 = mapper.getUserByID2(map);
        for (User user : userByID2) {
            System.out.println(user);
        }
        sqlSession.close();
    }

一种是在编写参数时，加入%%，另一种是在Mapper.xml中拼接%%