Package org.sqlite.jdbc3
Class JDBC3Statement
- java.lang.Object
-
- org.sqlite.core.CoreStatement
-
- org.sqlite.jdbc3.JDBC3Statement
-
- All Implemented Interfaces:
Codes
- Direct Known Subclasses:
JDBC4Statement
public abstract class JDBC3Statement extends CoreStatement
-
-
Nested Class Summary
Nested Classes Modifier and Type Class Description protected static interface
JDBC3Statement.SQLCallable<T>
-
Field Summary
Fields Modifier and Type Field Description protected boolean
exhaustedResults
protected long
updateCount
-
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
-
-
Constructor Summary
Constructors Modifier Constructor Description protected
JDBC3Statement(SQLiteConnection conn)
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description void
addBatch(String sql)
void
cancel()
void
clearBatch()
void
clearWarnings()
void
close()
boolean
execute(String sql)
boolean
execute(String sql, int autoGeneratedKeys)
boolean
execute(String sql, int[] colinds)
boolean
execute(String sql, String[] colnames)
int[]
executeBatch()
long[]
executeLargeBatch()
long
executeLargeUpdate(String sql)
long
executeLargeUpdate(String sql, int autoGeneratedKeys)
long
executeLargeUpdate(String sql, int[] colinds)
long
executeLargeUpdate(String sql, String[] cols)
ResultSet
executeQuery(String sql)
ResultSet
executeQuery(String sql, boolean closeStmt)
int
executeUpdate(String sql)
int
executeUpdate(String sql, int autoGeneratedKeys)
int
executeUpdate(String sql, int[] colinds)
int
executeUpdate(String sql, String[] cols)
Connection
getConnection()
int
getFetchDirection()
int
getFetchSize()
long
getLargeMaxRows()
long
getLargeUpdateCount()
This function has a complex behaviour best understood by carefully reading the JavaDoc for getMoreResults() and considering the test StatementTest.execute().int
getMaxFieldSize()
int
getMaxRows()
boolean
getMoreResults()
SQLite does not support multiple results from execute().boolean
getMoreResults(int current)
int
getQueryTimeout()
ResultSet
getResultSet()
int
getResultSetConcurrency()
int
getResultSetHoldability()
int
getResultSetType()
int
getUpdateCount()
This function has a complex behaviour best understood by carefully reading the JavaDoc for getMoreResults() and considering the test StatementTest.execute().SQLWarning
getWarnings()
void
setCursorName(String name)
void
setEscapeProcessing(boolean enable)
void
setFetchDirection(int direction)
void
setFetchSize(int r)
void
setLargeMaxRows(long max)
void
setMaxFieldSize(int max)
void
setMaxRows(int max)
void
setQueryTimeout(int seconds)
protected SQLException
unsupported()
protected <T> T
withConnectionTimeout(JDBC3Statement.SQLCallable<T> callable)
-
Methods inherited from class org.sqlite.core.CoreStatement
checkIndex, checkOpen, clearGeneratedKeys, exec, exec, getConnectionConfig, getDatabase, getGeneratedKeys, internalClose, notifyFirstStatementExecuted, updateGeneratedKeys
-
-
-
-
Constructor Detail
-
JDBC3Statement
protected JDBC3Statement(SQLiteConnection conn)
-
-
Method Detail
-
close
public void close() throws SQLException
- Throws:
SQLException
- See Also:
Statement.close()
-
execute
public boolean execute(String sql) throws SQLException
- Throws:
SQLException
- See Also:
Statement.execute(java.lang.String)
-
execute
public boolean execute(String sql, int autoGeneratedKeys) throws SQLException
- Throws:
SQLException
- See Also:
Statement.execute(java.lang.String, int)
-
executeQuery
public ResultSet executeQuery(String sql, boolean closeStmt) throws SQLException
- Specified by:
executeQuery
in classCoreStatement
- Parameters:
closeStmt
- Whether to close this statement when the resultset is closed.- Throws:
SQLException
- See Also:
Statement.executeQuery(java.lang.String)
-
executeQuery
public ResultSet executeQuery(String sql) throws SQLException
- Throws:
SQLException
- See Also:
Statement.executeQuery(java.lang.String)
-
executeUpdate
public int executeUpdate(String sql) throws SQLException
- Throws:
SQLException
- See Also:
Statement.executeUpdate(java.lang.String)
-
executeUpdate
public int executeUpdate(String sql, int autoGeneratedKeys) throws SQLException
- Throws:
SQLException
- See Also:
Statement.executeUpdate(java.lang.String, int)
-
executeLargeUpdate
public long executeLargeUpdate(String sql) throws SQLException
- Throws:
SQLException
- See Also:
Statement.executeLargeUpdate(java.lang.String)
-
executeLargeUpdate
public long executeLargeUpdate(String sql, int autoGeneratedKeys) throws SQLException
- Throws:
SQLException
- See Also:
Statement.executeLargeUpdate(java.lang.String, int)
-
getResultSet
public ResultSet getResultSet() throws SQLException
- Throws:
SQLException
- See Also:
Statement.getResultSet()
-
getUpdateCount
public int getUpdateCount() throws SQLException
This function has a complex behaviour best understood by carefully reading the JavaDoc for getMoreResults() and considering the test StatementTest.execute().- Throws:
SQLException
- See Also:
Statement.getUpdateCount()
-
getLargeUpdateCount
public long getLargeUpdateCount() throws SQLException
This function has a complex behaviour best understood by carefully reading the JavaDoc for getMoreResults() and considering the test StatementTest.execute().- Throws:
SQLException
- See Also:
Statement.getLargeUpdateCount()
-
addBatch
public void addBatch(String sql) throws SQLException
- Throws:
SQLException
- See Also:
Statement.addBatch(java.lang.String)
-
clearBatch
public void clearBatch() throws SQLException
- Throws:
SQLException
- See Also:
Statement.clearBatch()
-
executeBatch
public int[] executeBatch() throws SQLException
- Throws:
SQLException
- See Also:
Statement.executeBatch()
-
executeLargeBatch
public long[] executeLargeBatch() throws SQLException
- Throws:
SQLException
- See Also:
Statement.executeLargeBatch()
-
setCursorName
public void setCursorName(String name)
-
getWarnings
public SQLWarning getWarnings() throws SQLException
- Throws:
SQLException
- See Also:
Statement.getWarnings()
-
clearWarnings
public void clearWarnings() throws SQLException
- Throws:
SQLException
- See Also:
Statement.clearWarnings()
-
getConnection
public Connection getConnection() throws SQLException
- Throws:
SQLException
- See Also:
Statement.getConnection()
-
cancel
public void cancel() throws SQLException
- Throws:
SQLException
- See Also:
Statement.cancel()
-
getQueryTimeout
public int getQueryTimeout() throws SQLException
- Throws:
SQLException
- See Also:
Statement.getQueryTimeout()
-
setQueryTimeout
public void setQueryTimeout(int seconds) throws SQLException
- Throws:
SQLException
- See Also:
Statement.setQueryTimeout(int)
-
getMaxRows
public int getMaxRows() throws SQLException
- Throws:
SQLException
- See Also:
Statement.getMaxRows()
-
getLargeMaxRows
public long getLargeMaxRows() throws SQLException
- Throws:
SQLException
- See Also:
Statement.getLargeMaxRows()
-
setMaxRows
public void setMaxRows(int max) throws SQLException
- Throws:
SQLException
- See Also:
Statement.setMaxRows(int)
-
setLargeMaxRows
public void setLargeMaxRows(long max) throws SQLException
- Throws:
SQLException
- See Also:
Statement.setLargeMaxRows(long)
-
getMaxFieldSize
public int getMaxFieldSize() throws SQLException
- Throws:
SQLException
- See Also:
Statement.getMaxFieldSize()
-
setMaxFieldSize
public void setMaxFieldSize(int max) throws SQLException
- Throws:
SQLException
- See Also:
Statement.setMaxFieldSize(int)
-
getFetchSize
public int getFetchSize() throws SQLException
- Throws:
SQLException
- See Also:
Statement.getFetchSize()
-
setFetchSize
public void setFetchSize(int r) throws SQLException
- Throws:
SQLException
- See Also:
Statement.setFetchSize(int)
-
getFetchDirection
public int getFetchDirection() throws SQLException
- Throws:
SQLException
- See Also:
Statement.getFetchDirection()
-
setFetchDirection
public void setFetchDirection(int direction) throws SQLException
- Throws:
SQLException
- See Also:
Statement.setFetchDirection(int)
-
getMoreResults
public boolean getMoreResults() throws SQLException
SQLite does not support multiple results from execute().- Throws:
SQLException
- See Also:
Statement.getMoreResults()
-
getMoreResults
public boolean getMoreResults(int current) throws SQLException
- Throws:
SQLException
- See Also:
Statement.getMoreResults(int)
-
getResultSetConcurrency
public int getResultSetConcurrency() throws SQLException
- Throws:
SQLException
- See Also:
Statement.getResultSetConcurrency()
-
getResultSetHoldability
public int getResultSetHoldability() throws SQLException
- Throws:
SQLException
- See Also:
Statement.getResultSetHoldability()
-
getResultSetType
public int getResultSetType() throws SQLException
- Throws:
SQLException
- See Also:
Statement.getResultSetType()
-
setEscapeProcessing
public void setEscapeProcessing(boolean enable)
- See Also:
Statement.setEscapeProcessing(boolean)
-
unsupported
protected SQLException unsupported()
-
execute
public boolean execute(String sql, int[] colinds) throws SQLException
- Throws:
SQLException
-
execute
public boolean execute(String sql, String[] colnames) throws SQLException
- Throws:
SQLException
-
executeUpdate
public int executeUpdate(String sql, int[] colinds) throws SQLException
- Throws:
SQLException
-
executeUpdate
public int executeUpdate(String sql, String[] cols) throws SQLException
- Throws:
SQLException
-
executeLargeUpdate
public long executeLargeUpdate(String sql, int[] colinds) throws SQLException
- Throws:
SQLException
-
executeLargeUpdate
public long executeLargeUpdate(String sql, String[] cols) throws SQLException
- Throws:
SQLException
-
withConnectionTimeout
protected <T> T withConnectionTimeout(JDBC3Statement.SQLCallable<T> callable) throws SQLException
- Throws:
SQLException
-
-