17.18.1　取得するメソッド，及び取得するための設定

Driver

Connection connect(String url, Properties info)

1

1

−

Connection

Statement createStatement()^※2

1

1

−

Statement createStatement(int resultSetType, int resultSetConcurrency)^※3

1

1

−

Statement createStatement(int resultSetType, int resultSetConcurrency, int resultSetHoldability)^※4

1

1

−

PreparedStatement prepareStatement(String sql)^※2

1

1

−

PreparedStatement prepareStatement(String sql, int resultSetType, int resultSetConcurrency)^※3

1

1

−

PreparedStatement prepareStatement(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)^※4

1

1

−

CallableStatement prepareCall(String sql)^※2

1

1

−

CallableStatement prepareCall(String sql, int resultSetType, int resultSetConcurrency)^※3

1

1

−

CallableStatement prepareCall(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)^※4

1

1

−

void setAutoCommit(boolean autoCommit)

2

2

−

void commit()

2

1

−

void rollback()

2

1

−

void close()

1

1

−

boolean isValid(int timeout)

2

1

−

DatabaseMetaData getMetaData()

2

2

−

void setHoldability(int holdability)

−

1

−

Statement

ResultSet executeQuery(String sql)

1

1

−

int executeUpdate(String sql)

1

1

−

boolean execute(String sql)

1

1

−

void addBatch(String sql)

−

1

−

int[] executeBatch()

2

1

−

void clearBatch()

−

2

−

void close()

1

1

−

boolean isClosed()

2

2

−

void cancel()

2

1

−

ResultSet getResultSet()

2

2

−

boolean getMoreResults()

−

1

−

void setMaxFieldSize(int max)

−

2

−

void setMaxRows(int max)

−

2

−

void setQueryTimeout(int seconds)

−

1

−

void setFetchSize(int rows)

−

1

−

boolean isPoolable()

2

2

−

PreparedStatement

ResultSet executeQuery()^※2

2

1

[SQL]

int executeUpdate()^※2

2

1

[SQL]

boolean execute()^※2

2

1

[SQL]

ResultSetMetaData getMetaData()

2

2

−

void setBlob(int parameterIndex, Blob x)^※6

−

2

−

CallableStatement

String getString(int parameterIndex)^※6

−

2

−

long getLong(int parameterIndex)^※6

−

2

−

byte[] getBytes(int parameterIndex)^※6

−

2

−

Object getObject(int parameterIndex)^※6

−

2

−

Blob getBlob(int parameterIndex)^※6

−

2

−

String getString(String parameterName)^※6

−

2

−

long getLong(String parameterName)^※6

−

2

−

byte[] getBytes(String parameterName)^※6

−

2

−

Object getObject(String parameterName)^※6

−

2

−

Blob getBlob(String parameterName)^※6

−

2

−

ResultSet

boolean next()^※5

2

1

[COUNT]

boolean previous()

−

2

−

boolean absolute(int row)

2

1

−

boolean relative(int rows)

2

1

−

void beforeFirst()

2

1

−

boolean first()

2

1

−

boolean last()

2

1

−

void afterLast()

2

1

−

boolean isBeforeFirst()

2

1

−

boolean isAfterLast()

2

1

−

boolean isLast()

2

1

−

void close()^※5

2

1

[COUNT]

boolean isClosed()

2

2

−

Statement getStatement()

2

2

−

ResultSetMetaData getMetaData()

2

2

−

int getHoldability()

2

2

−

String getString(int columnIndex)^※6

−

2

−

long getLong(int columnIndex)^※6

−

2

−

byte[] getBytes(int columnIndex)^※6

−

2

−

Blob getBlob(int columnIndex)^※6

−

2

−

Object getObject(int columnIndex)^※6

−

2

−

InputStream getAsciiStream(int columnIndex)^※6

−

2

−

Reader getCharacterStream(int columnIndex)^※6

−

2

−

InputStream getBinaryStream(int columnIndex)^※6

−

2

−

String getString(String columnLabel)^※6

−

2

−

long getLong(String columnLabel)^※6

−

2

−

Blob getBlob(String columnLabel)^※6

−

2

−

Object getObject(String columnLabel)^※6

−

2

−

InputStream getAsciiStream(String columnLabel)^※6

−

2

−

Reader getCharacterStream(String columnLabel)^※6

−

2

−

InputStream getBinaryStream(String columnLabel)^※6

−

2

−

Blob

long length()^※6

2

2

−

byte[] getBytes(long pos, int length)^※6

2

2

−

long position(byte[] pattern, long start)^※6

2

2

−

long position(Blob pattern, long start)^※6

2

2

−

void free()^※6

1

1

−

DatabaseMetaData

ResultSet getProcedures(String catalog, String schemaPattern, String procedureNamePattern)

2

2

−

ResultSet getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern)

2

2

−

ResultSet getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types)

2

2

−

ResultSet getSchemas()

2

2

−

ResultSet getCatalogs()

2

2

−

ResultSet getTableTypes()

2

2

−

ResultSet getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern)

2

2

−

ResultSet getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern)

2

2

−

ResultSet getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern)

2

2

−

ResultSet getBestRowIdentifier(String catalog, String schema, String table, int scope, boolean nullable)

2

2

−

ResultSet getVersionColumns(String catalog, String schema, String table)

2

2

−

ResultSet getPrimaryKeys(String catalog, String schema, String table)

2

2

−

ResultSet getImportedKeys(String catalog, String schema, String table)

2

2

−

ResultSet getExportedKeys(String catalog, String schema, String table)

2

2

−

ResultSet getCrossReference(String parentCatalog, String parentSchema, String parentTable, String foreignCatalog, String foreignSchema, String foreignTable)

2

2

−

ResultSet getTypeInfo()

2

2

−

ResultSet getIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate)

2

2

−

ResultSet getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types)

2

2

−

Connection getConnection()

2

2

−

ResultSet getSuperTypes(String catalog, String schemaPattern, String typeNamePattern)

2

2

−

ResultSet getSuperTables(String catalog, String schemaPattern, String tableNamePattern)

2

2

−

ResultSet getAttributes(String catalog, String schemaPattern, String typeNamePattern, String attributeNamePattern)

2

2

−

RowIdLifetime getRowIdLifetime()

2

2

−

ResultSet getSchemas(String catalog, String schemaPattern)

2

2

−

boolean supportsStoredFunctionsUsingCallSyntax()

2

2

−

boolean autoCommitFailureClosesAllResultSets()

2

2

−

ResultSet getClientInfoProperties()

2

2

−

ResultSet getFunctions(String catalog, String schemaPattern, String functionNamePattern)

2

2

−

ResultSet getFunctionColumns(String catalog, String schemaPattern, String functionNamePattern, String columnNamePattern)

2

2

−

DataSource

Connection getConnection()^※2

1

1

−

Connection getConnection(String username, String password)^※3

1

1

−

ConnectionPool

DataSource

PooledConnection getPooledConnection()^※2

1

1

−

PooledConnection getPooledConnection(String user, String password)^※3

1

1

−

XADataSource

XAConnection getXAConnection()^※2

1

1

−

XAConnection getXAConnection(String user,String password)^※3

1

1

−

PooledConnection

Connection getConnection()

1

1

−

void close()

1

1

−

void addConnectionEventListener(ConnectionEventListener listener)

−

2

−

void removeConnectionEventListener(ConnectionEventListener listener)

−

2

−

void addStatementEventListener(StatementEventListener listener)

−

2

−

void removeStatementEventListener(StatementEventListener listener)

−

2

−

XAConnection

XAResource getXAResource()

1

1

−

XAResource

void start(Xid xid, int flags)

3

3

−

void end(Xid xid, int flags)

3

3

−

int prepare(Xid xid)

3

3

−

void commit(Xid xid, boolean onePhase)

3

3

−

void rollback(Xid xid)

3

3

−

void forget(Xid xid)

3

3

−

Xid[] recover(int flag)

3

3

−

boolean isSameRM(XAResource xares)

3

3

−

InputStream

int read()^※2

2

2

−

int read(byte[] data)^※3

2

2

−

int read(byte[] b, int off, int len)^※4

2

2

−

PrdbConnection

int checkSession (int waittime)

−

1

−