批量插入数据

package importDate;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

public class Test2 {
public static void main(String[] args) {
String url = "jdbc:oracle:thin:@10.71.181.25:1521:omsdb";
String username = "system";
String password = "i2000db";
Connection con = null;
PreparedStatement ps = null;

try {
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection(url, username, password);
con.setAutoCommit(false);
String sql =
"insert into OMSFM.HISTORICAL_ALARM201012 (ALARMSN, COUNTER, CLEARED, CLEARUSER, ACKED, ACKUSER, ACKTIME, LATESTLOGTIME, LATESTLOGSN, CLEAREDTIME, CLEAREDTYPE, CLEAREDCLASS, SEVERITYCHANGEDTIME, MODN, NEDN, SOURCE, OBJECTINSTANCE, OBJECTCLASS, NETYPE, MOVERSION, NEVERSION, DEVCSN, NOTIFICATIONID, EVENTTIME, ARRIVEDTIME, EVENTTYPE, ALARMID, ALARMNAME, PERCEIVEDSEVERITY, PROBABLECAUSE, DETAILEDINFORMATION, PROPOSEDREPAIRACTIONS, BACKEDUPSTATUS, SERVICEAFFECTINGINDICATOR, ROOTCASEALARMINDICATOR, THRESHOLDINFO, ROOTCASEALARMSN, ADDITIONALTEXT, ADDITIONALINFORMATION, USERDATA) values ("
+ "?, ?, ?, ?, ?, ?, ?, ?, ?, ?, "
+ "?, ?, ?, ?, ?, ?, ?, ?, ?, ?"
+ ", ?, ?, ?, ?, ?, ?, ?, ?, ?, ?"
+ ", ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";

ps = con.prepareStatement(sql);
for (int i = 1; i < 500001; i++) {
ps.setInt(1, i);
ps.setInt(2, 2);
ps.setInt(3, 1);
ps.setString(4, "admin");
ps.setInt(5, 1);
ps.setString(6, "admin");

ps.setLong(7, 1298600949000L);
ps.setLong(8, 1293617411000L);
ps.setInt(9, 4);
ps.setLong(10, 1298600960000L);
ps.setInt(11, 1);
ps.setInt(12, 3);

ps.setString(13, "");
ps.setString(14, "NE=1297766824934");
ps.setString(15, "NE=1297766824934");
ps.setString(16, "Agent:SNMP=1297766824935");
ps.setString(17, "objectInstance=Welluxe, moduleId=0");

ps.setString(18, "fmtest.mmsc");
ps.setString(19, "fmtest.mmsc");
ps.setString(20, "(zero-length)");
ps.setString(21, "(zero-length)");

ps.setInt(22, 1008);
ps.setString(23, "");

ps.setLong(24, 1293617411000L);
ps.setLong(25, 1298599680854L);
ps.setInt(26, 1);
ps.setInt(27, 1000);
ps.setString(28, "fmtest-mmsc");

ps.setInt(29, 1);
ps.setInt(30, 17);

ps.setString(31, "");
ps.setString(32, "");

ps.setInt(33, 3);
ps.setInt(34, 3);
ps.setInt(35, 3);

ps.setString(36, "");
ps.setString(37, "");
ps.setString(38, "");

ps.setString(39, "");
ps.setString(40, "");
ps.addBatch();
if (i % 10000 == 0) {
ps.executeBatch();
ps.clearBatch();
}

}

con.setAutoCommit(true);
ps.close();
con.close();

} catch (Exception e) {
e.printStackTrace();
}

}

}