JDBC Service

  • The Apps Script JDBC service allows connecting to various JDBC-compliant databases like Google Cloud SQL, MySQL, Microsoft SQL Server, and Oracle.

  • The Jdbc class is the primary entry point for establishing database connections and creating date/time objects.

  • The service provides numerous classes representing JDBC concepts, such as JdbcConnection, JdbcStatement, JdbcResultSet, and metadata classes, mirroring methods from the java.sql package.

  • These classes offer comprehensive methods for managing connections, executing queries and updates, handling different data types (including large objects and XML), retrieving result set information, and obtaining database metadata.

JDBC

This service allows scripts to connect to JDBC-compliant databases, including Google Cloud SQL, MySQL, Microsoft SQL Server, and Oracle. See also the guide to JDBC.

Classes

NameBrief description
Jdbc The JDBC service allows scripts to connect to Google Cloud SQL, MySQL, Microsoft SQL Server, and Oracle databases.
JdbcArray A JDBC Array.
JdbcBlob A JDBC Blob.
JdbcCallableStatement A JDBC CallableStatement.
JdbcClob A JDBC Clob.
JdbcConnection A JDBC Connection.
JdbcDatabaseMetaData A JDBC database metadata object.
JdbcDate A JDBC Date.
JdbcParameterMetaData A JDBC ParameterMetaData.
JdbcPreparedStatement A JDBC PreparedStatement.
JdbcRef A JDBC Ref.
JdbcResultSet A JDBC ResultSet.
JdbcResultSetMetaData A JDBC ResultSetMetaData.
JdbcRowId A JDBC RowId.
JdbcSQLXML A JDBC SQLXML.
JdbcSavepoint A JDBC Savepoint.
JdbcStatement A JDBC Statement.
JdbcStruct A JDBC Struct.
JdbcTime A JDBC Time.
JdbcTimestamp A JDBC Timestamp.

Jdbc

Methods

MethodReturn typeBrief description
getCloudSqlConnection(url) JdbcConnection Attempts to establish a connection to the given Google Cloud SQL URL.
getCloudSqlConnection(url, info) JdbcConnection Attempts to establish a connection to the given Google Cloud SQL URL.
getCloudSqlConnection(url, userName, password) JdbcConnection Attempts to establish a connection to the given Google Cloud SQL URL.
getConnection(url) JdbcConnection Attempts to establish a connection to the given database URL.
getConnection(url, info) JdbcConnection Attempts to establish a connection to the given database URL.
getConnection(url, userName, password) JdbcConnection Attempts to establish a connection to the given database using a username and password.
newDate(milliseconds) JdbcDate Create a date from milliseconds since epoch.
newTime(milliseconds) JdbcTime Create a time from milliseconds since epoch.
newTimestamp(milliseconds) JdbcTimestamp Create a timestamp from milliseconds since epoch.
parseDate(date) JdbcDate Create a date by parsing the SQL date string.
parseTime(time) JdbcTime Create a time by parsing the SQL time string.
parseTimestamp(timestamp) JdbcTimestamp Create a timestamp by parsing the SQL timestamp string.

JdbcArray

Methods

MethodReturn typeBrief description
free() voidFor documentation of this method, see java.sql.Array#free().
getArray() ObjectFor documentation of this method, see java.sql.Array#getArray()
getArray(index, count) ObjectFor documentation of this method, see java.sql.Array#getArray(long, int).
getBaseType() IntegerFor documentation of this method, see java.sql.Array#getBaseType().
getBaseTypeName() StringFor documentation of this method, see java.sql.Array#getBaseTypeName().
getResultSet() JdbcResultSet For documentation of this method, see java.sql.Array#getResultSet().
getResultSet(index, count) JdbcResultSet For documentation of this method, see java.sql.Array#getResultSet(long, int).

JdbcBlob

Methods

MethodReturn typeBrief description
free() voidFor documentation of this method, see java.sql.Blob#free().
getAppsScriptBlob() Blob Gets the content of this JdbcBlob as an Apps Script blob.
getAs(contentType) Blob Return the data inside this object as a blob converted to the specified content type.
getBytes(position, length) Byte[]For documentation of this method, see java.sql.Blob#getBytes(long, int).
length() IntegerFor documentation of this method, see java.sql.Blob#length().
position(pattern, start) IntegerFor documentation of this method, see java.sql.Blob#position(byte[], long).
position(pattern, start) IntegerFor documentation of this method, see java.sql.Blob#position(blob, long).
setBytes(position, blobSource) IntegerConvenience method for writing a JdbcBlob to this blob.
setBytes(position, blobSource, offset, length) IntegerConvenience method for writing a JdbcBlob to this blob.
setBytes(position, bytes) IntegerFor documentation of this method, see java.sql.Blob#setBytes(long, byte[]).
setBytes(position, bytes, offset, length) IntegerFor documentation of this method, see java.sql.Blob#setBytes(long, byte[], int, int).
truncate(length) voidFor documentation of this method, see java.sql.Blob#truncate(long).

JdbcCallableStatement

Methods

MethodReturn typeBrief description
addBatch() voidFor documentation of this method, see java.sql.PreparedStatement#addBatch().
addBatch(sql) voidFor documentation of this method, see java.sql.Statement#addBatch(String).
cancel() voidFor documentation of this method, see java.sql.Statement#cancel().
clearBatch() voidFor documentation of this method, see java.sql.Statement#clearBatch().
clearParameters() voidFor documentation of this method, see java.sql.PreparedStatement#clearParameters().
clearWarnings() voidFor documentation of this method, see java.sql.Statement#clearWarnings().
close() voidFor documentation of this method, see java.sql.Statement#close().
execute() BooleanFor documentation of this method, see java.sql.PreparedStatement#execute().
execute(sql) BooleanFor documentation of this method, see java.sql.Statement#execute(String).
execute(sql, autoGeneratedKeys) BooleanFor documentation of this method, see java.sql.Statement#execute(String, int).
execute(sql, columnIndexes) BooleanFor documentation of this method, see java.sql.Statement#execute(String, int[]).
execute(sql, columnNames) BooleanFor documentation of this method, see java.sql.Statement#execute(String, String[]).
executeBatch() Integer[]For documentation of this method, see java.sql.Statement#executeBatch().
executeBatch(parameters) Integer[]Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts.
executeQuery() JdbcResultSet For documentation of this method, see java.sql.PreparedStatement#executeQuery().
executeQuery(sql) JdbcResultSet For documentation of this method, see java.sql.Statement#executeQuery(String).
executeUpdate() IntegerFor documentation of this method, see java.sql.PreparedStatement#executeUpdate().
executeUpdate(sql) IntegerFor documentation of this method, see java.sql.Statement#executeUpdate(String).
executeUpdate(sql, autoGeneratedKeys) IntegerFor documentation of this method, see java.sql.Statement#executeUpdate(String, int).
executeUpdate(sql, columnIndexes) IntegerFor documentation of this method, see java.sql.Statement#executeUpdate(String, int[]).
executeUpdate(sql, columnNames) IntegerFor documentation of this method, see java.sql.Statement#executeUpdate(String, String[]).
getArray(parameterIndex) JdbcArray For documentation of this method, see java.sql.CallableStatement#getArray(int).
getArray(parameterName) JdbcArray For documentation of this method, see java.sql.CallableStatement#getArray(String).
getBigDecimal(parameterIndex) BigNumberFor documentation of this method, see java.sql.CallableStatement#getBigDecimal(int).
getBigDecimal(parameterName) BigNumberFor documentation of this method, see java.sql.CallableStatement#getBigDecimal(String).
getBlob(parameterIndex) JdbcBlob For documentation of this method, see java.sql.CallableStatement#getBlob(int).
getBlob(parameterName) JdbcBlob For documentation of this method, see java.sql.CallableStatement#getBlob(String).
getBoolean(parameterIndex) BooleanFor documentation of this method, see java.sql.CallableStatement#getBoolean(int).
getBoolean(parameterName) BooleanFor documentation of this method, see java.sql.CallableStatement#getBoolean(String).
getByte(parameterIndex) ByteFor documentation of this method, see java.sql.CallableStatement#getByte(int).
getByte(parameterName) ByteFor documentation of this method, see java.sql.CallableStatement#getByte(String).
getBytes(parameterIndex) Byte[]For documentation of this method, see java.sql.CallableStatement#getBytes(int).
getBytes(parameterName) Byte[]For documentation of this method, see java.sql.CallableStatement#getBytes(String).
getClob(parameterIndex) JdbcClob For documentation of this method, see java.sql.CallableStatement#getClob(int).
getClob(parameterName) JdbcClob For documentation of this method, see java.sql.CallableStatement#getClob(String).
getConnection() JdbcConnection For documentation of this method, see java.sql.Statement#getConnection().
getDate(parameterIndex) JdbcDate For documentation of this method, see java.sql.CallableStatement#getDate(int).
getDate(parameterIndex, timeZone) JdbcDate For documentation of this method, see java.sql.CallableStatement#getDate(int, Calendar).
getDate(parameterName) JdbcDate For documentation of this method, see java.sql.CallableStatement#getDate(String).
getDate(parameterName, timeZone) JdbcDate For documentation of this method, see java.sql.CallableStatement#getDate(String, Calendar).
getDouble(parameterIndex) NumberFor documentation of this method, see java.sql.CallableStatement#getDouble(int).
getDouble(parameterName) NumberFor documentation of this method, see java.sql.CallableStatement#getDouble(String).
getFetchDirection() IntegerFor documentation of this method, see java.sql.Statement#getFetchDirection().
getFetchSize() IntegerFor documentation of this method, see java.sql.Statement#getFetchSize().
getFloat(parameterIndex) NumberFor documentation of this method, see java.sql.CallableStatement#getFloat(int).
getFloat(parameterName) NumberFor documentation of this method, see java.sql.CallableStatement#getFloat(String).
getGeneratedKeys() JdbcResultSet For documentation of this method, see java.sql.Statement#getGeneratedKeys().
getInt(parameterIndex) IntegerFor documentation of this method, see java.sql.CallableStatement#getInt(int).
getInt(parameterName) IntegerFor documentation of this method, see java.sql.CallableStatement#getInt(String).
getLong(parameterIndex) IntegerFor documentation of this method, see java.sql.CallableStatement#getLong(int).
getLong(parameterName) IntegerFor documentation of this method, see java.sql.CallableStatement#getLong(String).
getMaxFieldSize() IntegerFor documentation of this method, see java.sql.Statement#getMaxFieldSize().
getMaxRows() IntegerFor documentation of this method, see java.sql.Statement#getMaxRows().
getMetaData() JdbcResultSetMetaData For documentation of this method, see java.sql.PreparedStatement#getMetaData().
getMoreResults() BooleanFor documentation of this method, see java.sql.Statement#getMoreResults().
getMoreResults(current) BooleanFor documentation of this method, see java.sql.Statement#getMoreResults(int).
getNClob(parameterIndex) JdbcClob For documentation of this method, see java.sql.CallableStatement#getNClob(int).
getNClob(parameterName) JdbcClob For documentation of this method, see java.sql.CallableStatement#getNClob(String).
getNString(parameterIndex) StringFor documentation of this method, see java.sql.CallableStatement#getNString(int).
getNString(parameterName) StringFor documentation of this method, see java.sql.CallableStatement#getNString(String).
getObject(parameterIndex) ObjectFor documentation of this method, see java.sql.CallableStatement#getObject(int).
getObject(parameterName) ObjectFor documentation of this method, see java.sql.CallableStatement#getObject(String).
getParameterMetaData() JdbcParameterMetaData For documentation of this method, see java.sql.PreparedStatement#getParameterMetaData().
getQueryTimeout() IntegerFor documentation of this method, see java.sql.Statement#getQueryTimeout().
getRef(parameterIndex) JdbcRef For documentation of this method, see java.sql.CallableStatement#getRef(int).
getRef(parameterName) JdbcRef For documentation of this method, see java.sql.CallableStatement#getRef(String).
getResultSet() JdbcResultSet For documentation of this method, see java.sql.Statement#getResultSet().
getResultSetConcurrency() IntegerFor documentation of this method, see java.sql.Statement#getResultSetConcurrency().
getResultSetHoldability() IntegerFor documentation of this method, see java.sql.Statement#getResultSetHoldability().
getResultSetType() IntegerFor documentation of this method, see java.sql.Statement#getResultSetType().
getRowId(parameterIndex) JdbcRowId For documentation of this method, see java.sql.CallableStatement#getRowId(int).
getRowId(parameterName) JdbcRowId For documentation of this method, see java.sql.CallableStatement#getRowId(String).
getSQLXML(parameterIndex) JdbcSQLXML For documentation of this method, see java.sql.CallableStatement#getSQLXML(int).
getSQLXML(parameterName) JdbcSQLXML For documentation of this method, see java.sql.CallableStatement#getSQLXML(String).
getShort(parameterIndex) IntegerFor documentation of this method, see java.sql.CallableStatement#getShort(int).
getShort(parameterName) IntegerFor documentation of this method, see java.sql.CallableStatement#getShort(String).
getString(parameterIndex) StringFor documentation of this method, see java.sql.CallableStatement#getString(int).
getString(parameterName) StringFor documentation of this method, see java.sql.CallableStatement#getString(String).
getTime(parameterIndex) JdbcTime For documentation of this method, see java.sql.CallableStatement#getTime(int).
getTime(parameterIndex, timeZone) JdbcTime For documentation of this method, see java.sql.CallableStatement#getTime(int, Calendar).
getTime(parameterName) JdbcTime For documentation of this method, see java.sql.CallableStatement#getTime(String).
getTime(parameterName, timeZone) JdbcTime For documentation of this method, see java.sql.CallableStatement#getTime(String, Calendar).
getTimestamp(parameterIndex) JdbcTimestamp For documentation of this method, see java.sql.CallableStatement#getTimestamp(int).
getTimestamp(parameterIndex, timeZone) JdbcTimestamp For documentation of this method, see java.sql.CallableStatement#getTimestamp(int, Calendar).
getTimestamp(parameterName) JdbcTimestamp For documentation of this method, see java.sql.CallableStatement#getTimestamp(String).
getTimestamp(parameterName, timeZone) JdbcTimestamp For documentation of this method, see java.sql.CallableStatement#getTimestamp(String, Calendar).
getURL(parameterIndex) StringFor documentation of this method, see java.sql.CallableStatement#getURL(int).
getURL(parameterName) StringFor documentation of this method, see java.sql.CallableStatement#getURL(String).
getUpdateCount() IntegerFor documentation of this method, see java.sql.Statement#getUpdateCount().
getWarnings() String[]For documentation of this method, see java.sql.Statement#getWarnings().
isClosed() BooleanFor documentation of this method, see java.sql.Statement#isClosed().
isPoolable() BooleanFor documentation of this method, see java.sql.Statement#isPoolable().
registerOutParameter(parameterIndex, sqlType) voidFor documentation of this method, see java.sql.CallableStatement#registerOutParameter(int, int).
registerOutParameter(parameterIndex, sqlType, scale) voidFor documentation of this method, see java.sql.CallableStatement#registerOutParameter(int, int, int).
registerOutParameter(parameterIndex, sqlType, typeName) voidFor documentation of this method, see java.sql.CallableStatement#registerOutParameter(int, int, String).
registerOutParameter(parameterName, sqlType) voidFor documentation of this method, see java.sql.CallableStatement#registerOutParameter(String, int).
registerOutParameter(parameterName, sqlType, scale) voidFor documentation of this method, see java.sql.CallableStatement#registerOutParameter(String, int, int).
registerOutParameter(parameterName, sqlType, typeName) voidFor documentation of this method, see java.sql.CallableStatement#registerOutParameter(String, int, String).
setArray(parameterIndex, x) voidFor documentation of this method, see java.sql.PreparedStatement#setArray(int, Array).
setBigDecimal(parameterIndex, x) voidFor documentation of this method, see java.sql.PreparedStatement#setBigDecimal(int, BigDecimal).
setBigDecimal(parameterName, x) voidFor documentation of this method, see java.sql.CallableStatement#setBigDecimal(String, BigDecimal).
setBlob(parameterIndex, x) voidFor documentation of this method, see java.sql.PreparedStatement#setBlob(int, Clob).
setBlob(parameterName, x) voidFor documentation of this method, see java.sql.CallableStatement#setBlob(String, Blob).
setBoolean(parameterIndex, x) voidFor documentation of this method, see java.sql.PreparedStatement#setBoolean(int, boolean).
setBoolean(parameterName, x) voidFor documentation of this method, see java.sql.CallableStatement#setBoolean(String, boolean).
setByte(parameterIndex, x) voidFor documentation of this method, see java.sql.PreparedStatement#setByte(int, byte).
setByte(parameterName, x) voidFor documentation of this method, see java.sql.CallableStatement#setByte(String, byte).
setBytes(parameterIndex, x) voidFor documentation of this method, see java.sql.PreparedStatement#setBytes(int, byte[]).
setBytes(parameterName, x) voidFor documentation of this method, see java.sql.CallableStatement#setBytes(String, byte[]).
setClob(parameterIndex, x) voidFor documentation of this method, see java.sql.PreparedStatement#setClob(int, Clob).
setClob(parameterName, x) voidFor documentation of this method, see java.sql.CallableStatement#setBlob(String, Clob).
setCursorName(name) voidFor documentation of this method, see java.sql.Statement#setCursorName(String).
setDate(parameterIndex, x) voidFor documentation of this method, see java.sql.PreparedStatement#setDate(int, Date).
setDate(parameterIndex, x, timeZone) voidFor documentation of this method, see java.sql.PreparedStatement#setDate(int, Date, Calendar).
setDate(parameterName, x) voidFor documentation of this method, see java.sql.CallableStatement#setDate(String, Date).
setDate(parameterName, x, timeZone) voidFor documentation of this method, see java.sql.CallableStatement#setDate(String, Date, Calendar).
setDouble(parameterIndex, x) voidFor documentation of this method, see java.sql.PreparedStatement#setDouble(int, double).
setDouble(parameterName, x) voidFor documentation of this method, see java.sql.CallableStatement#setDouble(String, double).
setEscapeProcessing(enable) voidFor documentation of this method, see java.sql.Statement#setEscapeProcessing(boolean).
setFetchDirection(direction) voidFor documentation of this method, see java.sql.Statement#setFetchDirection(int).
setFetchSize(rows) voidFor documentation of this method, see java.sql.Statement#setFetchSize(int).
setFloat(parameterIndex, x) voidFor documentation of this method, see java.sql.PreparedStatement#setFloat(int, float).
setFloat(parameterName, x) voidFor documentation of this method, see java.sql.CallableStatement#setFloat(String, float).
setInt(parameterIndex, x) voidFor documentation of this method, see java.sql.PreparedStatement#setInt(int, int).
setInt(parameterName, x) voidFor documentation of this method, see java.sql.CallableStatement#setInt(String, int).
setLong(parameterIndex, x) voidFor documentation of this method, see java.sql.PreparedStatement#setLong(int, long).
setLong(parameterName, x) voidFor documentation of this method, see java.sql.CallableStatement#setLong(String, long).
setMaxFieldSize(max) voidFor documentation of this method, see java.sql.Statement#setMaxFieldSize(int).
setMaxRows(max) voidFor documentation of this method, see java.sql.Statement#setMaxRows(int).
setNClob(parameterIndex, x) voidFor documentation of this method, see java.sql.PreparedStatement#setNClob(int, NClob).
setNClob(parameterName, value) voidFor documentation of this method, see java.sql.CallableStatement#setNClob(String, NClob).
setNString(parameterIndex, x) voidFor documentation of this method, see java.sql.PreparedStatement#setNString(int, String).
setNString(parameterName, value) voidFor documentation of this method, see java.sql.CallableStatement#setNString(String, String).
setNull(parameterIndex, sqlType) voidFor documentation of this method, see java.sql.PreparedStatement#setNull(int, int).
setNull(parameterIndex, sqlType, typeName) voidFor documentation of this method, see java.sql.PreparedStatement#setNull(int, int, String).
setNull(parameterName, sqlType) voidFor documentation of this method, see java.sql.CallableStatement#setNull(String, int).
setNull(parameterName, sqlType, typeName) voidFor documentation of this method, see java.sql.CallableStatement#setNull(String, int, String).
setObject(index, x) voidFor documentation of this method, see java.sql.PreparedStatement#setObject(int, Object).
setObject(parameterIndex, x, targetSqlType) voidFor documentation of this method, see java.sql.PreparedStatement#setObject(int, Object, int).
setObject(parameterIndex, x, targetSqlType, scaleOrLength) voidFor documentation of this method, see java.sql.PreparedStatement#setObject(int, Object, int, int).
setObject(parameterName, x) voidFor documentation of this method, see java.sql.CallableStatement#setObject(String, Object).
setObject(parameterName, x, targetSqlType) voidFor documentation of this method, see java.sql.CallableStatement#setObject(String, Object, int).
setObject(parameterName, x, targetSqlType, scale) voidFor documentation of this method, see java.sql.CallableStatement#setObject(String, Object, int, int).
setPoolable(poolable) voidFor documentation of this method, see java.sql.Statement#setPoolable(boolean).
setQueryTimeout(seconds) voidFor documentation of this method, see java.sql.Statement#setQueryTimeout(int).
setRef(parameterIndex, x) voidFor documentation of this method, see java.sql.PreparedStatement#setRef(int, Ref).
setRowId(parameterIndex, x) voidFor documentation of this method, see java.sql.PreparedStatement#setRowId(int, RowId).
setRowId(parameterName, x) voidFor documentation of this method, see java.sql.CallableStatement#setRowId(String, RowId).
setSQLXML(parameterIndex, x) voidFor documentation of this method, see java.sql.PreparedStatement#setSQLXML(int, SQLXML).
setSQLXML(parameterName, xmlObject) voidFor documentation of this method, see java.sql.CallableStatement#setSQLXML(String, SQLXML).
setShort(parameterIndex, x) voidFor documentation of this method, see java.sql.PreparedStatement#setShort(int, short).
setShort(parameterName, x) voidFor documentation of this method, see java.sql.CallableStatement#setShort(String, short).
setString(parameterIndex, x) voidFor documentation of this method, see java.sql.PreparedStatement#setString(int, String).
setString(parameterName, x) voidFor documentation of this method, see java.sql.CallableStatement#setString(String, String).
setTime(parameterIndex, x) voidFor documentation of this method, see java.sql.PreparedStatement#setTime(int, Time).
setTime(parameterIndex, x, timeZone) voidFor documentation of this method, see java.sql.PreparedStatement#setTime(int, Time, Calendar).
setTime(parameterName, x) voidFor documentation of this method, see java.sql.CallableStatement#setTime(String, Time).
setTime(parameterName, x, timeZone) voidFor documentation of this method, see java.sql.CallableStatement#setTime(String, Time, Calendar).
setTimestamp(parameterIndex, x) voidFor documentation of this method, see java.sql.PreparedStatement#setTimestamp(int, Timestamp).
setTimestamp(parameterIndex, x, timeZone) voidFor documentation of this method, see java.sql.PreparedStatement#setTimestamp(int, Timestamp, Calendar).
setTimestamp(parameterName, x) voidFor documentation of this method, see java.sql.CallableStatement#setTimestamp(String, Timestamp).
setTimestamp(parameterName, x, timeZone) voidFor documentation of this method, see java.sql.CallableStatement#setTimestamp(String, Timestamp, Calendar).
setURL(parameterIndex, x) voidFor documentation of this method, see java.sql.PreparedStatement#setURL(int, URL).
setURL(parameterName, val) voidFor documentation of this method, see java.sql.CallableStatement#setURL(String, URL).
wasNull() BooleanFor documentation of this method, see java.sql.CallableStatement#wasNull().

JdbcClob

Methods

MethodReturn typeBrief description
free() voidFor documentation of this method, see java.sql.Clob#truncate(long).
getAppsScriptBlob() Blob Gets the content of this JdbcClob as an Apps Script blob.
getAs(contentType) Blob Return the data inside this object as a blob converted to the specified content type.
getSubString(position, length) StringFor documentation of this method, see java.sql.Clob#getSubString(long, int).
length() IntegerFor documentation of this method, see java.sql.Clob#length().
position(search, start) IntegerFor documentation of this method, see java.sql.Clob#position(Clob, long).
position(search, start) IntegerFor documentation of this method, see java.sql.Clob#position(String, long).
setString(position, blobSource) IntegerConvenience method for writing a JdbcClob to a clob.
setString(position, blobSource, offset, len) IntegerConvenience method for writing a JdbcClob to a clob.
setString(position, value) IntegerFor documentation of this method, see java.sql.Clob#setString(long, String).
setString(position, value, offset, len) IntegerFor documentation of this method, see java.sql.Clob#setString(long, String, int, int).
truncate(length) voidFor documentation of this method, see java.sql.Clob#truncate(long).

JdbcConnection

Methods

MethodReturn typeBrief description
clearWarnings() voidFor documentation of this method, see java.sql.Connection#clearWarnings().
close() voidRelease this connection's database and all associated resources.
commit() voidMakes all pending changes permanent, releases database locks held by this JdbcConnection .
createArrayOf(typeName, elements) JdbcArray For documentation of this method, see java.sql.Connection#createArrayOf(String, Object[]).
createBlob() JdbcBlob Constructs a JdbcBlob instance.
createClob() JdbcClob For documentation of this method, see java.sql.Connection#createClob().
createNClob() JdbcClob For documentation of this method, see java.sql.Connection#createNClob().
createSQLXML() JdbcSQLXML For documentation of this method, see java.sql.Connection#createSQLXML().
createStatement() JdbcStatement Creates a JdbcStatement object for sending SQL statements to the database.
createStatement(resultSetType, resultSetConcurrency) JdbcStatement Creates a JdbcStatement object for sending SQL statements to the database.
createStatement(resultSetType, resultSetConcurrency, resultSetHoldability) JdbcStatement Creates a JdbcStatement object for sending SQL statements to the database.
createStruct(typeName, attributes) JdbcStruct For documentation of this method, see java.sql.Connection#createStruct(String, Object[]).
getAutoCommit() BooleanFor documentation of this method, see java.sql.Connection#getAutoCommit().
getCatalog() Stringor documentation of this method, see java.sql.Connection#getCatalog().
getHoldability() IntegerFor documentation of this method, see java.sql.Connection#getHoldability().
getMetaData() JdbcDatabaseMetaData For documentation of this method, see java.sql.Connection#getMetaData().
getTransactionIsolation() IntegerFor documentation of this method, see java.sql.Connection#getTransactionIsolation().
getWarnings() String[]For documentation of this method, see java.sql.Connection#getWarnings().
isClosed() BooleanFor documentation of this method, see java.sql.Connection#isClosed().
isReadOnly() BooleanFor documentation of this method, see java.sql.Connection#isReadOnly().
isValid(timeout) BooleanFor documentation of this method, see java.sql.Connection#isValid(int).
nativeSQL(sql) StringFor documentation of this method, see java.sql.Connection#nativeSQL(String).
prepareCall(sql) JdbcCallableStatement For documentation of this method, see java.sql.Connection#prepareCall(String).
prepareCall(sql, resultSetType, resultSetConcurrency) JdbcCallableStatement For documentation of this method, see java.sql.Connection#prepareCall(String, int, int).
prepareCall(sql, resultSetType, resultSetConcurrency, resultSetHoldability) JdbcCallableStatement For documentation of this method, see java.sql.Connection#prepareCall(String, int, int, int).
prepareStatement(sql) JdbcPreparedStatement For documentation of this method, see java.sql.Connection#prepareStatement(String).
prepareStatement(sql, autoGeneratedKeys) JdbcPreparedStatement For documentation of this method, see java.sql.Connection#prepareStatement(String, int).
prepareStatement(sql, resultSetType, resultSetConcurrency) JdbcPreparedStatement For documentation of this method, see java.sql.Connection#prepareStatement(String, int, int).
prepareStatement(sql, resultSetType, resultSetConcurrency, resultSetHoldability) JdbcPreparedStatement For documentation of this method, see java.sql.Connection#prepareStatement(String, int, int, int).
prepareStatementByIndex(sql, indices) JdbcPreparedStatement For documentation of this method, see java.sql.Connection#prepareStatement(String, int[]).
prepareStatementByName(sql, columnNames) JdbcPreparedStatement For documentation of this method, see java.sql.Connection#prepareStatement(String, String[]).
releaseSavepoint(savepoint) voidFor documentation of this method, see java.sql.Connection#releaseSavepoint(Savepoint).
rollback() voidFor documentation of this method, see java.sql.Connection#rollback().
rollback(savepoint) voidFor documentation of this method, see java.sql.Connection#rollback(Savepoint).
setAutoCommit(autoCommit) voidFor documentation of this method, see java.sql.Connection#setAutoCommit(boolean).
setCatalog(catalog) voidFor documentation of this method, see java.sql.Connection#setCatalog(String).
setHoldability(holdability) voidFor documentation of this method, see java.sql.Connection#setHoldability(int).
setReadOnly(readOnly) voidFor documentation of this method, see java.sql.Connection#setReadOnly(boolean).
setSavepoint() JdbcSavepoint For documentation of this method, see java.sql.Connection#setSavepoint().
setSavepoint(name) JdbcSavepoint For documentation of this method, see java.sql.Connection#setSavepoint(String).
setTransactionIsolation(level) voidFor documentation of this method, see java.sql.Connection#setTransactionIsolation(int).

JdbcDatabaseMetaData

Methods

MethodReturn typeBrief description
allProceduresAreCallable() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#allProceduresAreCallable().
allTablesAreSelectable() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#allTablesAreSelectable().
autoCommitFailureClosesAllResultSets() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#autoCommitFailureClosesAllResultSets().
dataDefinitionCausesTransactionCommit() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#dataDefinitionCausesTransactionCommit().
dataDefinitionIgnoredInTransactions() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#dataDefinitionIgnoredInTransactions().
deletesAreDetected(type) BooleanFor documentation of this method, see java.sql.DatabaseMetaData#deletesAreDetected(int).
doesMaxRowSizeIncludeBlobs() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#doesMaxRowSizeIncludeBlobs().
getAttributes(catalog, schemaPattern, typeNamePattern, attributeNamePattern) JdbcResultSet For documentation of this method, see java.sql.DatabaseMetaData#getAttributes(String, String, String, String).
getBestRowIdentifier(catalog, schema, table, scope, nullable) JdbcResultSet For documentation of this method, see java.sql.DatabaseMetaData#getBestRowIdentifier(String, String, String, int, boolean) .
getCatalogSeparator() StringFor documentation of this method, see java.sql.DatabaseMetaData#getCatalogSeparator().
getCatalogTerm() StringFor documentation of this method, see java.sql.DatabaseMetaData#getCatalogTerm().
getCatalogs() JdbcResultSet For documentation of this method, see java.sql.DatabaseMetaData#getCatalogs().
getClientInfoProperties() JdbcResultSet For documentation of this method, see java.sql.DatabaseMetaData#getClientInfoProperties().
getColumnPrivileges(catalog, schema, table, columnNamePattern) JdbcResultSet For documentation of this method, see java.sql.DatabaseMetaData#getColumnPrivileges(String, String, String, String) .
getColumns(catalog, schemaPattern, tableNamePattern, columnNamePattern) JdbcResultSet For documentation of this method, see java.sql.DatabaseMetaData#getColumns(String, String, String, String).
getConnection() JdbcConnection For documentation of this method, see java.sql.DatabaseMetaData#getConnection().
getCrossReference(parentCatalog, parentSchema, parentTable, foreignCatalog, foreignSchema, foreignTable) JdbcResultSet For documentation of this method, see java.sql.DatabaseMetaData#getCrossReference(String, String, String, String, String, String).
getDatabaseMajorVersion() IntegerFor documentation of this method, see java.sql.DatabaseMetaData#getDatabaseMajorVersion().
getDatabaseMinorVersion() IntegerFor documentation of this method, see java.sql.DatabaseMetaData#getDatabaseMinorVersion().
getDatabaseProductName() StringFor documentation of this method, see java.sql.DatabaseMetaData#getDatabaseProductName().
getDatabaseProductVersion() StringFor documentation of this method, see java.sql.DatabaseMetaData#getDatabaseProductVersion().
getDefaultTransactionIsolation() IntegerFor documentation of this method, see java.sql.DatabaseMetaData#getDefaultTransactionIsolation().
getDriverMajorVersion() IntegerFor documentation of this method, see java.sql.DatabaseMetaData#getDriverMajorVersion().
getDriverMinorVersion() IntegerFor documentation of this method, see java.sql.DatabaseMetaData#getDriverMinorVersion().
getDriverName() StringFor documentation of this method, see java.sql.DatabaseMetaData#getDriverName().
getDriverVersion() StringFor documentation of this method, see java.sql.DatabaseMetaData#getDriverVersion().
getExportedKeys(catalog, schema, table) JdbcResultSet For documentation of this method, see java.sql.DatabaseMetaData#getImportedKeys(String, String, String).
getExtraNameCharacters() StringFor documentation of this method, see java.sql.DatabaseMetaData#getExtraNameCharacters().
getFunctionColumns(catalog, schemaPattern, functionNamePattern, columnNamePattern) JdbcResultSet For documentation of this method, see java.sql.DatabaseMetaData#getFunctionColumns(String, String, String, String).
getFunctions(catalog, schemaPattern, functionNamePattern) JdbcResultSet For documentation of this method, see java.sql.DatabaseMetaData#getFunctions(String, String, String).
getIdentifierQuoteString() StringFor documentation of this method, see java.sql.DatabaseMetaData#getIdentifierQuoteString().
getImportedKeys(catalog, schema, table) JdbcResultSet For documentation of this method, see java.sql.DatabaseMetaData#getImportedKeys(String, String, String).
getIndexInfo(catalog, schema, table, unique, approximate) JdbcResultSet For documentation of this method, see java.sql.DatabaseMetaData#getIndexInfo(String, String, String, boolean, boolean) .
getJDBCMajorVersion() IntegerFor documentation of this method, see java.sql.DatabaseMetaData#getJDBCMajorVersion().
getJDBCMinorVersion() IntegerFor documentation of this method, see java.sql.DatabaseMetaData#getJDBCMinorVersion().
getMaxBinaryLiteralLength() IntegerFor documentation of this method, see java.sql.DatabaseMetaData#getMaxBinaryLiteralLength().
getMaxCatalogNameLength() IntegerFor documentation of this method, see java.sql.DatabaseMetaData#getMaxCatalogNameLength().
getMaxCharLiteralLength() IntegerFor documentation of this method, see java.sql.DatabaseMetaData#getMaxCharLiteralLength().
getMaxColumnNameLength() IntegerFor documentation of this method, see java.sql.DatabaseMetaData#getMaxColumnNameLength().
getMaxColumnsInGroupBy() IntegerFor documentation of this method, see java.sql.DatabaseMetaData#getMaxColumnsInGroupBy().
getMaxColumnsInIndex() IntegerFor documentation of this method, see java.sql.DatabaseMetaData#getMaxColumnsInIndex().
getMaxColumnsInOrderBy() IntegerFor documentation of this method, see java.sql.DatabaseMetaData#getMaxColumnsInOrderBy().
getMaxColumnsInSelect() IntegerFor documentation of this method, see java.sql.DatabaseMetaData#getMaxColumnsInSelect().
getMaxColumnsInTable() IntegerFor documentation of this method, see java.sql.DatabaseMetaData#getMaxColumnsInTable().
getMaxConnections() IntegerFor documentation of this method, see java.sql.DatabaseMetaData#getMaxConnections().
getMaxCursorNameLength() IntegerFor documentation of this method, see java.sql.DatabaseMetaData#getMaxCursorNameLength().
getMaxIndexLength() IntegerFor documentation of this method, see java.sql.DatabaseMetaData#getMaxIndexLength().
getMaxProcedureNameLength() IntegerFor documentation of this method, see java.sql.DatabaseMetaData#getMaxProcedureNameLength().
getMaxRowSize() IntegerFor documentation of this method, see java.sql.DatabaseMetaData#getMaxRowSize().
getMaxSchemaNameLength() IntegerFor documentation of this method, see java.sql.DatabaseMetaData#getMaxSchemaNameLength().
getMaxStatementLength() IntegerFor documentation of this method, see java.sql.DatabaseMetaData#getMaxStatementLength().
getMaxStatements() IntegerFor documentation of this method, see java.sql.DatabaseMetaData#getMaxStatements().
getMaxTableNameLength() IntegerFor documentation of this method, see java.sql.DatabaseMetaData#getMaxTableNameLength().
getMaxTablesInSelect() IntegerFor documentation of this method, see java.sql.DatabaseMetaData#getMaxTablesInSelect().
getMaxUserNameLength() IntegerFor documentation of this method, see java.sql.DatabaseMetaData#getMaxUserNameLength().
getNumericFunctions() StringFor documentation of this method, see java.sql.DatabaseMetaData#getNumericFunctions().
getPrimaryKeys(catalog, schema, table) JdbcResultSet For documentation of this method, see java.sql.DatabaseMetaData#getPrimaryKeys(String, String, String).
getProcedureColumns(catalog, schemaPattern, procedureNamePattern, columnNamePattern) JdbcResultSet For documentation of this method, see java.sql.DatabaseMetaData#getProcedureColumns(String, String, String, String) .
getProcedureTerm() StringFor documentation of this method, see java.sql.DatabaseMetaData#getProcedureTerm().
getProcedures(catalog, schemaPattern, procedureNamePattern) JdbcResultSet For documentation of this method, see java.sql.DatabaseMetaData#getProcedures(String, String, String).
getResultSetHoldability() IntegerFor documentation of this method, see java.sql.DatabaseMetaData#getResultSetHoldability().
getRowIdLifetime() IntegerFor documentation of this method, see java.sql.DatabaseMetaData#getRowIdLifetime().
getSQLKeywords() StringFor documentation of this method, see java.sql.DatabaseMetaData#getSQLKeywords().
getSQLStateType() IntegerFor documentation of this method, see java.sql.DatabaseMetaData#getSQLStateType().
getSchemaTerm() StringFor documentation of this method, see java.sql.DatabaseMetaData#getSchemaTerm().
getSchemas() JdbcResultSet For documentation of this method, see java.sql.DatabaseMetaData#getSchemas().
getSchemas(catalog, schemaPattern) JdbcResultSet For documentation of this method, see java.sql.DatabaseMetaData#getSchemas().
getSearchStringEscape() StringFor documentation of this method, see java.sql.DatabaseMetaData#getSearchStringEscape().
getStringFunctions() StringFor documentation of this method, see java.sql.DatabaseMetaData#getStringFunctions().
getSuperTables(catalog, schemaPattern, tableNamePattern) JdbcResultSet For documentation of this method, see java.sql.DatabaseMetaData#getSuperTables(String, String,String).
getSuperTypes(catalog, schemaPattern, typeNamePattern) JdbcResultSet For documentation of this method, see java.sql.DatabaseMetaData#getSuperTypes(String, String, String).
getSystemFunctions() StringFor documentation of this method, see java.sql.DatabaseMetaData#getSystemFunctions().
getTablePrivileges(catalog, schemaPattern, tableNamePattern) JdbcResultSet For documentation of this method, see java.sql.DatabaseMetaData#getTablePrivileges(String, String, String).
getTableTypes() JdbcResultSet For documentation of this method, see java.sql.DatabaseMetaData#getTableTypes().
getTables(catalog, schemaPattern, tableNamePattern, types) JdbcResultSet For documentation of this method, see java.sql.DatabaseMetaData#getTables(String, String, String, String[]).
getTimeDateFunctions() StringFor documentation of this method, see java.sql.DatabaseMetaData#getTimeDateFunctions().
getTypeInfo() JdbcResultSet For documentation of this method, see java.sql.DatabaseMetaData#getTypeInfo().
getUDTs(catalog, schemaPattern, typeNamePattern, types) JdbcResultSet For documentation of this method, see java.sql.DatabaseMetaData#getUDTs(String, String, String, int[]).
getURL() StringFor documentation of this method, see java.sql.DatabaseMetaData#getURL().
getUserName() StringFor documentation of this method, see java.sql.DatabaseMetaData#getUserName().
getVersionColumns(catalog, schema, table) JdbcResultSet For documentation of this method, see java.sql.DatabaseMetaData#getVersionColumns(String, String, String).
insertsAreDetected(type) BooleanFor documentation of this method, see java.sql.DatabaseMetaData#insertsAreDetected(int).
isCatalogAtStart() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#isCatalogAtStart().
isReadOnly() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#isReadOnly().
locatorsUpdateCopy() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#locatorsUpdateCopy().
nullPlusNonNullIsNull() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#nullPlusNonNullIsNull().
nullsAreSortedAtEnd() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#nullsAreSortedAtEnd().
nullsAreSortedAtStart() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#nullsAreSortedAtStart().
nullsAreSortedHigh() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#nullsAreSortedHigh().
nullsAreSortedLow() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#nullsAreSortedLow().
othersDeletesAreVisible(type) BooleanFor documentation of this method, see java.sql.DatabaseMetaData#othersDeletesAreVisible(int).
othersInsertsAreVisible(type) BooleanFor documentation of this method, see java.sql.DatabaseMetaData#othersInsertsAreVisible(int).
othersUpdatesAreVisible(type) BooleanFor documentation of this method, see java.sql.DatabaseMetaData#othersUpdatesAreVisible(int).
ownDeletesAreVisible(type) BooleanFor documentation of this method, see java.sql.DatabaseMetaData#ownDeletesAreVisible(int).
ownInsertsAreVisible(type) BooleanFor documentation of this method, see java.sql.DatabaseMetaData#ownInsertsAreVisible(int).
ownUpdatesAreVisible(type) BooleanFor documentation of this method, see java.sql.DatabaseMetaData#ownUpdatesAreVisible(int).
storesLowerCaseIdentifiers() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#storesLowerCaseIdentifiers().
storesLowerCaseQuotedIdentifiers() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#storesLowerCaseQuotedIdentifiers().
storesMixedCaseIdentifiers() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#storesMixedCaseIdentifiers().
storesMixedCaseQuotedIdentifiers() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#storesMixedCaseQuotedIdentifiers().
storesUpperCaseIdentifiers() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#storesUpperCaseIdentifiers().
storesUpperCaseQuotedIdentifiers() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#storesUpperCaseQuotedIdentifiers().
supportsANSI92EntryLevelSQL() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsANSI92EntryLevelSQL().
supportsANSI92FullSQL() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsANSI92FullSQL().
supportsANSI92IntermediateSQL() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsANSI92IntermediateSQL().
supportsAlterTableWithAddColumn() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsAlterTableWithAddColumn().
supportsAlterTableWithDropColumn() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsAlterTableWithDropColumn().
supportsBatchUpdates() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsBatchUpdates().
supportsCatalogsInDataManipulation() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsCatalogsInDataManipulation().
supportsCatalogsInIndexDefinitions() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsCatalogsInIndexDefinitions().
supportsCatalogsInPrivilegeDefinitions() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsCatalogsInPrivilegeDefinitions().
supportsCatalogsInProcedureCalls() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsCatalogsInProcedureCalls().
supportsCatalogsInTableDefinitions() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsCatalogsInTableDefinitions().
supportsColumnAliasing() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsColumnAliasing().
supportsConvert() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsConvert().
supportsConvert(fromType, toType) BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsConvert(int, int).
supportsCoreSQLGrammar() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsCoreSQLGrammar().
supportsCorrelatedSubqueries() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsCorrelatedSubqueries().
supportsDataDefinitionAndDataManipulationTransactions() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsDataDefinitionAndDataManipulationTransactions() .
supportsDataManipulationTransactionsOnly() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsDataManipulationTransactionsOnly().
supportsDifferentTableCorrelationNames() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsDifferentTableCorrelationNames().
supportsExpressionsInOrderBy() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsExpressionsInOrderBy().
supportsExtendedSQLGrammar() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsExtendedSQLGrammar().
supportsFullOuterJoins() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsFullOuterJoins().
supportsGetGeneratedKeys() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsGetGeneratedKeys().
supportsGroupBy() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsGroupBy().
supportsGroupByBeyondSelect() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsGroupByBeyondSelect().
supportsGroupByUnrelated() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsGroupByUnrelated().
supportsIntegrityEnhancementFacility() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsIntegrityEnhancementFacility().
supportsLikeEscapeClause() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsLikeEscapeClause().
supportsLimitedOuterJoins() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsLimitedOuterJoins().
supportsMinimumSQLGrammar() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsMinimumSQLGrammar().
supportsMixedCaseIdentifiers() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsMixedCaseIdentifiers().
supportsMixedCaseQuotedIdentifiers() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsMixedCaseQuotedIdentifiers().
supportsMultipleOpenResults() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsMultipleOpenResults().
supportsMultipleResultSets() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsMultipleResultSets().
supportsMultipleTransactions() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsMultipleTransactions().
supportsNamedParameters() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsNamedParameters().
supportsNonNullableColumns() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsNonNullableColumns().
supportsOpenCursorsAcrossCommit() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsOpenCursorsAcrossCommit().
supportsOpenCursorsAcrossRollback() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsOpenCursorsAcrossRollback().
supportsOpenStatementsAcrossCommit() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsOpenStatementsAcrossCommit().
supportsOpenStatementsAcrossRollback() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsOpenStatementsAcrossRollback().
supportsOrderByUnrelated() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsOrderByUnrelated().
supportsOuterJoins() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsOuterJoins().
supportsPositionedDelete() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsPositionedDelete().
supportsPositionedUpdate() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsPositionedUpdate().
supportsResultSetConcurrency(type, concurrency) BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsResultSetConcurrency(int, int).
supportsResultSetHoldability(holdability) BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsResultSetHoldability(int).
supportsResultSetType(type) BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsResultSetType(int).
supportsSavepoints() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsSavepoints().
supportsSchemasInDataManipulation() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsSchemasInDataManipulation().
supportsSchemasInIndexDefinitions() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsSchemasInIndexDefinitions().
supportsSchemasInPrivilegeDefinitions() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsSchemasInPrivilegeDefinitions().
supportsSchemasInProcedureCalls() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsSchemasInProcedureCalls().
supportsSchemasInTableDefinitions() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsSchemasInTableDefinitions().
supportsSelectForUpdate() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsSelectForUpdate().
supportsStatementPooling() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsStatementPooling().
supportsStoredFunctionsUsingCallSyntax() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsStoredFunctionsUsingCallSyntax().
supportsStoredProcedures() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsStoredProcedures().
supportsSubqueriesInComparisons() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsSubqueriesInComparisons().
supportsSubqueriesInExists() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsSubqueriesInExists().
supportsSubqueriesInIns() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsSubqueriesInIns().
supportsSubqueriesInQuantifieds() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsSubqueriesInQuantifieds().
supportsTableCorrelationNames() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsTableCorrelationNames().
supportsTransactionIsolationLevel(level) BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsTransactionIsolationLevel(int).
supportsTransactions() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsTransactions().
supportsUnion() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsUnion().
supportsUnionAll() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#supportsUnionAll().
updatesAreDetected(type) BooleanFor documentation of this method, see java.sql.DatabaseMetaData#updatesAreDetected(int).
usesLocalFilePerTable() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#usesLocalFilePerTable().
usesLocalFiles() BooleanFor documentation of this method, see java.sql.DatabaseMetaData#usesLocalFiles().

JdbcDate

Methods

MethodReturn typeBrief description
after(when) BooleanFor documentation of this method, see java.sql.Date#after(date).
before(when) BooleanFor documentation of this method, see java.sql.Date#before(date).
getDate() IntegerFor documentation of this method, see java.sql.Date#getDate().
getMonth() IntegerFor documentation of this method, see java.sql.Date#getMonth().
getTime() IntegerFor documentation of this method, see java.sql.Date#getTime().
getYear() IntegerFor documentation of this method, see java.sql.Date#getYear().
setDate(date) voidFor documentation of this method, see java.sql.Date#setDate(int).
setMonth(month) voidFor documentation of this method, see java.sql.Date#setMonth(int).
setTime(milliseconds) voidFor documentation of this method, see java.sql.Date#setTime(int).
setYear(year) voidFor documentation of this method, see java.sql.Date#setYear(int).

JdbcParameterMetaData

Methods

MethodReturn typeBrief description
getParameterClassName(param) StringFor documentation of this method, see java.sql.ParameterMetaData#getParameterClassName(int).
getParameterCount() IntegerFor documentation of this method, see java.sql.ParameterMetaData#getParameterCount().
getParameterMode(param) IntegerFor documentation of this method, see java.sql.ParameterMetaData#getParameterMode(int).
getParameterType(param) IntegerFor documentation of this method, see java.sql.ParameterMetaData#getParameterType(int).
getParameterTypeName(param) StringFor documentation of this method, see java.sql.ParameterMetaData#getParameterTypeName(int).
getPrecision(param) IntegerFor documentation of this method, see java.sql.ParameterMetaData#getPrecision(int).
getScale(param) IntegerFor documentation of this method, see java.sql.ParameterMetaData#getScale(int).
isNullable(param) IntegerFor documentation of this method, see java.sql.ParameterMetaData#isNullable(int).
isSigned(param) BooleanFor documentation of this method, see java.sql.ParameterMetaData#isSigned(int).

JdbcPreparedStatement

Methods

MethodReturn typeBrief description
addBatch() voidFor documentation of this method, see java.sql.PreparedStatement#addBatch().
addBatch(sql) voidFor documentation of this method, see java.sql.Statement#addBatch(String).
cancel() voidFor documentation of this method, see java.sql.Statement#cancel().
clearBatch() voidFor documentation of this method, see java.sql.Statement#clearBatch().
clearParameters() voidFor documentation of this method, see java.sql.PreparedStatement#clearParameters().
clearWarnings() voidFor documentation of this method, see java.sql.Statement#clearWarnings().
close() voidFor documentation of this method, see java.sql.Statement#close().
execute() BooleanFor documentation of this method, see java.sql.PreparedStatement#execute().
execute(sql) BooleanFor documentation of this method, see java.sql.Statement#execute(String).
execute(sql, autoGeneratedKeys) BooleanFor documentation of this method, see java.sql.Statement#execute(String, int).
execute(sql, columnIndexes) BooleanFor documentation of this method, see java.sql.Statement#execute(String, int[]).
execute(sql, columnNames) BooleanFor documentation of this method, see java.sql.Statement#execute(String, String[]).
executeBatch() Integer[]For documentation of this method, see java.sql.Statement#executeBatch().
executeBatch(parameters) Integer[]Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts.
executeQuery() JdbcResultSet For documentation of this method, see java.sql.PreparedStatement#executeQuery().
executeQuery(sql) JdbcResultSet For documentation of this method, see java.sql.Statement#executeQuery(String).
executeUpdate() IntegerFor documentation of this method, see java.sql.PreparedStatement#executeUpdate().
executeUpdate(sql) IntegerFor documentation of this method, see java.sql.Statement#executeUpdate(String).
executeUpdate(sql, autoGeneratedKeys) IntegerFor documentation of this method, see java.sql.Statement#executeUpdate(String, int).
executeUpdate(sql, columnIndexes) IntegerFor documentation of this method, see java.sql.Statement#executeUpdate(String, int[]).
executeUpdate(sql, columnNames) IntegerFor documentation of this method, see java.sql.Statement#executeUpdate(String, String[]).
getConnection() JdbcConnection For documentation of this method, see java.sql.Statement#getConnection().
getFetchDirection() IntegerFor documentation of this method, see java.sql.Statement#getFetchDirection().
getFetchSize() IntegerFor documentation of this method, see java.sql.Statement#getFetchSize().
getGeneratedKeys() JdbcResultSet For documentation of this method, see java.sql.Statement#getGeneratedKeys().
getMaxFieldSize() IntegerFor documentation of this method, see java.sql.Statement#getMaxFieldSize().
getMaxRows() IntegerFor documentation of this method, see java.sql.Statement#getMaxRows().
getMetaData() JdbcResultSetMetaData For documentation of this method, see java.sql.PreparedStatement#getMetaData().
getMoreResults() BooleanFor documentation of this method, see java.sql.Statement#getMoreResults().
getMoreResults(current) BooleanFor documentation of this method, see java.sql.Statement#getMoreResults(int).
getParameterMetaData() JdbcParameterMetaData For documentation of this method, see java.sql.PreparedStatement#getParameterMetaData().
getQueryTimeout() IntegerFor documentation of this method, see java.sql.Statement#getQueryTimeout().
getResultSet() JdbcResultSet For documentation of this method, see java.sql.Statement#getResultSet().
getResultSetConcurrency() IntegerFor documentation of this method, see java.sql.Statement#getResultSetConcurrency().
getResultSetHoldability() IntegerFor documentation of this method, see java.sql.Statement#getResultSetHoldability().
getResultSetType() IntegerFor documentation of this method, see java.sql.Statement#getResultSetType().
getUpdateCount() IntegerFor documentation of this method, see java.sql.Statement#getUpdateCount().
getWarnings() String[]For documentation of this method, see java.sql.Statement#getWarnings().
isClosed() BooleanFor documentation of this method, see java.sql.Statement#isClosed().
isPoolable() BooleanFor documentation of this method, see java.sql.Statement#isPoolable().
setArray(parameterIndex, x) voidFor documentation of this method, see java.sql.PreparedStatement#setArray(int, Array).
setBigDecimal(parameterIndex, x) voidFor documentation of this method, see java.sql.PreparedStatement#setBigDecimal(int, BigDecimal).
setBlob(parameterIndex, x) voidFor documentation of this method, see java.sql.PreparedStatement#setBlob(int, Clob).
setBoolean(parameterIndex, x) voidFor documentation of this method, see java.sql.PreparedStatement#setBoolean(int, boolean).
setByte(parameterIndex, x) voidFor documentation of this method, see java.sql.PreparedStatement#setByte(int, byte).
setBytes(parameterIndex, x) voidFor documentation of this method, see java.sql.PreparedStatement#setBytes(int, byte[]).
setClob(parameterIndex, x) voidFor documentation of this method, see java.sql.PreparedStatement#setClob(int, Clob).
setCursorName(name) voidFor documentation of this method, see java.sql.Statement#setCursorName(String).
setDate(parameterIndex, x) voidFor documentation of this method, see java.sql.PreparedStatement#setDate(int, Date).
setDate(parameterIndex, x, timeZone) voidFor documentation of this method, see java.sql.PreparedStatement#setDate(int, Date, Calendar).
setDouble(parameterIndex, x) voidFor documentation of this method, see java.sql.PreparedStatement#setDouble(int, double).
setEscapeProcessing(enable) voidFor documentation of this method, see java.sql.Statement#setEscapeProcessing(boolean).
setFetchDirection(direction) voidFor documentation of this method, see java.sql.Statement#setFetchDirection(int).
setFetchSize(rows) voidFor documentation of this method, see java.sql.Statement#setFetchSize(int).
setFloat(parameterIndex, x) voidFor documentation of this method, see java.sql.PreparedStatement#setFloat(int, float).
setInt(parameterIndex, x) voidFor documentation of this method, see java.sql.PreparedStatement#setInt(int, int).
setLong(parameterIndex, x) voidFor documentation of this method, see java.sql.PreparedStatement#setLong(int, long).
setMaxFieldSize(max) voidFor documentation of this method, see java.sql.Statement#setMaxFieldSize(int).
setMaxRows(max) voidFor documentation of this method, see java.sql.Statement#setMaxRows(int).
setNClob(parameterIndex, x) voidFor documentation of this method, see java.sql.PreparedStatement#setNClob(int, NClob).
setNString(parameterIndex, x) voidFor documentation of this method, see java.sql.PreparedStatement#setNString(int, String).
setNull(parameterIndex, sqlType) voidFor documentation of this method, see java.sql.PreparedStatement#setNull(int, int).
setNull(parameterIndex, sqlType, typeName) voidFor documentation of this method, see java.sql.PreparedStatement#setNull(int, int, String).
setObject(index, x) voidFor documentation of this method, see java.sql.PreparedStatement#setObject(int, Object).
setObject(parameterIndex, x, targetSqlType) voidFor documentation of this method, see java.sql.PreparedStatement#setObject(int, Object, int).
setObject(parameterIndex, x, targetSqlType, scaleOrLength) voidFor documentation of this method, see java.sql.PreparedStatement#setObject(int, Object, int, int).
setPoolable(poolable) voidFor documentation of this method, see java.sql.Statement#setPoolable(boolean).
setQueryTimeout(seconds) voidFor documentation of this method, see java.sql.Statement#setQueryTimeout(int).
setRef(parameterIndex, x) voidFor documentation of this method, see java.sql.PreparedStatement#setRef(int, Ref).
setRowId(parameterIndex, x) voidFor documentation of this method, see java.sql.PreparedStatement#setRowId(int, RowId).
setSQLXML(parameterIndex, x) voidFor documentation of this method, see java.sql.PreparedStatement#setSQLXML(int, SQLXML).
setShort(parameterIndex, x) voidFor documentation of this method, see java.sql.PreparedStatement#setShort(int, short).
setString(parameterIndex, x) voidFor documentation of this method, see java.sql.PreparedStatement#setString(int, String).
setTime(parameterIndex, x) voidFor documentation of this method, see java.sql.PreparedStatement#setTime(int, Time).
setTime(parameterIndex, x, timeZone) voidFor documentation of this method, see java.sql.PreparedStatement#setTime(int, Time, Calendar).
setTimestamp(parameterIndex, x) voidFor documentation of this method, see java.sql.PreparedStatement#setTimestamp(int, Timestamp).
setTimestamp(parameterIndex, x, timeZone) voidFor documentation of this method, see java.sql.PreparedStatement#setTimestamp(int, Timestamp, Calendar).
setURL(parameterIndex, x) voidFor documentation of this method, see java.sql.PreparedStatement#setURL(int, URL).

JdbcRef

Methods

MethodReturn typeBrief description
getBaseTypeName() StringFor documentation of this method, see java.sql.Ref#getBaseTypeName().
getObject() ObjectFor documentation of this method, see java.sql.Ref#getObject().
setObject(object) voidFor documentation of this method, see java.sql.Ref#setObject(Object).

JdbcResultSet

Methods

MethodReturn typeBrief description
absolute(row) BooleanFor documentation of this method, see java.sql.ResultSet#absolute(int).
afterLast() voidFor documentation of this method, see java.sql.ResultSet#afterLast().
beforeFirst() voidFor documentation of this method, see java.sql.ResultSet#beforeFirst().
cancelRowUpdates() voidFor documentation of this method, see java.sql.ResultSet#cancelRowUpdates().
clearWarnings() voidFor documentation of this method, see java.sql.ResultSet#clearWarnings().
close() voidFor documentation of this method, see java.sql.ResultSet#close().
deleteRow() voidFor documentation of this method, see java.sql.ResultSet#deleteRow().
findColumn(columnLabel) IntegerFor documentation of this method, see java.sql.ResultSet#findColumn(String).
first() BooleanFor documentation of this method, see java.sql.ResultSet#first().
getArray(columnIndex) JdbcArray For documentation of this method, see java.sql.ResultSet#getArray(int).
getArray(columnLabel) JdbcArray For documentation of this method, see java.sql.ResultSet#getArray(String).
getBigDecimal(columnIndex) BigNumberFor documentation of this method, see java.sql.ResultSet#getBigDecimal(int).
getBigDecimal(columnLabel) BigNumberFor documentation of this method, see java.sql.ResultSet#getBigDecimal(String).
getBlob(columnIndex) JdbcBlob For documentation of this method, see java.sql.ResultSet#getBlob(int).
getBlob(columnLabel) JdbcBlob For documentation of this method, see java.sql.ResultSet#getBlob(String).
getBoolean(columnIndex) BooleanFor documentation of this method, see java.sql.ResultSet#getBoolean(int).
getBoolean(columnLabel) BooleanFor documentation of this method, see java.sql.ResultSet#getBoolean(String).
getByte(columnIndex) ByteFor documentation of this method, see java.sql.ResultSet#getByte(int).
getByte(columnLabel) ByteFor documentation of this method, see java.sql.ResultSet#getByte(String).
getBytes(columnIndex) Byte[]For documentation of this method, see java.sql.ResultSet#getBytes(int).
getBytes(columnLabel) Byte[]For documentation of this method, see java.sql.ResultSet#getBytes(String).
getClob(columnIndex) JdbcClob For documentation of this method, see java.sql.ResultSet#getClob(int).
getClob(columnLabel) JdbcClob For documentation of this method, see java.sql.ResultSet#getClob(String).
getConcurrency() IntegerFor documentation of this method, see java.sql.ResultSet#getConcurrency().
getCursorName() StringFor documentation of this method, see java.sql.ResultSet#getCursorName().
getDate(columnIndex) JdbcDate For documentation of this method, see java.sql.ResultSet#getDate(int).
getDate(columnIndex, timeZone) JdbcDate For documentation of this method, see java.sql.ResultSet#getDate(int, Calendar).
getDate(columnLabel) JdbcDate For documentation of this method, see java.sql.ResultSet#getDate(String).
getDate(columnLabel, timeZone) JdbcDate For documentation of this method, see java.sql.ResultSet#getDate(String, Calendar).
getDouble(columnIndex) NumberFor documentation of this method, see java.sql.ResultSet#getDouble(int).
getDouble(columnLabel) NumberFor documentation of this method, see java.sql.ResultSet#getDouble(String).
getFetchDirection() IntegerFor documentation of this method, see java.sql.ResultSet#getFetchDirection().
getFetchSize() IntegerFor documentation of this method, see java.sql.ResultSet#getFetchSize().
getFloat(columnIndex) NumberFor documentation of this method, see java.sql.ResultSet#getFloat(int).
getFloat(columnLabel) NumberFor documentation of this method, see java.sql.ResultSet#getFloat(String).
getHoldability() IntegerFor documentation of this method, see java.sql.ResultSet#getHoldability().
getInt(columnIndex) IntegerFor documentation of this method, see java.sql.ResultSet#getInt(int).
getInt(columnLabel) IntegerFor documentation of this method, see java.sql.ResultSet#getInt(String).
getLong(columnIndex) IntegerFor documentation of this method, see java.sql.ResultSet#getLong(int).
getLong(columnLabel) IntegerFor documentation of this method, see java.sql.ResultSet#getLong(String).
getMetaData() JdbcResultSetMetaData For documentation of this method, see java.sql.ResultSet#getMetaData().
getNClob(columnIndex) JdbcClob For documentation of this method, see java.sql.ResultSet#getNClob(int).
getNClob(columnLabel) JdbcClob For documentation of this method, see java.sql.ResultSet#getNClob(String).
getNString(columnIndex) StringFor documentation of this method, see java.sql.ResultSet#getNString(int).
getNString(columnLabel) StringFor documentation of this method, see java.sql.ResultSet#getNString(String).
getObject(columnIndex) ObjectFor documentation of this method, see java.sql.ResultSet#getObject(int).
getObject(columnLabel) ObjectFor documentation of this method, see java.sql.ResultSet#getObject(String).
getRef(columnIndex) JdbcRef For documentation of this method, see java.sql.ResultSet#getRef(int).
getRef(columnLabel) JdbcRef For documentation of this method, see java.sql.ResultSet#getRef(String).
getRow() IntegerFor documentation of this method, see java.sql.ResultSet#getRow().
getRowId(columnIndex) JdbcRowId For documentation of this method, see java.sql.ResultSet#getRowId(int).
getRowId(columnLabel) JdbcRowId For documentation of this method, see java.sql.ResultSet#getRowId(String).
getRows(queryString) Object[][]Returns all the rows from this ResultSet object.
getRows(queryString, batchSize) Object[][]Returns up to batchSize rows from this ResultSet object.
getSQLXML(columnIndex) JdbcSQLXML For documentation of this method, see java.sql.ResultSet#getSQLXML(int).
getSQLXML(columnLabel) JdbcSQLXML For documentation of this method, see java.sql.ResultSet#getSQLXML(String).
getShort(columnIndex) IntegerFor documentation of this method, see java.sql.ResultSet#getShort(int).
getShort(columnLabel) IntegerFor documentation of this method, see java.sql.ResultSet#getShort(String).
getStatement() JdbcStatement For documentation of this method, see java.sql.ResultSet#getStatement().
getString(columnIndex) StringFor documentation of this method, see java.sql.ResultSet#getString(int).
getString(columnLabel) StringFor documentation of this method, see java.sql.ResultSet#getString(String).
getTime(columnIndex) JdbcTime For documentation of this method, see java.sql.ResultSet#getTime(int).
getTime(columnIndex, timeZone) JdbcTime For documentation of this method, see java.sql.ResultSet#getTime(int, Calendar).
getTime(columnLabel) JdbcTime For documentation of this method, see java.sql.ResultSet#getTime(String).
getTime(columnLabel, timeZone) JdbcTime For documentation of this method, see java.sql.ResultSet#getTime(String, Calendar).
getTimestamp(columnIndex) JdbcTimestamp For documentation of this method, see java.sql.ResultSet#getTimestamp(int).
getTimestamp(columnIndex, timeZone) JdbcTimestamp For documentation of this method, see java.sql.ResultSet#getTimestamp(int, Calendar).
getTimestamp(columnLabel) JdbcTimestamp For documentation of this method, see java.sql.ResultSet#getTimestamp(String).
getTimestamp(columnLabel, timeZone) JdbcTimestamp For documentation of this method, see java.sql.ResultSet#getTimestamp(String, Calendar).
getType() IntegerFor documentation of this method, see java.sql.ResultSet#getType().
getURL(columnIndex) StringFor documentation of this method, see java.sql.ResultSet#getURL(int).
getURL(columnLabel) StringFor documentation of this method, see java.sql.ResultSet#getURL(String).
getWarnings() String[]Returns the current set of warnings reported by the driver.
insertRow() voidFor documentation of this method, see java.sql.ResultSet#insertRow().
isAfterLast() BooleanFor documentation of this method, see java.sql.ResultSet#isAfterLast().
isBeforeFirst() BooleanFor documentation of this method, see java.sql.ResultSet#isBeforeFirst().
isClosed() BooleanFor documentation of this method, see java.sql.ResultSet#isClosed().
isFirst() BooleanFor documentation of this method, see java.sql.ResultSet#isFirst().
isLast() BooleanFor documentation of this method, see java.sql.ResultSet#isLast().
last() BooleanFor documentation of this method, see java.sql.ResultSet#first().
moveToCurrentRow() voidFor documentation of this method, see java.sql.ResultSet#moveToCurrentRow().
moveToInsertRow() voidFor documentation of this method, see java.sql.ResultSet#moveToInsertRow().
next() BooleanFor documentation of this method, see java.sql.ResultSet#next().
previous() BooleanFor documentation of this method, see java.sql.ResultSet#previous().
refreshRow() voidFor documentation of this method, see java.sql.ResultSet#refreshRow().
relative(rows) BooleanFor documentation of this method, see java.sql.ResultSet#relative(int).
rowDeleted() BooleanFor documentation of this method, see java.sql.ResultSet#rowDeleted().
rowInserted() BooleanFor documentation of this method, see java.sql.ResultSet#rowInserted().
rowUpdated() BooleanFor documentation of this method, see java.sql.ResultSet#rowUpdated().
setFetchDirection(direction) voidFor documentation of this method, see java.sql.ResultSet#setFetchDirection(int).
setFetchSize(rows) voidFor documentation of this method, see java.sql.ResultSet#setFetchSize(int).
updateArray(columnIndex, x) voidFor documentation of this method, see java.sql.ResultSet#updateArray(int, Array).
updateArray(columnLabel, x) voidFor documentation of this method, see java.sql.ResultSet#updateArray(String, Array).
updateBigDecimal(columnIndex, x) voidFor documentation of this method, see java.sql.ResultSet#updateBigDecimal(int, BigDecimal).
updateBigDecimal(columnLabel, x) voidFor documentation of this method, see java.sql.ResultSet#updateBigDecimal(String, BigDecimal).
updateBlob(columnIndex, x) voidFor documentation of this method, see java.sql.ResultSet#updateBlob(int, Blob).
updateBlob(columnLabel, x) voidFor documentation of this method, see java.sql.ResultSet#updateRef(String, Blob).
updateBoolean(columnIndex, x) voidFor documentation of this method, see java.sql.ResultSet#updateBoolean(int, boolean).
updateBoolean(columnLabel, x) voidFor documentation of this method, see java.sql.ResultSet#updateBoolean(String, boolean).
updateByte(columnIndex, x) voidFor documentation of this method, see java.sql.ResultSet#updateByte(int, byte).
updateByte(columnLabel, x) voidFor documentation of this method, see java.sql.ResultSet#updateByte(String, byte).
updateBytes(columnIndex, x) voidFor documentation of this method, see java.sql.ResultSet#updateBytes(int, byte[]).
updateBytes(columnLabel, x) voidFor documentation of this method, see java.sql.ResultSet#updateBytes(String, byte[]).
updateClob(columnIndex, x) voidFor documentation of this method, see java.sql.ResultSet#updateClob(int, Clob).
updateClob(columnLabel, x) voidFor documentation of this method, see java.sql.ResultSet#updateClob(String, Clob).
updateDate(columnIndex, x) voidFor documentation of this method, see java.sql.ResultSet#updateDate(int, Date).
updateDate(columnLabel, x) voidFor documentation of this method, see java.sql.ResultSet#updateDate(String, Date).
updateDouble(columnIndex, x) voidFor documentation of this method, see java.sql.ResultSet#updateDouble(int, double).
updateDouble(columnLabel, x) voidFor documentation of this method, see java.sql.ResultSet#updateDouble(String, double).
updateFloat(columnIndex, x) voidFor documentation of this method, see java.sql.ResultSet#updateFloat(int, float).
updateFloat(columnLabel, x) voidFor documentation of this method, see java.sql.ResultSet#updateFloat(String, float).
updateInt(columnIndex, x) voidFor documentation of this method, see java.sql.ResultSet#updateInt(int, int).
updateInt(columnLabel, x) voidFor documentation of this method, see java.sql.ResultSet#updateInt(String, int).
updateLong(columnIndex, x) voidFor documentation of this method, see java.sql.ResultSet#updateLong(int, long).
updateLong(columnLabel, x) voidFor documentation of this method, see java.sql.ResultSet#updateLong(String, long).
updateNClob(columnIndex, x) voidFor documentation of this method, see java.sql.ResultSet#updateNClob(int, NClob).
updateNClob(columnLabel, x) voidFor documentation of this method, see java.sql.ResultSet#updateNClob(String, NClob).
updateNString(columnIndex, x) voidFor documentation of this method, see java.sql.ResultSet#updateNString(int, String).
updateNString(columnLabel, x) voidFor documentation of this method, see java.sql.ResultSet#updateNString(String, String).
updateNull(columnIndex) voidFor documentation of this method, see java.sql.ResultSet#updateNull(int).
updateNull(columnLabel) voidFor documentation of this method, see java.sql.ResultSet#updateNull(String).
updateObject(columnIndex, x) voidFor documentation of this method, see java.sql.ResultSet#updateObject(int, Object).
updateObject(columnIndex, x, scaleOrLength) voidFor documentation of this method, see java.sql.ResultSet#updateObject(int, Object, int).
updateObject(columnLabel, x) voidFor documentation of this method, see java.sql.ResultSet#updateObject(String, Object).
updateObject(columnLabel, x, scaleOrLength) voidFor documentation of this method, see java.sql.ResultSet#updateObject(String, Object, int).
updateRef(columnIndex, x) voidFor documentation of this method, see java.sql.ResultSet#updateRef(int, Ref).
updateRef(columnLabel, x) voidFor documentation of this method, see java.sql.ResultSet#updateRef(String, Ref).
updateRow() voidFor documentation of this method, see java.sql.ResultSet#updateRow().
updateRowId(columnIndex, x) voidFor documentation of this method, see java.sql.ResultSet#updateRowId(int, RowId).
updateRowId(columnLabel, x) voidFor documentation of this method, see java.sql.ResultSet#updateRowId(String, RowId).
updateSQLXML(columnIndex, x) voidFor documentation of this method, see java.sql.ResultSet#updateSQLXML(int, SQLXML).
updateSQLXML(columnLabel, x) voidFor documentation of this method, see java.sql.ResultSet#updateSQLXML(String, SQLXML).
updateShort(columnIndex, x) voidFor documentation of this method, see java.sql.ResultSet#updateShort(int, short).
updateShort(columnLabel, x) voidFor documentation of this method, see java.sql.ResultSet#updateShort(String, short).
updateString(columnIndex, x) voidFor documentation of this method, see java.sql.ResultSet#updateString(int, String).
updateString(columnLabel, x) voidFor documentation of this method, see java.sql.ResultSet#updateString(String, String).
updateTime(columnIndex, x) voidFor documentation of this method, see java.sql.ResultSet#updateTime(int, Time).
updateTime(columnLabel, x) voidFor documentation of this method, see java.sql.ResultSet#updateTime(String, Time).
updateTimestamp(columnIndex, x) voidFor documentation of this method, see java.sql.ResultSet#updateTimestamp(int, Timestamp).
updateTimestamp(columnLabel, x) voidFor documentation of this method, see java.sql.ResultSet#updateTimestamp(String, Timestamp).
wasNull() BooleanFor documentation of this method, see java.sql.ResultSet#wasNull().

JdbcResultSetMetaData

Methods

MethodReturn typeBrief description
getCatalogName(column) StringFor documentation of this method, see java.sql.ResultSetMetaData#getCatalogName(int).
getColumnClassName(column) StringFor documentation of this method, see java.sql.ResultSetMetaData#getColumnClassName(int).
getColumnCount() IntegerFor documentation of this method, see java.sql.ResultSetMetaData#getColumnCount().
getColumnDisplaySize(column) IntegerFor documentation of this method, see java.sql.ResultSetMetaData#getColumnDisplaySize(int).
getColumnLabel(column) StringFor documentation of this method, see java.sql.ResultSetMetaData#getColumnLabel(int).
getColumnName(column) StringFor documentation of this method, see java.sql.ResultSetMetaData#getColumnName(int).
getColumnType(column) IntegerFor documentation of this method, see java.sql.ResultSetMetaData#getColumnType(int).
getColumnTypeName(column) StringFor documentation of this method, see java.sql.ResultSetMetaData#getColumnTypeName(int).
getPrecision(column) IntegerFor documentation of this method, see java.sql.ResultSetMetaData#getPrecision(int).
getScale(column) IntegerFor documentation of this method, see java.sql.ResultSetMetaData#getScale(int).
getSchemaName(column) StringFor documentation of this method, see java.sql.ResultSetMetaData#getSchemaName(int).
getTableName(column) StringFor documentation of this method, see java.sql.ResultSetMetaData#getTableName(int).
isAutoIncrement(column) BooleanFor documentation of this method, see java.sql.ResultSetMetaData#isAutoIncrement(int).
isCaseSensitive(column) BooleanFor documentation of this method, see java.sql.ResultSetMetaData#isCaseSensitive(int).
isCurrency(column) BooleanFor documentation of this method, see java.sql.ResultSetMetaData#isCurrency(int).
isDefinitelyWritable(column) BooleanFor documentation of this method, see java.sql.ResultSetMetaData#isDefinitelyWritable(int).
isNullable(column) IntegerFor documentation of this method, see java.sql.ResultSetMetaData#isNullable(int).
isReadOnly(column) BooleanFor documentation of this method, see java.sql.ResultSetMetaData#isReadOnly(int).
isSearchable(column) BooleanFor documentation of this method, see java.sql.ResultSetMetaData#isSearchable(int).
isSigned(column) BooleanFor documentation of this method, see java.sql.ResultSetMetaData#isSigned(int).
isWritable(column) BooleanFor documentation of this method, see java.sql.ResultSetMetaData#isWritable(int).

JdbcRowId

Methods

MethodReturn typeBrief description
getBytes() Byte[]For documentation of this method, see java.sql.RowId#getBytes().

JdbcSQLXML

Methods

MethodReturn typeBrief description
free() voidFor documentation of this method, see java.sql.SQLXML#free().
getString() StringFor documentation of this method, see java.sql.SQLXML#getString().
setString(value) voidFor documentation of this method, see java.sql.SQLXML#setString(String).

JdbcSavepoint

Methods

MethodReturn typeBrief description
getSavepointId() IntegerFor documentation of this method, see java.sql.Savepoint#getSavepointId().
getSavepointName() StringFor documentation of this method, see java.sql.Savepoint#getSavepointName().

JdbcStatement

Methods

MethodReturn typeBrief description
addBatch(sql) voidFor documentation of this method, see java.sql.Statement#addBatch(String).
cancel() voidFor documentation of this method, see java.sql.Statement#cancel().
clearBatch() voidFor documentation of this method, see java.sql.Statement#clearBatch().
clearWarnings() voidFor documentation of this method, see java.sql.Statement#clearWarnings().
close() voidFor documentation of this method, see java.sql.Statement#close().
execute(sql) BooleanFor documentation of this method, see java.sql.Statement#execute(String).
execute(sql, autoGeneratedKeys) BooleanFor documentation of this method, see java.sql.Statement#execute(String, int).
execute(sql, columnIndexes) BooleanFor documentation of this method, see java.sql.Statement#execute(String, int[]).
execute(sql, columnNames) BooleanFor documentation of this method, see java.sql.Statement#execute(String, String[]).
executeBatch() Integer[]For documentation of this method, see java.sql.Statement#executeBatch().
executeQuery(sql) JdbcResultSet For documentation of this method, see java.sql.Statement#executeQuery(String).
executeUpdate(sql) IntegerFor documentation of this method, see java.sql.Statement#executeUpdate(String).
executeUpdate(sql, autoGeneratedKeys) IntegerFor documentation of this method, see java.sql.Statement#executeUpdate(String, int).
executeUpdate(sql, columnIndexes) IntegerFor documentation of this method, see java.sql.Statement#executeUpdate(String, int[]).
executeUpdate(sql, columnNames) IntegerFor documentation of this method, see java.sql.Statement#executeUpdate(String, String[]).
getConnection() JdbcConnection For documentation of this method, see java.sql.Statement#getConnection().
getFetchDirection() IntegerFor documentation of this method, see java.sql.Statement#getFetchDirection().
getFetchSize() IntegerFor documentation of this method, see java.sql.Statement#getFetchSize().
getGeneratedKeys() JdbcResultSet For documentation of this method, see java.sql.Statement#getGeneratedKeys().
getMaxFieldSize() IntegerFor documentation of this method, see java.sql.Statement#getMaxFieldSize().
getMaxRows() IntegerFor documentation of this method, see java.sql.Statement#getMaxRows().
getMoreResults() BooleanFor documentation of this method, see java.sql.Statement#getMoreResults().
getMoreResults(current) BooleanFor documentation of this method, see java.sql.Statement#getMoreResults(int).
getQueryTimeout() IntegerFor documentation of this method, see java.sql.Statement#getQueryTimeout().
getResultSet() JdbcResultSet For documentation of this method, see java.sql.Statement#getResultSet().
getResultSetConcurrency() IntegerFor documentation of this method, see java.sql.Statement#getResultSetConcurrency().
getResultSetHoldability() IntegerFor documentation of this method, see java.sql.Statement#getResultSetHoldability().
getResultSetType() IntegerFor documentation of this method, see java.sql.Statement#getResultSetType().
getUpdateCount() IntegerFor documentation of this method, see java.sql.Statement#getUpdateCount().
getWarnings() String[]For documentation of this method, see java.sql.Statement#getWarnings().
isClosed() BooleanFor documentation of this method, see java.sql.Statement#isClosed().
isPoolable() BooleanFor documentation of this method, see java.sql.Statement#isPoolable().
setCursorName(name) voidFor documentation of this method, see java.sql.Statement#setCursorName(String).
setEscapeProcessing(enable) voidFor documentation of this method, see java.sql.Statement#setEscapeProcessing(boolean).
setFetchDirection(direction) voidFor documentation of this method, see java.sql.Statement#setFetchDirection(int).
setFetchSize(rows) voidFor documentation of this method, see java.sql.Statement#setFetchSize(int).
setMaxFieldSize(max) voidFor documentation of this method, see java.sql.Statement#setMaxFieldSize(int).
setMaxRows(max) voidFor documentation of this method, see java.sql.Statement#setMaxRows(int).
setPoolable(poolable) voidFor documentation of this method, see java.sql.Statement#setPoolable(boolean).
setQueryTimeout(seconds) voidFor documentation of this method, see java.sql.Statement#setQueryTimeout(int).

JdbcStruct

Methods

MethodReturn typeBrief description
getAttributes() Object[]For documentation of this method, see java.sql.Struct#getAttributes().
getSQLTypeName() StringFor documentation of this method, see java.sql.Struct#getSQLTypeName().

JdbcTime

Methods

MethodReturn typeBrief description
after(when) BooleanFor documentation of this method, see java.sql.Date#after(Date).
before(when) BooleanFor documentation of this method, see java.sql.Date#before(Date).
getHours() IntegerFor documentation of this method, see java.sql.Date#getHours().
getMinutes() IntegerFor documentation of this method, see java.sql.Date#getMinutes().
getSeconds() IntegerFor documentation of this method, see java.sql.Date#getSeconds().
getTime() IntegerFor documentation of this method, see java.sql.Date#getTime().
setHours(hours) voidFor documentation of this method, see java.sql.Date#setHours(int).
setMinutes(minutes) voidFor documentation of this method, see java.sql.Date#setMinutes(int).
setSeconds(seconds) voidFor documentation of this method, see java.sql.Date#setSeconds(int).
setTime(milliseconds) voidFor documentation of this method, see java.sql.Time#setTime(long).

JdbcTimestamp

Methods

MethodReturn typeBrief description
after(when) BooleanFor documentation of this method, see java.sql.Timestamp#after(Timestamp).
before(when) BooleanFor documentation of this method, see java.sql.Timestamp#before(Timestamp).
getDate() IntegerFor documentation of this method, see java.sql.Date#getDate().
getHours() IntegerFor documentation of this method, see java.sql.Date#getHours().
getMinutes() IntegerFor documentation of this method, see java.sql.Date#getMinutes().
getMonth() IntegerFor documentation of this method, see java.sql.Date#getMonth().
getNanos() IntegerFor documentation of this method, see java.sql.Timestamp#getNanos().
getSeconds() IntegerFor documentation of this method, see java.sql.Date#getSeconds().
getTime() IntegerFor documentation of this method, see java.sql.Timestamp#getTime().
getYear() IntegerFor documentation of this method, see java.sql.Date#getYear().
setDate(date) voidFor documentation of this method, see java.sql.Date#setDate(int).
setHours(hours) voidFor documentation of this method, see java.sql.Date#setHours(int).
setMinutes(minutes) voidFor documentation of this method, see java.sql.Date#setMinutes(int).
setMonth(month) voidFor documentation of this method, see java.sql.Date#setMonth(int).
setNanos(nanoseconds) voidFor documentation of this method, see java.sql.Timestamp#setNanos(int).
setSeconds(seconds) voidFor documentation of this method, see java.sql.Date#setSeconds(int).
setTime(milliseconds) voidFor documentation of this method, see java.sql.Timestamp#setTime(long).
setYear(year) voidFor documentation of this method, see java.sql.Date#setYear(int).

Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2025年11月13日 UTC.