com.scalar.db.sql

Class PreparedStatement

java.lang.Object

com.scalar.db.sql.PreparedStatement

@NotThreadSafe
public class PreparedStatement
extends java.lang.Object

A statement with bind parameters that has been pre-parsed.

Method Summary

Modifier and Type	Method and Description
void	clearParameters() Clears the parameters.
ResultSet	execute() Executes the statement in this PreparedStatement object.
PreparedStatement	set(int i, Value value) Sets the i-th parameter to the specified Value.
PreparedStatement	set(java.lang.String name, Value value) Sets the parameter for all occurrences of name to the specified Value.
PreparedStatement	setBigInt(int i, long value) Sets the i-th parameter to the specified BigIng value.
PreparedStatement	setBigInt(java.lang.String name, long value) Sets the parameter for all occurrences of name to the specified BigInt value.
PreparedStatement	setBlob(int i, byte[] value) Sets the i-th parameter to the specified Blob value.
PreparedStatement	setBlob(int i, java.nio.ByteBuffer value) Sets the i-th parameter to the specified Blob value.
PreparedStatement	setBlob(java.lang.String name, byte[] value) Sets the parameter for all occurrences of name to the specified Blob value.
PreparedStatement	setBlob(java.lang.String name, java.nio.ByteBuffer value) Sets the parameter for all occurrences of name to the specified Blob value.
PreparedStatement	setBoolean(int i, boolean value) Sets the i-th parameter to the specified Boolean value.
PreparedStatement	setBoolean(java.lang.String name, boolean value) Sets the parameter for all occurrences of name to the specified Boolean value.
PreparedStatement	setDouble(int i, double value) Sets the i-th parameter to the specified Double value.
PreparedStatement	setDouble(java.lang.String name, double value) Sets the parameter for all occurrences of name to the specified Double value.
PreparedStatement	setFloat(int i, float value) Sets the i-th parameter to the specified Float value.
PreparedStatement	setFloat(java.lang.String name, float value) Sets the parameter for all occurrences of name to the specified Float value.
PreparedStatement	setInt(int i, int value) Sets the i-th parameter to the specified Int value.
PreparedStatement	setInt(java.lang.String name, int value) Sets the parameter for all occurrences of name to the specified Int value.
PreparedStatement	setNull(int i) Sets the i-th parameter to a null value.
PreparedStatement	setNull(java.lang.String name) Sets the parameter for all occurrences of name to a null value.
PreparedStatement	setText(int i, java.lang.String value) Sets the i-th parameter to the specified Text value.
PreparedStatement	setText(java.lang.String name, java.lang.String value) Sets the parameter for all occurrences of name to the specified Text value.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Detail

set

public PreparedStatement set(int i,
                             Value value)

Sets the i-th parameter to the specified Value.

Parameters:

i - the position of the bind marker

value - a value to bind

Returns:

this object

setBoolean

public PreparedStatement setBoolean(int i,
                                    boolean value)

Sets the i-th parameter to the specified Boolean value.

Parameters:

i - the position of the bind marker

value - a Boolean value to bind

Returns:

this object

setInt

public PreparedStatement setInt(int i,
                                int value)

Sets the i-th parameter to the specified Int value.

Parameters:

i - the position of the bind marker

value - an Int value to bind

Returns:

this object

setBigInt

public PreparedStatement setBigInt(int i,
                                   long value)

Sets the i-th parameter to the specified BigIng value.

Parameters:

i - the position of the bind marker

value - a BigIng value to bind

Returns:

this object

setFloat

public PreparedStatement setFloat(int i,
                                  float value)

Sets the i-th parameter to the specified Float value.

Parameters:

i - the position of the bind marker

value - a Float value to bind

Returns:

this object

setDouble

public PreparedStatement setDouble(int i,
                                   double value)

Sets the i-th parameter to the specified Double value.

Parameters:

i - the position of the bind marker

value - a Double value to bind

Returns:

this object

setText

public PreparedStatement setText(int i,
                                 @Nullable
                                 java.lang.String value)

Sets the i-th parameter to the specified Text value.

Parameters:

i - the position of the bind marker

value - a Text value to bind

Returns:

this object

setBlob

public PreparedStatement setBlob(int i,
                                 @Nullable
                                 java.nio.ByteBuffer value)

Sets the i-th parameter to the specified Blob value.

Parameters:

i - the position of the bind marker

value - a Blob value to bind

Returns:

this object

setBlob

public PreparedStatement setBlob(int i,
                                 @Nullable
                                 byte[] value)

Sets the i-th parameter to the specified Blob value.

Parameters:

i - the position of the bind marker

value - a Blob value to bind

Returns:

this object

setNull

public PreparedStatement setNull(int i)

Sets the i-th parameter to a null value.

Parameters:

i - the position of the bind marker

Returns:

this object

set

public PreparedStatement set(java.lang.String name,
                             Value value)

Sets the parameter for all occurrences of name to the specified Value.

Parameters:

name - the name of the bind marker

value - a value to bind

Returns:

this object

setBoolean

public PreparedStatement setBoolean(java.lang.String name,
                                    boolean value)

Sets the parameter for all occurrences of name to the specified Boolean value.

Parameters:

name - the name of the bind marker

value - a Boolean value to bind

Returns:

this object

setInt

public PreparedStatement setInt(java.lang.String name,
                                int value)

Sets the parameter for all occurrences of name to the specified Int value.

Parameters:

name - the name of the bind marker

value - an Int value to bind

Returns:

this object

setBigInt

public PreparedStatement setBigInt(java.lang.String name,
                                   long value)

Sets the parameter for all occurrences of name to the specified BigInt value.

Parameters:

name - the name of the bind marker

value - a BigInt value to bind

Returns:

this object

setFloat

public PreparedStatement setFloat(java.lang.String name,
                                  float value)

Sets the parameter for all occurrences of name to the specified Float value.

Parameters:

name - the name of the bind marker

value - a Float value to bind

Returns:

this object

setDouble

public PreparedStatement setDouble(java.lang.String name,
                                   double value)

Sets the parameter for all occurrences of name to the specified Double value.

Parameters:

name - the name of the bind marker

value - a Double value to bind

Returns:

this object

setText

public PreparedStatement setText(java.lang.String name,
                                 @Nullable
                                 java.lang.String value)

Sets the parameter for all occurrences of name to the specified Text value.

Parameters:

name - the name of the bind marker

value - a Text value to bind

Returns:

this object

setBlob

public PreparedStatement setBlob(java.lang.String name,
                                 @Nullable
                                 java.nio.ByteBuffer value)

Sets the parameter for all occurrences of name to the specified Blob value.

Parameters:

name - the name of the bind marker

value - a Blob value to bind

Returns:

this object

setBlob

public PreparedStatement setBlob(java.lang.String name,
                                 @Nullable
                                 byte[] value)

Sets the parameter for all occurrences of name to the specified Blob value.

Parameters:

name - the name of the bind marker

value - a Blob value to bind

Returns:

this object

setNull

public PreparedStatement setNull(java.lang.String name)

Sets the parameter for all occurrences of name to a null value.

Parameters:

name - the name of the bind marker

Returns:

this object

clearParameters

public void clearParameters()

Clears the parameters.

execute

public ResultSet execute()

Executes the statement in this PreparedStatement object.

Returns:

a ResultSet object that contains the data produced by the query

Throws:

TransactionRetryableException - if the transaction operation execution fails due to retryable faults (e.g., a transaction conflict). You can retry the transaction from the beginning.

UnknownTransactionStatusException - if the transaction status (committed or aborted) is unknown when executing the COMMIT statement

SqlException - if the transaction operation execution fails due to transient or nontransient faults. You can try retrying the transaction from the beginning, but the transaction may still fail if the cause is nontranient