Skip to Main Content
JDBC Pocket Reference
book

JDBC Pocket Reference

by Donald Bales
January 2003
Intermediate to advanced content levelIntermediate to advanced
176 pages
5h 3m
English
O'Reilly Media, Inc.
Content preview from JDBC Pocket Reference
Connection
58
|
JDBC Pocket Reference
String nativeSQL(String sql)
Returns the specified SQL statement in the database’s native
SQL grammar.
CallableStatement prepareCall(String sql)
Returns a CallableStatement object, which can be used to
execute stored procedures.
CallableStatement prepareCall(String sql, int resultSetType,
int resultSetConcurrency)
Returns a CallableStatement object, which can be used to
execute stored procedures with the specified result set type
(Java 1.2):
ResultSet.TYPE_FORWARD_ONLY
ResultSet.TYPE_SCROLL_INSENSITIVE
ResultSet.TYPE_SCROLL_SENSITIVE
and result set concurrency:
ResultSet.CONCUR_READ_ONLY
ResultSet.CONCUR_UPDATABLE
CallableStatement prepareCall(String sql, int resultSetType,
int resultSetConcurrency, int resultSetHoldability)
Returns a CallableStatement object, which can be used to
execute stored procedures with the specified result set type
(Java 1.4):
ResultSet.TYPE_FORWARD_ONLY
ResultSet.TYPE_SCROLL_INSENSITIVE
ResultSet.TYPE_SCROLL_SENSITIVE
result set concurrency:
ResultSet.CONCUR_READ_ONLY
ResultSet.CONCUR_UPDATABLE
and result set holdability:
ResultSet.CLOSE_CURSORS_AT_COMMIT
ResultSet.HOLD_CURSORS_OVER_COMMIT
PreparedStatement prepareStatement(String sql)
Returns a PreparedStatement object, which can be used to
precompile and execute SQL INSERT, UPDATE, DELETE,
and SELECT statements.
PreparedStatement prepareStatement(String sql,
int autoGeneratedKeys)
Returns a PreparedStatement ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Pro Couchbase Server, Second Edition

Pro Couchbase Server, Second Edition

David Ostrovsky, Mohammed Haji, Yaniv Rodenski
Pro Couchbase Server

Pro Couchbase Server

David Ostrovsky, Yaniv Rodenski

Publisher Resources

ISBN: 9780596528713