Connection conn = getConnection();
conn.setAutoCommit(false);
PreparedStatement ps = null;
//String SQL = "INSERT INTO "+TableName +"( ID,";
//String sColumn0 = this.getColumnName(TableId, "专业基础库ID");
//SQL = SQL+sColumn0+",";
//String sColumn1 = this.getColumnName(TableId, "型号基础库ID");
//SQL = SQL+sColumn1+",";
//String sColumn2 = this.getColumnName(TableId, "用户基础库ID");
//SQL = SQL+sColumn2+") VALUES(SEQ_"+TableName+".nextval,?,?,?)";
String SQL=insertSQL+" VALUES( SEQ_"+TableName+".nextval,?,?,?)";
ps = conn.prepareStatement(SQL);
RelationInfo info;
for(int i=0;i<baseRelationList.size();i++)
{
info = baseRelationList.get(i);
ps.setString(1, info.getProfessionBaseId());
ps.setString(2, info.getRocketBaseId());
ps.setString(3, info.getPersonBaseId());
ps.addBatch();
if(i % 10000 == 0)
{
ps.executeBatch();
}
}
ps.executeBatch();
conn.commit();
conn.setAutoCommit(false);
PreparedStatement ps = null;
//String SQL = "INSERT INTO "+TableName +"( ID,";
//String sColumn0 = this.getColumnName(TableId, "专业基础库ID");
//SQL = SQL+sColumn0+",";
//String sColumn1 = this.getColumnName(TableId, "型号基础库ID");
//SQL = SQL+sColumn1+",";
//String sColumn2 = this.getColumnName(TableId, "用户基础库ID");
//SQL = SQL+sColumn2+") VALUES(SEQ_"+TableName+".nextval,?,?,?)";
String SQL=insertSQL+" VALUES( SEQ_"+TableName+".nextval,?,?,?)";
ps = conn.prepareStatement(SQL);
RelationInfo info;
for(int i=0;i<baseRelationList.size();i++)
{
info = baseRelationList.get(i);
ps.setString(1, info.getProfessionBaseId());
ps.setString(2, info.getRocketBaseId());
ps.setString(3, info.getPersonBaseId());
ps.addBatch();
if(i % 10000 == 0)
{
ps.executeBatch();
}
}
ps.executeBatch();
conn.commit();