public class NamedPreparedStatement extends Object 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 |
|---|
NamedPreparedStatement(Connection connection,
String sqlQuery)
Create a named prepared statement.
|
NamedPreparedStatement(Connection connection,
String sqlQuery,
Map<String,Integer> repetition)
Create a named prepared statement with repeated indexes.
|
NamedPreparedStatement(Connection connection,
String sqlQuery,
Map<String,Integer> repetition,
String returningColumnName)
Create a named prepared statement with repeated indexes and a specified column value to be returned.
|
NamedPreparedStatement(Connection connection,
String sqlQuery,
String returningColumnName)
Create a named prepared statement with a specified column value to be returned.
|
| Modifier and Type | Method and Description |
|---|---|
void |
addBatch() |
void |
addBatch(String sql) |
void |
cancel() |
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() |
int |
getQueryTimeout() |
ResultSet |
getResultSet() |
int |
getResultSetConcurrency() |
int |
getResultSetHoldability() |
int |
getResultSetType() |
int |
getUpdateCount() |
SQLWarning |
getWarnings() |
boolean |
isClosed() |
boolean |
isCloseOnCompletion() |
boolean |
isPoolable() |
boolean |
isWrapperFor(Class<?> iface) |
void |
setArray(int parameterIndex,
Array array) |
void |
setAsciiStream(int parameterIndex,
InputStream inputStream) |
void |
setAsciiStream(int parameterIndex,
InputStream inputStream,
int length) |
void |
setAsciiStream(int parameterIndex,
InputStream inputStream,
long length) |
void |
setBigDecimal(int parameterIndex,
BigDecimal bigDecimal) |
void |
setBinaryStream(int parameterIndex,
InputStream inputStream) |
void |
setBinaryStream(int parameterIndex,
InputStream inputStream,
int length) |
void |
setBinaryStream(int parameterIndex,
InputStream inputStream,
long length) |
void |
setBlob(int parameterIndex,
Blob blob) |
void |
setBlob(int parameterIndex,
InputStream inputStream) |
void |
setBlob(int parameterIndex,
InputStream inputStream,
long length) |
void |
setBoolean(int parameterIndex,
boolean value) |
void |
setByte(int parameterIndex,
byte value) |
void |
setBytes(int parameterIndex,
byte[] bytes) |
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 clob) |
void |
setClob(int parameterIndex,
Reader reader) |
void |
setClob(int parameterIndex,
Reader reader,
long length) |
void |
setCursorName(String name) |
void |
setDate(int parameterIndex,
Date date) |
void |
setDate(int parameterIndex,
Date date,
Calendar cal) |
void |
setDouble(int parameterIndex,
double value) |
void |
setEscapeProcessing(boolean enable) |
void |
setFetchDirection(int direction) |
void |
setFetchSize(int rows) |
void |
setFloat(int parameterIndex,
float value) |
void |
setInt(int parameterIndex,
int value) |
void |
setInt(String name,
int value)
Set
int value for the named index. |
void |
setLong(int parameterIndex,
long value) |
void |
setLong(String name,
long value)
Set
long value for the named index. |
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 object) |
void |
setObject(int parameterIndex,
Object object,
int targetSqlType) |
void |
setObject(int parameterIndex,
Object object,
int targetSqlType,
int scaleOrLength) |
void |
setObject(String name,
Object value) |
void |
setPoolable(boolean poolable) |
void |
setQueryTimeout(int seconds) |
void |
setRef(int parameterIndex,
Ref ref) |
void |
setRowId(int parameterIndex,
RowId rowId) |
void |
setShort(int parameterIndex,
short value) |
void |
setSQLXML(int parameterIndex,
SQLXML xmlObject) |
void |
setString(int parameterIndex,
String string) |
void |
setString(String name,
List<String> values)
Replace repeated indexes with the list of values.
|
void |
setString(String name,
String value)
Set
String value for the named index. |
void |
setTime(int parameterIndex,
Time time) |
void |
setTime(int parameterIndex,
Time time,
Calendar cal) |
void |
setTimestamp(int parameterIndex,
Timestamp timestamp) |
void |
setTimestamp(int parameterIndex,
Timestamp timestamp,
Calendar cal) |
void |
setTimeStamp(String name,
Timestamp timestamp,
Calendar calendar)
Set
TimeStamp value for the named index. |
void |
setUnicodeStream(int parameterIndex,
InputStream inputStream,
int length) |
void |
setURL(int parameterIndex,
URL url) |
<T> T |
unwrap(Class<T> iface) |
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, waitexecuteLargeUpdate, setObject, setObjectexecuteLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, getLargeMaxRows, getLargeUpdateCount, setLargeMaxRowspublic NamedPreparedStatement(Connection connection, String sqlQuery, Map<String,Integer> repetition) throws SQLException
connection - Database connection to be used.sqlQuery - Underlying SQL query.repetition - Repetition of given index.SQLException - SQL Exception.public NamedPreparedStatement(Connection connection, String sqlQuery) throws SQLException
connection - Database connection to be used.sqlQuery - Underlying SQL query.SQLException - SQL Exception.public NamedPreparedStatement(Connection connection, String sqlQuery, String returningColumnName) throws SQLException
connection - Database connection to be used.sqlQuery - Underlying SQL query.returningColumnName - Name of the unique column to be returned upon query success.SQLException - SQL Exception.public NamedPreparedStatement(Connection connection, String sqlQuery, Map<String,Integer> repetition, String returningColumnName) throws SQLException
connection - Database connection to be used.sqlQuery - Underlying SQL query.repetition - Repetition of given index.returningColumnName - Name of the column to be returned upon query success.SQLException - SQL Exception.public void setLong(String name, long value) throws SQLException
long value for the named index.name - Name of the index.value - Value to be replaced.SQLException - SQL Exception.public void setInt(String name, int value) throws SQLException
int value for the named index.name - Name of the index.value - Value to be replaced.SQLException - SQL Exception.public void setString(String name, String value) throws SQLException
String value for the named index.name - Name of the index.value - Value to be replaced.SQLException - SQL Exceptionpublic void setString(String name, List<String> values) throws SQLException
name - Name of the index.values - Values to be replaced.SQLException - SQL Exception.public void setObject(String name, Object value) throws SQLException
SQLExceptionpublic void setTimeStamp(String name, Timestamp timestamp, Calendar calendar) throws SQLException
TimeStamp value for the named index.name - Name of the index.timestamp - value to be replaced.calendar - value to be replaced.SQLException - SQL Exception.public ResultSet executeQuery() throws SQLException
executeQuery in interface PreparedStatementSQLExceptionpublic int executeUpdate()
throws SQLException
executeUpdate in interface PreparedStatementSQLExceptionpublic void setNull(int parameterIndex,
int sqlType)
throws SQLException
setNull in interface PreparedStatementSQLExceptionpublic void setBoolean(int parameterIndex,
boolean value)
throws SQLException
setBoolean in interface PreparedStatementSQLExceptionpublic void setByte(int parameterIndex,
byte value)
throws SQLException
setByte in interface PreparedStatementSQLExceptionpublic void setShort(int parameterIndex,
short value)
throws SQLException
setShort in interface PreparedStatementSQLExceptionpublic void setInt(int parameterIndex,
int value)
throws SQLException
setInt in interface PreparedStatementSQLExceptionpublic void setLong(int parameterIndex,
long value)
throws SQLException
setLong in interface PreparedStatementSQLExceptionpublic void setFloat(int parameterIndex,
float value)
throws SQLException
setFloat in interface PreparedStatementSQLExceptionpublic void setDouble(int parameterIndex,
double value)
throws SQLException
setDouble in interface PreparedStatementSQLExceptionpublic void setBigDecimal(int parameterIndex,
BigDecimal bigDecimal)
throws SQLException
setBigDecimal in interface PreparedStatementSQLExceptionpublic void setString(int parameterIndex,
String string)
throws SQLException
setString in interface PreparedStatementSQLExceptionpublic void setBytes(int parameterIndex,
byte[] bytes)
throws SQLException
setBytes in interface PreparedStatementSQLExceptionpublic void setDate(int parameterIndex,
Date date)
throws SQLException
setDate in interface PreparedStatementSQLExceptionpublic void setTime(int parameterIndex,
Time time)
throws SQLException
setTime in interface PreparedStatementSQLExceptionpublic void setTimestamp(int parameterIndex,
Timestamp timestamp)
throws SQLException
setTimestamp in interface PreparedStatementSQLExceptionpublic void setAsciiStream(int parameterIndex,
InputStream inputStream,
int length)
throws SQLException
setAsciiStream in interface PreparedStatementSQLExceptionpublic void setUnicodeStream(int parameterIndex,
InputStream inputStream,
int length)
throws SQLException
setUnicodeStream in interface PreparedStatementSQLExceptionpublic void setBinaryStream(int parameterIndex,
InputStream inputStream,
int length)
throws SQLException
setBinaryStream in interface PreparedStatementSQLExceptionpublic void clearParameters()
throws SQLException
clearParameters in interface PreparedStatementSQLExceptionpublic void setObject(int parameterIndex,
Object object,
int targetSqlType)
throws SQLException
setObject in interface PreparedStatementSQLExceptionpublic void setObject(int parameterIndex,
Object object)
throws SQLException
setObject in interface PreparedStatementSQLExceptionpublic boolean execute()
throws SQLException
execute in interface PreparedStatementSQLExceptionpublic void addBatch()
throws SQLException
addBatch in interface PreparedStatementSQLExceptionpublic void setCharacterStream(int parameterIndex,
Reader reader,
int length)
throws SQLException
setCharacterStream in interface PreparedStatementSQLExceptionpublic void setRef(int parameterIndex,
Ref ref)
throws SQLException
setRef in interface PreparedStatementSQLExceptionpublic void setBlob(int parameterIndex,
Blob blob)
throws SQLException
setBlob in interface PreparedStatementSQLExceptionpublic void setClob(int parameterIndex,
Clob clob)
throws SQLException
setClob in interface PreparedStatementSQLExceptionpublic void setArray(int parameterIndex,
Array array)
throws SQLException
setArray in interface PreparedStatementSQLExceptionpublic ResultSetMetaData getMetaData() throws SQLException
getMetaData in interface PreparedStatementSQLExceptionpublic void setDate(int parameterIndex,
Date date,
Calendar cal)
throws SQLException
setDate in interface PreparedStatementSQLExceptionpublic void setTime(int parameterIndex,
Time time,
Calendar cal)
throws SQLException
setTime in interface PreparedStatementSQLExceptionpublic void setTimestamp(int parameterIndex,
Timestamp timestamp,
Calendar cal)
throws SQLException
setTimestamp in interface PreparedStatementSQLExceptionpublic void setNull(int parameterIndex,
int sqlType,
String typeName)
throws SQLException
setNull in interface PreparedStatementSQLExceptionpublic void setURL(int parameterIndex,
URL url)
throws SQLException
setURL in interface PreparedStatementSQLExceptionpublic ParameterMetaData getParameterMetaData() throws SQLException
getParameterMetaData in interface PreparedStatementSQLExceptionpublic void setRowId(int parameterIndex,
RowId rowId)
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 setObject(int parameterIndex,
Object object,
int targetSqlType,
int scaleOrLength)
throws SQLException
setObject in interface PreparedStatementSQLExceptionpublic void setAsciiStream(int parameterIndex,
InputStream inputStream,
long length)
throws SQLException
setAsciiStream in interface PreparedStatementSQLExceptionpublic void setBinaryStream(int parameterIndex,
InputStream inputStream,
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 inputStream)
throws SQLException
setAsciiStream in interface PreparedStatementSQLExceptionpublic void setBinaryStream(int parameterIndex,
InputStream inputStream)
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 PreparedStatementSQLExceptionpublic ResultSet executeQuery(String sql) throws SQLException
executeQuery in interface StatementSQLExceptionpublic int executeUpdate(String sql) throws SQLException
executeUpdate in interface StatementSQLExceptionpublic void close()
throws SQLException
close in interface AutoCloseableclose in interface StatementSQLExceptionpublic int getMaxFieldSize()
throws SQLException
getMaxFieldSize in interface StatementSQLExceptionpublic void setMaxFieldSize(int max)
throws SQLException
setMaxFieldSize in interface StatementSQLExceptionpublic int getMaxRows()
throws SQLException
getMaxRows in interface StatementSQLExceptionpublic void setMaxRows(int max)
throws SQLException
setMaxRows in interface StatementSQLExceptionpublic void setEscapeProcessing(boolean enable)
throws SQLException
setEscapeProcessing in interface StatementSQLExceptionpublic int getQueryTimeout()
throws SQLException
getQueryTimeout in interface StatementSQLExceptionpublic void setQueryTimeout(int seconds)
throws SQLException
setQueryTimeout in interface StatementSQLExceptionpublic void cancel()
throws SQLException
cancel in interface StatementSQLExceptionpublic SQLWarning getWarnings() throws SQLException
getWarnings in interface StatementSQLExceptionpublic void clearWarnings()
throws SQLException
clearWarnings in interface StatementSQLExceptionpublic void setCursorName(String name) throws SQLException
setCursorName in interface StatementSQLExceptionpublic boolean execute(String sql) throws SQLException
execute in interface StatementSQLExceptionpublic ResultSet getResultSet() throws SQLException
getResultSet in interface StatementSQLExceptionpublic int getUpdateCount()
throws SQLException
getUpdateCount in interface StatementSQLExceptionpublic boolean getMoreResults()
throws SQLException
getMoreResults in interface StatementSQLExceptionpublic void setFetchDirection(int direction)
throws SQLException
setFetchDirection in interface StatementSQLExceptionpublic int getFetchDirection()
throws SQLException
getFetchDirection in interface StatementSQLExceptionpublic void setFetchSize(int rows)
throws SQLException
setFetchSize in interface StatementSQLExceptionpublic int getFetchSize()
throws SQLException
getFetchSize in interface StatementSQLExceptionpublic int getResultSetConcurrency()
throws SQLException
getResultSetConcurrency in interface StatementSQLExceptionpublic int getResultSetType()
throws SQLException
getResultSetType in interface StatementSQLExceptionpublic void addBatch(String sql) throws SQLException
addBatch in interface StatementSQLExceptionpublic void clearBatch()
throws SQLException
clearBatch in interface StatementSQLExceptionpublic int[] executeBatch()
throws SQLException
executeBatch in interface StatementSQLExceptionpublic Connection getConnection() throws SQLException
getConnection in interface StatementSQLExceptionpublic boolean getMoreResults(int current)
throws SQLException
getMoreResults in interface StatementSQLExceptionpublic ResultSet getGeneratedKeys() throws SQLException
getGeneratedKeys in interface StatementSQLExceptionpublic int executeUpdate(String sql, int autoGeneratedKeys) throws SQLException
executeUpdate in interface StatementSQLExceptionpublic int executeUpdate(String sql, int[] columnIndexes) throws SQLException
executeUpdate in interface StatementSQLExceptionpublic int executeUpdate(String sql, String[] columnNames) throws SQLException
executeUpdate in interface StatementSQLExceptionpublic boolean execute(String sql, int autoGeneratedKeys) throws SQLException
execute in interface StatementSQLExceptionpublic boolean execute(String sql, int[] columnIndexes) throws SQLException
execute in interface StatementSQLExceptionpublic boolean execute(String sql, String[] columnNames) throws SQLException
execute in interface StatementSQLExceptionpublic int getResultSetHoldability()
throws SQLException
getResultSetHoldability in interface StatementSQLExceptionpublic boolean isClosed()
throws SQLException
isClosed in interface StatementSQLExceptionpublic void setPoolable(boolean poolable)
throws SQLException
setPoolable in interface StatementSQLExceptionpublic boolean isPoolable()
throws SQLException
isPoolable in interface StatementSQLExceptionpublic void closeOnCompletion()
throws SQLException
closeOnCompletion in interface StatementSQLExceptionpublic boolean isCloseOnCompletion()
throws SQLException
isCloseOnCompletion in interface StatementSQLExceptionpublic <T> T unwrap(Class<T> iface) throws SQLException
unwrap in interface WrapperSQLExceptionpublic boolean isWrapperFor(Class<?> iface) throws SQLException
isWrapperFor in interface WrapperSQLExceptionCopyright © 2020 WSO2. All rights reserved.