JDBC应用程序连接数据库–插入数据并且获得相应自增长值的列（即主键id）

public int saveRegInfo(String salutation, String name, String mobile,
			String email, String address, String offer, String tncAgree)
			throws SQLException {
		int orderId=-1;
		try {
			getConnection();
			int i = 0;
			

			String sql="INSERT INTO GROUPBUYING(id,CRTE_DATE,SALUTATION,CUST_NAME,CONTACT_NO,EMAIL,ADDRESS,SERVER_TYPE,IS_ACCEPT) "
					+ "VALUES (SEQ_GROUPBUYING_ID.nextval, SYSDATE, ?,gen_encr(?), gen_encr(?), gen_encr(?),gen_encr(?), ?,?)";

      stmt = conn.prepareStatement(sql,new String[]{"id"});
			stmt.setString(++i, salutation);
			stmt.setString(++i, name);
			stmt.setString(++i, mobile);
			stmt.setString(++i, email);
			stmt.setString(++i, address);
			stmt.setString(++i, offer);
			stmt.setString(++i, tncAgree);

			int excuteResult=stmt.executeUpdate() ;
			if (excuteResult> 0) {
				
				ResultSet generatedKeys = stmt.getGeneratedKeys();

			    // if resultset has data, get the primary key value
			    // of last inserted record
			    if (null != generatedKeys && generatedKeys.next()) {

			        // voila! we got id which was generated from sequence
			    	orderId = generatedKeys.getInt(1);
			    }			    
				
			} else {
				throw new SQLException("Insert info to table GROUPBUYING failed! Error="+excuteResult);
			}
			
			
		} catch (SQLException e) {
			throw e;
		} finally {
			if (rs != null)
				rs.close();
			if (stmt != null)
				stmt.close();
			if (conn != null)
				conn.close();
		}
		return orderId;
	}