public abstract class JDBC3PreparedStatement extends CorePreparedStatement
batchQueryCount, columnCount, paramCount
batch, batchPos, conn, pointer, resultsWaiting, rs, sql
CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO
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 |
JDBC3PreparedStatement(SQLiteConnection conn,
String sql) |
Modifier and Type | Method and 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() |
batch, clearBatch, executeBatch, getUpdateCount, setDateByMilliseconds
close, closeOnCompletion, isClosed, isCloseOnCompletion, isPoolable, isWrapperFor, setPoolable, unwrap
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
checkOpen, exec, exec, getConnectionConfig, getDatbase, internalClose
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
cancel, clearWarnings, 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, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setQueryTimeout
protected JDBC3PreparedStatement(SQLiteConnection conn, String sql) throws SQLException
SQLException
public void clearParameters() throws SQLException
SQLException
PreparedStatement.clearParameters()
public boolean execute() throws SQLException
SQLException
PreparedStatement.execute()
public ResultSet executeQuery() throws SQLException
SQLException
PreparedStatement.executeQuery()
public int executeUpdate() throws SQLException
SQLException
PreparedStatement.executeUpdate()
public void addBatch() throws SQLException
SQLException
PreparedStatement.addBatch()
public ParameterMetaData getParameterMetaData()
PreparedStatement.getParameterMetaData()
public int getParameterCount() throws SQLException
SQLException
ParameterMetaData.getParameterCount()
public String getParameterClassName(int param) throws SQLException
SQLException
ParameterMetaData.getParameterClassName(int)
public String getParameterTypeName(int pos)
public int getParameterType(int pos)
ParameterMetaData.getParameterType(int)
public int getParameterMode(int pos)
ParameterMetaData.getParameterMode(int)
public int getPrecision(int pos)
ParameterMetaData.getPrecision(int)
public int getScale(int pos)
ParameterMetaData.getScale(int)
public int isNullable(int pos)
ParameterMetaData.isNullable(int)
public boolean isSigned(int pos)
ParameterMetaData.isSigned(int)
public Statement getStatement()
public void setBigDecimal(int pos, BigDecimal value) throws SQLException
SQLException
PreparedStatement.setBigDecimal(int, java.math.BigDecimal)
public void setBinaryStream(int pos, InputStream istream, int length) throws SQLException
SQLException
PreparedStatement.setBinaryStream(int, java.io.InputStream, int)
public void setAsciiStream(int pos, InputStream istream, int length) throws SQLException
SQLException
PreparedStatement.setAsciiStream(int, java.io.InputStream, int)
public void setUnicodeStream(int pos, InputStream istream, int length) throws SQLException
public void setBoolean(int pos, boolean value) throws SQLException
SQLException
PreparedStatement.setBoolean(int, boolean)
public void setByte(int pos, byte value) throws SQLException
SQLException
PreparedStatement.setByte(int, byte)
public void setBytes(int pos, byte[] value) throws SQLException
SQLException
PreparedStatement.setBytes(int, byte[])
public void setDouble(int pos, double value) throws SQLException
SQLException
PreparedStatement.setDouble(int, double)
public void setFloat(int pos, float value) throws SQLException
SQLException
PreparedStatement.setFloat(int, float)
public void setInt(int pos, int value) throws SQLException
SQLException
PreparedStatement.setInt(int, int)
public void setLong(int pos, long value) throws SQLException
SQLException
PreparedStatement.setLong(int, long)
public void setNull(int pos, int u1) throws SQLException
SQLException
PreparedStatement.setNull(int, int)
public void setNull(int pos, int u1, String u2) throws SQLException
SQLException
PreparedStatement.setNull(int, int, java.lang.String)
public void setObject(int pos, Object value) throws SQLException
SQLException
PreparedStatement.setObject(int, java.lang.Object)
public void setObject(int p, Object v, int t) throws SQLException
SQLException
PreparedStatement.setObject(int, java.lang.Object, int)
public void setObject(int p, Object v, int t, int s) throws SQLException
SQLException
PreparedStatement.setObject(int, java.lang.Object, int, int)
public void setShort(int pos, short value) throws SQLException
SQLException
PreparedStatement.setShort(int, short)
public void setString(int pos, String value) throws SQLException
SQLException
PreparedStatement.setString(int, java.lang.String)
public void setCharacterStream(int pos, Reader reader, int length) throws SQLException
SQLException
PreparedStatement.setCharacterStream(int, java.io.Reader, int)
public void setDate(int pos, Date x) throws SQLException
SQLException
PreparedStatement.setDate(int, java.sql.Date)
public void setDate(int pos, Date x, Calendar cal) throws SQLException
public void setTime(int pos, Time x) throws SQLException
SQLException
PreparedStatement.setTime(int, java.sql.Time)
public void setTime(int pos, Time x, Calendar cal) throws SQLException
public void setTimestamp(int pos, Timestamp x) throws SQLException
SQLException
PreparedStatement.setTimestamp(int, java.sql.Timestamp)
public void setTimestamp(int pos, Timestamp x, Calendar cal) throws SQLException
public ResultSetMetaData getMetaData() throws SQLException
SQLException
PreparedStatement.getMetaData()
protected SQLException unused()
unused
in class JDBC3Statement
public void setArray(int i, Array x) throws SQLException
SQLException
public void setBlob(int i, Blob x) throws SQLException
SQLException
public void setClob(int i, Clob x) throws SQLException
SQLException
public void setRef(int i, Ref x) throws SQLException
SQLException
public void setURL(int pos, URL x) throws SQLException
SQLException
public boolean execute(String sql) throws SQLException
execute
in interface Statement
execute
in class JDBC3Statement
SQLException
CoreStatement.exec(java.lang.String)
public int executeUpdate(String sql) throws SQLException
executeUpdate
in interface Statement
executeUpdate
in class JDBC3Statement
SQLException
CoreStatement.exec(java.lang.String)
public ResultSet executeQuery(String sql) throws SQLException
executeQuery
in interface Statement
executeQuery
in class JDBC3Statement
SQLException
CoreStatement.exec(String)
public void addBatch(String sql) throws SQLException
addBatch
in interface Statement
addBatch
in class JDBC3Statement
SQLException
Statement.addBatch(java.lang.String)
Copyright © 2021. All rights reserved.