Package org.sqlite.core

Class CoreStatement

java.lang.Object

org.sqlite.core.CoreStatement

All Implemented Interfaces:

Codes

Direct Known Subclasses:

JDBC3Statement

public abstract class CoreStatement
extends Object
implements Codes

Field Summary

Fields

Modifier and Type	Field	Description
protected Object[]	batch
protected int	batchPos
final SQLiteConnection	conn
SafeStmtPtr	pointer
protected boolean	resultsWaiting
protected final CoreResultSet	rs
protected String	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

Constructor Summary

Constructors

Modifier	Constructor	Description
protected	CoreStatement(SQLiteConnection c)

Method Summary

Modifier and Type	Method	Description
protected void	checkIndex(int index)
protected final void	checkOpen()
protected boolean	exec()	Calls sqlite3_step() and sets up results.
protected boolean	exec(String sql)	Executes SQL statement and throws SQLExceptions if the given SQL statement is null or no database is open.
abstract ResultSet	executeQuery(String sql, boolean closeStmt)
SQLiteConnectionConfig	getConnectionConfig()
DB	getDatabase()
protected void	internalClose()
(package private) boolean	isOpen()
protected void	notifyFirstStatementExecuted()

Methods inherited from class java.lang.Object

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

Field Details

conn

public final SQLiteConnection conn

rs

protected final CoreResultSet rs

pointer

public SafeStmtPtr pointer

sql

protected String sql

batchPos

protected int batchPos

batch

protected Object[] batch

resultsWaiting

protected boolean resultsWaiting

Constructor Details

CoreStatement

protected CoreStatement(SQLiteConnection c)

Method Details

getDatabase

public DB getDatabase()

getConnectionConfig

public SQLiteConnectionConfig getConnectionConfig()

checkOpen

protected final void checkOpen()
                        throws SQLException

Throws:

SQLException - If the database is not opened.

isOpen

boolean isOpen()
        throws SQLException

Returns:

True if the database is opened; false otherwise.

Throws:

SQLException

exec

protected boolean exec()
                throws SQLException

Calls sqlite3_step() and sets up results. Expects a clean stmt.

Returns:

True if the ResultSet has at least one row; false otherwise.

Throws:

SQLException - If the given SQL statement is null or no database is open.

exec

protected boolean exec(String sql)
                throws SQLException

Executes SQL statement and throws SQLExceptions if the given SQL statement is null or no database is open.

Parameters:

sql - SQL statement.

Returns:

True if the ResultSet has at least one row; false otherwise.

Throws:

SQLException - If the given SQL statement is null or no database is open.

internalClose

protected void internalClose()
                      throws SQLException

Throws:

SQLException

notifyFirstStatementExecuted

protected void notifyFirstStatementExecuted()

executeQuery

public abstract ResultSet executeQuery(String sql,
 boolean closeStmt)
                                throws SQLException

Throws:

SQLException

checkIndex

protected void checkIndex(int index)
                   throws SQLException

Throws:

SQLException