Posted on |

具体要求

  • 两张表 一张全量 一张开锁数据为1的不插入
  • 解析传过来的数据
  • 每100条数据插入两张表一次

插入

  • insert into category_all (latitude_, longitude_, time_,speed_,direction_,mileage_,vehicleId_,vehicleType_,vehicleNumber_,gpsDevicesNumber_,rawData_,stateValue_alarmValue_,companyCode_, vehicleCurrentStatus_)values(?,?,?,?,?,?,?,?,?,?,?,??,?,?);

insert into category_all (latitude_, longitude_, time_,speed_,direction_,mileage_,vehicleId_,vehicleType_,vehicleNumber_,gpsDevicesNumber_,rawData_,stateValue_alarmValue_,companyCode_, vehicleCurrentStatus_)values(0.1111,0.1111,null,0.1111,0.1111,0.1111,”121323”,1,”121323”,121323,121323,1,1,1,1);

latitude_ decimal(7,6) ,
longitude_ decimal(7,6),
time_ date,
speed_ decimal(3,2),
direction_ decimal(2,1),
mileage_ decimal(2,1),
vehicleId_ varchar(255) NOT NULL,
vehicleType_ int(4),
vehicleNumber_ varchar(255),
gpsDevicesNumber_ varchar(255),
rawData_ varchar(255),
stateValue_ int(32),
alarmValue_ int(32),
companyCode_ int(4),
vehicleCurrentStatus_ int(2),