public class PreparedStatementAdaptor extends Object implements PreparedStatement
PreparedStatement
.Modifier and Type | Class and Description |
---|---|
static interface | PreparedStatementAdaptor.Binder |
Modifier and Type | Field and Description |
---|---|
(package private) static Object[] | NO_PARAMS |
(package private) Object[] | params |
(package private) int | size |
CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO
Constructor and Description |
---|
PreparedStatementAdaptor() |
Modifier and Type | Method and Description |
---|---|
void | addBatch() |
void | addBatch(String sql) |
static Object[] | bind(PreparedStatementAdaptor.Binder binder) |
void | cancel() |
(package private) void | clear() |
void | clearBatch() |
void | clearParameters() |
void | clearWarnings() |
void | close() |
void | closeOnCompletion() |
boolean | execute() |
boolean | execute(String sql) |
boolean | execute(String sql, int autoGeneratedKeys) |
boolean | execute(String sql, int[] columnIndexes) |
boolean | execute(String sql, String[] columnNames) |
int[] | executeBatch() |
ResultSet | executeQuery() |
ResultSet | executeQuery(String sql) |
int | executeUpdate() |
int | executeUpdate(String sql) |
int | executeUpdate(String sql, int autoGeneratedKeys) |
int | executeUpdate(String sql, int[] columnIndexes) |
int | executeUpdate(String sql, String[] columnNames) |
Connection | getConnection() |
int | getFetchDirection() |
int | getFetchSize() |
ResultSet | getGeneratedKeys() |
int | getMaxFieldSize() |
int | getMaxRows() |
ResultSetMetaData | getMetaData() |
boolean | getMoreResults() |
boolean | getMoreResults(int current) |
ParameterMetaData | getParameterMetaData() |
Object[] | getParametersAsArray() |
int | getQueryTimeout() |
ResultSet | getResultSet() |
int | getResultSetConcurrency() |
int | getResultSetHoldability() |
int | getResultSetType() |
int | getUpdateCount() |
SQLWarning | getWarnings() |
boolean | isClosed() |
boolean | isCloseOnCompletion() |
boolean | isPoolable() |
boolean | isWrapperFor(Class<?> iface) |
(package private) void | put(int parameterIndex, Object parameter) |
void | setArray(int parameterIndex, Array x) |
void | setAsciiStream(int parameterIndex, InputStream x) |
void | setAsciiStream(int parameterIndex, InputStream x, int length) |
void | setAsciiStream(int parameterIndex, InputStream x, long length) |
void | setBigDecimal(int parameterIndex, BigDecimal x) |
void | setBinaryStream(int parameterIndex, InputStream x) |
void | setBinaryStream(int parameterIndex, InputStream x, int length) |
void | setBinaryStream(int parameterIndex, InputStream is, long length) |
void | setBlob(int parameterIndex, Blob x) |
void | setBlob(int parameterIndex, InputStream inputStream) |
void | setBlob(int parameterIndex, InputStream inputStream, long length) |
void | setBoolean(int parameterIndex, boolean x) |
void | setByte(int parameterIndex, byte x) |
void | setBytes(int parameterIndex, byte[] x) |
void | setCharacterStream(int parameterIndex, Reader reader) |
void | setCharacterStream(int parameterIndex, Reader reader, int length) |
void | setCharacterStream(int parameterIndex, Reader reader, long length) |
void | setClob(int parameterIndex, Clob x) |
void | setClob(int parameterIndex, Reader reader) |
void | setClob(int parameterIndex, Reader reader, long length) |
void | setCursorName(String name) |
void | setDate(int parameterIndex, Date x) |
void | setDate(int parameterIndex, Date x, Calendar cal) |
void | setDouble(int parameterIndex, double x) |
void | setEscapeProcessing(boolean enable) |
void | setFetchDirection(int direction) |
void | setFetchSize(int rows) |
void | setFloat(int parameterIndex, float x) |
void | setInt(int parameterIndex, int x) |
void | setLong(int parameterIndex, long x) |
void | setMaxFieldSize(int max) |
void | setMaxRows(int max) |
void | setNCharacterStream(int parameterIndex, Reader value) |
void | setNCharacterStream(int parameterIndex, Reader value, long length) |
void | setNClob(int parameterIndex, NClob value) |
void | setNClob(int parameterIndex, Reader reader) |
void | setNClob(int parameterIndex, Reader reader, long length) |
void | setNString(int parameterIndex, String value) |
void | setNull(int parameterIndex, int sqlType) |
void | setNull(int parameterIndex, int sqlType, String typeName) |
void | setObject(int parameterIndex, Object x) |
void | setObject(int parameterIndex, Object x, int targetSqlType) |
void | setObject(int parameterIndex, Object x, int targetSqlType, int scaleOrLength) |
void | setPoolable(boolean poolable) |
void | setQueryTimeout(int seconds) |
void | setRef(int parameterIndex, Ref x) |
void | setRowId(int parameterIndex, RowId x) |
void | setShort(int parameterIndex, short x) |
void | setSQLXML(int parameterIndex, SQLXML xmlObject) |
void | setString(int parameterIndex, String x) |
void | setTime(int parameterIndex, Time x) |
void | setTime(int parameterIndex, Time x, Calendar cal) |
void | setTimestamp(int parameterIndex, Timestamp x) |
void | setTimestamp(int parameterIndex, Timestamp x, Calendar cal) |
void | setUnicodeStream(int parameterIndex, InputStream x, int length) |
void | setURL(int parameterIndex, URL x) |
<T> T | unwrap(Class<T> iface) |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
executeLargeUpdate, setObject, setObject
executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, getLargeMaxRows, getLargeUpdateCount, setLargeMaxRows
public static Object[] bind(PreparedStatementAdaptor.Binder binder)
void put(int parameterIndex, Object parameter)
void clear()
public Object[] getParametersAsArray()
public ResultSet executeQuery()
executeQuery
in interface PreparedStatement
public int executeUpdate()
executeUpdate
in interface PreparedStatement
public void setNull(int parameterIndex, int sqlType)
setNull
in interface PreparedStatement
public void setBoolean(int parameterIndex, boolean x)
setBoolean
in interface PreparedStatement
public void setByte(int parameterIndex, byte x)
setByte
in interface PreparedStatement
public void setShort(int parameterIndex, short x)
setShort
in interface PreparedStatement
public void setInt(int parameterIndex, int x)
setInt
in interface PreparedStatement
public void setLong(int parameterIndex, long x)
setLong
in interface PreparedStatement
public void setFloat(int parameterIndex, float x)
setFloat
in interface PreparedStatement
public void setDouble(int parameterIndex, double x)
setDouble
in interface PreparedStatement
public void setBigDecimal(int parameterIndex, BigDecimal x)
setBigDecimal
in interface PreparedStatement
public void setString(int parameterIndex, String x)
setString
in interface PreparedStatement
public void setBytes(int parameterIndex, byte[] x)
setBytes
in interface PreparedStatement
public void setDate(int parameterIndex, Date x)
setDate
in interface PreparedStatement
public void setTime(int parameterIndex, Time x)
setTime
in interface PreparedStatement
public void setTimestamp(int parameterIndex, Timestamp x)
setTimestamp
in interface PreparedStatement
public void setAsciiStream(int parameterIndex, InputStream x, int length)
setAsciiStream
in interface PreparedStatement
public void setUnicodeStream(int parameterIndex, InputStream x, int length)
setUnicodeStream
in interface PreparedStatement
public void setBinaryStream(int parameterIndex, InputStream x, int length)
setBinaryStream
in interface PreparedStatement
public void clearParameters()
clearParameters
in interface PreparedStatement
public void setObject(int parameterIndex, Object x, int targetSqlType)
setObject
in interface PreparedStatement
public void setObject(int parameterIndex, Object x)
setObject
in interface PreparedStatement
public boolean execute()
execute
in interface PreparedStatement
public void addBatch()
addBatch
in interface PreparedStatement
public void setCharacterStream(int parameterIndex, Reader reader, int length)
setCharacterStream
in interface PreparedStatement
public void setRef(int parameterIndex, Ref x)
setRef
in interface PreparedStatement
public void setBlob(int parameterIndex, Blob x)
setBlob
in interface PreparedStatement
public void setClob(int parameterIndex, Clob x)
setClob
in interface PreparedStatement
public void setArray(int parameterIndex, Array x)
setArray
in interface PreparedStatement
public ResultSetMetaData getMetaData()
getMetaData
in interface PreparedStatement
public void setDate(int parameterIndex, Date x, Calendar cal)
setDate
in interface PreparedStatement
public void setTime(int parameterIndex, Time x, Calendar cal)
setTime
in interface PreparedStatement
public void setTimestamp(int parameterIndex, Timestamp x, Calendar cal)
setTimestamp
in interface PreparedStatement
public void setNull(int parameterIndex, int sqlType, String typeName)
setNull
in interface PreparedStatement
public void setURL(int parameterIndex, URL x)
setURL
in interface PreparedStatement
public ParameterMetaData getParameterMetaData()
getParameterMetaData
in interface PreparedStatement
public void setRowId(int parameterIndex, RowId x)
setRowId
in interface PreparedStatement
public void setNString(int parameterIndex, String value)
setNString
in interface PreparedStatement
public void setNCharacterStream(int parameterIndex, Reader value, long length)
setNCharacterStream
in interface PreparedStatement
public void setNClob(int parameterIndex, NClob value)
setNClob
in interface PreparedStatement
public void setClob(int parameterIndex, Reader reader, long length)
setClob
in interface PreparedStatement
public void setBlob(int parameterIndex, InputStream inputStream, long length)
setBlob
in interface PreparedStatement
public void setNClob(int parameterIndex, Reader reader, long length)
setNClob
in interface PreparedStatement
public void setSQLXML(int parameterIndex, SQLXML xmlObject)
setSQLXML
in interface PreparedStatement
public void setObject(int parameterIndex, Object x, int targetSqlType, int scaleOrLength)
setObject
in interface PreparedStatement
public void setAsciiStream(int parameterIndex, InputStream x, long length)
setAsciiStream
in interface PreparedStatement
public void setBinaryStream(int parameterIndex, InputStream is, long length)
setBinaryStream
in interface PreparedStatement
public void setCharacterStream(int parameterIndex, Reader reader, long length)
setCharacterStream
in interface PreparedStatement
public void setAsciiStream(int parameterIndex, InputStream x)
setAsciiStream
in interface PreparedStatement
public void setBinaryStream(int parameterIndex, InputStream x)
setBinaryStream
in interface PreparedStatement
public void setCharacterStream(int parameterIndex, Reader reader)
setCharacterStream
in interface PreparedStatement
public void setNCharacterStream(int parameterIndex, Reader value)
setNCharacterStream
in interface PreparedStatement
public void setClob(int parameterIndex, Reader reader)
setClob
in interface PreparedStatement
public void setBlob(int parameterIndex, InputStream inputStream)
setBlob
in interface PreparedStatement
public void setNClob(int parameterIndex, Reader reader)
setNClob
in interface PreparedStatement
public ResultSet executeQuery(String sql)
executeQuery
in interface Statement
public int executeUpdate(String sql)
executeUpdate
in interface Statement
public void close()
close
in interface AutoCloseable
close
in interface Statement
public int getMaxFieldSize()
getMaxFieldSize
in interface Statement
public void setMaxFieldSize(int max)
setMaxFieldSize
in interface Statement
public int getMaxRows()
getMaxRows
in interface Statement
public void setMaxRows(int max)
setMaxRows
in interface Statement
public void setEscapeProcessing(boolean enable)
setEscapeProcessing
in interface Statement
public int getQueryTimeout()
getQueryTimeout
in interface Statement
public void setQueryTimeout(int seconds)
setQueryTimeout
in interface Statement
public SQLWarning getWarnings()
getWarnings
in interface Statement
public void clearWarnings()
clearWarnings
in interface Statement
public void setCursorName(String name)
setCursorName
in interface Statement
public ResultSet getResultSet()
getResultSet
in interface Statement
public int getUpdateCount()
getUpdateCount
in interface Statement
public boolean getMoreResults()
getMoreResults
in interface Statement
public int getFetchDirection()
getFetchDirection
in interface Statement
public void setFetchDirection(int direction)
setFetchDirection
in interface Statement
public int getFetchSize()
getFetchSize
in interface Statement
public void setFetchSize(int rows)
setFetchSize
in interface Statement
public int getResultSetConcurrency()
getResultSetConcurrency
in interface Statement
public int getResultSetType()
getResultSetType
in interface Statement
public void clearBatch()
clearBatch
in interface Statement
public int[] executeBatch()
executeBatch
in interface Statement
public Connection getConnection()
getConnection
in interface Statement
public boolean getMoreResults(int current)
getMoreResults
in interface Statement
public ResultSet getGeneratedKeys()
getGeneratedKeys
in interface Statement
public int executeUpdate(String sql, int autoGeneratedKeys)
executeUpdate
in interface Statement
public int executeUpdate(String sql, int[] columnIndexes)
executeUpdate
in interface Statement
public int executeUpdate(String sql, String[] columnNames)
executeUpdate
in interface Statement
public boolean execute(String sql, int autoGeneratedKeys)
public boolean execute(String sql, int[] columnIndexes)
public int getResultSetHoldability()
getResultSetHoldability
in interface Statement
public boolean isPoolable()
isPoolable
in interface Statement
public void setPoolable(boolean poolable)
setPoolable
in interface Statement
public void closeOnCompletion()
closeOnCompletion
in interface Statement
public boolean isCloseOnCompletion()
isCloseOnCompletion
in interface Statement
public boolean isWrapperFor(Class<?> iface)
isWrapperFor
in interface Wrapper