public abstract class JDBC3Statement extends CoreStatement
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 autokeys) |
boolean |
execute(String sql,
int[] colinds) |
boolean |
execute(String sql,
String[] colnames) |
int[] |
executeBatch() |
ResultSet |
executeQuery(String sql) |
ResultSet |
executeQuery(String sql,
boolean closeStmt) |
int |
executeUpdate(String sql) |
int |
executeUpdate(String sql,
int autoKeys) |
int |
executeUpdate(String sql,
int[] colinds) |
int |
executeUpdate(String sql,
String[] cols) |
protected void |
finalize() |
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.
|
int |
getMaxFieldSize() |
int |
getMaxRows() |
boolean |
getMoreResults()
SQLite does not support multiple results from execute().
|
boolean |
getMoreResults(int c) |
int |
getQueryTimeout() |
ResultSet |
getResultSet() |
int |
getResultSetConcurrency() |
int |
getResultSetHoldability() |
int |
getResultSetType() |
int |
getUpdateCount() |
SQLWarning |
getWarnings() |
void |
setCursorName(String name) |
void |
setEscapeProcessing(boolean enable) |
void |
setFetchDirection(int d) |
void |
setFetchSize(int r) |
void |
setMaxFieldSize(int max) |
void |
setMaxRows(int max) |
void |
setQueryTimeout(int seconds) |
protected SQLException |
unused() |
checkOpen, exec, exec, getConnectionConfig, getDatbase, internalClose
protected JDBC3Statement(SQLiteConnection conn)
public void close() throws SQLException
SQLException
Statement.close()
protected void finalize() throws SQLException
finalize
in class Object
SQLException
Object.finalize()
public boolean execute(String sql) throws SQLException
SQLException
Statement.execute(java.lang.String)
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 ResultSet getResultSet() throws SQLException
SQLException
Statement.getResultSet()
public int getUpdateCount() throws SQLException
SQLException
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 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 void setMaxRows(int max) throws SQLException
SQLException
Statement.setMaxRows(int)
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 d) 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 c) 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) throws SQLException
SQLException
Statement.setEscapeProcessing(boolean)
protected SQLException unused()
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 autoKeys) throws SQLException
SQLException
public int executeUpdate(String sql, int[] colinds) throws SQLException
SQLException
public int executeUpdate(String sql, String[] cols) throws SQLException
SQLException
public boolean execute(String sql, int autokeys) throws SQLException
SQLException
Copyright © 2019. All rights reserved.