java oracle 执行语句_Java批量插入Oracle语句执行过程。

public String insertContractReal(String contractID, List cashIds) {

Connection conn = null;

PreparedStatement pstmt = null;

ResultSet rs = null;

try {

conn = this.loadNewConnection();

StringBuffer bufSql = new StringBuffer();

String sql = "";

bufSql.append(" insert into T_CASH_RELA t ");

bufSql.append(" (C_CONTRACT_ID,C_CASH_ID) ");

bufSql.append(" values(?,?) ");

sql = bufSql.toString();

pstmt = conn.prepareStatement(sql);

for (int i = 0; i < cashIds.size(); i++) {

pstmt.setString(1, contractID);

pstmt.setString(2, cashIds.get(i));

// 把一个SQL命令加入命令列表

pstmt.addBatch();

}

pstmt.executeBatch();

conn.setAutoCommit(true);

} catch (SQLException ex) {

ex.printStackTrace();

throw new DataAccessException("更新失败：" + ex.getMessage(), ex);

} finally {

closeResultSetFinal(rs);

closeStatementFinal(pstmt);

releaseConnection(conn);

}

return "";

}