public class UcanaccessPreparedStatement extends UcanaccessStatement implements PreparedStatement
CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO
Constructor and Description |
---|
UcanaccessPreparedStatement(NormalizedSQL nsql,
PreparedStatement hidden,
UcanaccessConnection connection) |
UcanaccessPreparedStatement(String _sql,
UcanaccessConnection _connection) |
Modifier and Type | Method and Description |
---|---|
void |
addBatch() |
void |
clearParameters() |
boolean |
execute() |
ResultSet |
executeQuery() |
int |
executeUpdate() |
ResultSetMetaData |
getMetaData() |
ParameterMetaData |
getParameterMetaData() |
protected void |
reset() |
void |
setArray(int idx,
Array array) |
void |
setAsciiStream(int idx,
InputStream is) |
void |
setAsciiStream(int idx,
InputStream is,
int length) |
void |
setAsciiStream(int idx,
InputStream is,
long length) |
void |
setBigDecimal(int idx,
BigDecimal dec) |
void |
setBinaryStream(int idx,
InputStream is) |
void |
setBinaryStream(int idx,
InputStream is,
int length) |
void |
setBinaryStream(int idx,
InputStream is,
long length) |
void |
setBlob(int idx,
Blob blob) |
void |
setBlob(int idx,
InputStream is) |
void |
setBlob(int idx,
InputStream is,
long length) |
void |
setBoolean(int idx,
boolean bool) |
void |
setByte(int idx,
byte b) |
void |
setBytes(int idx,
byte[] bytes) |
void |
setCharacterStream(int idx,
Reader reader) |
void |
setCharacterStream(int idx,
Reader reader,
int length) |
void |
setCharacterStream(int idx,
Reader reader,
long length) |
void |
setClob(int idx,
Clob clob) |
void |
setClob(int idx,
Reader reader) |
void |
setClob(int idx,
Reader reader,
long length) |
void |
setCursorName(String name) |
void |
setDate(int idx,
Date date) |
void |
setDate(int idx,
Date date,
Calendar cal) |
void |
setDouble(int idx,
double d) |
void |
setFloat(int idx,
float f) |
void |
setInt(int idx,
int i) |
void |
setLong(int idx,
long l) |
void |
setNCharacterStream(int idx,
Reader reader) |
void |
setNCharacterStream(int idx,
Reader reader,
long l) |
void |
setNClob(int idx,
NClob nclob) |
void |
setNClob(int idx,
Reader reader) |
void |
setNClob(int idx,
Reader reader,
long length) |
void |
setNString(int idx,
String string) |
void |
setNull(int idx,
int sqlt) |
void |
setNull(int idx,
int sqlt,
String tn) |
void |
setObject(int idx,
Object x) |
void |
setObject(int idx,
Object x,
int tsqlt) |
void |
setObject(int idx,
Object x,
int tsqlt,
int sol) |
void |
setRef(int idx,
Ref ref) |
void |
setRowId(int idx,
RowId rowId) |
void |
setShort(int idx,
short sht) |
void |
setSQLXML(int idx,
SQLXML sx) |
void |
setString(int idx,
String string) |
void |
setTime(int idx,
Time time) |
void |
setTime(int idx,
Time time,
Calendar cal) |
void |
setTimestamp(int idx,
Timestamp ts) |
void |
setTimestamp(int idx,
Timestamp ts,
Calendar cal) |
void |
setUnicodeStream(int idx,
InputStream is,
int length)
Deprecated.
|
void |
setURL(int idx,
URL url) |
<T> T |
unwrap(Class<T> iface) |
addBatch, cancel, checkLastModified, clearBatch, clearWarnings, close, closeOnCompletion, execute, execute, execute, execute, executeBatch, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getAliases, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, isWrapperFor, reset, setAliases, setEscapeProcessing, setFetchDirection, setFetchSize, setGeneratedKey, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
executeLargeUpdate, setObject, setObject
addBatch, cancel, clearBatch, clearWarnings, close, closeOnCompletion, execute, execute, execute, execute, executeBatch, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getLargeMaxRows, getLargeUpdateCount, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout
isWrapperFor
public UcanaccessPreparedStatement(NormalizedSQL nsql, PreparedStatement hidden, UcanaccessConnection connection) throws SQLException
SQLException
public UcanaccessPreparedStatement(String _sql, UcanaccessConnection _connection) throws SQLException
SQLException
public void addBatch() throws SQLException
addBatch
in interface PreparedStatement
SQLException
public void clearParameters() throws SQLException
clearParameters
in interface PreparedStatement
SQLException
public boolean execute() throws SQLException
execute
in interface PreparedStatement
SQLException
public ResultSet executeQuery() throws SQLException
executeQuery
in interface PreparedStatement
SQLException
public int executeUpdate() throws SQLException
executeUpdate
in interface PreparedStatement
SQLException
public ResultSetMetaData getMetaData() throws SQLException
getMetaData
in interface PreparedStatement
SQLException
public ParameterMetaData getParameterMetaData() throws SQLException
getParameterMetaData
in interface PreparedStatement
SQLException
public void setArray(int idx, Array array) throws SQLException
setArray
in interface PreparedStatement
SQLException
public void setAsciiStream(int idx, InputStream is) throws SQLException
setAsciiStream
in interface PreparedStatement
SQLException
public void setAsciiStream(int idx, InputStream is, int length) throws SQLException
setAsciiStream
in interface PreparedStatement
SQLException
public void setAsciiStream(int idx, InputStream is, long length) throws SQLException
setAsciiStream
in interface PreparedStatement
SQLException
public void setBigDecimal(int idx, BigDecimal dec) throws SQLException
setBigDecimal
in interface PreparedStatement
SQLException
public void setBinaryStream(int idx, InputStream is) throws SQLException
setBinaryStream
in interface PreparedStatement
SQLException
public void setBinaryStream(int idx, InputStream is, int length) throws SQLException
setBinaryStream
in interface PreparedStatement
SQLException
public void setBinaryStream(int idx, InputStream is, long length) throws SQLException
setBinaryStream
in interface PreparedStatement
SQLException
public void setBlob(int idx, Blob blob) throws SQLException
setBlob
in interface PreparedStatement
SQLException
public void setBlob(int idx, InputStream is) throws SQLException
setBlob
in interface PreparedStatement
SQLException
public void setBlob(int idx, InputStream is, long length) throws SQLException
setBlob
in interface PreparedStatement
SQLException
public void setBoolean(int idx, boolean bool) throws SQLException
setBoolean
in interface PreparedStatement
SQLException
public void setByte(int idx, byte b) throws SQLException
setByte
in interface PreparedStatement
SQLException
public void setBytes(int idx, byte[] bytes) throws SQLException
setBytes
in interface PreparedStatement
SQLException
public void setCharacterStream(int idx, Reader reader) throws SQLException
setCharacterStream
in interface PreparedStatement
SQLException
public void setCharacterStream(int idx, Reader reader, int length) throws SQLException
setCharacterStream
in interface PreparedStatement
SQLException
public void setCharacterStream(int idx, Reader reader, long length) throws SQLException
setCharacterStream
in interface PreparedStatement
SQLException
public void setClob(int idx, Clob clob) throws SQLException
setClob
in interface PreparedStatement
SQLException
public void setClob(int idx, Reader reader) throws SQLException
setClob
in interface PreparedStatement
SQLException
public void setClob(int idx, Reader reader, long length) throws SQLException
setClob
in interface PreparedStatement
SQLException
public void setCursorName(String name) throws SQLException
setCursorName
in interface Statement
setCursorName
in class UcanaccessStatement
SQLException
public void setDate(int idx, Date date) throws SQLException
setDate
in interface PreparedStatement
SQLException
public void setDate(int idx, Date date, Calendar cal) throws SQLException
setDate
in interface PreparedStatement
SQLException
public void setDouble(int idx, double d) throws SQLException
setDouble
in interface PreparedStatement
SQLException
public void setFloat(int idx, float f) throws SQLException
setFloat
in interface PreparedStatement
SQLException
public void setInt(int idx, int i) throws SQLException
setInt
in interface PreparedStatement
SQLException
public void setLong(int idx, long l) throws SQLException
setLong
in interface PreparedStatement
SQLException
public void setNCharacterStream(int idx, Reader reader) throws SQLException
setNCharacterStream
in interface PreparedStatement
SQLException
public void setNCharacterStream(int idx, Reader reader, long l) throws SQLException
setNCharacterStream
in interface PreparedStatement
SQLException
public void setNClob(int idx, NClob nclob) throws SQLException
setNClob
in interface PreparedStatement
SQLException
public void setNClob(int idx, Reader reader) throws SQLException
setNClob
in interface PreparedStatement
SQLException
public void setNClob(int idx, Reader reader, long length) throws SQLException
setNClob
in interface PreparedStatement
SQLException
public void setNString(int idx, String string) throws SQLException
setNString
in interface PreparedStatement
SQLException
public void setNull(int idx, int sqlt) throws SQLException
setNull
in interface PreparedStatement
SQLException
public void setNull(int idx, int sqlt, String tn) throws SQLException
setNull
in interface PreparedStatement
SQLException
public void setObject(int idx, Object x) throws SQLException
setObject
in interface PreparedStatement
SQLException
public void setObject(int idx, Object x, int tsqlt) throws SQLException
setObject
in interface PreparedStatement
SQLException
public void setObject(int idx, Object x, int tsqlt, int sol) throws SQLException
setObject
in interface PreparedStatement
SQLException
public void setRef(int idx, Ref ref) throws SQLException
setRef
in interface PreparedStatement
SQLException
public void setRowId(int idx, RowId rowId) throws SQLException
setRowId
in interface PreparedStatement
SQLException
public void setShort(int idx, short sht) throws SQLException
setShort
in interface PreparedStatement
SQLException
public void setSQLXML(int idx, SQLXML sx) throws SQLException
setSQLXML
in interface PreparedStatement
SQLException
public void setString(int idx, String string) throws SQLException
setString
in interface PreparedStatement
SQLException
public void setTime(int idx, Time time) throws SQLException
setTime
in interface PreparedStatement
SQLException
public void setTime(int idx, Time time, Calendar cal) throws SQLException
setTime
in interface PreparedStatement
SQLException
public void setTimestamp(int idx, Timestamp ts) throws SQLException
setTimestamp
in interface PreparedStatement
SQLException
public void setTimestamp(int idx, Timestamp ts, Calendar cal) throws SQLException
setTimestamp
in interface PreparedStatement
SQLException
@Deprecated public void setUnicodeStream(int idx, InputStream is, int length) throws SQLException
setUnicodeStream
in interface PreparedStatement
SQLException
public void setURL(int idx, URL url) throws SQLException
setURL
in interface PreparedStatement
SQLException
public <T> T unwrap(Class<T> iface) throws SQLException
unwrap
in interface Wrapper
unwrap
in class UcanaccessStatement
SQLException
protected void reset() throws SQLException
reset
in class UcanaccessStatement
SQLException
Copyright © 2012–2018 UCanAccess. All rights reserved.