批量插入

/**
     * 作者：zoutt
     * 日期：2018/8/22 18:57
     * 描述：5.3.5.6（新增）批量修改类目排序号controller层
     */
@RequestMapping(value = "batchEditCategorySorts.do",method = RequestMethod.POST)
    public Map<String, Object> batchEditCategorySorts(@RequestBody CategoryVO categoryVO){
        Map<String, Object> res = new HashMap<>();
        List<Category> categories = new ArrayList<>();
        List<List<Integer>> list = StringUtil.splitParam(categoryVO.getSorts(),2);
        if (list == null) {
            res.putAll(ResultStates.PARAM_ERROR.toMap());
            return res;
        }
        for (int i = 0; i < list.size(); i++) {
            Category category = new Category();
            // 取到id
            category.setCategoryId(list.get(i).get(0));
            if(list.get(i).get(1) <0){
                res.putAll(ResultStates.PARAM_ERROR.toMap());
                return res;
            }
            // 取到sort
            category.setSort(list.get(i).get(1));
            categories.add(category);
        }
        categoryService.batchEditSorts(categories);

        res.putAll(ResultStates.OPER_SUCESS.toMap());
        return res;
    }

service层

   int batchEditSorts(List<Category> categories);

serviceImpl

 @Override
    public int batchEditSorts(List<Category> categories) {
        return categoryMapper.batchEditSorts(categories);
    }

dao层

  int batchEditSorts(@Param("list") List<Category> categories);

xml文件 

  <update id="batchEditSorts" parameterType="java.util.List">
  update t_cc_category
    set sort =
  <foreach collection="list" item="item" index="index"
           separator=" " open="case category_id" close="end">
    when #{item.categoryId} then #{item.sort}
  </foreach>
  where category_id in
  <foreach collection="list" index="index" item="item"
           separator="," open="(" close=")">
    #{item.categoryId,jdbcType=INTEGER}
  </foreach>
</update>