PostgreSQLPreparedStatement

classin packageklyn.databases.sql.postgresql

public class PostgreSQLPreparedStatement extends PostgreSQLStatementBase implements PreparedStatement:

All Implemented Interfaces: PreparedStatement

PostgreSQL prepared statement.

Properties

Modifier and Type	Member	Description
public readonly property	parameterInfo `parameterInfo as ParameterMetaData:`	No summary.
public readonly property	parameterMetadata `parameterMetadata as ParameterMetaData:`	No summary.
public readonly property	parameters `parameters as Map<Int, Object>:`	No summary.
public readonly property	sql `sql as String:`	No summary.

Properties inherited from PreparedStatement: parameterInfo, parameterMetadata, parameters, sql

Properties inherited from Statement: batchSize, closeOnCompletion, closed, concurrency, connection, cursorName, escapeProcessing, fetchDirection, fetchSize, generatedKeys, holdability, largeMaxRows, maxFieldSize, maxRows, poolable, queryTimeoutSeconds, resultSetType, warning

Constructors

Modifier and Type	Member	Description
public	PostgreSQLPreparedStatement `PostgreSQLPreparedStatement(connection as PostgreSQLConnection, sql as String):`	No summary.

Methods

Modifier and Type	Member	Description
public	addBatch `addBatch() as Void throws SQLException:`	Configures or executes a SQL statement.
public	addBatch `addBatch(sql as String) as Void throws SQLException:`	Configures or executes a SQL statement.
public	clearParameters `clearParameters() as Void:`	No summary.
public	execute `execute() as Boolean throws SQLException:`	Configures or executes a SQL statement.
public	execute `execute(sql as String) as Boolean throws SQLException:`	Configures or executes a SQL statement.
public	executeQuery `executeQuery(sql as String) as ResultSet throws SQLException:`	Configures or executes a SQL statement.
public	executeUpdate `executeUpdate(sql as String) as Int throws SQLException:`	Configures or executes a SQL statement.
public	query `query() as ResultSet throws SQLException:`	Configures or executes a SQL statement.
public	set `set(index as Int, value as Object) as PreparedStatement throws SQLException:`	Configures or executes a SQL statement.
public	setBoolean `setBoolean(index as Int, value as Boolean) as PreparedStatement throws SQLException:`	Configures or executes a SQL statement.
public	setDouble `setDouble(index as Int, value as Double) as PreparedStatement throws SQLException:`	Configures or executes a SQL statement.
public	setInt `setInt(index as Int, value as Int) as PreparedStatement throws SQLException:`	Configures or executes a SQL statement.
public	setLong `setLong(index as Int, value as Long) as PreparedStatement throws SQLException:`	Configures or executes a SQL statement.
public	setNull `setNull(index as Int, sqlType as Int = Types.NULL) as PreparedStatement throws SQLException:`	Configures or executes a SQL statement.
public	setString `setString(index as Int, value as String) as PreparedStatement throws SQLException:`	Configures or executes a SQL statement.
public	update `update() as Long throws SQLException:`	Configures or executes a SQL statement.

Methods inherited from PreparedStatement: clearParameters, execute, query, set, setBoolean, setDouble, setInt, setLong, setNull, setString, update

Methods inherited from Statement: addBatch, clearBatch, clearWarnings, execute, executeBatch, executeQuery, executeUpdate, getResultSet

Methods inherited from AutoClosable: close