使用mybatis动态添加或删除多个用户

批量删除数据

 <!--    批量删除-->
    <!--    int deleteMoreByArray(@Param("users") int[] user);-->
    <delete id="deleteMoreByArray">
        delete from sys_users where id in
        <foreach collection="ids" item="id" separator="," open="(" close=")">
            #{id}
        </foreach>
    </delete>

test

 @Test
    public void Test8(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        mapper.deleteMoreByArray(new Integer[]{5,6,7,8,9});

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

批量增加数据

 <!--    批量添加-->
<!--    int insertMoreUser(@Param("users")List<User> users);-->
    <insert id="insertMoreUser">
       insert into sys_users values
        <foreach collection="users" item="user" separator=",">
            (null,#{user.usersn},#{user.password},#{user.name},#{user.age},#{user.sex})
        </foreach>
    </insert>

test

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

        User user1 = new User(7,"1","2","3",null,"4",null);
        User user2 = new User(8,"1","2","3",null,"4",null);

        List<User> users = Arrays.asList(user1, user2);
        System.out.println(mapper.insertMoreUser(users));

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