当前位置:首页 > 开发 > 数据库 > 正文

Java 获取Oracle ROWID

发表于: 2012-04-18   作者:aijuans   来源:转载   浏览:
摘要: 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 i

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
 

Java 获取Oracle ROWID

  • 0

    开心

    开心

  • 0

    板砖

    板砖

  • 0

    感动

    感动

  • 0

    有用

    有用

  • 0

    疑问

    疑问

  • 0

    难过

    难过

  • 0

    无聊

    无聊

  • 0

    震惊

    震惊

版权所有 IT知识库 CopyRight © 2009-2015 IT知识库 IT610.com , All Rights Reserved. 京ICP备09083238号