public class MariaDbStatement extends Object implements Statement, Cloneable
Modifier and Type | Field and Description |
---|---|
protected boolean |
binaryData |
protected MariaDbConnection |
connection
the Connection object.
|
static Pattern |
deleteEndSemicolonPattern |
protected ExecutionResult |
executionResult |
protected int |
fetchSize |
protected String |
firstRewrite |
protected boolean |
isRewriteable |
protected Protocol |
protocol
the protocol used to talk to the server.
|
protected int |
resultSetScrollType |
protected TimerTask |
timerTask
The actual query result.
|
CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO
Constructor and Description |
---|
MariaDbStatement(MariaDbConnection connection,
int resultSetScrollType)
Creates a new Statement.
|
Modifier and Type | Method and Description |
---|---|
void |
addBatch(String sql)
Adds the given SQL command to the current list of commmands for this
Statement object. |
protected void |
cacheMoreResults(ExecutionResult execResult,
int fetchSize,
boolean canHaveCallableResult) |
void |
cancel()
Cancels this
Statement object if both the DBMS and driver support aborting an SQL statement. |
protected void |
checkClose()
Check if statement is closed, and throw exception if so.
|
void |
clearBatch()
Empties this
Statement object's current list of SQL send. |
void |
clearWarnings()
Clears all the warnings reported on this
Statement object. |
MariaDbStatement |
clone()
Clone statement.
|
void |
close()
Releases this
Statement object's database and JDBC resources immediately instead of waiting for this to happen when it is
automatically closed. |
void |
closeOnCompletion() |
protected boolean |
execute(Query query,
int fetchSize)
executes a query.
|
boolean |
execute(String queryString)
executes a query.
|
boolean |
execute(String sql,
int autoGeneratedKeys)
Executes the given SQL statement, which may return multiple results, and signals the driver that any auto-generated keys should be made
available for retrieval.
|
boolean |
execute(String sql,
int[] columnIndexes)
Executes the given SQL statement, which may return multiple results, and signals the driver that the auto-generated keys indicated in the given
array should be made available for retrieval.
|
boolean |
execute(String sql,
String[] columnNames)
Executes the given SQL statement, which may return multiple results, and signals the driver that the auto-generated keys indicated in the
given array should be made available for retrieval.
|
int[] |
executeBatch()
Execute statements. depending on option, queries mays be rewritten :
those queries will be rewritten if possible to
INSERT INTO ...
|
protected ResultSet |
executeQuery(Query query)
executes a select query.
|
ResultSet |
executeQuery(String queryString)
executes a select query.
|
protected void |
executeQueryEpilog(QueryException queryException)
Reset timeout after query, re-throw SQL exception
|
protected int |
executeUpdate(Query query)
Executes an update.
|
int |
executeUpdate(String queryString)
Executes an update.
|
int |
executeUpdate(String sql,
int autoGeneratedKeys)
Executes the given SQL statement and signals the driver with the given flag about whether the auto-generated keys produced by this
Statement object should be made available for retrieval. |
int |
executeUpdate(String sql,
int[] columnIndexes)
Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for
retrieval.
|
int |
executeUpdate(String sql,
String[] columnNames)
Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for
retrieval.
|
Connection |
getConnection()
Gets the connection that created this statement.
|
int |
getFetchDirection()
Retrieves the direction for fetching rows from database tables that is the default for result sets generated from this
Statement
object. |
int |
getFetchSize()
Retrieves the number of result set rows that is the default fetch size for
ResultSet objects generated from this
Statement object. |
ResultSet |
getGeneratedKeys()
Retrieves any auto-generated keys created as a result of executing this
Statement object. |
protected int |
getInsertIncipit(String sql)
Parses the input string to understand if it is an INSERT statement.
|
int |
getMaxFieldSize()
Retrieves the maximum number of bytes that can be returned for character and binary column values in a
ResultSet object produced
by this Statement object. |
int |
getMaxRows()
Retrieves the maximum number of rows that a
ResultSet object produced by this Statement object can contain. |
boolean |
getMoreResults()
Moves to this
Statement object's next result, returns true if it is a ResultSet object, and
implicitly closes any current ResultSet object(s) obtained with the method getResultSet . |
boolean |
getMoreResults(int current)
Moves to this
Statement object's next result, deals with any current ResultSet object(s) according to the
instructions specified by the given flag, and returns true if the next result is a ResultSet object. |
Protocol |
getProtocol()
returns the protocol.
|
int |
getQueryTimeout()
Retrieves the number of seconds the driver will wait for a
Statement object to execute. |
ResultSet |
getResultSet()
Retrieves the current result as a ResultSet object.
|
int |
getResultSetConcurrency()
Retrieves the result set concurrency for
ResultSet objects generated by this Statement object. |
int |
getResultSetHoldability()
Retrieves the result set holdability for
ResultSet objects generated by this Statement object. |
int |
getResultSetType()
Retrieves the result set type for
ResultSet objects generated by this Statement object. |
int |
getUpdateCount()
Retrieves the current result as an update count; if the result is a ResultSet object or there are no more results, -1 is returned.
|
SQLWarning |
getWarnings()
Retrieves the first warning reported by calls on this
Statement object. |
boolean |
isClosed()
Retrieves whether this
Statement object has been closed. |
boolean |
isCloseOnCompletion() |
protected void |
isInsertRewriteable(String sql)
Parses the sql string to understand whether it is compatible with rewritten batches.
|
boolean |
isPoolable()
Returns a value indicating whether the
Statement is poolable or not. |
boolean |
isWrapperFor(Class<?> interfaceOrWrapper)
Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does.
|
protected ResultSet |
retrieveCallableResult()
Retrieve the output parameter result
|
void |
setCursorName(String name)
Sets the SQL cursor name to the given
String , which will be used by subsequent Statement object execute
methods. |
void |
setEscapeProcessing(boolean enable)
Sets escape processing on or off.
|
void |
setFetchDirection(int direction)
Gives the driver a hint as to the direction in which rows will be processed in
ResultSet objects created using this
Statement object. |
void |
setFetchSize(int rows)
Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed for
ResultSet objects genrated by this Statement . |
void |
setLocalInfileInputStream(InputStream inputStream)
Sets the inputStream that will be used for the next execute that uses "LOAD DATA LOCAL INFILE".
|
void |
setMaxFieldSize(int max)
Sets the limit for the maximum number of bytes that can be returned for character and binary column values in a
ResultSet object
produced by this Statement object. |
void |
setMaxRows(int max)
Sets the limit for the maximum number of rows that any
ResultSet object generated by this Statement object can
contain to the given number. |
void |
setPoolable(boolean poolable)
Requests that a
Statement be pooled or not pooled. |
void |
setQueryTimeout(int seconds)
Sets the number of seconds the driver will wait for a
Statement object to execute to the given number of seconds. |
protected void |
skipMoreResults() |
protected Query |
stringToQuery(String queryString) |
static void |
unloadDriver()
Provide a "cleanup" method that can be called after unloading driver, to fix Tomcat's obscure classpath handling.
|
<T> T |
unwrap(Class<T> iface)
Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the
proxy.
|
equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, getLargeMaxRows, getLargeUpdateCount, setLargeMaxRows
protected Protocol protocol
protected MariaDbConnection connection
protected boolean binaryData
protected TimerTask timerTask
protected boolean isRewriteable
protected String firstRewrite
protected int fetchSize
public static final Pattern deleteEndSemicolonPattern
protected ExecutionResult executionResult
protected int resultSetScrollType
public MariaDbStatement(MariaDbConnection connection, int resultSetScrollType)
connection
- the connection to return in getConnection.resultSetScrollType
- one of the following ResultSet
constants: ResultSet.TYPE_FORWARD_ONLY
,
ResultSet.TYPE_SCROLL_INSENSITIVE
, or ResultSet.TYPE_SCROLL_SENSITIVE
public MariaDbStatement clone() throws CloneNotSupportedException
clone
in class Object
CloneNotSupportedException
- if any error occur.public static void unloadDriver()
public Protocol getProtocol()
protected void cacheMoreResults(ExecutionResult execResult, int fetchSize, boolean canHaveCallableResult)
protected void executeQueryEpilog(QueryException queryException) throws SQLException
queryException
- exception if existSQLException
- exception with new message in case of timer timeout.protected boolean execute(Query query, int fetchSize) throws SQLException
query
- the queryfetchSize
- fetch sizeSQLException
- the error descriptionpublic boolean execute(String queryString) throws SQLException
execute
in interface Statement
queryString
- the querySQLException
- if the query could not be sent to serverpublic boolean execute(String sql, int autoGeneratedKeys) throws SQLException
Executes the given SQL statement, which may return multiple results, and signals the driver that any auto-generated keys should be made
available for retrieval. The driver will ignore this signal if the SQL statement is not an INSERT
statement, or an SQL statement
able to return auto-generated keys (the list of such statements is vendor-specific).
In some (uncommon) situations, a single SQL statement may return multiple result sets and/or update counts. Normally you can ignore this unless you are (1) executing a stored procedure that you know may return multiple results or (2) you are dynamically executing an unknown SQL string.
Theexecute
method
executes an SQL statement and indicates the form of the first result. You must then use the methods getResultSet
or
getUpdateCount
to retrieve the result, and getInternalMoreResults
to move to any subsequent result(s).execute
in interface Statement
sql
- any SQL statementautoGeneratedKeys
- a constant indicating whether auto-generated keys should be made available for retrieval using the method
getGeneratedKeys
; one of the following constants: Statement.RETURN_GENERATED_KEYS
or
Statement.NO_GENERATED_KEYS
true
if the first result is a ResultSet
object; false
if it is an update count or there are no
resultsSQLException
- if a database access error occurs, this method is called on a closed Statement
or the second
parameter supplied to this method is not Statement.RETURN_GENERATED_KEYS
or Statement.NO_GENERATED_KEYS
.SQLFeatureNotSupportedException
- if the JDBC driver does not support this method with a constant of
Statement.RETURN_GENERATED_KEYSgetResultSet()
,
getUpdateCount()
,
getMoreResults()
,
getGeneratedKeys()
public boolean execute(String sql, int[] columnIndexes) throws SQLException
INSERT
statement, or an SQL statement able to return auto-generated keys (the list of such statements is vendor-specific). Under some (uncommon) situations, a single SQL statement may return multiple result sets and/or update counts. Normally you can ignore this unless you are (1) executing a stored procedure that you know may return multiple results or (2) you are dynamically executing an unknown SQL string.
Theexecute
method executes an SQL statement and indicates the form of the first result. You must then use the methods
getResultSet
or getUpdateCount
to retrieve the result, and getInternalMoreResults
to move to any
subsequent result(s).execute
in interface Statement
sql
- any SQL statementcolumnIndexes
- an array of the indexes of the columns in the inserted row that should be made available for retrieval by a call to the
method getGeneratedKeys
true
if the first result is a ResultSet
object; false
if it is an update count or there are no
resultsSQLException
- if a database access error occurs, this method is called on a closed Statement
or the elements in
the int
array passed to this method are not valid column indexesSQLFeatureNotSupportedException
- if the JDBC driver does not support this methodgetResultSet()
,
getUpdateCount()
,
getMoreResults()
public boolean execute(String sql, String[] columnNames) throws SQLException
Executes the given SQL statement, which may return multiple results, and signals the driver that the auto-generated keys indicated in the
given array should be made available for retrieval. This array contains the names of the columns in the target table that contain the
auto-generated keys that should be made available. The driver will ignore the array if the SQL statement is not an INSERT
statement, or an SQL statement able to return auto-generated keys (the list of such statements is vendor-specific).
In some (uncommon) situations, a single SQL statement may return multiple result sets and/or update counts. Normally you can ignore this unless you are (1) executing a stored procedure that you know may return multiple results or (2) you are dynamically executing an unknown SQL string.
The execute
method executes an SQL statement and indicates the form of the first result. You must then use the methods
getResultSet
or getUpdateCount
to retrieve the result, and getInternalMoreResults
to move to any
subsequent result(s).
execute
in interface Statement
sql
- any SQL statementcolumnNames
- an array of the names of the columns in the inserted row that should be made available for retrieval by a call to the method
getGeneratedKeys
true
if the next result is a ResultSet
object; false
if it is an update count or there are no
more resultsSQLException
- if a database access error occurs, this method is called on a closed Statement
or the elements of
the String
array passed to this method are not valid column namesSQLFeatureNotSupportedException
- if the JDBC driver does not support this methodgetResultSet()
,
getUpdateCount()
,
getMoreResults()
,
getGeneratedKeys()
protected ResultSet executeQuery(Query query) throws SQLException
query
- the query to send to the serverSQLException
- if something went wrongpublic ResultSet executeQuery(String queryString) throws SQLException
executeQuery
in interface Statement
queryString
- the query to send to the serverSQLException
- if something went wrongprotected int executeUpdate(Query query) throws SQLException
query
- the update query.SQLException
- if the query could not be sent to server.public int executeUpdate(String queryString) throws SQLException
executeUpdate
in interface Statement
queryString
- the update query.SQLException
- if the query could not be sent to server.public int executeUpdate(String sql, int autoGeneratedKeys) throws SQLException
Statement
object should be made available for retrieval. The driver will ignore the flag if the SQL statement is not an
INSERT
statement, or an SQL statement able to return auto-generated keys (the list of such statements is vendor-specific).executeUpdate
in interface Statement
sql
- 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.autoGeneratedKeys
- a flag indicating whether auto-generated keys should be made available for retrieval; one of the following constants:
Statement.RETURN_GENERATED_KEYS
Statement.NO_GENERATED_KEYS
SQLException
- if a database access error occurs, this method is called on a closed Statement
, the given SQL
statement returns a ResultSet
object, or the given constant is not one of those allowedSQLFeatureNotSupportedException
- if the JDBC driver does not support this method with a constant of
Statement.RETURN_GENERATED_KEYSpublic int executeUpdate(String sql, int[] columnIndexes) throws SQLException
INSERT
statement, or an SQL statement able to return
auto-generated keys (the list of such statements is vendor-specific).executeUpdate
in interface Statement
sql
- 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.columnIndexes
- an array of column indexes indicating the columns that should be returned from the inserted rowSQLException
- if a database access error occurs, this method is called on a closed Statement
, the SQL statement
returns a ResultSet
object, or the second argument supplied to this method is not an int
array whose elements are
valid column indexesSQLFeatureNotSupportedException
- if the JDBC driver does not support this methodpublic int executeUpdate(String sql, String[] columnNames) throws SQLException
INSERT
statement, or an SQL statement able to return
auto-generated keys (the list of such statements is vendor-specific).executeUpdate
in interface Statement
sql
- 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.columnNames
- an array of the names of the columns that should be returned from the inserted rowINSERT
, UPDATE
, or DELETE
statements, or 0 for SQL statements that
return nothingSQLException
- if a database access error occurs, this method is called on a closed Statement
, the SQL statement
returns a ResultSet
object, or the second argument supplied to this method is not a String
array whose elements are
valid column namesSQLFeatureNotSupportedException
- if the JDBC driver does not support this methodprotected Query stringToQuery(String queryString) throws SQLException
SQLException
public void close() throws SQLException
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.close
in interface AutoCloseable
close
in interface Statement
SQLException
- if a database access error occursprotected ResultSet retrieveCallableResult() throws SQLException
SQLException
- if any error occurpublic int getMaxFieldSize() throws SQLException
ResultSet
object produced
by this Statement
object. This limit applies only to BINARY
, VARBINARY
, LONGVARBINARY
,
CHAR
, VARCHAR
, NCHAR
, NVARCHAR
, LONGNVARCHAR
and LONGVARCHAR
columns. If the limit is exceeded, the excess data is silently discarded.getMaxFieldSize
in interface Statement
SQLException
- if a database access error occurs or this method is called on a closed Statement
setMaxFieldSize(int)
public void setMaxFieldSize(int max) throws SQLException
ResultSet
object
produced by this Statement
object. This limit applies only to BINARY
, VARBINARY
,
LONGVARBINARY
, CHAR
, VARCHAR
, NCHAR
, NVARCHAR
, LONGNVARCHAR
and
LONGVARCHAR
fields. If the limit is exceeded, the excess data is silently discarded. For maximum portability, use values greater
than 256.setMaxFieldSize
in interface Statement
max
- the new column size limit in bytes; zero means there is no limitSQLException
- if a database access error occurs, this method is called on a closed Statement
or the condition max
>= 0 is not satisfiedgetMaxFieldSize()
public int getMaxRows() throws SQLException
ResultSet
object produced by this Statement
object can contain. If this
limit is exceeded, the excess rows are silently dropped.getMaxRows
in interface Statement
ResultSet
object produced by this Statement
object; zero means there
is no limitSQLException
- if a database access error occurs or this method is called on a closed Statement
setMaxRows(int)
public void setMaxRows(int max) throws SQLException
ResultSet
object generated by this Statement
object can
contain to the given number. If the limit is exceeded, the excess rows are silently dropped.setMaxRows
in interface Statement
max
- the new max rows limit; zero means there is no limitSQLException
- if the condition max >= 0 is not satisfiedgetMaxRows()
public void setEscapeProcessing(boolean enable) throws SQLException
PreparedStatements
objects will have no effect.setEscapeProcessing
in interface Statement
enable
- true
to enable escape processing; false
to disable itSQLException
- if a database access error occurs or this method is called on a closed Statement
public int getQueryTimeout() throws SQLException
Statement
object to execute. If the limit is exceeded, a
SQLException
is thrown.getQueryTimeout
in interface Statement
SQLException
- if a database access error occurs or this method is called on a closed Statement
setQueryTimeout(int)
public void setQueryTimeout(int seconds) throws SQLException
Statement
object to execute to the given number of seconds. If the limit is
exceeded, an SQLException
is thrown. A JDBC driver must apply this limit to the execute
, executeQuery
and executeUpdate
methods. JDBC driver implementations may also apply this limit to ResultSet
methods (consult your
driver vendor documentation for details).setQueryTimeout
in interface Statement
seconds
- the new query timeout limit in seconds; zero means there is no limitSQLException
- if a database access error occurs, this method is called on a closed Statement
or the condition
seconds >= 0 is not satisfiedgetQueryTimeout()
public void setLocalInfileInputStream(InputStream inputStream) throws SQLException
inputStream
- inputStream instance, that will be used to send data to serverSQLException
- if statement is closedpublic void cancel() throws SQLException
Statement
object if both the DBMS and driver support aborting an SQL statement. This method can be used by one thread
to cancel a statement that is being executed by another thread.cancel
in interface Statement
SQLException
- if a database access error occurs or this method is called on a closed Statement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this methodpublic SQLWarning getWarnings() throws SQLException
Statement
object. Subsequent Statement
object warnings will be
chained to this SQLWarning
object. The warning chain is automatically cleared each time a statement is (re)executed. This
method may not be called on a closed Statement
object; doing so will cause an SQLException
to be thrown.
Note: If you are processing a ResultSet
object, any warnings associated with reads on that ResultSet
object
will be chained on it rather than on the Statement
object that produced it.
getWarnings
in interface Statement
SQLWarning
object or null
if there are no warningsSQLException
- if a database access error occurs or this method is called on a closed Statement
public void clearWarnings() throws SQLException
Statement
object. After a call to this method, the method getWarnings
will
return null
until a new warning is reported for this Statement
object.clearWarnings
in interface Statement
SQLException
- if a database access error occurs or this method is called on a closed Statement
public void setCursorName(String name) throws SQLException
String
, which will be used by subsequent Statement
object execute
methods. This name can then be used in SQL positioned update or delete statements to identify the current row in the ResultSet
object generated by this statement. If the database does not support positioned update/delete, this method is a noop. To insure that a cursor
has the proper isolation level to support updates, the cursor's SELECT
statement should have the form SELECT FOR
UPDATE
. If FOR UPDATE
is not present, positioned updates may fail. Note: By definition, the execution of
positioned updates and deletes must be done by a different Statement
object than the one that generated the ResultSet
object being used for positioning. Also, cursor names must be unique within a connection.
setCursorName
in interface Statement
name
- the new cursor name, which must be unique within a connectionSQLException
- if a database access error occurs or this method is called on a closed Statement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this methodpublic Connection getConnection() throws SQLException
getConnection
in interface Statement
SQLException
- if connection is invalidpublic ResultSet getGeneratedKeys() throws SQLException
Statement
object. If this Statement
object
did not generate any keys, an empty ResultSet
object is returned. Note:If the columns which represent the auto-generated keys were not specified, the JDBC driver implementation will determine the columns which best represent the auto-generated keys.
getGeneratedKeys
in interface Statement
ResultSet
object containing the auto-generated key(s) generated by the execution of this Statement
objectSQLException
- if a database access error occurs or this method is called on a closed Statement
SQLFeatureNotSupportedException
- if the JDBC driver does not support this methodpublic int getResultSetHoldability() throws SQLException
ResultSet
objects generated by this Statement
object.getResultSetHoldability
in interface Statement
ResultSet.HOLD_CURSORS_OVER_COMMIT
or ResultSet.CLOSE_CURSORS_AT_COMMIT
SQLException
- if a database access error occurs or this method is called on a closed Statement
public boolean isClosed() throws SQLException
Statement
object has been closed. A Statement
is closed if the method close has been called on
it, or if it is automatically closed.isClosed
in interface Statement
Statement
object is closed; false if it is still openSQLException
- if a database access error occurspublic boolean isPoolable() throws SQLException
Statement
is poolable or not.isPoolable
in interface Statement
true
if the Statement
is poolable; false
otherwiseSQLException
- if this method is called on a closed Statement
setPoolable(boolean)
public void setPoolable(boolean poolable) throws SQLException
Requests that a Statement
be pooled or not pooled. The value specified is a hint to the statement pool implementation
indicating whether the applicaiton wants the statement to be pooled. It is up to the statement pool manager as to whether the hint is
used.
The poolable value of a statement is applicable to both internal statement caches implemented by the driver and external statement caches implemented by application servers and other applications.
By default, a Statement
is not poolable when
created, and a PreparedStatement
and CallableStatement
are poolable when created.
setPoolable
in interface Statement
poolable
- requests that the statement be pooled if true and that the statement not be pooled if falseSQLException
- if this method is called on a closed Statement
public ResultSet getResultSet() throws SQLException
getResultSet
in interface Statement
SQLException
- if a database access error occurs or this method is called on a closed Statementpublic int getUpdateCount() throws SQLException
getUpdateCount
in interface Statement
SQLException
- if a database access error occurs or this method is called on a closed Statementprotected void skipMoreResults() throws SQLException
SQLException
public boolean getMoreResults() throws SQLException
Moves to this Statement
object's next result, returns true
if it is a ResultSet
object, and
implicitly closes any current ResultSet
object(s) obtained with the method getResultSet
.
// stmt is a Statement object ((stmt.getInternalMoreResults() == false) && (stmt.getUpdateCount() == -1))
getMoreResults
in interface Statement
true
if the next result is a ResultSet
object; false
if it is an update count or there are no
more resultsSQLException
- if a database access error occurs or this method is called on a closed Statement
execute(org.mariadb.jdbc.internal.query.Query, int)
public boolean getMoreResults(int current) throws SQLException
Moves to this Statement
object's next result, deals with any current ResultSet
object(s) according to the
instructions specified by the given flag, and returns true
if the next result is a ResultSet
object.
// stmt is a Statement object ((stmt.getInternalMoreResults(current) == false) && (stmt.getUpdateCount() == -1))
getMoreResults
in interface Statement
current
- one of the following Statement
constants indicating what should happen to current ResultSet
objects
obtained using the method getResultSet
: Statement.CLOSE_CURRENT_RESULT
, Statement.KEEP_CURRENT_RESULT
,
or Statement.CLOSE_ALL_RESULTS
true
if the next result is a ResultSet
object; false
if it is an update count or there are no
more resultsSQLException
- if a database access error occurs, this method is called on a closed Statement
or the argument
supplied is not one of the following: Statement.CLOSE_CURRENT_RESULT
, Statement.KEEP_CURRENT_RESULT
or
Statement.CLOSE_ALL_RESULTS
SQLFeatureNotSupportedException
- if DatabaseMetaData.supportsMultipleOpenResults
returns false
and
either Statement.KEEP_CURRENT_RESULT
or Statement.CLOSE_ALL_RESULTS
are supplied as the argument.execute(org.mariadb.jdbc.internal.query.Query, int)
public int getFetchDirection() throws SQLException
Statement
object. If this Statement
object has not set a fetch direction by calling the method setFetchDirection
, the return
value is implementation-specific.getFetchDirection
in interface Statement
Statement
objectSQLException
- if a database access error occurs or this method is called on a closed Statement
setFetchDirection(int)
public void setFetchDirection(int direction) throws SQLException
Gives the driver a hint as to the direction in which rows will be processed in ResultSet
objects created using this
Statement
object. The default value is ResultSet.FETCH_FORWARD
.
Note that this method sets the default fetch
direction for result sets generated by this Statement
object. Each result set has its own methods for getting and setting its own
fetch direction.
setFetchDirection
in interface Statement
direction
- the initial direction for processing rowsSQLException
- if a database access error occurs, this method is called on a closed Statement
or the given
direction is not one of ResultSet.FETCH_FORWARD
, ResultSet.FETCH_REVERSE
, or ResultSet.FETCH_UNKNOWN
getFetchDirection()
public int getFetchSize() throws SQLException
ResultSet
objects generated from this
Statement
object. If this Statement
object has not set a fetch size by calling the method setFetchSize
,
the return value is implementation-specific.getFetchSize
in interface Statement
Statement
objectSQLException
- if a database access error occurs or this method is called on a closed Statement
setFetchSize(int)
public void setFetchSize(int rows) throws SQLException
ResultSet
objects genrated by this Statement
. If the value specified is zero, then the hint is ignored. The default
value is zero.setFetchSize
in interface Statement
rows
- the number of rows to fetchSQLException
- if a database access error occurs, this method is called on a closed Statement
or the condition
rows >= 0
is not satisfied.getFetchSize()
public int getResultSetConcurrency() throws SQLException
ResultSet
objects generated by this Statement
object.getResultSetConcurrency
in interface Statement
ResultSet.CONCUR_READ_ONLY
or ResultSet.CONCUR_UPDATABLE
SQLException
- if a database access error occurs or this method is called on a closed Statement
public int getResultSetType() throws SQLException
ResultSet
objects generated by this Statement
object.getResultSetType
in interface Statement
ResultSet.TYPE_FORWARD_ONLY
, ResultSet.TYPE_SCROLL_INSENSITIVE
, or
ResultSet.TYPE_SCROLL_SENSITIVE
SQLException
- if a database access error occurs or this method is called on a closed Statement
public void addBatch(String sql) throws SQLException
Statement
object. The send in this list can be executed
as a batch by calling the method executeBatch
.addBatch
in interface Statement
sql
- 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 updatesexecuteBatch()
,
DatabaseMetaData.supportsBatchUpdates()
protected void isInsertRewriteable(String sql)
sql
- the sql stringprotected int getInsertIncipit(String sql)
sql
- the input SQL statementpublic void clearBatch() throws SQLException
Statement
object's current list of SQL send.clearBatch
in interface Statement
SQLException
- if a database access error occurs, this method is called on a closed Statement
or the driver does
not support batch updatesaddBatch(java.lang.String)
,
DatabaseMetaData.supportsBatchUpdates()
public int[] executeBatch() throws SQLException
executeBatch
in interface Statement
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 send
sent to the database fails to execute properly or attempts to return a result set.addBatch(java.lang.String)
,
DatabaseMetaData.supportsBatchUpdates()
public <T> T unwrap(Class<T> iface) throws SQLException
Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy.
If the receiver implements the interface then the result is the receiver or a proxy for the receiver. If the receiver is a wrapper and
the wrapped object implements the interface then the result is the wrapped object or a proxy for the wrapped object. Otherwise return the the
result of calling unwrap
recursively on the wrapped object or a proxy for that result. If the receiver is not a wrapper and does
not implement the interface, then an SQLException
is thrown.
unwrap
in interface Wrapper
iface
- A Class defining an interface that the result must implement.SQLException
- If no object found that implements the interfacepublic boolean isWrapperFor(Class<?> interfaceOrWrapper) throws SQLException
isWrapperFor
on the wrapped object. If this does not implement the interface and is not a wrapper, return false. This method
should be implemented as a low-cost operation compared to unwrap
so that callers can use this method to avoid expensive
unwrap
calls that may fail. If this method returns true then calling unwrap
with the same argument should succeed.isWrapperFor
in interface Wrapper
interfaceOrWrapper
- a Class defining an interface.SQLException
- if an error occurs while determining whether this is a wrapper for an object with the given interface.public void closeOnCompletion() throws SQLException
closeOnCompletion
in interface Statement
SQLException
public boolean isCloseOnCompletion() throws SQLException
isCloseOnCompletion
in interface Statement
SQLException
protected void checkClose() throws SQLException
SQLException
- if statement closeCopyright © 2016. All rights reserved.