Mybatis04——Map、模糊查询

一、map

    //添加用户
    int addUser2(Map<String,Object> map);

    <insert id="addUser2" parameterType="map" >
        insert into user (id,pwd) value (#{id},#{pwd})
    </insert>

    @Test
    public void test(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);

        HashMap<String, Object> map = new HashMap<>();
        map.put("id",5);
        map.put("pwd","123456");

        mapper.addUser2(map);

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

 

二、模糊查询

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

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

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

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

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


        for (User user : userList) {
            System.out.println(user);
        }
//        提交事务
//        sqlSession.commit();
        sqlSession.close();

<!--    模糊查询-->
    <select id="getUserLike" parameterType="String" resultType="com.jia.pojo.User">
        select * from user where name like "%"#{value}"%"
    </select>
<!--也可将%放入查询语句-->