@Insert("<script>"
+ "insert into file_device (mission_id,device_id,file_id) VALUES "
+ "<foreach collection='list' item='item' index='index' separator=',' >"
+ "<foreach collection='item.file' item='itemId' index='index' separator=','>"
+ "(#{mission_id},#{item.device_id},#{itemId}) "
+ "</foreach>"
+ "</foreach>"
+ "</script>")
int insertFileDevice(@Param("list")List<DeviceParam2> device,@Param("mission_id") Integer mid);
@Update("<script>"
+ "<foreach collection='list' item='item' index='index' separator=';' >"
+ "<foreach collection='item.file' item='itemId' index='index' separator=';'>" +
"update files_info set status=1 where id=#{itemId}"
+ "</foreach>"
+ "</foreach>"
+ "</script>")
int setStatusByList(@Param("list") List<DeviceParam2> list,Integer status);