public class TrafT4PreparedStatement extends TrafT4Statement implements PreparedStatement
NO_GENERATED_KEYSCLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO| Modifier and Type | Method and Description |
|---|---|
void |
addBatch() |
void |
clearBatch() |
void |
clearParameters() |
void |
close()
Closes the statement object.
|
void |
close(boolean hardClose) |
void |
closeOnCompletion() |
boolean |
execute()
This method will execute an operation.
|
int[] |
executeBatch() |
ResultSet |
executeQuery() |
int |
executeUpdate() |
long |
executeUpdate64() |
ResultSetMetaData |
getMetaData() |
ParameterMetaData |
getParameterMetaData() |
String |
getStatementType()
Use this method to retrieve the statement type that was used when
creating the statement through the connectivity service.
|
int |
getStatementTypeInt()
Use this method to retrieve the statement type that was used when
creating the statement through the connectivity service.
|
short |
getStatementTypeShort()
Use this method to retrieve the statement type that was used when
creating the statement through the connectivity service.
|
boolean |
isClosed() |
boolean |
isCloseOnCompletion() |
boolean |
isPoolable() |
boolean |
isWrapperFor(Class iface) |
void |
prepare(String sql,
int queryTimeout,
int holdability) |
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 x,
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)
Sets the designated parameter to the given Clob object.
|
void |
setClob(int parameterIndex,
Reader reader) |
void |
setClob(int parameterIndex,
Reader reader,
long length) |
void |
setDataBuffer(int numRows,
ByteBuffer buffer)
This method will associate user defined data with the prepared statement.
|
void |
setDate(int parameterIndex,
Date x) |
void |
setDate(int parameterIndex,
Date x,
Calendar cal) |
void |
setDouble(int parameterIndex,
double x) |
void |
setFetchSize(int rows) |
void |
setFloat(int parameterIndex,
float x) |
void |
setInt(int parameterIndex,
int x) |
void |
setLong(int parameterIndex,
long x) |
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 paramIndex,
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 scale) |
void |
setPoolable(boolean poolable) |
void |
setRef(int i,
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) |
Object |
unwrap(Class iface) |
protected void |
validateExecuteInvocation() |
addBatch, cancel, execute, execute, execute, execute, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, executeUpdate64, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getInputParamsLength_, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getOperationBuffer, getOperationID, getOperationReplyBuffer, getOutputParamsLength_, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getSQL, getStatementLabel, getStmtHandle, getUpdateCount, getUpdateCount64, setCursorName, setEscapeProcessing, setFetchDirection, setMaxFieldSize, setMaxRows, setOperationBuffer, setOperationID, setQueryTimeout, setRoundingMode, setRoundingMode, setTransactionToJoinclearWarnings, getWarningsclone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, waitaddBatch, cancel, clearWarnings, execute, execute, execute, execute, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, setCursorName, setEscapeProcessing, setFetchDirection, setMaxFieldSize, setMaxRows, setQueryTimeoutpublic static final short TYPE_UNKNOWN
public static final short TYPE_SELECT
public static final short TYPE_UPDATE
public static final short TYPE_DELETE
public static final short TYPE_INSERT
public static final short TYPE_EXPLAIN
public static final short TYPE_CREATE
public static final short TYPE_GRANT
public static final short TYPE_DROP
public static final short TYPE_INSERT_PARAM
public static final short TYPE_SELECT_CATALOG
public static final short TYPE_SMD
public static final short TYPE_CALL
public static final short TYPE_STATS
public static final short TYPE_CONFIG
public static final int SQL_OTHER
public static final int SQL_UNKNOWN
public static final int SQL_SELECT_UNIQUE
public static final int SQL_SELECT_NON_UNIQUE
public static final int SQL_INSERT_UNIQUE
public static final int SQL_INSERT_NON_UNIQUE
public static final int SQL_UPDATE_UNIQUE
public static final int SQL_UPDATE_NON_UNIQUE
public static final int SQL_DELETE_UNIQUE
public static final int SQL_DELETE_NON_UNIQUE
public static final int SQL_CONTROL
public static final int SQL_SET_TRANSACTION
public static final int SQL_SET_CATALOG
public static final int SQL_SET_SCHEMA
public static final int SQL_CREATE_TABLE
public static final int SQL_CREATE_VIEW
public static final int SQL_CREATE_INDEX
public static final int SQL_CREATE_UNIQUE_INDEX
public static final int SQL_CREATE_SYNONYM
public static final int SQL_CREATE_VOLATILE_TABLE
public static final int SQL_CREATE_MV
public static final int SQL_CREATE_MVG
public static final int SQL_CREATE_MP_ALIAS
public static final int SQL_CREATE_PROCEDURE
public static final int SQL_CREATE_TRIGGER
public static final int SQL_CREATE_SET_TABLE
public static final int SQL_CREATE_MULTISET_TABLE
public static final int SQL_DROP_TABLE
public static final int SQL_DROP_VIEW
public static final int SQL_DROP_INDEX
public static final int SQL_DROP_SYNONYM
public static final int SQL_DROP_VOLATILE_TABLE
public static final int SQL_DROP_MV
public static final int SQL_DROP_MVG
public static final int SQL_DROP_MP_ALIAS
public static final int SQL_DROP_PROCEDURE
public static final int SQL_DROP_TRIGGER
public static final int SQL_DROP_SET_TABLE
public static final int SQL_DROP_MULTISET_TABLE
public static final int SQL_ALTER_TABLE
public static final int SQL_ALTER_INDEX
public static final int SQL_ALTER_TRIGGER
public static final int SQL_ALTER_MP_ALIAS
public void addBatch()
throws SQLException
addBatch in interface PreparedStatementSQLExceptionpublic void clearBatch()
throws SQLException
clearBatch in interface StatementclearBatch in class TrafT4StatementSQLExceptionpublic void clearParameters()
throws SQLException
clearParameters in interface PreparedStatementSQLExceptionpublic void close()
throws SQLException
TrafT4Statementclose in interface AutoCloseableclose in interface Statementclose in class TrafT4StatementSQLExceptionpublic boolean execute()
throws SQLException
TrafT4Statementexecute in interface PreparedStatementexecute in class TrafT4StatementSQLExceptionpublic int[] executeBatch()
throws SQLException,
BatchUpdateException
executeBatch in interface StatementexecuteBatch in class TrafT4StatementSQLExceptionBatchUpdateExceptionpublic ResultSet executeQuery() throws SQLException
executeQuery in interface PreparedStatementSQLExceptionpublic int executeUpdate()
throws SQLException
executeUpdate in interface PreparedStatementSQLExceptionpublic long executeUpdate64()
throws SQLException
SQLExceptionpublic ResultSetMetaData getMetaData() throws SQLException
getMetaData in interface PreparedStatementSQLExceptionpublic ParameterMetaData getParameterMetaData() throws SQLException
getParameterMetaData in interface PreparedStatementSQLExceptionpublic void setArray(int parameterIndex,
Array x)
throws SQLException
setArray in interface PreparedStatementSQLExceptionpublic void setAsciiStream(int parameterIndex,
InputStream x,
int length)
throws SQLException
setAsciiStream in interface PreparedStatementSQLExceptionpublic void setBigDecimal(int parameterIndex,
BigDecimal x)
throws SQLException
setBigDecimal in interface PreparedStatementSQLExceptionpublic void setBinaryStream(int parameterIndex,
InputStream x,
int length)
throws SQLException
setBinaryStream in interface PreparedStatementSQLExceptionpublic void setBlob(int parameterIndex,
Blob x)
throws SQLException
setBlob in interface PreparedStatementSQLExceptionpublic void setBoolean(int parameterIndex,
boolean x)
throws SQLException
setBoolean in interface PreparedStatementSQLExceptionpublic void setByte(int parameterIndex,
byte x)
throws SQLException
setByte in interface PreparedStatementSQLExceptionpublic void setBytes(int parameterIndex,
byte[] x)
throws SQLException
setBytes in interface PreparedStatementSQLExceptionpublic void setCharacterStream(int parameterIndex,
Reader reader,
int length)
throws SQLException
setCharacterStream in interface PreparedStatementSQLExceptionpublic void setClob(int parameterIndex,
Clob x)
throws SQLException
setClob in interface PreparedStatementparameterIndex - the first parameter is 1, the second is 2, ...x - a Clob object that maps an SQL CLOBSQLException - invalid data type for column, or restricted data type.public void setDate(int parameterIndex,
Date x)
throws SQLException
setDate in interface PreparedStatementSQLExceptionpublic void setDate(int parameterIndex,
Date x,
Calendar cal)
throws SQLException
setDate in interface PreparedStatementSQLExceptionpublic void setDouble(int parameterIndex,
double x)
throws SQLException
setDouble in interface PreparedStatementSQLExceptionpublic void setFloat(int parameterIndex,
float x)
throws SQLException
setFloat in interface PreparedStatementSQLExceptionpublic void setInt(int parameterIndex,
int x)
throws SQLException
setInt in interface PreparedStatementSQLExceptionpublic void setLong(int parameterIndex,
long x)
throws SQLException
setLong in interface PreparedStatementSQLExceptionpublic void setNull(int parameterIndex,
int sqlType)
throws SQLException
setNull in interface PreparedStatementSQLExceptionpublic void setNull(int paramIndex,
int sqlType,
String typeName)
throws SQLException
setNull in interface PreparedStatementSQLExceptionpublic void setObject(int parameterIndex,
Object x)
throws SQLException
setObject in interface PreparedStatementSQLExceptionpublic void setObject(int parameterIndex,
Object x,
int targetSqlType)
throws SQLException
setObject in interface PreparedStatementSQLExceptionpublic void setObject(int parameterIndex,
Object x,
int targetSqlType,
int scale)
throws SQLException
setObject in interface PreparedStatementSQLExceptionpublic void setRef(int i,
Ref x)
throws SQLException
setRef in interface PreparedStatementSQLExceptionpublic void setShort(int parameterIndex,
short x)
throws SQLException
setShort in interface PreparedStatementSQLExceptionpublic void setString(int parameterIndex,
String x)
throws SQLException
setString in interface PreparedStatementSQLExceptionpublic void setTime(int parameterIndex,
Time x)
throws SQLException
setTime in interface PreparedStatementSQLExceptionpublic void setTime(int parameterIndex,
Time x,
Calendar cal)
throws SQLException
setTime in interface PreparedStatementSQLExceptionpublic void setTimestamp(int parameterIndex,
Timestamp x)
throws SQLException
setTimestamp in interface PreparedStatementSQLExceptionpublic void setTimestamp(int parameterIndex,
Timestamp x,
Calendar cal)
throws SQLException
setTimestamp in interface PreparedStatementSQLExceptionpublic void setUnicodeStream(int parameterIndex,
InputStream x,
int length)
throws SQLException
setUnicodeStream in interface PreparedStatementSQLExceptionpublic void setURL(int parameterIndex,
URL x)
throws SQLException
setURL in interface PreparedStatementSQLExceptionpublic void setDataBuffer(int numRows,
ByteBuffer buffer)
throws SQLException
numRows - the number of rows contained in bufferbuffer - a buffer containing the rowsA - SQLException is thrownSQLExceptionprotected void validateExecuteInvocation()
throws SQLException
SQLExceptionpublic void close(boolean hardClose)
throws SQLException
SQLExceptionpublic void prepare(String sql, int queryTimeout, int holdability) throws SQLException
SQLExceptionpublic void setFetchSize(int rows)
throws SQLException
setFetchSize in interface StatementsetFetchSize in class TrafT4StatementSQLExceptionpublic String getStatementType()
public short getStatementTypeShort()
public int getStatementTypeInt()
public boolean isClosed()
throws SQLException
isClosed in interface StatementisClosed in class TrafT4StatementSQLExceptionpublic void setPoolable(boolean poolable)
throws SQLException
setPoolable in interface StatementsetPoolable in class TrafT4StatementSQLExceptionpublic boolean isPoolable()
throws SQLException
isPoolable in interface StatementisPoolable in class TrafT4StatementSQLExceptionpublic void closeOnCompletion()
throws SQLException
closeOnCompletion in interface StatementcloseOnCompletion in class TrafT4StatementSQLExceptionpublic boolean isCloseOnCompletion()
throws SQLException
isCloseOnCompletion in interface StatementisCloseOnCompletion in class TrafT4StatementSQLExceptionpublic Object unwrap(Class iface) throws SQLException
unwrap in interface Wrapperunwrap in class TrafT4StatementSQLExceptionpublic boolean isWrapperFor(Class iface) throws SQLException
isWrapperFor in interface WrapperisWrapperFor in class TrafT4StatementSQLExceptionpublic void setRowId(int parameterIndex,
RowId x)
throws SQLException
setRowId in interface PreparedStatementSQLExceptionpublic void setNString(int parameterIndex,
String value)
throws SQLException
setNString in interface PreparedStatementSQLExceptionpublic void setNCharacterStream(int parameterIndex,
Reader value,
long length)
throws SQLException
setNCharacterStream in interface PreparedStatementSQLExceptionpublic void setNClob(int parameterIndex,
NClob value)
throws SQLException
setNClob in interface PreparedStatementSQLExceptionpublic void setClob(int parameterIndex,
Reader reader,
long length)
throws SQLException
setClob in interface PreparedStatementSQLExceptionpublic void setBlob(int parameterIndex,
InputStream inputStream,
long length)
throws SQLException
setBlob in interface PreparedStatementSQLExceptionpublic void setNClob(int parameterIndex,
Reader reader,
long length)
throws SQLException
setNClob in interface PreparedStatementSQLExceptionpublic void setSQLXML(int parameterIndex,
SQLXML xmlObject)
throws SQLException
setSQLXML in interface PreparedStatementSQLExceptionpublic void setAsciiStream(int parameterIndex,
InputStream x,
long length)
throws SQLException
setAsciiStream in interface PreparedStatementSQLExceptionpublic void setBinaryStream(int parameterIndex,
InputStream x,
long length)
throws SQLException
setBinaryStream in interface PreparedStatementSQLExceptionpublic void setCharacterStream(int parameterIndex,
Reader reader,
long length)
throws SQLException
setCharacterStream in interface PreparedStatementSQLExceptionpublic void setAsciiStream(int parameterIndex,
InputStream x)
throws SQLException
setAsciiStream in interface PreparedStatementSQLExceptionpublic void setBinaryStream(int parameterIndex,
InputStream x)
throws SQLException
setBinaryStream in interface PreparedStatementSQLExceptionpublic void setCharacterStream(int parameterIndex,
Reader reader)
throws SQLException
setCharacterStream in interface PreparedStatementSQLExceptionpublic void setNCharacterStream(int parameterIndex,
Reader value)
throws SQLException
setNCharacterStream in interface PreparedStatementSQLExceptionpublic void setClob(int parameterIndex,
Reader reader)
throws SQLException
setClob in interface PreparedStatementSQLExceptionpublic void setBlob(int parameterIndex,
InputStream inputStream)
throws SQLException
setBlob in interface PreparedStatementSQLExceptionpublic void setNClob(int parameterIndex,
Reader reader)
throws SQLException
setNClob in interface PreparedStatementSQLExceptionCopyright © 2017. All Rights Reserved.