SpringBootMybatis批量插入Oracle数据库数据

 {
     "shipId":"424",
     "shipName":"大唐2号",
     "ballastCabinData":["艏尖舱","双层底1左","双层底1右","双层底2左","双层底2右","双层底3左","双层底3右","双层底4左","双层底4右","双层底5左","双层底5右","顶边5左","顶边5右","尾尖舱"],
     "freshCabinData":["淡水舱1左","淡水舱1右"]
 }

 @PostMapping("/savecabin")
 public ajaxResult savecabin(@RequestBody Map<String,Object> postCabinData){
 ​
     // 获取map中的参数
     String shipIdStr = (String) postCabinData.get("shipId");
     Integer shipId = Integer.valueOf(shipIdStr);
     String shipName = (String) postCabinData.get("shipName");
     List<String> ballastCabinData = (List<String>) postCabinData.get("ballastCabinData");
     List<String> freshCabinData = (List<String>) postCabinData.get("freshCabinData");
 ​
     // 获取shipid下的所有的船舱记录
     List<DraftCabin> list = draftCabinService.selectCabinByShipId(shipId);
     // 船舱记录大于0时，执行批量删除；船舱
     if (list.size()>0){
         List<Long> idcards= list.stream().map(DraftCabin::getCabinId).collect(Collectors.toList());
         Long[] ids = idcards.toArray(new Long[idcards.size()]);
         draftCabinService.deleteDraftCabinByIds(ids);
     }
     // 批量插入船舱
     draftCabinService.insertDraftCabins(ballastCabinData,shipId,"压舱水",shipName);
     draftCabinService.insertDraftCabins(freshCabinData,shipId,"淡水",shipName);
 ​
     return AjaxResult.success();
 }

 public int insertDraftCabins(@Param("DraftCabin")List DraftCabin, @Param("shipId")Integer shipId, @Param("cabinType")String cabinType,@Param("shipName")String shipName) ;

 <!--批量新增-->
 <insert id="insertDraftCabins" useGeneratedKeys="false">
     INSERT ALL
     <foreach collection="DraftCabin" item="item" index="index">
         INTO draft_cabin
         (cabin_name,ship_id,cabin_type,ship_name)
         values(#{item},#{shipId},#{cabinType},#{shipName,jdbcType=VARCHAR})
     </foreach>
     SELECT 1 FROM DUAL
 </insert>

 insert all
     into <tableName>[(<table_column1>,<table_column2>...)] 
     values([<column_value1>,<column_value2>...]) 
     [into <tableName>[(<table_column1>,<table_column2>...)] 
     values([<column_value1>,<column_value2>...])]...
 select  <table_value1>[,<table_value2>...] from dual;