org.mariadb.jdbc

Class MySQLServerPreparedStatement

java.lang.Object

org.mariadb.jdbc.MySQLStatement

org.mariadb.jdbc.AbstractMySQLPrepareStatement

org.mariadb.jdbc.MySQLServerPreparedStatement

All Implemented Interfaces:

AutoCloseable, PreparedStatement, Statement, Wrapper

public class MySQLServerPreparedStatement
extends AbstractMySQLPrepareStatement

Field Summary

Fields inherited from class org.mariadb.jdbc.MySQLStatement

batchResultSet, firstRewrite, isRewriteable, protocol, queryResult, stLock, timerTask

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 and Description
MySQLServerPreparedStatement(MySQLConnection connection, String sql)

Method Summary

Modifier and Type	Method and Description
void	addBatch()
protected Calendar	cal()
void	clearBatch() Empties this Statement object's current list of SQL commands.
void	clearParameters()
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()
int[]	executeBatch() Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts.
ResultSet	executeQuery()
int	executeUpdate()
ResultSetMetaData	getMetaData()
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()

Methods inherited from class org.mariadb.jdbc.AbstractMySQLPrepareStatement

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, setURL

Methods inherited from class org.mariadb.jdbc.MySQLStatement

addBatch, cacheMoreResults, cancel, clearWarnings, closeOnCompletion, execute, execute, execute, execute, execute, execute, 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, unwrap

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface java.sql.PreparedStatement

executeLargeUpdate, setObject, setObject

Methods inherited from interface java.sql.Statement

addBatch, cancel, clearWarnings, closeOnCompletion, execute, execute, execute, execute, 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, setQueryTimeout

Methods inherited from interface java.sql.Wrapper

isWrapperFor, unwrap

Constructor Detail

MySQLServerPreparedStatement

public MySQLServerPreparedStatement(MySQLConnection connection,
                                    String sql)
                             throws SQLException

Throws:

SQLException

Method Detail

isNoBackslashEscapes

protected boolean isNoBackslashEscapes()

Specified by:

isNoBackslashEscapes in class AbstractMySQLPrepareStatement

useFractionalSeconds

protected boolean useFractionalSeconds()

Specified by:

useFractionalSeconds in class AbstractMySQLPrepareStatement

cal

protected Calendar cal()

Specified by:

cal in class AbstractMySQLPrepareStatement

setParameter

protected void setParameter(int parameterIndex,
                            ParameterHolder holder)
                     throws SQLException

Specified by:

setParameter in class AbstractMySQLPrepareStatement

Throws:

SQLException

addBatch

public void addBatch()
              throws SQLException

Throws:

SQLException

clearBatch

public void clearBatch()

Description copied from class: MySQLStatement

Empties this Statement object's current list of SQL commands.

Specified by:

clearBatch in interface Statement

Overrides:

clearBatch in class MySQLStatement

See Also:

MySQLStatement.addBatch(java.lang.String), DatabaseMetaData.supportsBatchUpdates()

getParameterMetaData

public ParameterMetaData getParameterMetaData()
                                       throws SQLException

Description copied from class: AbstractMySQLPrepareStatement

Retrieves the number, types and properties of this PreparedStatement object's parameters.

Specified by:

getParameterMetaData in interface PreparedStatement

Specified by:

getParameterMetaData in class AbstractMySQLPrepareStatement

Returns:

a ParameterMetaData object that contains information about the number, types and properties for each parameter marker of this PreparedStatement object

Throws:

SQLException - if a database access error occurs or this method is called on a closed PreparedStatement

See Also:

ParameterMetaData

getMetaData

public ResultSetMetaData getMetaData()
                              throws SQLException

Throws:

SQLException

executeBatch

public int[] executeBatch()
                   throws SQLException

Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts. The int elements of the array that is returned are ordered to correspond to the commands in the batch, which are ordered according to the order in which they were added to the batch. The elements in the array returned by the method executeBatch may be one of the following:

1. A number greater than or equal to zero -- indicates that the command was processed successfully and is an update count giving the number of rows in the database that were affected by the command's execution
2. A value of SUCCESS_NO_INFO -- indicates that the command was processed successfully but that the number of rows affected is unknown If one of the commands in a batch update fails to execute properly, this method throws a BatchUpdateException, and a JDBC driver may or may not continue to process the remaining commands in the batch. However, the driver's behavior must be consistent with a particular DBMS, either always continuing to process commands or never continuing to process commands. If the driver continues processing after a failure, the array returned by the method BatchUpdateException.getUpdateCounts will contain as many elements as there are commands in the batch, and at least one of the elements will be the following:
3. A value of EXECUTE_FAILED -- indicates that the command failed to execute successfully and occurs only if a driver continues to process commands after a command fails

The possible implementations and return values have been modified in the Java 2 SDK, Standard Edition, version 1.3 to accommodate the option of continuing to proccess commands in a batch update after a BatchUpdateException object has been thrown.

Specified by:

executeBatch in interface Statement

Overrides:

executeBatch in class MySQLStatement

Returns:

an array of update counts containing one element for each command in the batch. The elements of the array are ordered according to the order in which commands were added to the batch.

Throws:

SQLException - if a database access error occurs, this method is called on a closed Statement or the driver does not support batch statements. Throws BatchUpdateException (a subclass of SQLException) if one of the commands sent to the database fails to execute properly or attempts to return a result set.

Since:

1.3

See Also:

addBatch(), DatabaseMetaData.supportsBatchUpdates()

executeQuery

public ResultSet executeQuery()
                       throws SQLException

Throws:

SQLException

executeUpdate

public int executeUpdate()
                  throws SQLException

Throws:

SQLException

clearParameters

public void clearParameters()
                     throws SQLException

Throws:

SQLException

execute

public boolean execute()
                throws SQLException

Throws:

SQLException

close

public void close()
           throws SQLException

Releases this Statement 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.

Specified by:

close in interface AutoCloseable

Specified by:

close in interface Statement

Overrides:

close in class MySQLStatement

Throws:

SQLException - if a database access error occurs

toString

public String toString()

Overrides:

toString in class Object