mybatis练习3

mybatis练习3 万能Map

  //万能的Map
    int addUser2(Map map);

    
        insert into mybatis.user (id, name,pwd) values (#{id},#{name},#{pwd});
    

  @Test
    public void addUser2(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();

        UserMapper mapper = sqlSession.getMapper(UserMapper.class);


        Map map = new HashMap();

        map.put("id",5);
        map.put("name","王五");    
        map.put("pwd","2222333");

        mapper.addUser2(map);

        sqlSession.commit();
        sqlSession.close();
    }

Java代码执行的时候，传递通配符 % %

List userList = mapper.getUserLike("%李%");

在sql拼接中使用通配符

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