public class MySQLClientPreparedStatement extends AbstractMySQLPrepareStatement
batchResultSet, connection, firstRewrite, isRewriteable, protocol, queryResult, stLock, timerTaskCLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO| Constructor and Description |
|---|
MySQLClientPreparedStatement(MySQLConnection connection,
String sql) |
| Modifier and Type | Method and Description |
|---|---|
void |
addBatch()
Adds a set of parameters to this
PreparedStatement object's batch of commands. |
void |
addBatch(String sql)
Adds the given SQL command to the current list of commmands for this
Statement object. |
protected Calendar |
cal() |
void |
clearBatch()
Empties this
Statement object's current list of SQL commands. |
void |
clearParameters()
Clears the current parameter values immediately.
|
void |
close()
Releases this
Statement object's database and JDBC resources immediately instead of waiting for this
to happen when it is automatically closed. |
boolean |
execute()
Executes the SQL statement in this
PreparedStatement object,
which may be any kind of SQL statement. |
ResultSet |
executeQuery()
Executes the SQL query in this
PreparedStatement object
and returns the ResultSet object generated by the query. |
int |
executeUpdate()
Executes the SQL statement in this
PreparedStatement object, which must be an SQL Data Manipulation
Language (DML) statement, such as INSERT, UPDATE or DELETE; or an SQL
statement that returns nothing, such as a DDL statement. |
ResultSetMetaData |
getMetaData()
Retrieves a
ResultSetMetaData object that contains information about the columns of the
ResultSet object that will be returned when this PreparedStatement object is executed. |
ParameterMetaData |
getParameterMetaData()
Retrieves the number, types and properties of this
PreparedStatement object's parameters. |
protected boolean |
isNoBackslashEscapes() |
protected void |
setParameter(int parameterIndex,
ParameterHolder holder) |
String |
toString() |
protected boolean |
useFractionalSeconds() |
setArray, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBinaryStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setNull, setNull, setNull, setObject, setObject, setObject, setRef, setRowId, setShort, setSQLXML, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURLcacheMoreResults, cancel, clearWarnings, closeOnCompletion, execute, execute, execute, execute, execute, execute, executeBatch, executeQuery, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getInsertIncipit, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getMoreResults, getProtocol, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getUpdateCounts, getUpdateCountsForReWrittenBatch, getWarnings, isClosed, isCloseOnCompletion, isInsertRewriteable, isPoolable, isStreaming, isWrapperFor, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLocalInfileInputStream, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout, unloadDriver, unwrapclone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, waitexecuteLargeUpdate, setObject, setObjectcancel, clearWarnings, 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, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeoutisWrapperFor, unwrappublic MySQLClientPreparedStatement(MySQLConnection connection, String sql) throws SQLException
SQLExceptionprotected boolean isNoBackslashEscapes()
isNoBackslashEscapes in class AbstractMySQLPrepareStatementprotected boolean useFractionalSeconds()
useFractionalSeconds in class AbstractMySQLPrepareStatementprotected Calendar cal()
cal in class AbstractMySQLPrepareStatementpublic ResultSet executeQuery() throws SQLException
PreparedStatement object
and returns the ResultSet object generated by the query.ResultSet object that contains the data produced by the
query; never nullSQLException - if a database access error occurs;
this method is called on a closed PreparedStatement or the SQL
statement does not return a ResultSet objectpublic boolean execute()
throws SQLException
PreparedStatement object,
which may be any kind of SQL statement.
Some prepared statements return multiple results; the execute
method handles these complex statements as well as the simpler
form of statements handled by the methods executeQuery
and executeUpdate.
execute method returns a boolean to
indicate the form of the first result. You must call either the method
getResultSet or getUpdateCount
to retrieve the result; you must call getMoreResults to
move to any subsequent result(s).true if the first result is a ResultSet
object; false if the first result is an update
count or there is no resultSQLException - if a database access error occurs;
this method is called on a closed PreparedStatement
or an argument is supplied to this methodStatement.execute(java.lang.String),
Statement.getResultSet(),
Statement.getUpdateCount(),
Statement.getMoreResults()public int executeUpdate()
throws SQLException
PreparedStatement object, which must be an SQL Data Manipulation
Language (DML) statement, such as INSERT, UPDATE or DELETE; or an SQL
statement that returns nothing, such as a DDL statement.SQLException - if a database access error occurs; this method is called on a closed
PreparedStatement or the SQL statement returns a
ResultSet objectpublic void addBatch()
throws SQLException
PreparedStatement object's batch of commands.
SQLException - if a database access error occurs or this method is called on a closed
PreparedStatementStatement.addBatch(java.lang.String)public void addBatch(String sql) throws SQLException
MySQLStatementStatement object. The commands
in this list can be executed as a batch by calling the method executeBatch.addBatch in interface StatementaddBatch in class MySQLStatementsql - typically this is a SQL INSERT or UPDATE statementSQLException - if a database access error occurs, this method is called on a closed
Statement or the driver does not support batch updatesMySQLStatement.executeBatch(),
DatabaseMetaData.supportsBatchUpdates()public void clearBatch()
MySQLStatementStatement object's current list of SQL commands.clearBatch in interface StatementclearBatch in class MySQLStatementMySQLStatement.addBatch(java.lang.String),
DatabaseMetaData.supportsBatchUpdates()public ResultSetMetaData getMetaData() throws SQLException
ResultSetMetaData object that contains information about the columns of the
ResultSet object that will be returned when this PreparedStatement object is executed.
PreparedStatement object is precompiled, it is possible to know about the
ResultSet object that it will return without having to execute it. Consequently, it is possible to
invoke the method getMetaData on a PreparedStatement object rather than waiting to
execute it and then invoking the ResultSet.getMetaData method on the ResultSet object
that is returned.
ResultSet object's columns or null if the driver cannot
return a ResultSetMetaData objectSQLException - if a database access error occurs or this method is called on a closed
PreparedStatementSQLFeatureNotSupportedException - if the JDBC driver does not support this methodprotected void setParameter(int parameterIndex,
ParameterHolder holder)
throws SQLException
setParameter in class AbstractMySQLPrepareStatementSQLExceptionpublic ParameterMetaData getParameterMetaData() throws SQLException
PreparedStatement object's parameters.getParameterMetaData in interface PreparedStatementgetParameterMetaData in class AbstractMySQLPrepareStatementParameterMetaData object that contains information about the number, types and properties
for each parameter marker of this PreparedStatement objectSQLException - if a database access error occurs or this method is called on a closed
PreparedStatementParameterMetaDatapublic void clearParameters()
In general, parameter values remain in force for repeated use
of a statement. Setting a parameter value automatically clears its previous value. However, in some cases it is
useful to immediately release the resources used by the current parameter values; this can be done by calling the
method clearParameters.
public void close()
throws SQLException
MySQLStatementStatement object's database and JDBC resources immediately instead of waiting for this
to happen when it is automatically closed. It is generally good practice to release resources as soon as you are
finished with them to avoid tying up database resources.
Calling the method close on a Statement object that is already closed has no effect.
Note:When a Statement object is closed, its current ResultSet object, if one
exists, is also closed.close in interface AutoCloseableclose in interface Statementclose in class MySQLStatementSQLException - if a database access error occursCopyright © 2015. All rights reserved.