public class PStmtKey
extends java.lang.Object
PreparedStatement
s.Constructor and Description |
---|
PStmtKey(java.lang.String sql)
Deprecated.
|
PStmtKey(java.lang.String sql,
int resultSetType,
int resultSetConcurrency)
Deprecated.
|
PStmtKey(java.lang.String sql,
java.lang.String catalog)
Deprecated.
|
PStmtKey(java.lang.String sql,
java.lang.String catalog,
int autoGeneratedKeys)
Deprecated.
|
PStmtKey(java.lang.String sql,
java.lang.String catalog,
int[] columnIndexes)
Deprecated.
|
PStmtKey(java.lang.String sql,
java.lang.String catalog,
int resultSetType,
int resultSetConcurrency)
Deprecated.
Use @link
PStmtKey(String, String, String, int, int) . |
PStmtKey(java.lang.String sql,
java.lang.String catalog,
int resultSetType,
int resultSetConcurrency,
int resultSetHoldability)
Deprecated.
|
PStmtKey(java.lang.String sql,
java.lang.String catalog,
int resultSetType,
int resultSetConcurrency,
int resultSetHoldability,
PoolingConnection.StatementType statementType)
|
PStmtKey(java.lang.String sql,
java.lang.String catalog,
int resultSetType,
int resultSetConcurrency,
PoolingConnection.StatementType statementType)
|
PStmtKey(java.lang.String sql,
java.lang.String catalog,
PoolingConnection.StatementType statementType)
Deprecated.
|
PStmtKey(java.lang.String sql,
java.lang.String catalog,
PoolingConnection.StatementType statementType,
java.lang.Integer autoGeneratedKeys)
|
PStmtKey(java.lang.String sql,
java.lang.String catalog,
java.lang.String schema)
Constructs a key to uniquely identify a prepared statement.
|
PStmtKey(java.lang.String sql,
java.lang.String catalog,
java.lang.String[] columnNames)
Deprecated.
|
PStmtKey(java.lang.String sql,
java.lang.String catalog,
java.lang.String schema,
int autoGeneratedKeys)
Constructs a key to uniquely identify a prepared statement.
|
PStmtKey(java.lang.String sql,
java.lang.String catalog,
java.lang.String schema,
int[] columnIndexes)
Constructs a key to uniquely identify a prepared statement.
|
PStmtKey(java.lang.String sql,
java.lang.String catalog,
java.lang.String schema,
int resultSetType,
int resultSetConcurrency)
Constructs a key to uniquely identify a prepared statement.
|
PStmtKey(java.lang.String sql,
java.lang.String catalog,
java.lang.String schema,
int resultSetType,
int resultSetConcurrency,
int resultSetHoldability)
Constructs a key to uniquely identify a prepared statement.
|
PStmtKey(java.lang.String sql,
java.lang.String catalog,
java.lang.String schema,
int resultSetType,
int resultSetConcurrency,
int resultSetHoldability,
PoolingConnection.StatementType statementType)
Constructs a key to uniquely identify a prepared statement.
|
PStmtKey(java.lang.String sql,
java.lang.String catalog,
java.lang.String schema,
int resultSetType,
int resultSetConcurrency,
PoolingConnection.StatementType statementType)
Constructs a key to uniquely identify a prepared statement.
|
PStmtKey(java.lang.String sql,
java.lang.String catalog,
java.lang.String schema,
PoolingConnection.StatementType statementType)
Constructs a key to uniquely identify a prepared statement.
|
PStmtKey(java.lang.String sql,
java.lang.String catalog,
java.lang.String schema,
PoolingConnection.StatementType statementType,
java.lang.Integer autoGeneratedKeys)
Constructs a key to uniquely identify a prepared statement.
|
PStmtKey(java.lang.String sql,
java.lang.String catalog,
java.lang.String schema,
java.lang.String[] columnNames)
Constructs a key to uniquely identify a prepared statement.
|
Modifier and Type | Method and Description |
---|---|
java.sql.Statement |
createStatement(java.sql.Connection connection)
Creates a new Statement from the given Connection.
|
boolean |
equals(java.lang.Object obj) |
java.lang.Integer |
getAutoGeneratedKeys()
Gets a flag indicating whether auto-generated keys should be returned; one of
Statement.RETURN_GENERATED_KEYS or Statement.NO_GENERATED_KEYS . |
java.lang.String |
getCatalog()
The catalog.
|
int[] |
getColumnIndexes()
Gets an array of column indexes indicating the columns that should be returned from the inserted row or rows.
|
java.lang.String[] |
getColumnNames()
Gets an array of column names indicating the columns that should be returned from the inserted row or rows.
|
java.lang.Integer |
getResultSetConcurrency()
Gets the result set concurrency type; one of
ResultSet.CONCUR_READ_ONLY or
ResultSet.CONCUR_UPDATABLE . |
java.lang.Integer |
getResultSetHoldability()
Gets the result set holdability, one of the following
ResultSet constants:
ResultSet.HOLD_CURSORS_OVER_COMMIT or ResultSet.CLOSE_CURSORS_AT_COMMIT . |
java.lang.Integer |
getResultSetType()
Gets the result set type, one of
ResultSet.TYPE_FORWARD_ONLY ,
ResultSet.TYPE_SCROLL_INSENSITIVE , or ResultSet.TYPE_SCROLL_SENSITIVE . |
java.lang.String |
getSchema()
The schema.
|
java.lang.String |
getSql()
Gets the SQL statement.
|
PoolingConnection.StatementType |
getStmtType()
The SQL statement type.
|
int |
hashCode() |
java.lang.String |
toString() |
@Deprecated public PStmtKey(java.lang.String sql)
PStmtKey(String, String, String)
.sql
- The SQL statement.@Deprecated public PStmtKey(java.lang.String sql, int resultSetType, int resultSetConcurrency)
PStmtKey(String, String, String, int, int)
.sql
- The SQL statement.resultSetType
- A result set type; one of ResultSet.TYPE_FORWARD_ONLY
,
ResultSet.TYPE_SCROLL_INSENSITIVE
, or ResultSet.TYPE_SCROLL_SENSITIVE
.resultSetConcurrency
- A concurrency type; one of ResultSet.CONCUR_READ_ONLY
or
ResultSet.CONCUR_UPDATABLE
.@Deprecated public PStmtKey(java.lang.String sql, java.lang.String catalog)
PStmtKey(String, String, String)
.sql
- The SQL statement.catalog
- The catalog.@Deprecated public PStmtKey(java.lang.String sql, java.lang.String catalog, int autoGeneratedKeys)
PStmtKey(String, String, String, int)
.sql
- The SQL statement.catalog
- The catalog.autoGeneratedKeys
- A flag indicating whether auto-generated keys should be returned; one of
Statement.RETURN_GENERATED_KEYS
or Statement.NO_GENERATED_KEYS
.@Deprecated public PStmtKey(java.lang.String sql, java.lang.String catalog, int resultSetType, int resultSetConcurrency)
PStmtKey(String, String, String, int, int)
.sql
- The SQL statement.catalog
- The catalog.resultSetType
- A result set type; one of ResultSet.TYPE_FORWARD_ONLY
,
ResultSet.TYPE_SCROLL_INSENSITIVE
, or ResultSet.TYPE_SCROLL_SENSITIVE
.resultSetConcurrency
- A concurrency type; one of ResultSet.CONCUR_READ_ONLY
or
ResultSet.CONCUR_UPDATABLE
.@Deprecated public PStmtKey(java.lang.String sql, java.lang.String catalog, int resultSetType, int resultSetConcurrency, int resultSetHoldability)
PStmtKey(String, String, String, int, int, int)
.sql
- The SQL statement.catalog
- The catalog.resultSetType
- a result set type; one of ResultSet.TYPE_FORWARD_ONLY
,
ResultSet.TYPE_SCROLL_INSENSITIVE
, or ResultSet.TYPE_SCROLL_SENSITIVE
.resultSetConcurrency
- A concurrency type; one of ResultSet.CONCUR_READ_ONLY
or
ResultSet.CONCUR_UPDATABLE
resultSetHoldability
- One of the following ResultSet
constants: ResultSet.HOLD_CURSORS_OVER_COMMIT
or ResultSet.CLOSE_CURSORS_AT_COMMIT
.@Deprecated public PStmtKey(java.lang.String sql, java.lang.String catalog, int resultSetType, int resultSetConcurrency, int resultSetHoldability, PoolingConnection.StatementType statementType)
sql
- The SQL statement.catalog
- The catalog.resultSetType
- a result set type; one of ResultSet.TYPE_FORWARD_ONLY
,
ResultSet.TYPE_SCROLL_INSENSITIVE
, or ResultSet.TYPE_SCROLL_SENSITIVE
resultSetConcurrency
- A concurrency type; one of ResultSet.CONCUR_READ_ONLY
or
ResultSet.CONCUR_UPDATABLE
.resultSetHoldability
- One of the following ResultSet
constants: ResultSet.HOLD_CURSORS_OVER_COMMIT
or ResultSet.CLOSE_CURSORS_AT_COMMIT
.statementType
- The SQL statement type, prepared or callable.@Deprecated public PStmtKey(java.lang.String sql, java.lang.String catalog, int resultSetType, int resultSetConcurrency, PoolingConnection.StatementType statementType)
sql
- The SQL statement.catalog
- The catalog.resultSetType
- A result set type; one of ResultSet.TYPE_FORWARD_ONLY
,
ResultSet.TYPE_SCROLL_INSENSITIVE
, or ResultSet.TYPE_SCROLL_SENSITIVE
.resultSetConcurrency
- A concurrency type; one of ResultSet.CONCUR_READ_ONLY
or
ResultSet.CONCUR_UPDATABLE
.statementType
- The SQL statement type, prepared or callable.@Deprecated public PStmtKey(java.lang.String sql, java.lang.String catalog, int[] columnIndexes)
PStmtKey(String, String, String, int[])
.sql
- The SQL statement.catalog
- The catalog.columnIndexes
- An array of column indexes indicating the columns that should be returned from the inserted row or
rows.@Deprecated public PStmtKey(java.lang.String sql, java.lang.String catalog, PoolingConnection.StatementType statementType)
PStmtKey(String, String, String, PoolingConnection.StatementType)
.sql
- The SQL statement.catalog
- The catalog.statementType
- The SQL statement type, prepared or callable.@Deprecated public PStmtKey(java.lang.String sql, java.lang.String catalog, PoolingConnection.StatementType statementType, java.lang.Integer autoGeneratedKeys)
sql
- The SQL statement.catalog
- The catalog.statementType
- The SQL statement type, prepared or callable.autoGeneratedKeys
- A flag indicating whether auto-generated keys should be returned; one of
Statement.RETURN_GENERATED_KEYS
or Statement.NO_GENERATED_KEYS
.public PStmtKey(java.lang.String sql, java.lang.String catalog, java.lang.String schema)
sql
- The SQL statement.catalog
- The catalog.schema
- The schemapublic PStmtKey(java.lang.String sql, java.lang.String catalog, java.lang.String schema, int autoGeneratedKeys)
sql
- The SQL statement.catalog
- The catalog.schema
- The schemaautoGeneratedKeys
- A flag indicating whether auto-generated keys should be returned; one of
Statement.RETURN_GENERATED_KEYS
or Statement.NO_GENERATED_KEYS
.public PStmtKey(java.lang.String sql, java.lang.String catalog, java.lang.String schema, int resultSetType, int resultSetConcurrency)
sql
- The SQL statement.catalog
- The catalog.schema
- The schemaresultSetType
- A result set type; one of ResultSet.TYPE_FORWARD_ONLY
,
ResultSet.TYPE_SCROLL_INSENSITIVE
, or ResultSet.TYPE_SCROLL_SENSITIVE
.resultSetConcurrency
- A concurrency type; one of ResultSet.CONCUR_READ_ONLY
or
ResultSet.CONCUR_UPDATABLE
.public PStmtKey(java.lang.String sql, java.lang.String catalog, java.lang.String schema, int resultSetType, int resultSetConcurrency, int resultSetHoldability)
sql
- The SQL statement.catalog
- The catalog.schema
- The schemaresultSetType
- a result set type; one of ResultSet.TYPE_FORWARD_ONLY
,
ResultSet.TYPE_SCROLL_INSENSITIVE
, or ResultSet.TYPE_SCROLL_SENSITIVE
.resultSetConcurrency
- A concurrency type; one of ResultSet.CONCUR_READ_ONLY
or
ResultSet.CONCUR_UPDATABLE
resultSetHoldability
- One of the following ResultSet
constants: ResultSet.HOLD_CURSORS_OVER_COMMIT
or ResultSet.CLOSE_CURSORS_AT_COMMIT
.public PStmtKey(java.lang.String sql, java.lang.String catalog, java.lang.String schema, int resultSetType, int resultSetConcurrency, int resultSetHoldability, PoolingConnection.StatementType statementType)
sql
- The SQL statement.catalog
- The catalog.schema
- The schema.resultSetType
- a result set type; one of ResultSet.TYPE_FORWARD_ONLY
,
ResultSet.TYPE_SCROLL_INSENSITIVE
, or ResultSet.TYPE_SCROLL_SENSITIVE
resultSetConcurrency
- A concurrency type; one of ResultSet.CONCUR_READ_ONLY
or
ResultSet.CONCUR_UPDATABLE
.resultSetHoldability
- One of the following ResultSet
constants: ResultSet.HOLD_CURSORS_OVER_COMMIT
or ResultSet.CLOSE_CURSORS_AT_COMMIT
.statementType
- The SQL statement type, prepared or callable.public PStmtKey(java.lang.String sql, java.lang.String catalog, java.lang.String schema, int resultSetType, int resultSetConcurrency, PoolingConnection.StatementType statementType)
sql
- The SQL statement.catalog
- The catalog.schema
- The schema.resultSetType
- A result set type; one of ResultSet.TYPE_FORWARD_ONLY
,
ResultSet.TYPE_SCROLL_INSENSITIVE
, or ResultSet.TYPE_SCROLL_SENSITIVE
.resultSetConcurrency
- A concurrency type; one of ResultSet.CONCUR_READ_ONLY
or
ResultSet.CONCUR_UPDATABLE
.statementType
- The SQL statement type, prepared or callable.public PStmtKey(java.lang.String sql, java.lang.String catalog, java.lang.String schema, int[] columnIndexes)
sql
- The SQL statement.catalog
- The catalog.schema
- The schema.columnIndexes
- An array of column indexes indicating the columns that should be returned from the inserted row or
rows.public PStmtKey(java.lang.String sql, java.lang.String catalog, java.lang.String schema, PoolingConnection.StatementType statementType)
sql
- The SQL statement.catalog
- The catalog.schema
- The schema.statementType
- The SQL statement type, prepared or callable.public PStmtKey(java.lang.String sql, java.lang.String catalog, java.lang.String schema, PoolingConnection.StatementType statementType, java.lang.Integer autoGeneratedKeys)
sql
- The SQL statement.catalog
- The catalog.schema
- The schema.statementType
- The SQL statement type, prepared or callable.autoGeneratedKeys
- A flag indicating whether auto-generated keys should be returned; one of
Statement.RETURN_GENERATED_KEYS
or Statement.NO_GENERATED_KEYS
.public PStmtKey(java.lang.String sql, java.lang.String catalog, java.lang.String schema, java.lang.String[] columnNames)
sql
- The SQL statement.catalog
- The catalog.schema
- The schema.columnNames
- An array of column names indicating the columns that should be returned from the inserted row or rows.@Deprecated public PStmtKey(java.lang.String sql, java.lang.String catalog, java.lang.String[] columnNames)
PStmtKey(String, String, String, String[])
.sql
- The SQL statement.catalog
- The catalog.columnNames
- An array of column names indicating the columns that should be returned from the inserted row or rows.public java.sql.Statement createStatement(java.sql.Connection connection) throws java.sql.SQLException
connection
- The Connection to use to create the statement.java.sql.SQLException
- Thrown when there is a problem creating the statement.public boolean equals(java.lang.Object obj)
equals
in class java.lang.Object
public java.lang.Integer getAutoGeneratedKeys()
Statement.RETURN_GENERATED_KEYS
or Statement.NO_GENERATED_KEYS
.public java.lang.String getCatalog()
public int[] getColumnIndexes()
public java.lang.String[] getColumnNames()
public java.lang.Integer getResultSetConcurrency()
ResultSet.CONCUR_READ_ONLY
or
ResultSet.CONCUR_UPDATABLE
.public java.lang.Integer getResultSetHoldability()
ResultSet
constants:
ResultSet.HOLD_CURSORS_OVER_COMMIT
or ResultSet.CLOSE_CURSORS_AT_COMMIT
.public java.lang.Integer getResultSetType()
ResultSet.TYPE_FORWARD_ONLY
,
ResultSet.TYPE_SCROLL_INSENSITIVE
, or ResultSet.TYPE_SCROLL_SENSITIVE
.public java.lang.String getSchema()
public java.lang.String getSql()
public PoolingConnection.StatementType getStmtType()
public int hashCode()
hashCode
in class java.lang.Object
public java.lang.String toString()
toString
in class java.lang.Object
Copyright © 2000-2019 Apache Software Foundation. All Rights Reserved.