A ROWID is an identification tag unique for each row of an Oracle Database table. The?ROWID can be thought of as a virtual column, containing the ID for each row.
The oracle.sql.ROWID class is supplied as a container for ROWID SQL data type.
If you include the ROWID pseudo-column in a query, then you can retrieve the?ROWIDs with the result set getString method. You can also bind a ROWID to a?PreparedStatement parameter with the setString method. This enables in-place?updating, as in the example that follows. Note: Use the oracle.sql.ROWID class, only when you are using J2SE 1.5. For JSE 6, you should use the standard java.sql.RowId interface instead.
ResultSet rst = stmt.executeQuery("select rowid,name from friend");
...
String rowid=rst.getString(1);
...
//or
RowId rowid = rst.getRowId(1); // Get the ROWID as a String
?
相关文章
