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

Nested Class Summary

Nested classes/interfaces inherited from class JDBC3Statement

JDBC3Statement.SQLCallable<T>

Field Summary

Fields inherited from class CorePreparedStatement

batchQueryCount, columnCount, paramCount

Fields inherited from class JDBC3Statement

exhaustedResults, updateCount

Fields inherited from class CoreStatement

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

Fields inherited from interface 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 ParameterMetaData

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

Fields inherited from interface 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
JDBC4PreparedStatement(SQLiteConnection conn, String sql)

Method Summary

Modifier and Type	Method	Description
private byte[]	readBytes(InputStream istream)	Reads given number of bytes from an input stream.
private void	requireLengthIsPositiveInt(long length)
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, Reader reader)
void	setNClob(int parameterIndex, Reader reader, long length)
void	setNClob(int parameterIndex, NClob value)
void	setNString(int parameterIndex, String value)
void	setRowId(int parameterIndex, RowId x)
void	setSQLXML(int parameterIndex, SQLXML xmlObject)
String	toString()

Methods inherited from class JDBC3PreparedStatement

addBatch, addBatch, clearParameters, execute, execute, execute, execute, execute, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeQuery, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getMetaData, getParameterClassName, getParameterCount, getParameterMetaData, getParameterMode, getParameterType, getParameterTypeName, getPrecision, getScale, getStatement, invalid, 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, unsupported

Methods inherited from class CorePreparedStatement

batch, clearBatch, executeBatch, executeLargeBatch, setDateByMilliseconds

Methods inherited from class JDBC4Statement

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

Methods inherited from class JDBC3Statement

cancel, clearWarnings, executeQuery, getConnection, getFetchDirection, getFetchSize, getLargeMaxRows, getLargeUpdateCount, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setQueryTimeout, withConnectionTimeout

Methods inherited from class CoreStatement

checkIndex, checkOpen, clearGeneratedKeys, exec, exec, getConnectionConfig, getDatabase, getGeneratedKeys, internalClose, notifyFirstStatementExecuted, updateGeneratedKeys

Methods inherited from class Object

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

Methods inherited from interface ParameterMetaData

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

Methods inherited from interface 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 Statement

addBatch, cancel, clearBatch, clearWarnings, close, closeOnCompletion, enquoteIdentifier, enquoteLiteral, enquoteNCharLiteral, 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, isSimpleIdentifier, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout

Methods inherited from interface Wrapper

isWrapperFor, unwrap

Constructor Details

JDBC4PreparedStatement

public JDBC4PreparedStatement(SQLiteConnection conn,
 String sql)
                       throws SQLException

Throws:

SQLException

Method Details

toString

public String toString()

Overrides:

toString in class Object

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

requireLengthIsPositiveInt

private void requireLengthIsPositiveInt(long length)
                                 throws SQLFeatureNotSupportedException

Throws:

SQLFeatureNotSupportedException

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

readBytes

private byte[] readBytes(InputStream istream)
                  throws SQLException

Reads given number of bytes from an input stream.

Parameters:

istream - The input stream.

length - The number of bytes to read.

Returns:

byte array.

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