Package org.sqlite.core

Class CorePreparedStatement

java.lang.Object

org.sqlite.core.CoreStatement

org.sqlite.jdbc3.JDBC3Statement

org.sqlite.jdbc4.JDBC4Statement

org.sqlite.core.CorePreparedStatement

All Implemented Interfaces:

java.lang.AutoCloseable, java.sql.Statement, java.sql.Wrapper, Codes

Direct Known Subclasses:

JDBC3PreparedStatement

public abstract class CorePreparedStatement
extends JDBC4Statement

Field Summary

Fields

Modifier and Type	Field	Description
protected int	batchQueryCount
protected int	columnCount
protected int	paramCount

Fields inherited from class org.sqlite.core.CoreStatement

batch, batchPos, conn, pointer, resultsWaiting, rs, sql

Fields inherited from interface org.sqlite.core.Codes

SQLITE_ABORT, SQLITE_AUTH, SQLITE_BLOB, SQLITE_BUSY, SQLITE_CANTOPEN, SQLITE_CONSTRAINT, SQLITE_CORRUPT, SQLITE_DONE, SQLITE_EMPTY, SQLITE_ERROR, SQLITE_FLOAT, SQLITE_FULL, SQLITE_INTEGER, SQLITE_INTERNAL, SQLITE_INTERRUPT, SQLITE_IOERR, SQLITE_LOCKED, SQLITE_MISMATCH, SQLITE_MISUSE, SQLITE_NOLFS, SQLITE_NOMEM, SQLITE_NOTFOUND, SQLITE_NULL, SQLITE_OK, SQLITE_PERM, SQLITE_PROTOCOL, SQLITE_READONLY, SQLITE_ROW, SQLITE_SCHEMA, SQLITE_TEXT, SQLITE_TOOBIG

Fields inherited from interface java.sql.Statement

CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO

Constructor Summary

Constructors

Modifier	Constructor	Description
protected	CorePreparedStatement(SQLiteConnection conn, java.lang.String sql)	Constructs a prepared statement on a provided connection.

Method Summary

Modifier and Type	Method	Description
protected void	batch(int pos, java.lang.Object value)	Assigns the object value to the element at the specific position of array batch.
void	clearBatch()
int[]	executeBatch()
int	getUpdateCount()
protected void	setDateByMilliseconds(int pos, java.lang.Long value, java.util.Calendar calendar)	Store the date in the user's preferred format (text, int, or real)

Methods inherited from class org.sqlite.jdbc4.JDBC4Statement

close, closeOnCompletion, isClosed, isCloseOnCompletion, isPoolable, isWrapperFor, setPoolable, unwrap

Methods inherited from class org.sqlite.jdbc3.JDBC3Statement

addBatch, cancel, clearWarnings, execute, execute, execute, execute, executeQuery, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getWarnings, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setQueryTimeout, unused

Methods inherited from class org.sqlite.core.CoreStatement

checkOpen, exec, exec, getConnectionConfig, getDatbase, internalClose

Methods inherited from class java.lang.Object

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

Methods inherited from interface java.sql.Statement

addBatch, cancel, clearWarnings, enquoteIdentifier, enquoteLiteral, enquoteNCharLiteral, execute, execute, execute, execute, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getLargeMaxRows, getLargeUpdateCount, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getWarnings, isSimpleIdentifier, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setQueryTimeout

Field Detail

columnCount

protected int columnCount

paramCount

protected int paramCount

batchQueryCount

protected int batchQueryCount

Constructor Detail

CorePreparedStatement

protected CorePreparedStatement(SQLiteConnection conn,
                                java.lang.String sql)
                         throws java.sql.SQLException

Constructs a prepared statement on a provided connection.

Parameters:

conn - Connection on which to create the prepared statement.

sql - The SQL script to prepare.

Throws:

java.sql.SQLException

Method Detail

executeBatch

public int[] executeBatch()
                   throws java.sql.SQLException

Specified by:

executeBatch in interface java.sql.Statement

Overrides:

executeBatch in class JDBC3Statement

Throws:

java.sql.SQLException

See Also:

JDBC3Statement.executeBatch()

clearBatch

public void clearBatch()
                throws java.sql.SQLException

Specified by:

clearBatch in interface java.sql.Statement

Overrides:

clearBatch in class JDBC3Statement

Throws:

java.sql.SQLException

See Also:

()

getUpdateCount

public int getUpdateCount()
                   throws java.sql.SQLException

Specified by:

getUpdateCount in interface java.sql.Statement

Overrides:

getUpdateCount in class JDBC3Statement

Throws:

java.sql.SQLException

See Also:

JDBC3Statement.getUpdateCount()

batch

protected void batch(int pos,
                     java.lang.Object value)
              throws java.sql.SQLException

Assigns the object value to the element at the specific position of array batch.

Parameters:

pos -

value -

Throws:

java.sql.SQLException

setDateByMilliseconds

protected void setDateByMilliseconds(int pos,
                                     java.lang.Long value,
                                     java.util.Calendar calendar)
                              throws java.sql.SQLException

Store the date in the user's preferred format (text, int, or real)

Throws:

java.sql.SQLException