PStmtKey (Apache Tomcat 8.0.53 API Documentation)

java.lang.Object
- org.apache.tomcat.dbcp.dbcp2.PStmtKey

Direct Known Subclasses:

PStmtKeyCPDS
```
public class PStmtKey
extends java.lang.Object
```
A key uniquely identifying PreparedStatements.

Since:

2.0

Constructor Summary

Constructors
Constructor and Description
`PStmtKey(java.lang.String sql)` Constructs a key to uniquely identify a prepared statement.
`PStmtKey(java.lang.String sql, int resultSetType, int resultSetConcurrency)` Constructs a key to uniquely identify a prepared statement.
`PStmtKey(java.lang.String sql, java.lang.String catalog)` Constructs a key to uniquely identify a prepared statement.
`PStmtKey(java.lang.String sql, java.lang.String catalog, int autoGeneratedKeys)` Constructs a key to uniquely identify a prepared statement.
`PStmtKey(java.lang.String sql, java.lang.String catalog, int[] columnIndexes)` Constructs a key to uniquely identify a prepared statement.
`PStmtKey(java.lang.String sql, java.lang.String catalog, int resultSetType, int resultSetConcurrency)` Constructs a key to uniquely identify a prepared statement.
`PStmtKey(java.lang.String sql, java.lang.String catalog, int resultSetType, int resultSetConcurrency, int resultSetHoldability)` Constructs a key to uniquely identify a prepared statement.
`PStmtKey(java.lang.String sql, java.lang.String catalog, 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, 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, PoolingConnection.StatementType statementType)` Constructs a key to uniquely identify a prepared statement.
`PStmtKey(java.lang.String sql, java.lang.String catalog, 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[] columnNames)` Constructs a key to uniquely identify a prepared statement.

Method Summary

Methods
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`	`getSql()` Gets the SQL statement.
`PoolingConnection.StatementType`	`getStmtType()` The SQL statement type.
`int`	`hashCode()`
`java.lang.String`	`toString()`

Methods inherited from class java.lang.Object
clone, finalize, getClass, notify, notifyAll, wait, wait, wait

- Constructor Detail
  - PStmtKey
```
public PStmtKey(java.lang.String sql)
```
    Constructs a key to uniquely identify a prepared statement.
    
    Parameters:
    sql - The SQL statement.
  - PStmtKey
```
public PStmtKey(java.lang.String sql,
        java.lang.String catalog)
```
    Constructs a key to uniquely identify a prepared statement.
    
    Parameters:
    sql - The SQL statement.
    catalog - The catalog.
  - PStmtKey
```
public PStmtKey(java.lang.String sql,
        java.lang.String catalog,
        PoolingConnection.StatementType statementType)
```
    Constructs a key to uniquely identify a prepared statement.
    
    Parameters:
    sql - The SQL statement.
    catalog - The catalog.
    statementType - The SQL statement type, prepared or callable.
  - PStmtKey
```
public PStmtKey(java.lang.String sql,
        java.lang.String catalog,
        int autoGeneratedKeys)
```
    Constructs a key to uniquely identify a prepared statement.
    
    Parameters:
    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.
  - PStmtKey
```
public PStmtKey(java.lang.String sql,
        java.lang.String catalog,
        PoolingConnection.StatementType statementType,
        java.lang.Integer autoGeneratedKeys)
```
    Constructs a key to uniquely identify a prepared statement.
    
    Parameters:
    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.
  - PStmtKey
```
public PStmtKey(java.lang.String sql,
        java.lang.String catalog,
        int[] columnIndexes)
```
    Constructs a key to uniquely identify a prepared statement.
    
    Parameters:
    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.
  - PStmtKey
```
public PStmtKey(java.lang.String sql,
        java.lang.String catalog,
        java.lang.String[] columnNames)
```
    Constructs a key to uniquely identify a prepared statement.
    
    Parameters:
    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.
  - PStmtKey
```
public PStmtKey(java.lang.String sql,
        int resultSetType,
        int resultSetConcurrency)
```
    Constructs a key to uniquely identify a prepared statement.
    
    Parameters:
    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.
  - PStmtKey
```
public PStmtKey(java.lang.String sql,
        java.lang.String catalog,
        int resultSetType,
        int resultSetConcurrency)
```
    Constructs a key to uniquely identify a prepared statement.
    
    Parameters:
    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.
  - PStmtKey
```
public PStmtKey(java.lang.String sql,
        java.lang.String catalog,
        int resultSetType,
        int resultSetConcurrency,
        PoolingConnection.StatementType statementType)
```
    Constructs a key to uniquely identify a prepared statement.
    
    Parameters:
    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.
  - PStmtKey
```
public PStmtKey(java.lang.String sql,
        java.lang.String catalog,
        int resultSetType,
        int resultSetConcurrency,
        int resultSetHoldability)
```
    Constructs a key to uniquely identify a prepared statement.
    
    Parameters:
    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.
  - PStmtKey
```
public PStmtKey(java.lang.String sql,
        java.lang.String catalog,
        int resultSetType,
        int resultSetConcurrency,
        int resultSetHoldability,
        PoolingConnection.StatementType statementType)
```
    Constructs a key to uniquely identify a prepared statement.
    
    Parameters:
    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.
- Method Detail
  - getSql
```
public java.lang.String getSql()
```
    Gets the SQL statement.
    
    Returns:
    the SQL statement.
  - getResultSetType
```
public java.lang.Integer getResultSetType()
```
    Gets the result set type, one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE.
    
    Returns:
    the result set type.
  - getResultSetConcurrency
```
public java.lang.Integer getResultSetConcurrency()
```
    Gets the result set concurrency type; one of ResultSet.CONCUR_READ_ONLY or ResultSet.CONCUR_UPDATABLE.
    
    Returns:
    The result set concurrency type.
  - getResultSetHoldability
```
public 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.
    
    Returns:
    The result set holdability.
  - getAutoGeneratedKeys
```
public 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.
    
    Returns:
    a flag indicating whether auto-generated keys should be returned.
  - getColumnIndexes
```
public int[] getColumnIndexes()
```
    Gets an array of column indexes indicating the columns that should be returned from the inserted row or rows.
    
    Returns:
    An array of column indexes.
  - getColumnNames
```
public java.lang.String[] getColumnNames()
```
    Gets an array of column names indicating the columns that should be returned from the inserted row or rows.
    
    Returns:
    An array of column names.
  - getCatalog
```
public java.lang.String getCatalog()
```
    The catalog.
    
    Returns:
    The catalog.
  - getStmtType
```
public PoolingConnection.StatementType getStmtType()
```
    The SQL statement type.
    
    Returns:
    The SQL statement type.
  - equals
```
public boolean equals(java.lang.Object obj)
```
    Overrides:
    
    equals in class java.lang.Object
  - hashCode
```
public int hashCode()
```
    Overrides:
    
    hashCode in class java.lang.Object
  - toString
```
public java.lang.String toString()
```
    Overrides:
    
    toString in class java.lang.Object
  - createStatement
```
public java.sql.Statement createStatement(java.sql.Connection connection)
                                   throws java.sql.SQLException
```
    Creates a new Statement from the given Connection.
    
    Parameters:
    connection - The Connection to use to create the statement.
    
    Returns:
    The statement.
    
    Throws:
    
    java.sql.SQLException - Thrown when there is a problem creating the statement.

Class PStmtKey

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Constructor Detail

PStmtKey

PStmtKey

PStmtKey

PStmtKey

PStmtKey

PStmtKey

PStmtKey

PStmtKey

PStmtKey

PStmtKey

PStmtKey

PStmtKey

Method Detail

getSql

getResultSetType

getResultSetConcurrency

getResultSetHoldability

getAutoGeneratedKeys

getColumnIndexes

getColumnNames

getCatalog

getStmtType

equals

hashCode

toString

createStatement