oracle JDBC使用例子

Connection orcDbConn = getOracleConnect();orcDbConn.setAutoCommit(false);PreparedStatement statement =orcDbConn.prepareStatement("INSERT INTO INVITEKEYTMP SELECT I.ID FROM INVITE I WHERE I.REBATE_STATE ='0' and INVITE_TIME>=TO_DATE(?,'yyyy-MM-dd') ");statement.setQueryTimeout(QUERY_TIMEOUT);statement.execute();orcDbConn.commit();<span style="font-family: Arial, Helvetica, sans-serif;">statement.close();</span><span style="white-space:pre"></span>orcDbConn.close();

public Connection getOracleConnect() throws Exception {Connection orcDbConn = null;try {// 初始化驱动包Class.forName(proCon.getProperty("driverClass"));// 根据数据库连接字符，名称，密码给conn赋值orcDbConn = DriverManager.getConnection(proCon.getProperty("jdbcUrl"), proCon.getProperty("user"), proCon.getProperty("password"));} catch (Exception ex) {throw ex;}return orcDbConn;}