Java批量插入Oracle语句执行过程。

	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 "";
	}