| | |
| | | void batchadd2(List<MobilePosition> mobilePositions); |
| | | |
| | | @Insert("<script> " + |
| | | "<foreach collection='mobilePositions' index='index' item='item' separator=','> " + |
| | | "<foreach collection='mobilePositions' index='index' item='item' separator=';'> " + |
| | | "insert into wvp_device_mobile_position " + |
| | | "(device_id,channel_id, device_name,time,longitude,latitude,altitude,speed,direction,report_source," + |
| | | "longitude_gcj02,latitude_gcj02,longitude_wgs84,latitude_wgs84,create_time)"+ |
| | |
| | | "(#{item.deviceId}, #{item.channelId}, #{item.deviceName}, #{item.time}, #{item.longitude}, " + |
| | | "#{item.latitude}, #{item.altitude}, #{item.speed},#{item.direction}," + |
| | | "#{item.reportSource}, #{item.longitudeGcj02}, #{item.latitudeGcj02}, #{item.longitudeWgs84}, #{item.latitudeWgs84}, " + |
| | | "#{item.createTime}); " + |
| | | "#{item.createTime}) " + |
| | | "</foreach> " + |
| | | "</script>") |
| | | void batchadd(List<MobilePosition> mobilePositions); |