com.oceanbase.jdbc

类 OceanBaseProcedureStatement

java.lang.Object

com.oceanbase.jdbc.OceanBaseStatement

com.oceanbase.jdbc.BasePrepareStatement

com.oceanbase.jdbc.JDBC4ServerPreparedStatement

com.oceanbase.jdbc.ServerSidePreparedStatement

com.oceanbase.jdbc.CallableProcedureStatement

com.oceanbase.jdbc.JDBC4ServerCallableStatement

com.oceanbase.jdbc.OceanBaseProcedureStatement

所有已实现的接口:

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

public class OceanBaseProcedureStatement
extends JDBC4ServerCallableStatement

字段概要

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

arguments, hasInOutParameters, outputParameterMapper, parameterMetadata, params, resetSpecialParamIndex

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

currentParameterHolder, isObFunction, parametersList, serverPrepareResult

从类继承的字段 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

构造器概要

构造器

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

方法概要

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

clone, execute, executeBatch, executeLargeBatch, getOutputResult, setParameter

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

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, getParameter, getParameterMetaData, 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, setArray, setAsciiStream, setAsciiStream, setAsciiStream, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBigDecimal, setBinaryStream, setBinaryStream, setBinaryStream, setBinaryStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBlob, setBlob, setBlob, setBoolean, setBoolean, setByte, setByte, setBytes, setBytes, setCharacterStream, setCharacterStream, setCharacterStream, setCharacterStream, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setClob, setClob, setClob, setDate, setDate, setDate, setDate, setDouble, setDouble, setFloat, setFloat, setInt, setInt, setLong, setLong, setNCharacterStream, setNCharacterStream, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNClob, setNClob, setNClob, setNString, setNString, setNull, setNull, setNull, setNull, setObject, setObject, setObject, setObject, setObject, setObject, setObject, setObject, setRef, setRowId, setRowId, setShort, setShort, setSQLXML, setSQLXML, setString, setString, setTime, setTime, setTime, setTime, setTimestamp, setTimestamp, setTimestamp, setTimestamp, setUnicodeStream, setURL, setURL, wasNull

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

addBatch, addBatch, clearBatch, clearParameters, close, closeCursor, cursorFetch, cursorFetchForOracle, executeBatchQuerys, executeInternal, executeLargeBatchQuerys, executeLargeUpdate, executeQuery, executeUpdate, getGeneratedKeys, getMetaData, getParameters, getReturnResultSet, getServerThreadId, prepareExecuteInternal, realClose, registerReturnAutoGeneratedKey, registerReturnParameter, registerReturnParameter, registerReturnParameter, setParameters, toString, validParameters

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

asSql, getParameterCount, setBINARY_DOUBLE, setBINARY_FLOAT, setFixedCHAR, setIndexMap, setINTERVALDS, setINTERVALYM, setLobLocator, setLocalDateTime, setNull, setNUMBER_FLOAT, setNUMBER, setObject, setObject, setParameterCount, setStruct, setTIMESTAMP, setTIMESTAMPLTZ, setTIMESTAMPTZ

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

cancel, checkClose, checkCloseOnCompletion, clearWarnings, 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, 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, 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, executeQuery, executeUpdate, 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, 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

构造器详细资料

OceanBaseProcedureStatement

public OceanBaseProcedureStatement(boolean isObFunction,
                                   String query,
                                   OceanBaseConnection connection,
                                   String procedureName,
                                   String database,
                                   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, ...)]}.

参数:

isObFunction -

query - query

connection - current connection

procedureName - procedure name

database - database

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

OceanBaseProcedureStatement

public OceanBaseProcedureStatement(boolean isObFunction,
                                   String query,
                                   OceanBaseConnection connection,
                                   String procedureName,
                                   String database,
                                   String arguments,
                                   int resultSetType,
                                   int resultSetConcurrency,
                                   ExceptionFactory exceptionFactory,
                                   boolean isAnoymousBlock)
                            throws SQLException

抛出:

SQLException