Statement.return_generated_keys Example
As an example, create the following table in the sample database: CREATE TABLE TestTable (Col1 int IDENTITY, Col2 varchar(50), Col3 int); In the following example, an open connection to the sample database is passed in to the function, an SQL statement is constructed that will add data to the table, and then the statement is run and the IDENTITY column value is displayed. Mar 16, 2004 Problem with Statement.RETURNGENERATEDKEYS ra.416892.us Mar 15, 2004 4:05 PM Dear Colleagues, I am using Oracle 9i Enterprise Edition Release 9.2.0.1.0 with Java 1.4.101 on Red Hat Linux 8.0 and I am observing the following problem.
7.4 Retrieving AUTOINCREMENT Column Values through JDBC getGeneratedKeys is the preferred method to use if you need to retrieve AUTOINCREMENT keys and through JDBC; this is illustrated in the first example below. Retrieving auto-generated keys Many databases have hidden columns (pseudo-columns) that represent a unique key for each row in a table. Typically, using these types of columns in a query is the fastest way to access a row because the pseudo-columns usually represent the physical disk address of the data. Most of the examples will not contain the whole code and may omit fragments which are not relevant to the example being discussed. The readers can download or view all code from the above link. The following class shows how to retrieve the auto generated key after a new value is added to the table. The following are Jave code examples for showing how to use getGeneratedKeys of the java.sql.Statement class. You can vote up the examples you like. Your votes will be used in our system to get more good examples. Sep 18, 2006 When the Statement.RETURNGENERATEDKEYS integer flag is used, Oracle JDBC drivers cannot identify these columns, since the column indices/names have not been specified. Therefore, when the integer flag is used to indicate that auto-generated keys are to be returned, the ROWID pseudo column is returned as key.
Statement.RETURN_GENERATED_KEYSを使用したPreparedStatement (4)
このような意味ですか？
Statement.RETURN_GENERATED_KEYSを返すJDBCドライバのいくつかは、以下のことを行う唯一の方法です。
PreparedStatement同じことをする方法はありますか？
Statement.return_generated_keys Example Paper
編集
私がPreparedStatement同じことをすることができるかどうか尋ねた理由は、次のようなシナリオを考えます：
USERテーブルには、 BIGINT AUTOINCREMENTあるPRIMARY KEY (USER_ID)あります（なぜそれがSQL_CREATE文字列に表示されないのですか？
さて、私は?PreparedStatement.setXXXX(index, value)ます。 ResultSet rs = PreparedStatement.getGeneratedKeys()を返したい。 どうすればこれを達成できますか？
今私のコンパイラを持っていないので、私は質問して答えます。
あなたはこれを試しましたか？ それは動作しますか？
免責事項：明らかに、私はこれを編集していないが、あなたはその考えを得る。
Statement.return_generated_keys Example Essay
PreparedStatementはStatementサブインターフェースですので、一部のJDBCドライバーがバグでない限り、これが機能しない理由はありません。