- 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:
AutoCloseable
,Statement
,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, String sql)
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description void
addBatch()
void
addBatch(String sql)
void
clearParameters()
boolean
execute()
boolean
execute(String sql)
ResultSet
executeQuery()
ResultSet
executeQuery(String sql)
int
executeUpdate()
int
executeUpdate(String sql)
ResultSetMetaData
getMetaData()
String
getParameterClassName(int param)
int
getParameterCount()
ParameterMetaData
getParameterMetaData()
int
getParameterMode(int pos)
int
getParameterType(int pos)
String
getParameterTypeName(int pos)
int
getPrecision(int pos)
int
getScale(int pos)
Statement
getStatement()
int
isNullable(int pos)
boolean
isSigned(int pos)
void
setArray(int i, Array x)
void
setAsciiStream(int pos, InputStream istream, int length)
void
setBigDecimal(int pos, BigDecimal value)
void
setBinaryStream(int pos, InputStream istream, int length)
void
setBlob(int i, Blob x)
void
setBoolean(int pos, boolean value)
void
setByte(int pos, byte value)
void
setBytes(int pos, byte[] value)
void
setCharacterStream(int pos, Reader reader, int length)
void
setClob(int i, Clob x)
void
setDate(int pos, Date x)
void
setDate(int pos, Date x, 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, String u2)
void
setObject(int pos, Object value)
void
setObject(int p, Object v, int t)
void
setObject(int p, Object v, int t, int s)
void
setRef(int i, Ref x)
void
setShort(int pos, short value)
void
setString(int pos, String value)
void
setTime(int pos, Time x)
void
setTime(int pos, Time x, Calendar cal)
void
setTimestamp(int pos, Timestamp x)
void
setTimestamp(int pos, Timestamp x, Calendar cal)
void
setUnicodeStream(int pos, InputStream istream, int length)
void
setURL(int pos, URL x)
protected 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, String sql) throws SQLException
- Throws:
SQLException
-
-
Method Detail
-
clearParameters
public void clearParameters() throws SQLException
- Throws:
SQLException
- See Also:
PreparedStatement.clearParameters()
-
execute
public boolean execute() throws SQLException
- Throws:
SQLException
- See Also:
PreparedStatement.execute()
-
executeQuery
public ResultSet executeQuery() throws SQLException
- Throws:
SQLException
- See Also:
PreparedStatement.executeQuery()
-
executeUpdate
public int executeUpdate() throws SQLException
- Throws:
SQLException
- See Also:
PreparedStatement.executeUpdate()
-
addBatch
public void addBatch() throws SQLException
- Throws:
SQLException
- See Also:
PreparedStatement.addBatch()
-
getParameterMetaData
public ParameterMetaData getParameterMetaData()
- See Also:
PreparedStatement.getParameterMetaData()
-
getParameterCount
public int getParameterCount() throws SQLException
- Throws:
SQLException
- See Also:
ParameterMetaData.getParameterCount()
-
getParameterClassName
public String getParameterClassName(int param) throws SQLException
- Throws:
SQLException
- See Also:
ParameterMetaData.getParameterClassName(int)
-
getParameterTypeName
public String getParameterTypeName(int pos)
-
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 Statement getStatement()
- Returns:
-
setBigDecimal
public void setBigDecimal(int pos, BigDecimal value) throws SQLException
- Throws:
SQLException
- See Also:
PreparedStatement.setBigDecimal(int, java.math.BigDecimal)
-
setBinaryStream
public void setBinaryStream(int pos, InputStream istream, int length) throws SQLException
- Throws:
SQLException
- See Also:
PreparedStatement.setBinaryStream(int, java.io.InputStream, int)
-
setAsciiStream
public void setAsciiStream(int pos, InputStream istream, int length) throws SQLException
- Throws:
SQLException
- See Also:
PreparedStatement.setAsciiStream(int, java.io.InputStream, int)
-
setUnicodeStream
public void setUnicodeStream(int pos, InputStream istream, int length) throws SQLException
-
setBoolean
public void setBoolean(int pos, boolean value) throws SQLException
- Throws:
SQLException
- See Also:
PreparedStatement.setBoolean(int, boolean)
-
setByte
public void setByte(int pos, byte value) throws SQLException
- Throws:
SQLException
- See Also:
PreparedStatement.setByte(int, byte)
-
setBytes
public void setBytes(int pos, byte[] value) throws SQLException
- Throws:
SQLException
- See Also:
PreparedStatement.setBytes(int, byte[])
-
setDouble
public void setDouble(int pos, double value) throws SQLException
- Throws:
SQLException
- See Also:
PreparedStatement.setDouble(int, double)
-
setFloat
public void setFloat(int pos, float value) throws SQLException
- Throws:
SQLException
- See Also:
PreparedStatement.setFloat(int, float)
-
setInt
public void setInt(int pos, int value) throws SQLException
- Throws:
SQLException
- See Also:
PreparedStatement.setInt(int, int)
-
setLong
public void setLong(int pos, long value) throws SQLException
- Throws:
SQLException
- See Also:
PreparedStatement.setLong(int, long)
-
setNull
public void setNull(int pos, int u1) throws SQLException
- Throws:
SQLException
- See Also:
PreparedStatement.setNull(int, int)
-
setNull
public void setNull(int pos, int u1, String u2) throws SQLException
- Throws:
SQLException
- See Also:
PreparedStatement.setNull(int, int, java.lang.String)
-
setObject
public void setObject(int pos, Object value) throws SQLException
- Throws:
SQLException
- See Also:
PreparedStatement.setObject(int, java.lang.Object)
-
setObject
public void setObject(int p, Object v, int t) throws SQLException
- Throws:
SQLException
- See Also:
PreparedStatement.setObject(int, java.lang.Object, int)
-
setObject
public void setObject(int p, Object v, int t, int s) throws SQLException
- Throws:
SQLException
- See Also:
PreparedStatement.setObject(int, java.lang.Object, int, int)
-
setShort
public void setShort(int pos, short value) throws SQLException
- Throws:
SQLException
- See Also:
PreparedStatement.setShort(int, short)
-
setString
public void setString(int pos, String value) throws SQLException
- Throws:
SQLException
- See Also:
PreparedStatement.setString(int, java.lang.String)
-
setCharacterStream
public void setCharacterStream(int pos, Reader reader, int length) throws SQLException
- Throws:
SQLException
- See Also:
PreparedStatement.setCharacterStream(int, java.io.Reader, int)
-
setDate
public void setDate(int pos, Date x) throws SQLException
- Throws:
SQLException
- See Also:
PreparedStatement.setDate(int, java.sql.Date)
-
setDate
public void setDate(int pos, Date x, Calendar cal) throws SQLException
-
setTime
public void setTime(int pos, Time x) throws SQLException
- Throws:
SQLException
- See Also:
PreparedStatement.setTime(int, java.sql.Time)
-
setTime
public void setTime(int pos, Time x, Calendar cal) throws SQLException
-
setTimestamp
public void setTimestamp(int pos, Timestamp x) throws SQLException
- Throws:
SQLException
- See Also:
PreparedStatement.setTimestamp(int, java.sql.Timestamp)
-
setTimestamp
public void setTimestamp(int pos, Timestamp x, Calendar cal) throws SQLException
-
getMetaData
public ResultSetMetaData getMetaData() throws SQLException
- Throws:
SQLException
- See Also:
PreparedStatement.getMetaData()
-
unused
protected SQLException unused()
- Overrides:
unused
in classJDBC3Statement
-
setArray
public void setArray(int i, Array x) throws SQLException
- Throws:
SQLException
-
setBlob
public void setBlob(int i, Blob x) throws SQLException
- Throws:
SQLException
-
setClob
public void setClob(int i, Clob x) throws SQLException
- Throws:
SQLException
-
setRef
public void setRef(int i, Ref x) throws SQLException
- Throws:
SQLException
-
setURL
public void setURL(int pos, URL x) throws SQLException
- Throws:
SQLException
-
execute
public boolean execute(String sql) throws SQLException
- Specified by:
execute
in interfaceStatement
- Overrides:
execute
in classJDBC3Statement
- Throws:
SQLException
- See Also:
CoreStatement.exec(java.lang.String)
-
executeUpdate
public int executeUpdate(String sql) throws SQLException
- Specified by:
executeUpdate
in interfaceStatement
- Overrides:
executeUpdate
in classJDBC3Statement
- Throws:
SQLException
- See Also:
CoreStatement.exec(java.lang.String)
-
executeQuery
public ResultSet executeQuery(String sql) throws SQLException
- Specified by:
executeQuery
in interfaceStatement
- Overrides:
executeQuery
in classJDBC3Statement
- Throws:
SQLException
- See Also:
CoreStatement.exec(String)
-
addBatch
public void addBatch(String sql) throws SQLException
- Specified by:
addBatch
in interfaceStatement
- Overrides:
addBatch
in classJDBC3Statement
- Throws:
SQLException
- See Also:
Statement.addBatch(java.lang.String)
-
-