org.sqlite.jdbc4

Class JDBC4PreparedStatement

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

All Implemented Interfaces:

AutoCloseable, ParameterMetaData, PreparedStatement, Statement, Wrapper, Codes

public class JDBC4PreparedStatement
extends JDBC3PreparedStatement
implements PreparedStatement, ParameterMetaData

Field Summary

Fields inherited from class org.sqlite.core.CorePreparedStatement

batchQueryCount, columnCount, paramCount

Fields inherited from class org.sqlite.core.CoreStatement

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

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

Fields inherited from interface java.sql.ParameterMetaData

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

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

Constructor and Description
JDBC4PreparedStatement(SQLiteConnection conn, String sql)

Method Summary

Modifier and Type	Method and Description
void	setAsciiStream(int parameterIndex, InputStream x)
void	setAsciiStream(int parameterIndex, InputStream x, long length)
void	setBinaryStream(int parameterIndex, InputStream x)
void	setBinaryStream(int parameterIndex, InputStream x, long length)
void	setBlob(int parameterIndex, InputStream inputStream)
void	setBlob(int parameterIndex, InputStream inputStream, long length)
void	setCharacterStream(int parameterIndex, Reader reader)
void	setCharacterStream(int parameterIndex, Reader reader, long length)
void	setClob(int parameterIndex, Reader reader)
void	setClob(int parameterIndex, Reader reader, long length)
void	setNCharacterStream(int parameterIndex, Reader value)
void	setNCharacterStream(int parameterIndex, Reader value, long length)
void	setNClob(int parameterIndex, NClob value)
void	setNClob(int parameterIndex, Reader reader)
void	setNClob(int parameterIndex, Reader reader, long length)
void	setNString(int parameterIndex, String value)
void	setRowId(int parameterIndex, RowId x)
void	setSQLXML(int parameterIndex, SQLXML xmlObject)

Methods inherited from class org.sqlite.jdbc3.JDBC3PreparedStatement

addBatch, addBatch, clearParameters, execute, execute, executeQuery, executeQuery, executeUpdate, executeUpdate, getMetaData, getParameterClassName, getParameterCount, getParameterMetaData, getParameterMode, getParameterType, getParameterTypeName, getPrecision, getScale, getStatement, isNullable, isSigned, setArray, 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, 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, getConnectionConfig, getDatbase, internalClose

Methods inherited from class java.lang.Object

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

Methods inherited from interface java.sql.PreparedStatement

addBatch, clearParameters, execute, executeLargeUpdate, executeQuery, executeUpdate, getMetaData, getParameterMetaData, setArray, 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

Methods inherited from interface java.sql.ParameterMetaData

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

Constructor Detail

JDBC4PreparedStatement

public JDBC4PreparedStatement(SQLiteConnection conn,
                              String sql)
                       throws SQLException

Throws:

SQLException

Method Detail

setRowId

public void setRowId(int parameterIndex,
                     RowId x)
              throws SQLException

Specified by:

setRowId in interface PreparedStatement

Throws:

SQLException

setNString

public void setNString(int parameterIndex,
                       String value)
                throws SQLException

Specified by:

setNString in interface PreparedStatement

Throws:

SQLException

setNCharacterStream

public void setNCharacterStream(int parameterIndex,
                                Reader value,
                                long length)
                         throws SQLException

Specified by:

setNCharacterStream in interface PreparedStatement

Throws:

SQLException

setNClob

public void setNClob(int parameterIndex,
                     NClob value)
              throws SQLException

Specified by:

setNClob in interface PreparedStatement

Throws:

SQLException

setClob

public void setClob(int parameterIndex,
                    Reader reader,
                    long length)
             throws SQLException

Specified by:

setClob in interface PreparedStatement

Throws:

SQLException

setBlob

public void setBlob(int parameterIndex,
                    InputStream inputStream,
                    long length)
             throws SQLException

Specified by:

setBlob in interface PreparedStatement

Throws:

SQLException

setNClob

public void setNClob(int parameterIndex,
                     Reader reader,
                     long length)
              throws SQLException

Specified by:

setNClob in interface PreparedStatement

Throws:

SQLException

setSQLXML

public void setSQLXML(int parameterIndex,
                      SQLXML xmlObject)
               throws SQLException

Specified by:

setSQLXML in interface PreparedStatement

Throws:

SQLException

setAsciiStream

public void setAsciiStream(int parameterIndex,
                           InputStream x,
                           long length)
                    throws SQLException

Specified by:

setAsciiStream in interface PreparedStatement

Throws:

SQLException

setBinaryStream

public void setBinaryStream(int parameterIndex,
                            InputStream x,
                            long length)
                     throws SQLException

Specified by:

setBinaryStream in interface PreparedStatement

Throws:

SQLException

setCharacterStream

public void setCharacterStream(int parameterIndex,
                               Reader reader,
                               long length)
                        throws SQLException

Specified by:

setCharacterStream in interface PreparedStatement

Throws:

SQLException

setAsciiStream

public void setAsciiStream(int parameterIndex,
                           InputStream x)
                    throws SQLException

Specified by:

setAsciiStream in interface PreparedStatement

Throws:

SQLException

setBinaryStream

public void setBinaryStream(int parameterIndex,
                            InputStream x)
                     throws SQLException

Specified by:

setBinaryStream in interface PreparedStatement

Throws:

SQLException

setCharacterStream

public void setCharacterStream(int parameterIndex,
                               Reader reader)
                        throws SQLException

Specified by:

setCharacterStream in interface PreparedStatement

Throws:

SQLException

setNCharacterStream

public void setNCharacterStream(int parameterIndex,
                                Reader value)
                         throws SQLException

Specified by:

setNCharacterStream in interface PreparedStatement

Throws:

SQLException

setClob

public void setClob(int parameterIndex,
                    Reader reader)
             throws SQLException

Specified by:

setClob in interface PreparedStatement

Throws:

SQLException

setBlob

public void setBlob(int parameterIndex,
                    InputStream inputStream)
             throws SQLException

Specified by:

setBlob in interface PreparedStatement

Throws:

SQLException

setNClob

public void setNClob(int parameterIndex,
                     Reader reader)
              throws SQLException

Specified by:

setNClob in interface PreparedStatement

Throws:

SQLException