mybatis批量插入

mapper

public interface EquipmentMapper extends BaseMapper<Equipment> {
    @Insert({
            "<script>",
            "INSERT INTO equipment (name, a3, v3, type_id)",
            "VALUES",
            "<foreach collection ='list' item='equipment' separator =','>",
            "(#{equipment.name}, #{equipment.a3}, #{equipment.v3}, #{equipment.typeId})",
            "</foreach>",
            "</script>"
    })
    int moreInsert(List<Equipment> equipment);
    @Update({
            "<script>",
            "<foreach collection='list' item='equipment' index='index' separator=';'>",
            "UPDATE equipment SET name = #{equipment.name},a3 = #{equipment.a3},v3 = #{equipment.v3},type_id = #{equipment.typeId} WHERE id = #{equipment.id}",
            "</foreach>",
            "</script>"
    })

    int moreUpdate(List<Equipment> equipment);


}

业务实现层调用

  @Override
    public CommonResult updateEquipmentMore(JSONArray jsonArray) {

        List<Equipment> list = JSONObject.parseArray(jsonArray.toJSONString(), Equipment.class);
        System.out.println(list);


        if(list.isEmpty()){
            throw new IllegalArgumentException("请添加设备信息");
        }else {
            if(list.get(0).getId()==0){
              int insert =  equipmentMapper.moreInsert(list);
                return insert == 0 ? CommonResult.failure("批量新增失败！") : CommonResult.success("批量新增成功！");
            }
            if(list.get(0).getId()>0){
                int update =  equipmentMapper.moreUpdate(list);
                return update == 0 ? CommonResult.failure("批量修改失败！") : CommonResult.success("批量修改成功！");
            }
        }

        return null;
    }

/**
 * 批量删除
 * @param 
 * @return
 */
@Delete({
        "<script>",
        "DELETE FROM equipment WHERE id IN",
        "<foreach collection='list' item='equipmentId' open='(' separator=',' close=')'>",
        "#{equipmentId}",
        "</foreach>",
        "</script>"
})
int moreDelete(List<string> equipmentId);

/**
 * 批量查询
 * @param 
 */
@Select({
        "<script>",
        "SELECT * FROM equipment ",
        "WHERE session_id in",
        "<foreach item='equipmentId' index='index' collection='list' open='(' separator=',' close=')'>",
        "#{equipmentId}",
        "</foreach>",
        "</script>"
})
public List<Equipment> moreSelect(List<String> equipmentId);