com.oceanbase.jdbc

类 JDBC4CallableStatement

java.lang.Object

com.oceanbase.jdbc.OceanBaseStatement

com.oceanbase.jdbc.BasePrepareStatement

com.oceanbase.jdbc.JDBC4PreparedStatement

com.oceanbase.jdbc.ClientSidePreparedStatement

com.oceanbase.jdbc.CallableFunctionStatement

com.oceanbase.jdbc.JDBC4CallableStatement

所有已实现的接口:

CloneableCallableStatement, ObPrepareStatement, AutoCloseable, Cloneable, CallableStatement, PreparedStatement, Statement, Wrapper

直接已知子类:

OceanBaseFunctionStatement

public class JDBC4CallableStatement
extends CallableFunctionStatement
implements CloneableCallableStatement

字段概要

从类继承的字段 com.oceanbase.jdbc.CallableFunctionStatement

arguments, parameterMetadata

从类继承的字段 com.oceanbase.jdbc.BasePrepareStatement

autoGeneratedKeys, hasLongData, indexMap, parameterCount, SPEC_ISO_ZONED_DATE_TIME

从类继承的字段 com.oceanbase.jdbc.OceanBaseStatement

actualSql, addRowid, batchQueries, canUseServerTimeout, connection, exceptionFactory, executing, fetchSize, isFetchSizeSet, isInternal, lock, lockLogger, maxRows, options, originalSql, protocol, queryTimeout, results, resultSetConcurrency, resultSetScrollType, selectEndPos, simpleSql, sqlType, status, STMT_ALTER, STMT_BEGIN, STMT_CALL, STMT_CREATE, STMT_DECLARE, STMT_DELETE, STMT_DROP, STMT_INSERT, STMT_SELECT, STMT_UNINITIALIZED, STMT_UNKNOWN, STMT_UPDATE, tableName, whereEndPos

从接口继承的字段 java.sql.Statement

CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO

构造器概要

构造器

构造器和说明
JDBC4CallableStatement(OceanBaseConnection connection, String databaseName, String procedureName, String arguments, int resultSetType, int resultSetConcurrency, ExceptionFactory exceptionFactory) Specific implementation of CallableStatement to handle function call, represent by call like {?

方法概要

限定符和类型	方法和说明
JDBC4CallableStatement	clone(OceanBaseConnection connection) Clone statement.
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 CALL statement.
protected SelectResultSet	getResult()
void	setParameter(int parameterIndex, ParameterHolder holder) Set parameter.

从类继承的方法 com.oceanbase.jdbc.CallableFunctionStatement

getArray, getArray, getBigDecimal, getBigDecimal, getBigDecimal, getBlob, getBlob, getBoolean, getBoolean, getByte, getByte, getBytes, getBytes, getCharacterStream, getCharacterStream, getClob, getClob, getDate, getDate, getDate, getDate, getDouble, getDouble, getFloat, getFloat, getInt, getInt, getLong, getLong, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getObject, getObject, getObject, getObject, getObject, getObject, getParameterMetaData, getRef, getRef, getRowId, getRowId, getShort, getShort, getSQLXML, getSQLXML, getString, getString, getTime, getTime, getTime, getTime, getTimestamp, getTimestamp, getTimestamp, getTimestamp, getURL, getURL, initFunctionData, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, 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, setObject, setObject, setObject, setObject, setObject, setRowId, setShort, setSQLXML, setString, setTime, setTime, setTimestamp, setTimestamp, setURL, wasNull

从类继承的方法 com.oceanbase.jdbc.JDBC4PreparedStatement

addBatch, addBatch, asSql, asSql, clearBatch, clearParameters, executeBatch, executeInternal, executeLargeBatch, getMetaData, getParameters, getPrepareResult, getServerUpdateCounts, setArray, setParameters, toString

从类继承的方法 com.oceanbase.jdbc.BasePrepareStatement

executeLargeUpdate, getParameterCount, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBINARY_DOUBLE, setBINARY_FLOAT, setBinaryStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setDate, setDate, setDouble, setFixedCHAR, setFloat, setIndexMap, setInt, setINTERVALDS, setINTERVALYM, setLobLocator, setLocalDateTime, setLong, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setNull, setNull, setNull, setNUMBER_FLOAT, setNUMBER, setObject, setObject, setObject, setObject, setObject, setParameterCount, setRef, setRowId, setShort, setSQLXML, setString, setStruct, setTime, setTime, setTimestamp, setTIMESTAMP, setTimestamp, setTIMESTAMPLTZ, setTIMESTAMPTZ, setUnicodeStream, setURL

从类继承的方法 com.oceanbase.jdbc.OceanBaseStatement

cancel, checkClose, checkCloseOnCompletion, clearWarnings, close, closeOnCompletion, enquoteIdentifier, enquoteLiteral, enquoteNCharLiteral, execute, execute, execute, execute, executeBatchEpilogue, executeBatchExceptionEpilogue, executeBatchExceptionEpilogue, executeEpilogue, executeExceptionEpilogue, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeQuery, executeQueryPrologue, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getActualSql, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getLargeMaxRows, getLargeUpdateCount, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResults, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getServerInfo, getSqlType, getSqlType, getUpdateCount, getWarnings, getWhereEndPos, isAddRowid, isClosed, isCloseOnCompletion, isCursorResultSet, isDml, isInternal, isPoolable, isSimpleIdentifier, isWrapperFor, realClose, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setInternal, setLargeMaxRows, setLocalInfileInputStream, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout, setTimerTask, skipMoreResults, testExecute, unwrap

从类继承的方法 java.lang.Object

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

从接口继承的方法 java.sql.CallableStatement

getArray, getArray, getBigDecimal, getBigDecimal, getBigDecimal, getBlob, getBlob, getBoolean, getBoolean, getByte, getByte, getBytes, getBytes, getCharacterStream, getCharacterStream, getClob, getClob, getDate, getDate, getDate, getDate, getDouble, getDouble, getFloat, getFloat, getInt, getInt, getLong, getLong, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getObject, getObject, getObject, getObject, getObject, getObject, getRef, getRef, getRowId, getRowId, getShort, getShort, getSQLXML, getSQLXML, getString, getString, getTime, getTime, getTime, getTime, getTimestamp, getTimestamp, getTimestamp, getTimestamp, getURL, getURL, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, 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, setObject, setObject, setObject, setObject, setObject, setRowId, setShort, setSQLXML, setString, setTime, setTime, setTimestamp, setTimestamp, setURL, wasNull

从接口继承的方法 java.sql.PreparedStatement

addBatch, clearParameters, executeLargeUpdate, getMetaData, getParameterMetaData, 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, setObject, setObject, setObject, setObject, setObject, setRef, setRowId, setShort, setSQLXML, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL

从接口继承的方法 java.sql.Statement

addBatch, cancel, clearBatch, clearWarnings, close, 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, setQueryTimeout

从接口继承的方法 java.sql.Wrapper

isWrapperFor, unwrap

构造器详细资料

JDBC4CallableStatement

public JDBC4CallableStatement(OceanBaseConnection connection,
                              String databaseName,
                              String procedureName,
                              String arguments,
                              int resultSetType,
                              int resultSetConcurrency,
                              ExceptionFactory exceptionFactory)
                       throws SQLException

Specific implementation of CallableStatement to handle function call, represent by call like {?= call procedure-name[(arg1,arg2, ...)]}.

参数:

connection - current connection

databaseName - database name

procedureName - function name

arguments - function args

resultSetType - a result set type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE

resultSetConcurrency - a concurrency type; one of ResultSet.CONCUR_READ_ONLY or ResultSet.CONCUR_UPDATABLE

exceptionFactory - Exception factory

抛出:

SQLException - exception

方法详细资料

getResult

protected SelectResultSet getResult()
                             throws SQLException

指定者:

getResult 在类中 CallableFunctionStatement

抛出:

SQLException

clone

public JDBC4CallableStatement clone(OceanBaseConnection connection)
                             throws CloneNotSupportedException

Clone statement.

指定者:

clone 在接口中 CloneableCallableStatement

覆盖:

clone 在类中 CallableFunctionStatement

参数:

connection - connection

返回:

Clone statement.

抛出:

CloneNotSupportedException - if any error occur.

executeUpdate

public int executeUpdate()
                  throws SQLException

Executes the CALL statement.

指定者:

executeUpdate 在接口中 PreparedStatement

覆盖:

executeUpdate 在类中 JDBC4PreparedStatement

返回:

either (1) the row count for SQL Data Manipulation Language (DML) statements or (2) 0 for SQL statements that return nothing

抛出:

SQLException - if a database access error occurs; this method is called on a closed PreparedStatement or the SQL statement returns a ResultSet object

setParameter

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

从类复制的说明: JDBC4PreparedStatement

Set parameter.

覆盖:

setParameter 在类中 JDBC4PreparedStatement

参数:

parameterIndex - index

holder - parameter holder

抛出:

SQLException - if index position doesn't correspond to query parameters

executeQuery

public ResultSet executeQuery()
                       throws SQLException

从类复制的说明: JDBC4PreparedStatement

Executes the SQL query in this PreparedStatement object and returns the ResultSet object generated by the query.

指定者:

executeQuery 在接口中 PreparedStatement

覆盖:

executeQuery 在类中 JDBC4PreparedStatement

返回:

a ResultSet object that contains the data produced by the query; never null

抛出:

SQLException - if a database access error occurs; this method is called on a closed PreparedStatement or the SQL statement does not return a ResultSet object

execute

public boolean execute()
                throws SQLException

从类复制的说明: JDBC4PreparedStatement

Executes the SQL statement in this 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.
The 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 getInternalMoreResults to move to any subsequent result(s).

指定者:

execute 在接口中 PreparedStatement

覆盖:

execute 在类中 JDBC4PreparedStatement

返回:

true if the first result is a ResultSet object; false if the first result is an update count or there is no result

抛出:

SQLException - if a database access error occurs; this method is called on a closed PreparedStatement or an argument is supplied to this method

另请参阅:

Statement.execute(java.lang.String), Statement.getResultSet(), Statement.getUpdateCount(), Statement.getMoreResults()