In many cases, it is desirable to immediately release a
Statements's database and JDBC resources instead of waiting for
this to happen when it is automatically closed; the close
method provides this immediate release.
Some prepared statements return multiple results; the execute
method handles these complex statements as well as the simpler
form of statements handled by executeQuery and executeUpdate.
Execute a SQL statement that may return multiple results and signal
the driver that the auto-generated keys indicated in the given array
should be made available for retrieval.
Execute a SQL statement that may return multiple results and signal
the driver that the auto-generated keys indicated in the given array
should be made available for retrieval.
Execute a SQL statement that may return multiple results and signal
the driver that the auto-generated keys indicated in the given array
should be made available for retrieval.
Execute a SQL INSERT, UPDATE or DELETE statement and signal the driver
that the auto-generated keys indicated in the given array should be made
available for retrieval.
Execute a SQL INSERT, UPDATE or DELETE statement and signal the driver
that the auto-generated keys indicated in the given array should be made
available for retrieval.
Execute a SQL INSERT, UPDATE or DELETE statement and signal the driver
with the given flag about whether the auto-generated keys produced by this
Statement object should be made available for retrieval.
JDBC 2.0 Gets the value of a JDBC NUMERIC parameter as a
java.math.BigDecimal object with as many digits to the right of the
decimal point as the value contains.
Retrieves the value of a JDBC NUMERIC parameter as a java.math.BigDecimal object with as many digits to the right of the decimal point as the value contains.
getMoreResults moves to this Statements next result, deals with any
current ResultSet objects according to the instructions specified by the
given flag, and returns true is the next result is a ResultSet object.
Get the value of a column as an object; an integral value is
returned as its java.lang equivalent object; a LONGVARCHAR or
LONGVARBINARY value is returned as a java.io.InputStream.
Get the value of a column as an object; an integral value is
returned as its java.lang equivalent object; a LONGVARCHAR or
LONGVARBINARY value is returned as a java.io.InputStream.
The getPropertyInfo method is intended to allow a generic GUI tool to
discover what properties it should prompt a human for in order to get
enough information to connect to a database.
When a Connection is in auto-close mode all its
PreparedStatements, CallableStatements, and ResultSets will be
closed when a transaction is committed or rolled back.