Java批量插入Oracle数据库数据的实现

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