没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
try {
PreparedStatement stmt = conn.prepareStatement("insert into trafficinfotab_"
+ ConstantPool.mapCityCode.get(citycode).toLowerCase()
+ "(MsgNum,OppNum,OppTime,ItemStatus,OppType,OppID,CheckID,LocationText,EventSource,EventSourceText,"
+ "EventType,EventsType,EventCtrlType,EventCtrlsType,Severity,Remark,AffectLinks,StartLink,"
+ "StartName,StartCon,EndLink,EndName,EndCon,StartDistance,EndDistance,PassingRoad,"
+ "PassingRoadcon,TimeType,StartTime,EndTime) VALUES(?, ?, ?, ?, ? ,?, ?, ?, ?, ?, ?,"
+ " ?, ?, ?, ? ,?, ?, ?, ?, ?, ?, ?, ?, ?, ? ,?, ?, ?, ?, ?)");
for (int i = 0; i < listTrafficinfotab.size(); i++) {
Trafficinfotab trafficinfotab = listTrafficinfotab.get(i);
stmt.setString(1, trafficinfotab.getMsgNum()); // MsgNum
stmt.setInt(2, trafficinfotab.getOppNum()); // OppNum
stmt.setString(3, trafficinfotab.getOppTime()); // OppTime
stmt.setInt(4, trafficinfotab.getItemStatus()); // ItemStatus
stmt.setInt(5, trafficinfotab.getOppType()); // OppType
stmt.setString(6, trafficinfotab.getOppID()); // OppID
stmt.setString(7, trafficinfotab.getCheckID()); // CheckID
stmt.setString(8, trafficinfotab.getLocationText()); // LocationText
stmt.setInt(9, trafficinfotab.getEventSource()); // EventSource
stmt.setString(10, trafficinfotab.getEventSourceText()); // EventSourceText
stmt.setInt(11, trafficinfotab.getEventType()); // EventType
stmt.setInt(12, trafficinfotab.getEventsType()); // EventsType
stmt.setInt(13, trafficinfotab.getEventCtrlType()); // EventCtrlType
stmt.setInt(14, trafficinfotab.getEventCtrlsType()); // EventCtrlsType
stmt.setInt(15, trafficinfotab.getSeverity()); // Severity
stmt.setString(16, trafficinfotab.getRemark()); // Remark
stmt.setInt(17, trafficinfotab.getAffectLinks()); // AffectLinks
stmt.setString(18, trafficinfotab.getStartLink()); // StartLink
stmt.setString(19, trafficinfotab.getStartName()); // StartName
PreparedStatement stmt = conn.prepareStatement("insert into trafficinfotab_"
+ ConstantPool.mapCityCode.get(citycode).toLowerCase()
+ "(MsgNum,OppNum,OppTime,ItemStatus,OppType,OppID,CheckID,LocationText,EventSource,EventSourceText,"
+ "EventType,EventsType,EventCtrlType,EventCtrlsType,Severity,Remark,AffectLinks,StartLink,"
+ "StartName,StartCon,EndLink,EndName,EndCon,StartDistance,EndDistance,PassingRoad,"
+ "PassingRoadcon,TimeType,StartTime,EndTime) VALUES(?, ?, ?, ?, ? ,?, ?, ?, ?, ?, ?,"
+ " ?, ?, ?, ? ,?, ?, ?, ?, ?, ?, ?, ?, ?, ? ,?, ?, ?, ?, ?)");
for (int i = 0; i < listTrafficinfotab.size(); i++) {
Trafficinfotab trafficinfotab = listTrafficinfotab.get(i);
stmt.setString(1, trafficinfotab.getMsgNum()); // MsgNum
stmt.setInt(2, trafficinfotab.getOppNum()); // OppNum
stmt.setString(3, trafficinfotab.getOppTime()); // OppTime
stmt.setInt(4, trafficinfotab.getItemStatus()); // ItemStatus
stmt.setInt(5, trafficinfotab.getOppType()); // OppType
stmt.setString(6, trafficinfotab.getOppID()); // OppID
stmt.setString(7, trafficinfotab.getCheckID()); // CheckID
stmt.setString(8, trafficinfotab.getLocationText()); // LocationText
stmt.setInt(9, trafficinfotab.getEventSource()); // EventSource
stmt.setString(10, trafficinfotab.getEventSourceText()); // EventSourceText
stmt.setInt(11, trafficinfotab.getEventType()); // EventType
stmt.setInt(12, trafficinfotab.getEventsType()); // EventsType
stmt.setInt(13, trafficinfotab.getEventCtrlType()); // EventCtrlType
stmt.setInt(14, trafficinfotab.getEventCtrlsType()); // EventCtrlsType
stmt.setInt(15, trafficinfotab.getSeverity()); // Severity
stmt.setString(16, trafficinfotab.getRemark()); // Remark
stmt.setInt(17, trafficinfotab.getAffectLinks()); // AffectLinks
stmt.setString(18, trafficinfotab.getStartLink()); // StartLink
stmt.setString(19, trafficinfotab.getStartName()); // StartName
小安1111
- 粉丝: 3
- 资源: 25
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
- 1
- 2
前往页