public String insertContractReal(String contractID, List<String> 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 "";
}
Java批量插入Oracle语句执行过程。
最新推荐文章于 2023-10-26 10:01:24 发布