Package org.sqlite.jdbc3

Class JDBC3PreparedStatement

java.lang.Object

org.sqlite.core.CoreStatement

org.sqlite.jdbc3.JDBC3Statement

org.sqlite.jdbc4.JDBC4Statement

org.sqlite.core.CorePreparedStatement

org.sqlite.jdbc3.JDBC3PreparedStatement

All Implemented Interfaces:

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

Direct Known Subclasses:

JDBC4PreparedStatement

public abstract class JDBC3PreparedStatement
extends CorePreparedStatement

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 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	JDBC3PreparedStatement(SQLiteConnection conn, java.lang.String sql)

Method Summary

Modifier and Type	Method	Description
void	addBatch()
void	addBatch(java.lang.String sql)
void	clearParameters()
boolean	execute()
boolean	execute(java.lang.String sql)
java.sql.ResultSet	executeQuery()
java.sql.ResultSet	executeQuery(java.lang.String sql)
int	executeUpdate()
int	executeUpdate(java.lang.String sql)
java.sql.ResultSetMetaData	getMetaData()
java.lang.String	getParameterClassName(int param)
int	getParameterCount()
java.sql.ParameterMetaData	getParameterMetaData()
int	getParameterMode(int pos)
int	getParameterType(int pos)
java.lang.String	getParameterTypeName(int pos)
int	getPrecision(int pos)
int	getScale(int pos)
java.sql.Statement	getStatement()
int	isNullable(int pos)
boolean	isSigned(int pos)
void	setArray(int i, java.sql.Array x)
void	setAsciiStream(int pos, java.io.InputStream istream, int length)
void	setBigDecimal(int pos, java.math.BigDecimal value)
void	setBinaryStream(int pos, java.io.InputStream istream, int length)
void	setBlob(int i, java.sql.Blob x)
void	setBoolean(int pos, boolean value)
void	setByte(int pos, byte value)
void	setBytes(int pos, byte[] value)
void	setCharacterStream(int pos, java.io.Reader reader, int length)
void	setClob(int i, java.sql.Clob x)
void	setDate(int pos, java.sql.Date x)
void	setDate(int pos, java.sql.Date x, java.util.Calendar cal)
void	setDouble(int pos, double value)
void	setFloat(int pos, float value)
void	setInt(int pos, int value)
void	setLong(int pos, long value)
void	setNull(int pos, int u1)
void	setNull(int pos, int u1, java.lang.String u2)
void	setObject(int pos, java.lang.Object value)
void	setObject(int p, java.lang.Object v, int t)
void	setObject(int p, java.lang.Object v, int t, int s)
void	setRef(int i, java.sql.Ref x)
void	setShort(int pos, short value)
void	setString(int pos, java.lang.String value)
void	setTime(int pos, java.sql.Time x)
void	setTime(int pos, java.sql.Time x, java.util.Calendar cal)
void	setTimestamp(int pos, java.sql.Timestamp x)
void	setTimestamp(int pos, java.sql.Timestamp x, java.util.Calendar cal)
void	setUnicodeStream(int pos, java.io.InputStream istream, int length)
void	setURL(int pos, java.net.URL x)
protected java.sql.SQLException	unused()

Methods inherited from class org.sqlite.core.CorePreparedStatement

batch, clearBatch, executeBatch, 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, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface java.sql.Statement

cancel, clearWarnings, enquoteIdentifier, enquoteLiteral, enquoteNCharLiteral, execute, execute, execute, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, 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

Constructor Detail

JDBC3PreparedStatement

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

Throws:

java.sql.SQLException

Method Detail

clearParameters

public void clearParameters()
                     throws java.sql.SQLException

Throws:

java.sql.SQLException

See Also:

PreparedStatement.clearParameters()

execute

public boolean execute()
                throws java.sql.SQLException

Throws:

java.sql.SQLException

See Also:

PreparedStatement.execute()

executeQuery

public java.sql.ResultSet executeQuery()
                                throws java.sql.SQLException

Throws:

java.sql.SQLException

See Also:

PreparedStatement.executeQuery()

executeUpdate

public int executeUpdate()
                  throws java.sql.SQLException

Throws:

java.sql.SQLException

See Also:

PreparedStatement.executeUpdate()

addBatch

public void addBatch()
              throws java.sql.SQLException

Throws:

java.sql.SQLException

See Also:

PreparedStatement.addBatch()

getParameterMetaData

public java.sql.ParameterMetaData getParameterMetaData()

See Also:

PreparedStatement.getParameterMetaData()

getParameterCount

public int getParameterCount()
                      throws java.sql.SQLException

Throws:

java.sql.SQLException

See Also:

ParameterMetaData.getParameterCount()

getParameterClassName

public java.lang.String getParameterClassName(int param)
                                       throws java.sql.SQLException

Throws:

java.sql.SQLException

See Also:

ParameterMetaData.getParameterClassName(int)

getParameterTypeName

public java.lang.String getParameterTypeName(int pos)

See Also:

ParameterMetaData.getParameterTypeName(int)

getParameterType

public int getParameterType(int pos)

See Also:

ParameterMetaData.getParameterType(int)

getParameterMode

public int getParameterMode(int pos)

See Also:

ParameterMetaData.getParameterMode(int)

getPrecision

public int getPrecision(int pos)

See Also:

ParameterMetaData.getPrecision(int)

getScale

public int getScale(int pos)

See Also:

ParameterMetaData.getScale(int)

isNullable

public int isNullable(int pos)

See Also:

ParameterMetaData.isNullable(int)

isSigned

public boolean isSigned(int pos)

See Also:

ParameterMetaData.isSigned(int)

getStatement

public java.sql.Statement getStatement()

Returns:

setBigDecimal

public void setBigDecimal(int pos,
                          java.math.BigDecimal value)
                   throws java.sql.SQLException

Throws:

java.sql.SQLException

See Also:

PreparedStatement.setBigDecimal(int, java.math.BigDecimal)

setBinaryStream

public void setBinaryStream(int pos,
                            java.io.InputStream istream,
                            int length)
                     throws java.sql.SQLException

Throws:

java.sql.SQLException

See Also:

PreparedStatement.setBinaryStream(int, java.io.InputStream, int)

setAsciiStream

public void setAsciiStream(int pos,
                           java.io.InputStream istream,
                           int length)
                    throws java.sql.SQLException

Throws:

java.sql.SQLException

See Also:

PreparedStatement.setAsciiStream(int, java.io.InputStream, int)

setUnicodeStream

public void setUnicodeStream(int pos,
                             java.io.InputStream istream,
                             int length)
                      throws java.sql.SQLException

Throws:

java.sql.SQLException

See Also:

PreparedStatement.setUnicodeStream(int, java.io.InputStream, int)

setBoolean

public void setBoolean(int pos,
                       boolean value)
                throws java.sql.SQLException

Throws:

java.sql.SQLException

See Also:

PreparedStatement.setBoolean(int, boolean)

setByte

public void setByte(int pos,
                    byte value)
             throws java.sql.SQLException

Throws:

java.sql.SQLException

See Also:

PreparedStatement.setByte(int, byte)

setBytes

public void setBytes(int pos,
                     byte[] value)
              throws java.sql.SQLException

Throws:

java.sql.SQLException

See Also:

PreparedStatement.setBytes(int, byte[])

setDouble

public void setDouble(int pos,
                      double value)
               throws java.sql.SQLException

Throws:

java.sql.SQLException

See Also:

PreparedStatement.setDouble(int, double)

setFloat

public void setFloat(int pos,
                     float value)
              throws java.sql.SQLException

Throws:

java.sql.SQLException

See Also:

PreparedStatement.setFloat(int, float)

setInt

public void setInt(int pos,
                   int value)
            throws java.sql.SQLException

Throws:

java.sql.SQLException

See Also:

PreparedStatement.setInt(int, int)

setLong

public void setLong(int pos,
                    long value)
             throws java.sql.SQLException

Throws:

java.sql.SQLException

See Also:

PreparedStatement.setLong(int, long)

setNull

public void setNull(int pos,
                    int u1)
             throws java.sql.SQLException

Throws:

java.sql.SQLException

See Also:

PreparedStatement.setNull(int, int)

setNull

public void setNull(int pos,
                    int u1,
                    java.lang.String u2)
             throws java.sql.SQLException

Throws:

java.sql.SQLException

See Also:

PreparedStatement.setNull(int, int, java.lang.String)

setObject

public void setObject(int pos,
                      java.lang.Object value)
               throws java.sql.SQLException

Throws:

java.sql.SQLException

See Also:

PreparedStatement.setObject(int, java.lang.Object)

setObject

public void setObject(int p,
                      java.lang.Object v,
                      int t)
               throws java.sql.SQLException

Throws:

java.sql.SQLException

See Also:

PreparedStatement.setObject(int, java.lang.Object, int)

setObject

public void setObject(int p,
                      java.lang.Object v,
                      int t,
                      int s)
               throws java.sql.SQLException

Throws:

java.sql.SQLException

See Also:

PreparedStatement.setObject(int, java.lang.Object, int, int)

setShort

public void setShort(int pos,
                     short value)
              throws java.sql.SQLException

Throws:

java.sql.SQLException

See Also:

PreparedStatement.setShort(int, short)

setString

public void setString(int pos,
                      java.lang.String value)
               throws java.sql.SQLException

Throws:

java.sql.SQLException

See Also:

PreparedStatement.setString(int, java.lang.String)

setCharacterStream

public void setCharacterStream(int pos,
                               java.io.Reader reader,
                               int length)
                        throws java.sql.SQLException

Throws:

java.sql.SQLException

See Also:

PreparedStatement.setCharacterStream(int, java.io.Reader, int)

setDate

public void setDate(int pos,
                    java.sql.Date x)
             throws java.sql.SQLException

Throws:

java.sql.SQLException

See Also:

PreparedStatement.setDate(int, java.sql.Date)

setDate

public void setDate(int pos,
                    java.sql.Date x,
                    java.util.Calendar cal)
             throws java.sql.SQLException

Throws:

java.sql.SQLException

See Also:

PreparedStatement.setDate(int, java.sql.Date, java.util.Calendar)

setTime

public void setTime(int pos,
                    java.sql.Time x)
             throws java.sql.SQLException

Throws:

java.sql.SQLException

See Also:

PreparedStatement.setTime(int, java.sql.Time)

setTime

public void setTime(int pos,
                    java.sql.Time x,
                    java.util.Calendar cal)
             throws java.sql.SQLException

Throws:

java.sql.SQLException

See Also:

PreparedStatement.setTime(int, java.sql.Time, java.util.Calendar)

setTimestamp

public void setTimestamp(int pos,
                         java.sql.Timestamp x)
                  throws java.sql.SQLException

Throws:

java.sql.SQLException

See Also:

PreparedStatement.setTimestamp(int, java.sql.Timestamp)

setTimestamp

public void setTimestamp(int pos,
                         java.sql.Timestamp x,
                         java.util.Calendar cal)
                  throws java.sql.SQLException

Throws:

java.sql.SQLException

See Also:

PreparedStatement.setTimestamp(int, java.sql.Timestamp, java.util.Calendar)

getMetaData

public java.sql.ResultSetMetaData getMetaData()
                                       throws java.sql.SQLException

Throws:

java.sql.SQLException

See Also:

PreparedStatement.getMetaData()

unused

protected java.sql.SQLException unused()

Overrides:

unused in class JDBC3Statement

setArray

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

Throws:

java.sql.SQLException

setBlob

public void setBlob(int i,
                    java.sql.Blob x)
             throws java.sql.SQLException

Throws:

java.sql.SQLException

setClob

public void setClob(int i,
                    java.sql.Clob x)
             throws java.sql.SQLException

Throws:

java.sql.SQLException

setRef

public void setRef(int i,
                   java.sql.Ref x)
            throws java.sql.SQLException

Throws:

java.sql.SQLException

setURL

public void setURL(int pos,
                   java.net.URL x)
            throws java.sql.SQLException

Throws:

java.sql.SQLException

execute

public boolean execute(java.lang.String sql)
                throws java.sql.SQLException

Specified by:

execute in interface java.sql.Statement

Overrides:

execute in class JDBC3Statement

Throws:

java.sql.SQLException

See Also:

CoreStatement.exec(java.lang.String)

executeUpdate

public int executeUpdate(java.lang.String sql)
                  throws java.sql.SQLException

Specified by:

executeUpdate in interface java.sql.Statement

Overrides:

executeUpdate in class JDBC3Statement

Throws:

java.sql.SQLException

See Also:

CoreStatement.exec(java.lang.String)

executeQuery

public java.sql.ResultSet executeQuery(java.lang.String sql)
                                throws java.sql.SQLException

Specified by:

executeQuery in interface java.sql.Statement

Overrides:

executeQuery in class JDBC3Statement

Throws:

java.sql.SQLException

See Also:

CoreStatement.exec(String)

addBatch

public void addBatch(java.lang.String sql)
              throws java.sql.SQLException

Specified by:

addBatch in interface java.sql.Statement

Overrides:

addBatch in class JDBC3Statement

Throws:

java.sql.SQLException

See Also:

Statement.addBatch(java.lang.String)