Package es.bsc.dataclay.dbhandler.sql.sqlite

Class ExtendedPreparedStatement

java.lang.Object

org.sqlite.core.CoreStatement

org.sqlite.jdbc3.JDBC3Statement

org.sqlite.jdbc4.JDBC4Statement

org.sqlite.core.CorePreparedStatement

org.sqlite.jdbc3.JDBC3PreparedStatement

org.sqlite.jdbc4.JDBC4PreparedStatement

es.bsc.dataclay.dbhandler.sql.sqlite.ExtendedPreparedStatement

All Implemented Interfaces:

AutoCloseable, ParameterMetaData, PreparedStatement, Statement, Wrapper, org.sqlite.core.Codes

public class ExtendedPreparedStatement
extends org.sqlite.jdbc4.JDBC4PreparedStatement

Field Summary

Fields inherited from class org.sqlite.core.CorePreparedStatement

batchQueryCount, columnCount, paramCount

Fields inherited from class org.sqlite.core.CoreStatement

batch, batchPos, conn, db, metadata, 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.ParameterMetaData

parameterModeIn, parameterModeInOut, parameterModeOut, parameterModeUnknown, parameterNoNulls, parameterNullable, parameterNullableUnknown

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

Constructor	Description
ExtendedPreparedStatement(org.sqlite.SQLiteConnection conn, String sql)

Method Summary

Modifier and Type	Method	Description
boolean	execute()
ResultSet	executeQuery()
int	executeUpdate()
void	setArray(int i, Array x)
String	toString()

Methods inherited from class org.sqlite.jdbc4.JDBC4PreparedStatement

setAsciiStream, setAsciiStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setCharacterStream, setCharacterStream, setClob, setClob, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setRowId, setSQLXML

Methods inherited from class org.sqlite.jdbc3.JDBC3PreparedStatement

addBatch, addBatch, clearParameters, execute, executeQuery, executeUpdate, getMetaData, getParameterClassName, getParameterCount, getParameterMetaData, getParameterMode, getParameterType, getParameterTypeName, getPrecision, getScale, getStatement, isNullable, isSigned, setAsciiStream, setBigDecimal, setBinaryStream, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNull, setNull, setObject, setObject, setObject, setRef, setShort, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL, unused

Methods inherited from class org.sqlite.core.CorePreparedStatement

batch, checkParameters, clearBatch, executeBatch, finalize, getUpdateCount, setDateByMilliseconds

Methods inherited from class org.sqlite.jdbc4.JDBC4Statement

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

Methods inherited from class org.sqlite.jdbc3.JDBC3Statement

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

Methods inherited from class org.sqlite.core.CoreStatement

checkOpen, exec, exec, internalClose

Methods inherited from class java.lang.Object

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

Methods inherited from interface java.sql.ParameterMetaData

getParameterClassName, getParameterCount, getParameterMode, getParameterType, getParameterTypeName, getPrecision, getScale, isNullable, isSigned

Methods inherited from interface java.sql.PreparedStatement

addBatch, clearParameters, executeLargeUpdate, getMetaData, getParameterMetaData, setAsciiStream, setBigDecimal, setBinaryStream, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNull, setNull, setObject, setObject, setObject, setObject, setObject, setRef, setShort, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL

Methods inherited from interface java.sql.Statement

addBatch, cancel, clearBatch, clearWarnings, close, closeOnCompletion, execute, execute, execute, execute, executeBatch, 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, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout

Methods inherited from interface java.sql.Wrapper

isWrapperFor, unwrap

Constructor Detail

ExtendedPreparedStatement

public ExtendedPreparedStatement(org.sqlite.SQLiteConnection conn,
                                 String sql)
                          throws SQLException

Throws:

SQLException

Method Detail

executeQuery

public ResultSet executeQuery()
                       throws SQLException

Specified by:

executeQuery in interface PreparedStatement

Overrides:

executeQuery in class org.sqlite.jdbc3.JDBC3PreparedStatement

Throws:

SQLException

executeUpdate

public int executeUpdate()
                  throws SQLException

Specified by:

executeUpdate in interface PreparedStatement

Overrides:

executeUpdate in class org.sqlite.jdbc3.JDBC3PreparedStatement

Throws:

SQLException

execute

public boolean execute()
                throws SQLException

Specified by:

execute in interface PreparedStatement

Overrides:

execute in class org.sqlite.jdbc3.JDBC3PreparedStatement

Throws:

SQLException

setArray

public void setArray(int i,
                     Array x)
              throws SQLException

Specified by:

setArray in interface PreparedStatement

Overrides:

setArray in class org.sqlite.jdbc3.JDBC3PreparedStatement

Throws:

SQLException

toString

public String toString()

Overrides:

toString in class Object