4.Map和模糊查询

文章目录
         1.Map

         2.模糊查询

1.Map
当实体类的属性太多，不适合将属性列举，可用Map

<insert id="addUser2" parameterType="map">
   insert into mybatis.user (id, name, pwd) values (#{id1}, #{name1}, #{pwd1});
</insert>

int addUser2(Map<String, Object> map);

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

    UserMapper mapper = sqlSession.getMapper(UserMapper.class);
    Map<String, Object> map = new HashMap<String, Object>();
    map.put("id1",5);
    map.put("name1","dong");
    map.put("pwd1","12345");
    mapper.addUser2(map);

    //提交事务
    sqlSession.commit();
    sqlSession.close();
}

2.模糊查询
%模糊查询

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

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

    UserMapper mapper = sqlSession.getMapper(UserMapper.class);
    List<User> list = mapper.getUserLike("%o%");

    for(User user : list){
        System.out.println(user);
    }

    sqlSession.close();
}