cgb2107-第三阶段-day04-mybatis高级用法

1. Mybatis作业

1.1 模糊查询

1.1.1 编辑测试类

/*
        Mybatis作业:
            需求: 查询name中包含"精"的数据.并且按照年龄降序排列
     */
    @Test
    public void findLike(){
   
        SqlSession sqlSession = sqlSessionFactory.openSession(true);
        DemoUserMapper demoUserMapper = sqlSession.getMapper(DemoUserMapper.class);
        //String name = "精";
        String name = "%精%";
        List<DemoUser> list = demoUserMapper.findLike(name);
        System.out.println(list);
        sqlSession.close();
    }

1.1.2 编辑xml映射文件

 <!--关于模糊查询的说明: 使用%号需要使用""号包裹.
        注意事项: mybatis中的sql 最好小写. 因为不同的系统对于大小写 不敏感.
        键位:  eclipse    ctrl + shift + y  小写
                         ctrl + shift + u  大写/小写
      -->
    <select id="findLike" resultType="com.jt.pojo.DemoUser">
        <!--select * from demo_user where name like "%"#{name}"%" order by age desc -->
        select * from demo_user where name like #{name} order by age desc
    </select>

1.2 批量更新操作

1.2.1 编辑测试方法

/**
     * 作业2: 将name为小乔/大乔/王昭君的年龄改为18岁,性别女
     */
    @Test
    public void updateUser(){
   
        SqlSession sqlSession = sqlSessionFactory.openSession(true);
        DemoUserMapper demoUserMapper = sqlSession.getMapper(DemoUserMapper.class);
        Map<String,Object> map = new HashMap<>();
        String[] array = {
   "小乔","大乔","王昭君"};
        map.put("names",array);
        map.put("age",18);
        map.put("sex","女");
        demoUserMapper.updateUser(map);
        sqlSession.close();
    }

1.2.2 编辑xml映射文件

<!--批量更新操作-->
    <update id="updateUser">
        update demo_user set age = #{age},sex = #{sex}
        where name in (
            <foreach collection="names" item="name" separator=",">
                #{name}