Class PreparedStatementWrapper
- java.lang.Object
-
- es.bsc.dataclay.dbhandler.sql.common.PreparedStatementWrapper
-
- All Implemented Interfaces:
AutoCloseable
,PreparedStatement
,Statement
,Wrapper
public class PreparedStatementWrapper extends Object implements PreparedStatement
-
-
Field Summary
-
Fields inherited from interface java.sql.Statement
CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO
-
-
Constructor Summary
Constructors Constructor Description PreparedStatementWrapper(PreparedStatement ps)
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description void
addBatch()
void
addBatch(String arg0)
void
cancel()
void
clearBatch()
void
clearParameters()
void
clearWarnings()
void
close()
void
closeOnCompletion()
boolean
execute()
boolean
execute(String arg0)
boolean
execute(String arg0, int arg1)
boolean
execute(String arg0, int[] arg1)
boolean
execute(String arg0, String[] arg1)
int[]
executeBatch()
long[]
executeLargeBatch()
long
executeLargeUpdate()
long
executeLargeUpdate(String arg0)
long
executeLargeUpdate(String arg0, int arg1)
long
executeLargeUpdate(String arg0, int[] arg1)
long
executeLargeUpdate(String arg0, String[] arg1)
ResultSet
executeQuery()
ResultSet
executeQuery(String arg0)
int
executeUpdate()
int
executeUpdate(String arg0)
int
executeUpdate(String arg0, int arg1)
int
executeUpdate(String arg0, int[] arg1)
int
executeUpdate(String arg0, String[] arg1)
Connection
getConnection()
int
getFetchDirection()
int
getFetchSize()
ResultSet
getGeneratedKeys()
long
getLargeMaxRows()
long
getLargeUpdateCount()
int
getMaxFieldSize()
int
getMaxRows()
ResultSetMetaData
getMetaData()
boolean
getMoreResults()
boolean
getMoreResults(int arg0)
ParameterMetaData
getParameterMetaData()
int
getQueryTimeout()
ResultSet
getResultSet()
int
getResultSetConcurrency()
int
getResultSetHoldability()
int
getResultSetType()
int
getUpdateCount()
SQLWarning
getWarnings()
boolean
isClosed()
boolean
isCloseOnCompletion()
boolean
isPoolable()
boolean
isWrapperFor(Class arg0)
void
setArray(int i, Array x)
void
setAsciiStream(int arg0, InputStream arg1)
void
setAsciiStream(int arg0, InputStream arg1, int arg2)
void
setAsciiStream(int arg0, InputStream arg1, long arg2)
void
setBigDecimal(int arg0, BigDecimal arg1)
void
setBinaryStream(int arg0, InputStream arg1)
void
setBinaryStream(int arg0, InputStream arg1, int arg2)
void
setBinaryStream(int arg0, InputStream arg1, long arg2)
void
setBlob(int arg0, InputStream arg1)
void
setBlob(int arg0, InputStream arg1, long arg2)
void
setBlob(int arg0, Blob arg1)
void
setBoolean(int arg0, boolean arg1)
void
setByte(int arg0, byte arg1)
void
setBytes(int arg0, byte[] arg1)
void
setCharacterStream(int arg0, Reader arg1)
void
setCharacterStream(int arg0, Reader arg1, int arg2)
void
setCharacterStream(int arg0, Reader arg1, long arg2)
void
setClob(int arg0, Reader arg1)
void
setClob(int arg0, Reader arg1, long arg2)
void
setClob(int arg0, Clob arg1)
void
setCursorName(String arg0)
void
setDate(int arg0, Date arg1)
void
setDate(int arg0, Date arg1, Calendar arg2)
void
setDouble(int arg0, double arg1)
void
setEscapeProcessing(boolean arg0)
void
setFetchDirection(int arg0)
void
setFetchSize(int arg0)
void
setFloat(int arg0, float arg1)
void
setInt(int arg0, int arg1)
void
setLargeMaxRows(long arg0)
void
setLong(int arg0, long arg1)
void
setMaxFieldSize(int arg0)
void
setMaxRows(int arg0)
void
setNCharacterStream(int arg0, Reader arg1)
void
setNCharacterStream(int arg0, Reader arg1, long arg2)
void
setNClob(int arg0, Reader arg1)
void
setNClob(int arg0, Reader arg1, long arg2)
void
setNClob(int arg0, NClob arg1)
void
setNString(int arg0, String arg1)
void
setNull(int arg0, int arg1)
void
setNull(int arg0, int arg1, String arg2)
void
setObject(int arg0, Object arg1)
void
setObject(int arg0, Object arg1, int arg2)
void
setObject(int arg0, Object arg1, int arg2, int arg3)
void
setObject(int arg0, Object arg1, SQLType arg2)
void
setObject(int arg0, Object arg1, SQLType arg2, int arg3)
void
setPoolable(boolean arg0)
void
setQueryTimeout(int arg0)
void
setRef(int arg0, Ref arg1)
void
setRowId(int arg0, RowId arg1)
void
setShort(int arg0, short arg1)
void
setSQLXML(int arg0, SQLXML arg1)
void
setString(int arg0, String arg1)
void
setTime(int arg0, Time arg1)
void
setTime(int arg0, Time arg1, Calendar arg2)
void
setTimestamp(int arg0, Timestamp arg1)
void
setTimestamp(int arg0, Timestamp arg1, Calendar arg2)
void
setUnicodeStream(int arg0, InputStream arg1, int arg2)
void
setURL(int arg0, URL arg1)
String
toString()
Object
unwrap(Class arg0)
-
-
-
Constructor Detail
-
PreparedStatementWrapper
public PreparedStatementWrapper(PreparedStatement ps)
-
-
Method Detail
-
executeQuery
public ResultSet executeQuery() throws SQLException
- Specified by:
executeQuery
in interfacePreparedStatement
- Throws:
SQLException
-
setArray
public void setArray(int i, Array x) throws SQLException
- Specified by:
setArray
in interfacePreparedStatement
- Throws:
SQLException
-
executeUpdate
public int executeUpdate() throws SQLException
- Specified by:
executeUpdate
in interfacePreparedStatement
- Throws:
SQLException
-
setNull
public void setNull(int arg0, int arg1, String arg2) throws SQLException
- Specified by:
setNull
in interfacePreparedStatement
- Throws:
SQLException
-
setNull
public void setNull(int arg0, int arg1) throws SQLException
- Specified by:
setNull
in interfacePreparedStatement
- Throws:
SQLException
-
setBigDecimal
public void setBigDecimal(int arg0, BigDecimal arg1) throws SQLException
- Specified by:
setBigDecimal
in interfacePreparedStatement
- Throws:
SQLException
-
setString
public void setString(int arg0, String arg1) throws SQLException
- Specified by:
setString
in interfacePreparedStatement
- Throws:
SQLException
-
setBytes
public void setBytes(int arg0, byte[] arg1) throws SQLException
- Specified by:
setBytes
in interfacePreparedStatement
- Throws:
SQLException
-
setDate
public void setDate(int arg0, Date arg1, Calendar arg2) throws SQLException
- Specified by:
setDate
in interfacePreparedStatement
- Throws:
SQLException
-
setDate
public void setDate(int arg0, Date arg1) throws SQLException
- Specified by:
setDate
in interfacePreparedStatement
- Throws:
SQLException
-
setAsciiStream
public void setAsciiStream(int arg0, InputStream arg1, int arg2) throws SQLException
- Specified by:
setAsciiStream
in interfacePreparedStatement
- Throws:
SQLException
-
setAsciiStream
public void setAsciiStream(int arg0, InputStream arg1, long arg2) throws SQLException
- Specified by:
setAsciiStream
in interfacePreparedStatement
- Throws:
SQLException
-
setAsciiStream
public void setAsciiStream(int arg0, InputStream arg1) throws SQLException
- Specified by:
setAsciiStream
in interfacePreparedStatement
- Throws:
SQLException
-
setUnicodeStream
public void setUnicodeStream(int arg0, InputStream arg1, int arg2) throws SQLException
- Specified by:
setUnicodeStream
in interfacePreparedStatement
- Throws:
SQLException
-
setBinaryStream
public void setBinaryStream(int arg0, InputStream arg1, int arg2) throws SQLException
- Specified by:
setBinaryStream
in interfacePreparedStatement
- Throws:
SQLException
-
setBinaryStream
public void setBinaryStream(int arg0, InputStream arg1, long arg2) throws SQLException
- Specified by:
setBinaryStream
in interfacePreparedStatement
- Throws:
SQLException
-
setBinaryStream
public void setBinaryStream(int arg0, InputStream arg1) throws SQLException
- Specified by:
setBinaryStream
in interfacePreparedStatement
- Throws:
SQLException
-
clearParameters
public void clearParameters() throws SQLException
- Specified by:
clearParameters
in interfacePreparedStatement
- Throws:
SQLException
-
setObject
public void setObject(int arg0, Object arg1, int arg2) throws SQLException
- Specified by:
setObject
in interfacePreparedStatement
- Throws:
SQLException
-
setObject
public void setObject(int arg0, Object arg1, int arg2, int arg3) throws SQLException
- Specified by:
setObject
in interfacePreparedStatement
- Throws:
SQLException
-
setObject
public void setObject(int arg0, Object arg1) throws SQLException
- Specified by:
setObject
in interfacePreparedStatement
- Throws:
SQLException
-
setObject
public void setObject(int arg0, Object arg1, SQLType arg2) throws SQLException
- Specified by:
setObject
in interfacePreparedStatement
- Throws:
SQLException
-
setObject
public void setObject(int arg0, Object arg1, SQLType arg2, int arg3) throws SQLException
- Specified by:
setObject
in interfacePreparedStatement
- Throws:
SQLException
-
addBatch
public void addBatch() throws SQLException
- Specified by:
addBatch
in interfacePreparedStatement
- Throws:
SQLException
-
setCharacterStream
public void setCharacterStream(int arg0, Reader arg1, int arg2) throws SQLException
- Specified by:
setCharacterStream
in interfacePreparedStatement
- Throws:
SQLException
-
setCharacterStream
public void setCharacterStream(int arg0, Reader arg1, long arg2) throws SQLException
- Specified by:
setCharacterStream
in interfacePreparedStatement
- Throws:
SQLException
-
setCharacterStream
public void setCharacterStream(int arg0, Reader arg1) throws SQLException
- Specified by:
setCharacterStream
in interfacePreparedStatement
- Throws:
SQLException
-
setRef
public void setRef(int arg0, Ref arg1) throws SQLException
- Specified by:
setRef
in interfacePreparedStatement
- Throws:
SQLException
-
setBlob
public void setBlob(int arg0, InputStream arg1, long arg2) throws SQLException
- Specified by:
setBlob
in interfacePreparedStatement
- Throws:
SQLException
-
setBlob
public void setBlob(int arg0, Blob arg1) throws SQLException
- Specified by:
setBlob
in interfacePreparedStatement
- Throws:
SQLException
-
setBlob
public void setBlob(int arg0, InputStream arg1) throws SQLException
- Specified by:
setBlob
in interfacePreparedStatement
- Throws:
SQLException
-
setClob
public void setClob(int arg0, Reader arg1, long arg2) throws SQLException
- Specified by:
setClob
in interfacePreparedStatement
- Throws:
SQLException
-
setClob
public void setClob(int arg0, Clob arg1) throws SQLException
- Specified by:
setClob
in interfacePreparedStatement
- Throws:
SQLException
-
setClob
public void setClob(int arg0, Reader arg1) throws SQLException
- Specified by:
setClob
in interfacePreparedStatement
- Throws:
SQLException
-
getMetaData
public ResultSetMetaData getMetaData() throws SQLException
- Specified by:
getMetaData
in interfacePreparedStatement
- Throws:
SQLException
-
getParameterMetaData
public ParameterMetaData getParameterMetaData() throws SQLException
- Specified by:
getParameterMetaData
in interfacePreparedStatement
- Throws:
SQLException
-
setRowId
public void setRowId(int arg0, RowId arg1) throws SQLException
- Specified by:
setRowId
in interfacePreparedStatement
- Throws:
SQLException
-
setNString
public void setNString(int arg0, String arg1) throws SQLException
- Specified by:
setNString
in interfacePreparedStatement
- Throws:
SQLException
-
setNCharacterStream
public void setNCharacterStream(int arg0, Reader arg1, long arg2) throws SQLException
- Specified by:
setNCharacterStream
in interfacePreparedStatement
- Throws:
SQLException
-
setNCharacterStream
public void setNCharacterStream(int arg0, Reader arg1) throws SQLException
- Specified by:
setNCharacterStream
in interfacePreparedStatement
- Throws:
SQLException
-
setNClob
public void setNClob(int arg0, Reader arg1, long arg2) throws SQLException
- Specified by:
setNClob
in interfacePreparedStatement
- Throws:
SQLException
-
setNClob
public void setNClob(int arg0, NClob arg1) throws SQLException
- Specified by:
setNClob
in interfacePreparedStatement
- Throws:
SQLException
-
setNClob
public void setNClob(int arg0, Reader arg1) throws SQLException
- Specified by:
setNClob
in interfacePreparedStatement
- Throws:
SQLException
-
setSQLXML
public void setSQLXML(int arg0, SQLXML arg1) throws SQLException
- Specified by:
setSQLXML
in interfacePreparedStatement
- Throws:
SQLException
-
executeLargeUpdate
public long executeLargeUpdate() throws SQLException
- Specified by:
executeLargeUpdate
in interfacePreparedStatement
- Throws:
SQLException
-
setTime
public void setTime(int arg0, Time arg1, Calendar arg2) throws SQLException
- Specified by:
setTime
in interfacePreparedStatement
- Throws:
SQLException
-
setTime
public void setTime(int arg0, Time arg1) throws SQLException
- Specified by:
setTime
in interfacePreparedStatement
- Throws:
SQLException
-
setURL
public void setURL(int arg0, URL arg1) throws SQLException
- Specified by:
setURL
in interfacePreparedStatement
- Throws:
SQLException
-
execute
public boolean execute() throws SQLException
- Specified by:
execute
in interfacePreparedStatement
- Throws:
SQLException
-
setBoolean
public void setBoolean(int arg0, boolean arg1) throws SQLException
- Specified by:
setBoolean
in interfacePreparedStatement
- Throws:
SQLException
-
setByte
public void setByte(int arg0, byte arg1) throws SQLException
- Specified by:
setByte
in interfacePreparedStatement
- Throws:
SQLException
-
setShort
public void setShort(int arg0, short arg1) throws SQLException
- Specified by:
setShort
in interfacePreparedStatement
- Throws:
SQLException
-
setInt
public void setInt(int arg0, int arg1) throws SQLException
- Specified by:
setInt
in interfacePreparedStatement
- Throws:
SQLException
-
setLong
public void setLong(int arg0, long arg1) throws SQLException
- Specified by:
setLong
in interfacePreparedStatement
- Throws:
SQLException
-
setFloat
public void setFloat(int arg0, float arg1) throws SQLException
- Specified by:
setFloat
in interfacePreparedStatement
- Throws:
SQLException
-
setDouble
public void setDouble(int arg0, double arg1) throws SQLException
- Specified by:
setDouble
in interfacePreparedStatement
- Throws:
SQLException
-
setTimestamp
public void setTimestamp(int arg0, Timestamp arg1, Calendar arg2) throws SQLException
- Specified by:
setTimestamp
in interfacePreparedStatement
- Throws:
SQLException
-
setTimestamp
public void setTimestamp(int arg0, Timestamp arg1) throws SQLException
- Specified by:
setTimestamp
in interfacePreparedStatement
- Throws:
SQLException
-
executeQuery
public ResultSet executeQuery(String arg0) throws SQLException
- Specified by:
executeQuery
in interfaceStatement
- Throws:
SQLException
-
executeUpdate
public int executeUpdate(String arg0, String[] arg1) throws SQLException
- Specified by:
executeUpdate
in interfaceStatement
- Throws:
SQLException
-
executeUpdate
public int executeUpdate(String arg0, int[] arg1) throws SQLException
- Specified by:
executeUpdate
in interfaceStatement
- Throws:
SQLException
-
executeUpdate
public int executeUpdate(String arg0, int arg1) throws SQLException
- Specified by:
executeUpdate
in interfaceStatement
- Throws:
SQLException
-
executeUpdate
public int executeUpdate(String arg0) throws SQLException
- Specified by:
executeUpdate
in interfaceStatement
- Throws:
SQLException
-
addBatch
public void addBatch(String arg0) throws SQLException
- Specified by:
addBatch
in interfaceStatement
- Throws:
SQLException
-
executeLargeUpdate
public long executeLargeUpdate(String arg0) throws SQLException
- Specified by:
executeLargeUpdate
in interfaceStatement
- Throws:
SQLException
-
executeLargeUpdate
public long executeLargeUpdate(String arg0, String[] arg1) throws SQLException
- Specified by:
executeLargeUpdate
in interfaceStatement
- Throws:
SQLException
-
executeLargeUpdate
public long executeLargeUpdate(String arg0, int arg1) throws SQLException
- Specified by:
executeLargeUpdate
in interfaceStatement
- Throws:
SQLException
-
executeLargeUpdate
public long executeLargeUpdate(String arg0, int[] arg1) throws SQLException
- Specified by:
executeLargeUpdate
in interfaceStatement
- Throws:
SQLException
-
getMaxFieldSize
public int getMaxFieldSize() throws SQLException
- Specified by:
getMaxFieldSize
in interfaceStatement
- Throws:
SQLException
-
setMaxFieldSize
public void setMaxFieldSize(int arg0) throws SQLException
- Specified by:
setMaxFieldSize
in interfaceStatement
- Throws:
SQLException
-
getMaxRows
public int getMaxRows() throws SQLException
- Specified by:
getMaxRows
in interfaceStatement
- Throws:
SQLException
-
setMaxRows
public void setMaxRows(int arg0) throws SQLException
- Specified by:
setMaxRows
in interfaceStatement
- Throws:
SQLException
-
setEscapeProcessing
public void setEscapeProcessing(boolean arg0) throws SQLException
- Specified by:
setEscapeProcessing
in interfaceStatement
- Throws:
SQLException
-
getQueryTimeout
public int getQueryTimeout() throws SQLException
- Specified by:
getQueryTimeout
in interfaceStatement
- Throws:
SQLException
-
setQueryTimeout
public void setQueryTimeout(int arg0) throws SQLException
- Specified by:
setQueryTimeout
in interfaceStatement
- Throws:
SQLException
-
cancel
public void cancel() throws SQLException
- Specified by:
cancel
in interfaceStatement
- Throws:
SQLException
-
getWarnings
public SQLWarning getWarnings() throws SQLException
- Specified by:
getWarnings
in interfaceStatement
- Throws:
SQLException
-
clearWarnings
public void clearWarnings() throws SQLException
- Specified by:
clearWarnings
in interfaceStatement
- Throws:
SQLException
-
setCursorName
public void setCursorName(String arg0) throws SQLException
- Specified by:
setCursorName
in interfaceStatement
- Throws:
SQLException
-
getResultSet
public ResultSet getResultSet() throws SQLException
- Specified by:
getResultSet
in interfaceStatement
- Throws:
SQLException
-
getUpdateCount
public int getUpdateCount() throws SQLException
- Specified by:
getUpdateCount
in interfaceStatement
- Throws:
SQLException
-
getMoreResults
public boolean getMoreResults() throws SQLException
- Specified by:
getMoreResults
in interfaceStatement
- Throws:
SQLException
-
getMoreResults
public boolean getMoreResults(int arg0) throws SQLException
- Specified by:
getMoreResults
in interfaceStatement
- Throws:
SQLException
-
setFetchDirection
public void setFetchDirection(int arg0) throws SQLException
- Specified by:
setFetchDirection
in interfaceStatement
- Throws:
SQLException
-
getFetchDirection
public int getFetchDirection() throws SQLException
- Specified by:
getFetchDirection
in interfaceStatement
- Throws:
SQLException
-
setFetchSize
public void setFetchSize(int arg0) throws SQLException
- Specified by:
setFetchSize
in interfaceStatement
- Throws:
SQLException
-
getFetchSize
public int getFetchSize() throws SQLException
- Specified by:
getFetchSize
in interfaceStatement
- Throws:
SQLException
-
getResultSetConcurrency
public int getResultSetConcurrency() throws SQLException
- Specified by:
getResultSetConcurrency
in interfaceStatement
- Throws:
SQLException
-
getResultSetType
public int getResultSetType() throws SQLException
- Specified by:
getResultSetType
in interfaceStatement
- Throws:
SQLException
-
clearBatch
public void clearBatch() throws SQLException
- Specified by:
clearBatch
in interfaceStatement
- Throws:
SQLException
-
executeBatch
public int[] executeBatch() throws SQLException
- Specified by:
executeBatch
in interfaceStatement
- Throws:
SQLException
-
getConnection
public Connection getConnection() throws SQLException
- Specified by:
getConnection
in interfaceStatement
- Throws:
SQLException
-
getGeneratedKeys
public ResultSet getGeneratedKeys() throws SQLException
- Specified by:
getGeneratedKeys
in interfaceStatement
- Throws:
SQLException
-
getResultSetHoldability
public int getResultSetHoldability() throws SQLException
- Specified by:
getResultSetHoldability
in interfaceStatement
- Throws:
SQLException
-
isClosed
public boolean isClosed() throws SQLException
- Specified by:
isClosed
in interfaceStatement
- Throws:
SQLException
-
setPoolable
public void setPoolable(boolean arg0) throws SQLException
- Specified by:
setPoolable
in interfaceStatement
- Throws:
SQLException
-
isPoolable
public boolean isPoolable() throws SQLException
- Specified by:
isPoolable
in interfaceStatement
- Throws:
SQLException
-
closeOnCompletion
public void closeOnCompletion() throws SQLException
- Specified by:
closeOnCompletion
in interfaceStatement
- Throws:
SQLException
-
isCloseOnCompletion
public boolean isCloseOnCompletion() throws SQLException
- Specified by:
isCloseOnCompletion
in interfaceStatement
- Throws:
SQLException
-
getLargeUpdateCount
public long getLargeUpdateCount() throws SQLException
- Specified by:
getLargeUpdateCount
in interfaceStatement
- Throws:
SQLException
-
setLargeMaxRows
public void setLargeMaxRows(long arg0) throws SQLException
- Specified by:
setLargeMaxRows
in interfaceStatement
- Throws:
SQLException
-
getLargeMaxRows
public long getLargeMaxRows() throws SQLException
- Specified by:
getLargeMaxRows
in interfaceStatement
- Throws:
SQLException
-
executeLargeBatch
public long[] executeLargeBatch() throws SQLException
- Specified by:
executeLargeBatch
in interfaceStatement
- Throws:
SQLException
-
execute
public boolean execute(String arg0, int[] arg1) throws SQLException
- Specified by:
execute
in interfaceStatement
- Throws:
SQLException
-
execute
public boolean execute(String arg0, int arg1) throws SQLException
- Specified by:
execute
in interfaceStatement
- Throws:
SQLException
-
execute
public boolean execute(String arg0, String[] arg1) throws SQLException
- Specified by:
execute
in interfaceStatement
- Throws:
SQLException
-
execute
public boolean execute(String arg0) throws SQLException
- Specified by:
execute
in interfaceStatement
- Throws:
SQLException
-
close
public void close() throws SQLException
- Specified by:
close
in interfaceAutoCloseable
- Specified by:
close
in interfaceStatement
- Throws:
SQLException
-
isWrapperFor
public boolean isWrapperFor(Class arg0) throws SQLException
- Specified by:
isWrapperFor
in interfaceWrapper
- Throws:
SQLException
-
unwrap
public Object unwrap(Class arg0) throws SQLException
- Specified by:
unwrap
in interfaceWrapper
- Throws:
SQLException
-
-