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
Name | Brief description |
---|---|
Jdbc
|
The JDBC service allows scripts to connect to Google Cloud SQL , MySQL, Microsoft SQL Server, and Oracle databases. |
Jdbc
|
A JDBC Array
. |
Jdbc
|
A JDBC Blob
. |
Jdbc
|
A JDBC Callable
. |
Jdbc
|
A JDBC Clob
. |
Jdbc
|
A JDBC Connection
. |
Jdbc
|
A JDBC database metadata object. |
Jdbc
|
A JDBC Date
. |
Jdbc
|
A JDBC Parameter
. |
Jdbc
|
A JDBC Prepared
. |
Jdbc
|
A JDBC Ref
. |
Jdbc
|
A JDBC Result
. |
Jdbc
|
A JDBC Result
. |
Jdbc
|
A JDBC Row
. |
Jdbc
|
A JDBC SQLXML
. |
Jdbc
|
A JDBC Savepoint
. |
Jdbc
|
A JDBC Statement
. |
Jdbc
|
A JDBC Struct
. |
Jdbc
|
A JDBC Time
. |
Jdbc
|
A JDBC Timestamp
. |
Jdbc
Methods
Method | Return type | Brief description |
---|---|---|
Jdbc
|
Attempts to establish a connection to the given Google Cloud SQL URL. | |
Jdbc
|
Attempts to establish a connection to the given Google Cloud SQL URL. | |
Jdbc
|
Attempts to establish a connection to the given Google Cloud SQL URL. | |
Jdbc
|
Attempts to establish a connection to the given database URL. | |
Jdbc
|
Attempts to establish a connection to the given database URL. | |
Jdbc
|
Attempts to establish a connection to the given database using a username and password. | |
Jdbc
|
Create a date from milliseconds since epoch. | |
Jdbc
|
Create a time from milliseconds since epoch. | |
Jdbc
|
Create a timestamp from milliseconds since epoch. | |
Jdbc
|
Create a date by parsing the SQL date string. | |
Jdbc
|
Create a time by parsing the SQL time string. | |
Jdbc
|
Create a timestamp by parsing the SQL timestamp string. |
Jdbc
Array
Methods
Method | Return type | Brief description |
---|---|---|
void
|
For documentation of this method, see java.sql.Array#free()
. |
|
Object
|
For documentation of this method, see java.sql.Array#getArray()
|
|
Object
|
For documentation of this method, see java.sql.Array#getArray(long, int)
. |
|
Integer
|
For documentation of this method, see java.sql.Array#getBaseType()
. |
|
String
|
For documentation of this method, see java.sql.Array#getBaseTypeName()
. |
|
Jdbc
|
For documentation of this method, see java.sql.Array#getResultSet()
. |
|
Jdbc
|
For documentation of this method, see java.sql.Array#getResultSet(long, int)
. |
Jdbc
Blob
Methods
Method | Return type | Brief description |
---|---|---|
void
|
For documentation of this method, see java.sql.Blob#free()
. |
|
Blob
|
Gets the content of this JdbcBlob as an Apps Script blob. | |
Blob
|
Return the data inside this object as a blob converted to the specified content type. | |
Byte[]
|
For documentation of this method, see java.sql.Blob#getBytes(long, int)
. |
|
Integer
|
For documentation of this method, see java.sql.Blob#length()
. |
|
Integer
|
For documentation of this method, see java.sql.Blob#position(byte[], long)
. |
|
Integer
|
For documentation of this method, see java.sql.Blob#position(blob, long)
. |
|
Integer
|
Convenience method for writing a Jdbc
to this blob. |
|
Integer
|
Convenience method for writing a Jdbc
to this blob. |
|
Integer
|
For documentation of this method, see java.sql.Blob#setBytes(long, byte[])
. |
|
Integer
|
For documentation of this method, see java.sql.Blob#setBytes(long, byte[], int, int)
. |
|
void
|
For documentation of this method, see java.sql.Blob#truncate(long)
. |
Jdbc
Callable
Statement
Methods
Jdbc
Clob
Methods
Method | Return type | Brief description |
---|---|---|
void
|
For documentation of this method, see java.sql.Clob#truncate(long)
. |
|
Blob
|
Gets the content of this JdbcClob as an Apps Script blob. | |
Blob
|
Return the data inside this object as a blob converted to the specified content type. | |
String
|
For documentation of this method, see java.sql.Clob#getSubString(long, int)
. |
|
Integer
|
For documentation of this method, see java.sql.Clob#length()
. |
|
Integer
|
For documentation of this method, see java.sql.Clob#position(Clob, long)
. |
|
Integer
|
For documentation of this method, see java.sql.Clob#position(String, long)
. |
|
Integer
|
Convenience method for writing a Jdbc
to a clob. |
|
Integer
|
Convenience method for writing a Jdbc
to a clob. |
|
Integer
|
For documentation of this method, see java.sql.Clob#setString(long, String)
. |
|
Integer
|
For documentation of this method, see java.sql.Clob#setString(long, String, int, int)
. |
|
void
|
For documentation of this method, see java.sql.Clob#truncate(long)
. |
Jdbc
Connection
Methods
Method | Return type | Brief description |
---|---|---|
void
|
For documentation of this method, see java.sql.Connection#clearWarnings()
. |
|
void
|
Release this connection's database and all associated resources. | |
void
|
Makes all pending changes permanent, releases database locks held by this Jdbc
. |
|
Jdbc
|
For documentation of this method, see java.sql.Connection#createArrayOf(String, Object[])
. |
|
Jdbc
|
Constructs a Jdbc
instance. |
|
Jdbc
|
For documentation of this method, see java.sql.Connection#createClob()
. |
|
Jdbc
|
For documentation of this method, see java.sql.Connection#createNClob()
. |
|
Jdbc
|
For documentation of this method, see java.sql.Connection#createSQLXML()
. |
|
Jdbc
|
Creates a Jdbc
object for sending SQL statements to the database. |
|
Jdbc
|
Creates a Jdbc
object for sending SQL statements to the database. |
|
Jdbc
|
Creates a Jdbc
object for sending SQL statements to the database. |
|
Jdbc
|
For documentation of this method, see java.sql.Connection#createStruct(String, Object[])
. |
|
Boolean
|
For documentation of this method, see java.sql.Connection#getAutoCommit()
. |
|
String
|
or documentation of this method, see java.sql.Connection#getCatalog()
. |
|
Integer
|
For documentation of this method, see java.sql.Connection#getHoldability()
. |
|
Jdbc
|
For documentation of this method, see java.sql.Connection#getMetaData()
. |
|
Integer
|
For documentation of this method, see java.sql.Connection#getTransactionIsolation()
. |
|
String[]
|
For documentation of this method, see java.sql.Connection#getWarnings()
. |
|
Boolean
|
For documentation of this method, see java.sql.Connection#isClosed()
. |
|
Boolean
|
For documentation of this method, see java.sql.Connection#isReadOnly()
. |
|
Boolean
|
For documentation of this method, see java.sql.Connection#isValid(int)
. |
|
String
|
For documentation of this method, see java.sql.Connection#nativeSQL(String)
. |
|
Jdbc
|
For documentation of this method, see java.sql.Connection#prepareCall(String)
. |
|
Jdbc
|
For documentation of this method, see java.sql.Connection#prepareCall(String, int, int)
. |
|
Jdbc
|
For documentation of this method, see java.sql.Connection#prepareCall(String, int, int, int)
. |
|
Jdbc
|
For documentation of this method, see java.sql.Connection#prepareStatement(String)
. |
|
Jdbc
|
For documentation of this method, see java.sql.Connection#prepareStatement(String, int)
. |
|
Jdbc
|
For documentation of this method, see java.sql.Connection#prepareStatement(String, int, int)
. |
|
Jdbc
|
For documentation of this method, see java.sql.Connection#prepareStatement(String, int, int, int)
. |
|
Jdbc
|
For documentation of this method, see java.sql.Connection#prepareStatement(String, int[])
. |
|
Jdbc
|
For documentation of this method, see java.sql.Connection#prepareStatement(String, String[])
. |
|
void
|
For documentation of this method, see java.sql.Connection#releaseSavepoint(Savepoint)
. |
|
void
|
For documentation of this method, see java.sql.Connection#rollback()
. |
|
void
|
For documentation of this method, see java.sql.Connection#rollback(Savepoint)
. |
|
void
|
For documentation of this method, see java.sql.Connection#setAutoCommit(boolean)
. |
|
void
|
For documentation of this method, see java.sql.Connection#setCatalog(String)
. |
|
void
|
For documentation of this method, see java.sql.Connection#setHoldability(int)
. |
|
void
|
For documentation of this method, see java.sql.Connection#setReadOnly(boolean)
. |
|
Jdbc
|
For documentation of this method, see java.sql.Connection#setSavepoint()
. |
|
Jdbc
|
For documentation of this method, see java.sql.Connection#setSavepoint(String)
. |
|
void
|
For documentation of this method, see java.sql.Connection#setTransactionIsolation(int)
. |
Jdbc
Database
Meta
Data
Methods
Jdbc
Date
Methods
Method | Return type | Brief description |
---|---|---|
Boolean
|
For documentation of this method, see java.sql.Date#after(date)
. |
|
Boolean
|
For documentation of this method, see java.sql.Date#before(date)
. |
|
Integer
|
For documentation of this method, see java.sql.Date#getDate()
. |
|
Integer
|
For documentation of this method, see java.sql.Date#getMonth()
. |
|
Integer
|
For documentation of this method, see java.sql.Date#getTime()
. |
|
Integer
|
For documentation of this method, see java.sql.Date#getYear()
. |
|
void
|
For documentation of this method, see java.sql.Date#setDate(int)
. |
|
void
|
For documentation of this method, see java.sql.Date#setMonth(int)
. |
|
void
|
For documentation of this method, see java.sql.Date#setTime(int)
. |
|
void
|
For documentation of this method, see java.sql.Date#setYear(int)
. |
Jdbc
Parameter
Meta
Data
Methods
Method | Return type | Brief description |
---|---|---|
String
|
For documentation of this method, see java.sql.ParameterMetaData#getParameterClassName(int)
. |
|
Integer
|
For documentation of this method, see java.sql.ParameterMetaData#getParameterCount()
. |
|
Integer
|
For documentation of this method, see java.sql.ParameterMetaData#getParameterMode(int)
. |
|
Integer
|
For documentation of this method, see java.sql.ParameterMetaData#getParameterType(int)
. |
|
String
|
For documentation of this method, see java.sql.ParameterMetaData#getParameterTypeName(int)
. |
|
Integer
|
For documentation of this method, see java.sql.ParameterMetaData#getPrecision(int)
. |
|
Integer
|
For documentation of this method, see java.sql.ParameterMetaData#getScale(int)
. |
|
Integer
|
For documentation of this method, see java.sql.ParameterMetaData#isNullable(int)
. |
|
Boolean
|
For documentation of this method, see java.sql.ParameterMetaData#isSigned(int)
. |
Jdbc
Prepared
Statement
Methods
Method | Return type | Brief description |
---|---|---|
void
|
For documentation of this method, see java.sql.PreparedStatement#addBatch()
. |
|
void
|
For documentation of this method, see java.sql.Statement#addBatch(String)
. |
|
void
|
For documentation of this method, see java.sql.Statement#cancel()
. |
|
void
|
For documentation of this method, see java.sql.Statement#clearBatch()
. |
|
void
|
For documentation of this method, see java.sql.PreparedStatement#clearParameters()
. |
|
void
|
For documentation of this method, see java.sql.Statement#clearWarnings()
. |
|
void
|
For documentation of this method, see java.sql.Statement#close()
. |
|
Boolean
|
For documentation of this method, see java.sql.PreparedStatement#execute()
. |
|
Boolean
|
For documentation of this method, see java.sql.Statement#execute(String)
. |
|
Boolean
|
For documentation of this method, see java.sql.Statement#execute(String, int)
. |
|
Boolean
|
For documentation of this method, see java.sql.Statement#execute(String, int[])
. |
|
Boolean
|
For documentation of this method, see java.sql.Statement#execute(String, String[])
. |
|
Integer[]
|
For documentation of this method, see java.sql.Statement#executeBatch()
. |
|
Jdbc
|
For documentation of this method, see java.sql.PreparedStatement#executeQuery()
. |
|
Jdbc
|
For documentation of this method, see java.sql.Statement#executeQuery(String)
. |
|
Integer
|
For documentation of this method, see java.sql.PreparedStatement#executeUpdate()
. |
|
Integer
|
For documentation of this method, see java.sql.Statement#executeUpdate(String)
. |
|
Integer
|
For documentation of this method, see java.sql.Statement#executeUpdate(String, int)
. |
|
Integer
|
For documentation of this method, see java.sql.Statement#executeUpdate(String, int[])
. |
|
Integer
|
For documentation of this method, see java.sql.Statement#executeUpdate(String, String[])
. |
|
Jdbc
|
For documentation of this method, see java.sql.Statement#getConnection()
. |
|
Integer
|
For documentation of this method, see java.sql.Statement#getFetchDirection()
. |
|
Integer
|
For documentation of this method, see java.sql.Statement#getFetchSize()
. |
|
Jdbc
|
For documentation of this method, see java.sql.Statement#getGeneratedKeys()
. |
|
Integer
|
For documentation of this method, see java.sql.Statement#getMaxFieldSize()
. |
|
Integer
|
For documentation of this method, see java.sql.Statement#getMaxRows()
. |
|
Jdbc
|
For documentation of this method, see java.sql.PreparedStatement#getMetaData()
. |
|
Boolean
|
For documentation of this method, see java.sql.Statement#getMoreResults()
. |
|
Boolean
|
For documentation of this method, see java.sql.Statement#getMoreResults(int)
. |
|
Jdbc
|
For documentation of this method, see java.sql.PreparedStatement#getParameterMetaData()
. |
|
Integer
|
For documentation of this method, see java.sql.Statement#getQueryTimeout()
. |
|
Jdbc
|
For documentation of this method, see java.sql.Statement#getResultSet()
. |
|
Integer
|
For documentation of this method, see java.sql.Statement#getResultSetConcurrency()
. |
|
Integer
|
For documentation of this method, see java.sql.Statement#getResultSetHoldability()
. |
|
Integer
|
For documentation of this method, see java.sql.Statement#getResultSetType()
. |
|
Integer
|
For documentation of this method, see java.sql.Statement#getUpdateCount()
. |
|
String[]
|
For documentation of this method, see java.sql.Statement#getWarnings()
. |
|
Boolean
|
For documentation of this method, see java.sql.Statement#isClosed()
. |
|
Boolean
|
For documentation of this method, see java.sql.Statement#isPoolable()
. |
|
void
|
For documentation of this method, see java.sql.PreparedStatement#setArray(int, Array)
. |
|
void
|
For documentation of this method, see java.sql.PreparedStatement#setBigDecimal(int, BigDecimal)
. |
|
void
|
For documentation of this method, see java.sql.PreparedStatement#setBlob(int, Clob)
. |
|
void
|
For documentation of this method, see java.sql.PreparedStatement#setBoolean(int, boolean)
. |
|
void
|
For documentation of this method, see java.sql.PreparedStatement#setByte(int, byte)
. |
|
void
|
For documentation of this method, see java.sql.PreparedStatement#setBytes(int, byte[])
. |
|
void
|
For documentation of this method, see java.sql.PreparedStatement#setClob(int, Clob)
. |
|
void
|
For documentation of this method, see java.sql.Statement#setCursorName(String)
. |
|
void
|
For documentation of this method, see java.sql.PreparedStatement#setDate(int, Date)
. |
|
void
|
For documentation of this method, see java.sql.PreparedStatement#setDate(int, Date, Calendar)
. |
|
void
|
For documentation of this method, see java.sql.PreparedStatement#setDouble(int, double)
. |
|
void
|
For documentation of this method, see java.sql.Statement#setEscapeProcessing(boolean)
. |
|
void
|
For documentation of this method, see java.sql.Statement#setFetchDirection(int)
. |
|
void
|
For documentation of this method, see java.sql.Statement#setFetchSize(int)
. |
|
void
|
For documentation of this method, see java.sql.PreparedStatement#setFloat(int, float)
. |
|
void
|
For documentation of this method, see java.sql.PreparedStatement#setInt(int, int)
. |
|
void
|
For documentation of this method, see java.sql.PreparedStatement#setLong(int, long)
. |
|
void
|
For documentation of this method, see java.sql.Statement#setMaxFieldSize(int)
. |
|
void
|
For documentation of this method, see java.sql.Statement#setMaxRows(int)
. |
|
void
|
For documentation of this method, see java.sql.PreparedStatement#setNClob(int, NClob)
. |
|
void
|
For documentation of this method, see java.sql.PreparedStatement#setNString(int, String)
. |
|
void
|
For documentation of this method, see java.sql.PreparedStatement#setNull(int, int)
. |
|
void
|
For documentation of this method, see java.sql.PreparedStatement#setNull(int, int, String)
. |
|
void
|
For documentation of this method, see java.sql.PreparedStatement#setObject(int, Object)
. |
|
void
|
For documentation of this method, see java.sql.PreparedStatement#setObject(int, Object, int)
. |
|
void
|
For documentation of this method, see java.sql.PreparedStatement#setObject(int, Object, int, int)
. |
|
void
|
For documentation of this method, see java.sql.Statement#setPoolable(boolean)
. |
|
void
|
For documentation of this method, see java.sql.Statement#setQueryTimeout(int)
. |
|
void
|
For documentation of this method, see java.sql.PreparedStatement#setRef(int, Ref)
. |
|
void
|
For documentation of this method, see java.sql.PreparedStatement#setRowId(int, RowId)
. |
|
void
|
For documentation of this method, see java.sql.PreparedStatement#setSQLXML(int, SQLXML)
. |
|
void
|
For documentation of this method, see java.sql.PreparedStatement#setShort(int, short)
. |
|
void
|
For documentation of this method, see java.sql.PreparedStatement#setString(int, String)
. |
|
void
|
For documentation of this method, see java.sql.PreparedStatement#setTime(int, Time)
. |
|
void
|
For documentation of this method, see java.sql.PreparedStatement#setTime(int, Time, Calendar)
. |
|
void
|
For documentation of this method, see java.sql.PreparedStatement#setTimestamp(int, Timestamp)
. |
|
void
|
For documentation of this method, see java.sql.PreparedStatement#setTimestamp(int, Timestamp, Calendar)
. |
|
void
|
For documentation of this method, see java.sql.PreparedStatement#setURL(int, URL)
. |
Jdbc
Ref
Methods
Method | Return type | Brief description |
---|---|---|
String
|
For documentation of this method, see java.sql.Ref#getBaseTypeName()
. |
|
Object
|
For documentation of this method, see java.sql.Ref#getObject()
. |
|
void
|
For documentation of this method, see java.sql.Ref#setObject(Object)
. |
Jdbc
Result
Set
Methods
Method | Return type | Brief description |
---|---|---|
Boolean
|
For documentation of this method, see java.sql.ResultSet#absolute(int)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#afterLast()
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#beforeFirst()
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#cancelRowUpdates()
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#clearWarnings()
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#close()
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#deleteRow()
. |
|
Integer
|
For documentation of this method, see java.sql.ResultSet#findColumn(String)
. |
|
Boolean
|
For documentation of this method, see java.sql.ResultSet#first()
. |
|
Jdbc
|
For documentation of this method, see java.sql.ResultSet#getArray(int)
. |
|
Jdbc
|
For documentation of this method, see java.sql.ResultSet#getArray(String)
. |
|
Big
|
For documentation of this method, see java.sql.ResultSet#getBigDecimal(int)
. |
|
Big
|
For documentation of this method, see java.sql.ResultSet#getBigDecimal(String)
. |
|
Jdbc
|
For documentation of this method, see java.sql.ResultSet#getBlob(int)
. |
|
Jdbc
|
For documentation of this method, see java.sql.ResultSet#getBlob(String)
. |
|
Boolean
|
For documentation of this method, see java.sql.ResultSet#getBoolean(int)
. |
|
Boolean
|
For documentation of this method, see java.sql.ResultSet#getBoolean(String)
. |
|
Byte
|
For documentation of this method, see java.sql.ResultSet#getByte(int)
. |
|
Byte
|
For documentation of this method, see java.sql.ResultSet#getByte(String)
. |
|
Byte[]
|
For documentation of this method, see java.sql.ResultSet#getBytes(int)
. |
|
Byte[]
|
For documentation of this method, see java.sql.ResultSet#getBytes(String)
. |
|
Jdbc
|
For documentation of this method, see java.sql.ResultSet#getClob(int)
. |
|
Jdbc
|
For documentation of this method, see java.sql.ResultSet#getClob(String)
. |
|
Integer
|
For documentation of this method, see java.sql.ResultSet#getConcurrency()
. |
|
String
|
For documentation of this method, see java.sql.ResultSet#getCursorName()
. |
|
Jdbc
|
For documentation of this method, see java.sql.ResultSet#getDate(int)
. |
|
Jdbc
|
For documentation of this method, see java.sql.ResultSet#getDate(int, Calendar)
. |
|
Jdbc
|
For documentation of this method, see java.sql.ResultSet#getDate(String)
. |
|
Jdbc
|
For documentation of this method, see java.sql.ResultSet#getDate(String, Calendar)
. |
|
Number
|
For documentation of this method, see java.sql.ResultSet#getDouble(int)
. |
|
Number
|
For documentation of this method, see java.sql.ResultSet#getDouble(String)
. |
|
Integer
|
For documentation of this method, see java.sql.ResultSet#getFetchDirection()
. |
|
Integer
|
For documentation of this method, see java.sql.ResultSet#getFetchSize()
. |
|
Number
|
For documentation of this method, see java.sql.ResultSet#getFloat(int)
. |
|
Number
|
For documentation of this method, see java.sql.ResultSet#getFloat(String)
. |
|
Integer
|
For documentation of this method, see java.sql.ResultSet#getHoldability()
. |
|
Integer
|
For documentation of this method, see java.sql.ResultSet#getInt(int)
. |
|
Integer
|
For documentation of this method, see java.sql.ResultSet#getInt(String)
. |
|
Integer
|
For documentation of this method, see java.sql.ResultSet#getLong(int)
. |
|
Integer
|
For documentation of this method, see java.sql.ResultSet#getLong(String)
. |
|
Jdbc
|
For documentation of this method, see java.sql.ResultSet#getMetaData()
. |
|
Jdbc
|
For documentation of this method, see java.sql.ResultSet#getNClob(int)
. |
|
Jdbc
|
For documentation of this method, see java.sql.ResultSet#getNClob(String)
. |
|
String
|
For documentation of this method, see java.sql.ResultSet#getNString(int)
. |
|
String
|
For documentation of this method, see java.sql.ResultSet#getNString(String)
. |
|
Object
|
For documentation of this method, see java.sql.ResultSet#getObject(int)
. |
|
Object
|
For documentation of this method, see java.sql.ResultSet#getObject(String)
. |
|
Jdbc
|
For documentation of this method, see java.sql.ResultSet#getRef(int)
. |
|
Jdbc
|
For documentation of this method, see java.sql.ResultSet#getRef(String)
. |
|
Integer
|
For documentation of this method, see java.sql.ResultSet#getRow()
. |
|
Jdbc
|
For documentation of this method, see java.sql.ResultSet#getRowId(int)
. |
|
Jdbc
|
For documentation of this method, see java.sql.ResultSet#getRowId(String)
. |
|
Jdbc
|
For documentation of this method, see java.sql.ResultSet#getSQLXML(int)
. |
|
Jdbc
|
For documentation of this method, see java.sql.ResultSet#getSQLXML(String)
. |
|
Integer
|
For documentation of this method, see java.sql.ResultSet#getShort(int)
. |
|
Integer
|
For documentation of this method, see java.sql.ResultSet#getShort(String)
. |
|
Jdbc
|
For documentation of this method, see java.sql.ResultSet#getStatement()
. |
|
String
|
For documentation of this method, see java.sql.ResultSet#getString(int)
. |
|
String
|
For documentation of this method, see java.sql.ResultSet#getString(String)
. |
|
Jdbc
|
For documentation of this method, see java.sql.ResultSet#getTime(int)
. |
|
Jdbc
|
For documentation of this method, see java.sql.ResultSet#getTime(int, Calendar)
. |
|
Jdbc
|
For documentation of this method, see java.sql.ResultSet#getTime(String)
. |
|
Jdbc
|
For documentation of this method, see java.sql.ResultSet#getTime(String, Calendar)
. |
|
Jdbc
|
For documentation of this method, see java.sql.ResultSet#getTimestamp(int)
. |
|
Jdbc
|
For documentation of this method, see java.sql.ResultSet#getTimestamp(int, Calendar)
. |
|
Jdbc
|
For documentation of this method, see java.sql.ResultSet#getTimestamp(String)
. |
|
Jdbc
|
For documentation of this method, see java.sql.ResultSet#getTimestamp(String, Calendar)
. |
|
Integer
|
For documentation of this method, see java.sql.ResultSet#getType()
. |
|
String
|
For documentation of this method, see java.sql.ResultSet#getURL(int)
. |
|
String
|
For documentation of this method, see java.sql.ResultSet#getURL(String)
. |
|
String[]
|
Returns the current set of warnings reported by the driver. | |
void
|
For documentation of this method, see java.sql.ResultSet#insertRow()
. |
|
Boolean
|
For documentation of this method, see java.sql.ResultSet#isAfterLast()
. |
|
Boolean
|
For documentation of this method, see java.sql.ResultSet#isBeforeFirst()
. |
|
Boolean
|
For documentation of this method, see java.sql.ResultSet#isClosed()
. |
|
Boolean
|
For documentation of this method, see java.sql.ResultSet#isFirst()
. |
|
Boolean
|
For documentation of this method, see java.sql.ResultSet#isLast()
. |
|
Boolean
|
For documentation of this method, see java.sql.ResultSet#first()
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#moveToCurrentRow()
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#moveToInsertRow()
. |
|
Boolean
|
For documentation of this method, see java.sql.ResultSet#next()
. |
|
Boolean
|
For documentation of this method, see java.sql.ResultSet#previous()
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#refreshRow()
. |
|
Boolean
|
For documentation of this method, see java.sql.ResultSet#relative(int)
. |
|
Boolean
|
For documentation of this method, see java.sql.ResultSet#rowDeleted()
. |
|
Boolean
|
For documentation of this method, see java.sql.ResultSet#rowInserted()
. |
|
Boolean
|
For documentation of this method, see java.sql.ResultSet#rowUpdated()
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#setFetchDirection(int)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#setFetchSize(int)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateArray(int, Array)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateArray(String, Array)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateBigDecimal(int, BigDecimal)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateBigDecimal(String, BigDecimal)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateBlob(int, Blob)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateRef(String, Blob)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateBoolean(int, boolean)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateBoolean(String, boolean)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateByte(int, byte)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateByte(String, byte)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateBytes(int, byte[])
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateBytes(String, byte[])
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateClob(int, Clob)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateClob(String, Clob)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateDate(int, Date)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateDate(String, Date)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateDouble(int, double)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateDouble(String, double)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateFloat(int, float)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateFloat(String, float)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateInt(int, int)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateInt(String, int)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateLong(int, long)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateLong(String, long)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateNClob(int, NClob)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateNClob(String, NClob)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateNString(int, String)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateNString(String, String)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateNull(int)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateNull(String)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateObject(int, Object)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateObject(int, Object, int)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateObject(String, Object)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateObject(String, Object, int)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateRef(int, Ref)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateRef(String, Ref)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateRow()
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateRowId(int, RowId)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateRowId(String, RowId)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateSQLXML(int, SQLXML)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateSQLXML(String, SQLXML)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateShort(int, short)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateShort(String, short)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateString(int, String)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateString(String, String)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateTime(int, Time)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateTime(String, Time)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateTimestamp(int, Timestamp)
. |
|
void
|
For documentation of this method, see java.sql.ResultSet#updateTimestamp(String, Timestamp)
. |
|
Boolean
|
For documentation of this method, see java.sql.ResultSet#wasNull()
. |
Jdbc
Result
Set
Meta
Data
Methods
Method | Return type | Brief description |
---|---|---|
String
|
For documentation of this method, see java.sql.ResultSetMetaData#getCatalogName(int)
. |
|
String
|
For documentation of this method, see java.sql.ResultSetMetaData#getColumnClassName(int)
. |
|
Integer
|
For documentation of this method, see java.sql.ResultSetMetaData#getColumnCount()
. |
|
Integer
|
For documentation of this method, see java.sql.ResultSetMetaData#getColumnDisplaySize(int)
. |
|
String
|
For documentation of this method, see java.sql.ResultSetMetaData#getColumnLabel(int)
. |
|
String
|
For documentation of this method, see java.sql.ResultSetMetaData#getColumnName(int)
. |
|
Integer
|
For documentation of this method, see java.sql.ResultSetMetaData#getColumnType(int)
. |
|
String
|
For documentation of this method, see java.sql.ResultSetMetaData#getColumnTypeName(int)
. |
|
Integer
|
For documentation of this method, see java.sql.ResultSetMetaData#getPrecision(int)
. |
|
Integer
|
For documentation of this method, see java.sql.ResultSetMetaData#getScale(int)
. |
|
String
|
For documentation of this method, see java.sql.ResultSetMetaData#getSchemaName(int)
. |
|
String
|
For documentation of this method, see java.sql.ResultSetMetaData#getTableName(int)
. |
|
Boolean
|
For documentation of this method, see java.sql.ResultSetMetaData#isAutoIncrement(int)
. |
|
Boolean
|
For documentation of this method, see java.sql.ResultSetMetaData#isCaseSensitive(int)
. |
|
Boolean
|
For documentation of this method, see java.sql.ResultSetMetaData#isCurrency(int)
. |
|
Boolean
|
For documentation of this method, see java.sql.ResultSetMetaData#isDefinitelyWritable(int)
. |
|
Integer
|
For documentation of this method, see java.sql.ResultSetMetaData#isNullable(int)
. |
|
Boolean
|
For documentation of this method, see java.sql.ResultSetMetaData#isReadOnly(int)
. |
|
Boolean
|
For documentation of this method, see java.sql.ResultSetMetaData#isSearchable(int)
. |
|
Boolean
|
For documentation of this method, see java.sql.ResultSetMetaData#isSigned(int)
. |
|
Boolean
|
For documentation of this method, see java.sql.ResultSetMetaData#isWritable(int)
. |
Jdbc
Row
Id
Methods
Method | Return type | Brief description |
---|---|---|
Byte[]
|
For documentation of this method, see java.sql.RowId#getBytes()
. |
Jdbc
SQLXML
Methods
Method | Return type | Brief description |
---|---|---|
void
|
For documentation of this method, see java.sql.SQLXML#free()
. |
|
String
|
For documentation of this method, see java.sql.SQLXML#getString()
. |
|
void
|
For documentation of this method, see java.sql.SQLXML#setString(String)
. |
Jdbc
Savepoint
Methods
Method | Return type | Brief description |
---|---|---|
Integer
|
For documentation of this method, see java.sql.Savepoint#getSavepointId()
. |
|
String
|
For documentation of this method, see java.sql.Savepoint#getSavepointName()
. |
Jdbc
Statement
Methods
Method | Return type | Brief description |
---|---|---|
void
|
For documentation of this method, see java.sql.Statement#addBatch(String)
. |
|
void
|
For documentation of this method, see java.sql.Statement#cancel()
. |
|
void
|
For documentation of this method, see java.sql.Statement#clearBatch()
. |
|
void
|
For documentation of this method, see java.sql.Statement#clearWarnings()
. |
|
void
|
For documentation of this method, see java.sql.Statement#close()
. |
|
Boolean
|
For documentation of this method, see java.sql.Statement#execute(String)
. |
|
Boolean
|
For documentation of this method, see java.sql.Statement#execute(String, int)
. |
|
Boolean
|
For documentation of this method, see java.sql.Statement#execute(String, int[])
. |
|
Boolean
|
For documentation of this method, see java.sql.Statement#execute(String, String[])
. |
|
Integer[]
|
For documentation of this method, see java.sql.Statement#executeBatch()
. |
|
Jdbc
|
For documentation of this method, see java.sql.Statement#executeQuery(String)
. |
|
Integer
|
For documentation of this method, see java.sql.Statement#executeUpdate(String)
. |
|
Integer
|
For documentation of this method, see java.sql.Statement#executeUpdate(String, int)
. |
|
Integer
|
For documentation of this method, see java.sql.Statement#executeUpdate(String, int[])
. |
|
Integer
|
For documentation of this method, see java.sql.Statement#executeUpdate(String, String[])
. |
|
Jdbc
|
For documentation of this method, see java.sql.Statement#getConnection()
. |
|
Integer
|
For documentation of this method, see java.sql.Statement#getFetchDirection()
. |
|
Integer
|
For documentation of this method, see java.sql.Statement#getFetchSize()
. |
|
Jdbc
|
For documentation of this method, see java.sql.Statement#getGeneratedKeys()
. |
|
Integer
|
For documentation of this method, see java.sql.Statement#getMaxFieldSize()
. |
|
Integer
|
For documentation of this method, see java.sql.Statement#getMaxRows()
. |
|
Boolean
|
For documentation of this method, see java.sql.Statement#getMoreResults()
. |
|
Boolean
|
For documentation of this method, see java.sql.Statement#getMoreResults(int)
. |
|
Integer
|
For documentation of this method, see java.sql.Statement#getQueryTimeout()
. |
|
Jdbc
|
For documentation of this method, see java.sql.Statement#getResultSet()
. |
|
Integer
|
For documentation of this method, see java.sql.Statement#getResultSetConcurrency()
. |
|
Integer
|
For documentation of this method, see java.sql.Statement#getResultSetHoldability()
. |
|
Integer
|
For documentation of this method, see java.sql.Statement#getResultSetType()
. |
|
Integer
|
For documentation of this method, see java.sql.Statement#getUpdateCount()
. |
|
String[]
|
For documentation of this method, see java.sql.Statement#getWarnings()
. |
|
Boolean
|
For documentation of this method, see java.sql.Statement#isClosed()
. |
|
Boolean
|
For documentation of this method, see java.sql.Statement#isPoolable()
. |
|
void
|
For documentation of this method, see java.sql.Statement#setCursorName(String)
. |
|
void
|
For documentation of this method, see java.sql.Statement#setEscapeProcessing(boolean)
. |
|
void
|
For documentation of this method, see java.sql.Statement#setFetchDirection(int)
. |
|
void
|
For documentation of this method, see java.sql.Statement#setFetchSize(int)
. |
|
void
|
For documentation of this method, see java.sql.Statement#setMaxFieldSize(int)
. |
|
void
|
For documentation of this method, see java.sql.Statement#setMaxRows(int)
. |
|
void
|
For documentation of this method, see java.sql.Statement#setPoolable(boolean)
. |
|
void
|
For documentation of this method, see java.sql.Statement#setQueryTimeout(int)
. |
Jdbc
Struct
Methods
Method | Return type | Brief description |
---|---|---|
Object[]
|
For documentation of this method, see java.sql.Struct#getAttributes()
. |
|
String
|
For documentation of this method, see java.sql.Struct#getSQLTypeName()
. |
Jdbc
Time
Methods
Method | Return type | Brief description |
---|---|---|
Boolean
|
For documentation of this method, see java.sql.Date#after(Date)
. |
|
Boolean
|
For documentation of this method, see java.sql.Date#before(Date)
. |
|
Integer
|
For documentation of this method, see java.sql.Date#getHours()
. |
|
Integer
|
For documentation of this method, see java.sql.Date#getMinutes()
. |
|
Integer
|
For documentation of this method, see java.sql.Date#getSeconds()
. |
|
Integer
|
For documentation of this method, see java.sql.Date#getTime()
. |
|
void
|
For documentation of this method, see java.sql.Date#setHours(int)
. |
|
void
|
For documentation of this method, see java.sql.Date#setMinutes(int)
. |
|
void
|
For documentation of this method, see java.sql.Date#setSeconds(int)
. |
|
void
|
For documentation of this method, see java.sql.Time#setTime(long)
. |
Jdbc
Timestamp
Methods
Method | Return type | Brief description |
---|---|---|
Boolean
|
For documentation of this method, see java.sql.Timestamp#after(Timestamp)
. |
|
Boolean
|
For documentation of this method, see java.sql.Timestamp#before(Timestamp)
. |
|
Integer
|
For documentation of this method, see java.sql.Date#getDate()
. |
|
Integer
|
For documentation of this method, see java.sql.Date#getHours()
. |
|
Integer
|
For documentation of this method, see java.sql.Date#getMinutes()
. |
|
Integer
|
For documentation of this method, see java.sql.Date#getMonth()
. |
|
Integer
|
For documentation of this method, see java.sql.Timestamp#getNanos()
. |
|
Integer
|
For documentation of this method, see java.sql.Date#getSeconds()
. |
|
Integer
|
For documentation of this method, see java.sql.Timestamp#getTime()
. |
|
Integer
|
For documentation of this method, see java.sql.Date#getYear()
. |
|
void
|
For documentation of this method, see java.sql.Date#setDate(int)
. |
|
void
|
For documentation of this method, see java.sql.Date#setHours(int)
. |
|
void
|
For documentation of this method, see java.sql.Date#setMinutes(int)
. |
|
void
|
For documentation of this method, see java.sql.Date#setMonth(int)
. |
|
void
|
For documentation of this method, see java.sql.Timestamp#setNanos(int)
. |
|
void
|
For documentation of this method, see java.sql.Date#setSeconds(int)
. |
|
void
|
For documentation of this method, see java.sql.Timestamp#setTime(long)
. |
|
void
|
For documentation of this method, see java.sql.Date#setYear(int)
. |