public abstract class JDBC3Statement extends CoreStatement
Modifier and Type | Class and Description |
---|---|
protected static interface |
JDBC3Statement.SQLCallable<T> |
batch, batchPos, conn, pointer, resultsWaiting, rs, sql
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
Modifier | Constructor and Description |
---|---|
protected |
JDBC3Statement(SQLiteConnection conn) |
Modifier and Type | Method and 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() |
ResultSet |
getGeneratedKeys()
As SQLite's last_insert_rowid() function is DB-specific not statement specific, this function
introduces a race condition if the same connection is used by two threads and both insert.
|
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) |
checkOpen, exec, exec, getConnectionConfig, getDatabase, internalClose, notifyFirstStatementExecuted
protected JDBC3Statement(SQLiteConnection conn)
public void close() throws SQLException
SQLException
Statement.close()
public boolean execute(String sql) throws SQLException
SQLException
Statement.execute(java.lang.String)
public boolean execute(String sql, int autoGeneratedKeys) throws SQLException
SQLException
Statement.execute(java.lang.String, int)
public ResultSet executeQuery(String sql, boolean closeStmt) throws SQLException
executeQuery
in class CoreStatement
closeStmt
- Whether to close this statement when the resultset is closed.SQLException
Statement.executeQuery(java.lang.String)
public ResultSet executeQuery(String sql) throws SQLException
SQLException
Statement.executeQuery(java.lang.String)
public int executeUpdate(String sql) throws SQLException
SQLException
Statement.executeUpdate(java.lang.String)
public int executeUpdate(String sql, int autoGeneratedKeys) throws SQLException
SQLException
Statement.executeUpdate(java.lang.String, int)
public long executeLargeUpdate(String sql) throws SQLException
SQLException
Statement.executeLargeUpdate(java.lang.String)
public long executeLargeUpdate(String sql, int autoGeneratedKeys) throws SQLException
SQLException
Statement.executeLargeUpdate(java.lang.String, int)
public ResultSet getResultSet() throws SQLException
SQLException
Statement.getResultSet()
public int getUpdateCount() throws SQLException
SQLException
Statement.getUpdateCount()
public long getLargeUpdateCount() throws SQLException
SQLException
Statement.getLargeUpdateCount()
public void addBatch(String sql) throws SQLException
SQLException
Statement.addBatch(java.lang.String)
public void clearBatch() throws SQLException
SQLException
Statement.clearBatch()
public int[] executeBatch() throws SQLException
SQLException
Statement.executeBatch()
public long[] executeLargeBatch() throws SQLException
SQLException
Statement.executeLargeBatch()
public void setCursorName(String name)
public SQLWarning getWarnings() throws SQLException
SQLException
Statement.getWarnings()
public void clearWarnings() throws SQLException
SQLException
Statement.clearWarnings()
public Connection getConnection() throws SQLException
SQLException
Statement.getConnection()
public void cancel() throws SQLException
SQLException
Statement.cancel()
public int getQueryTimeout() throws SQLException
SQLException
Statement.getQueryTimeout()
public void setQueryTimeout(int seconds) throws SQLException
SQLException
Statement.setQueryTimeout(int)
public int getMaxRows() throws SQLException
SQLException
Statement.getMaxRows()
public long getLargeMaxRows() throws SQLException
SQLException
Statement.getLargeMaxRows()
public void setMaxRows(int max) throws SQLException
SQLException
Statement.setMaxRows(int)
public void setLargeMaxRows(long max) throws SQLException
SQLException
Statement.setLargeMaxRows(long)
public int getMaxFieldSize() throws SQLException
SQLException
Statement.getMaxFieldSize()
public void setMaxFieldSize(int max) throws SQLException
SQLException
Statement.setMaxFieldSize(int)
public int getFetchSize() throws SQLException
SQLException
Statement.getFetchSize()
public void setFetchSize(int r) throws SQLException
SQLException
Statement.setFetchSize(int)
public int getFetchDirection() throws SQLException
SQLException
Statement.getFetchDirection()
public void setFetchDirection(int direction) throws SQLException
SQLException
Statement.setFetchDirection(int)
public ResultSet getGeneratedKeys() throws SQLException
SQLException
Statement.getGeneratedKeys()
public boolean getMoreResults() throws SQLException
SQLException
Statement.getMoreResults()
public boolean getMoreResults(int current) throws SQLException
SQLException
Statement.getMoreResults(int)
public int getResultSetConcurrency() throws SQLException
SQLException
Statement.getResultSetConcurrency()
public int getResultSetHoldability() throws SQLException
SQLException
Statement.getResultSetHoldability()
public int getResultSetType() throws SQLException
SQLException
Statement.getResultSetType()
public void setEscapeProcessing(boolean enable)
Statement.setEscapeProcessing(boolean)
protected SQLException unsupported()
public boolean execute(String sql, int[] colinds) throws SQLException
SQLException
public boolean execute(String sql, String[] colnames) throws SQLException
SQLException
public int executeUpdate(String sql, int[] colinds) throws SQLException
SQLException
public int executeUpdate(String sql, String[] cols) throws SQLException
SQLException
public long executeLargeUpdate(String sql, int[] colinds) throws SQLException
SQLException
public long executeLargeUpdate(String sql, String[] cols) throws SQLException
SQLException
protected <T> T withConnectionTimeout(JDBC3Statement.SQLCallable<T> callable) throws SQLException
SQLException
Copyright © 2022. All rights reserved.