| @Insert({"<script>" + "<foreach collection=\"list\" item=\"item\" separator=\";\"> " + "INSERT INTO sc_water_month (\n" + "id,\n" + "section_name,\n" + "section_code,\n" + "province_name,\n" + "province_code,\n" + "city_name,\n" + "city_code,\n" + "basin_name,\n" + "river_name,\n" + "result,\n" + "analyse_item,\n" + "water_quality,\n" + "water_temperature,\n" + "ph,\n" + "dissolved_oxygen,\n" + "conductivity,\n" + "turbidity,\n" + "permanganate_index,\n" + "cod,\n" + "five_day_bod,\n" + "ammonia,\n" + "total_phosphorus,\n" + "total_nitrogen,\n" + "cu,\n" + "zn,\n" + "fluoride,\n" + "selenium,\n" + "arsenic,\n" + "hg,\n" + "cadmium,\n" + "hexavalent_chrome,\n" + "pb,\n" + "cyn,\n" + "volatile_phenol,\n" + "petroleum,\n" + "anion_active_agent,\n" + "sulphide,\n" + "data_time,\n" + "create_time,\n" + "update_time\n" + ")\n" + "VALUES\n" + "(#{item.id},\n" + "#{item.sectionName},\n" + "#{item.sectionCode},\n" + "#{item.provinceName},\n" + "#{item.provinceCode},\n" + "#{item.cityName},\n" + "#{item.cityCode},\n" + "#{item.basinName},\n" + "#{item.riverName},\n" + "#{item.result},\n" + "#{item.analyseItem},\n" + "#{item.waterQuality},\n" + "#{item.waterTemperature},\n" + "#{item.ph},\n" + "#{item.dissolvedOxygen},\n" + "#{item.conductivity},\n" + "#{item.turbidity},\n" + "#{item.permanganateIndex},\n" + "#{item.cod},\n" + "#{item.fiveDayBod},\n" + "#{item.ammonia},\n" + "#{item.totalPhosphorus},\n" + "#{item.totalNitrogen},\n" + "#{item.cu},\n" + "#{item.zn},\n" + "#{item.fluoride},\n" + "#{item.selenium},\n" + "#{item.arsenic},\n" + "#{item.hg},\n" + "#{item.cadmium},\n" + "#{item.hexavalentChrome},\n" + "#{item.pb},\n" + "#{item.cyn},\n" + "#{item.volatilePhenol},\n" + "#{item.petroleum},\n" + "#{item.anionActiveAgent},\n" + "#{item.sulphide},\n" + "#{item.dataTime},\n" + "#{item.createTime},\n" + "#{item.updateTime}\n" + " ) ON conflict (section_name, city_name, data_time) DO\n" + "UPDATE \n" + "SET \n" + "water_quality=#{item.waterQuality},\n" + "water_temperature=#{item.waterTemperature},\n" + "ph=#{item.ph},\n" + "dissolved_oxygen=#{item.dissolvedOxygen},\n" + "conductivity=#{item.conductivity},\n" + "turbidity=#{item.turbidity},\n" + "permanganate_index=#{item.permanganateIndex},\n" + "cod=#{item.cod},\n" + "five_day_bod=#{item.fiveDayBod},\n"+ "ammonia=#{item.ammonia},\n"+ "total_phosphorus=#{item.totalPhosphorus},\n" + "total_nitrogen=#{item.totalNitrogen},\n"+ "cu=#{item.cu},\n"+ "zn=#{item.zn},\n"+ "fluoride=#{item.fluoride},\n"+ "selenium=#{item.selenium},\n"+ "arsenic=#{item.arsenic},\n"+ "hg=#{item.hg},\n"+ "cadmium=#{item.cadmium},\n"+ "hexavalent_chrome=#{item.hexavalentChrome},\n"+ "pb=#{item.pb},\n"+ "cyn=#{item.cyn},\n"+ "volatile_phenol=#{item.volatilePhenol},\n"+ "petroleum=#{item.petroleum},\n"+ "anion_active_agent=#{item.anionActiveAgent},\n"+ "sulphide=#{item.sulphide},\n"+ "data_time=#{item.dataTime},\n"+ "create_time=#{item.createTime},\n"+ "update_time=#{item.updateTime}\n"+ "</foreach>" + "</script>"}) void insertOrUpdateBatch(@Param("list") List<ScWaterDO> list); |
/6 
|手机版|小黑屋|梦想之都-俊月星空
( 粤ICP备18056059号 )
GMT+8, 2025-2-22 05:26 , Processed in 0.025876 second(s), 18 queries .
Powered by Mxzdjyxk! X3.5
© 2001-2025 Discuz! Team.
