MariaDbPreparedStatement
class in package klyn.databases.sql.mariadb

    public class MariaDbPreparedStatement extends MariaDbStatementBase implements PreparedStatement:

MariaDbPreparedStatement
All Implemented Interfaces: PreparedStatement

MariaDB prepared statement.

The current implementation renders bound parameters client-side before sending the final SQL to MariaDB.

    import klyn.databases.sql.mariadb

    # prepared = connection.prepared("select * from users where id = ?")

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
Methods

Modifier and Type | Member | Description
--- | --- | ---
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