
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 ...