com.oceanbase.jdbc

类 CallableParameterMetaData

java.lang.Object

com.oceanbase.jdbc.CallableParameterMetaData

所有已实现的接口:

ParameterMetaData, Wrapper

直接已知子类:

OceanBaseCallableParameterMetaData

public class CallableParameterMetaData
extends Object
implements ParameterMetaData

字段概要

字段

限定符和类型	字段和说明
protected List<com.oceanbase.jdbc.CallParameter>	allParams
protected OceanBaseConnection	con
protected String	database
protected boolean	isFunction
protected boolean	isOracleMode
protected String	name
protected String	obOraclePackageName
protected String	obOracleSchema
protected SQLException	outputParamSetParamValueException
protected static Pattern	PARAMETER_PATTERN
protected static Pattern	PARAMETER_PATTERN_MYSQL_MODE_NOT_INFORMATION_SCHEMA
protected List<com.oceanbase.jdbc.CallParameter>	placeholderParams
protected int[]	placeholderToParameterIndexMap placeholderToParameterIndexMap[i] = j The assignment placeholderToParameterIndexMap[i] = j indicates that the (i+1)th placeholder in the SQL string corresponds to the (j+1)th parameter in the SQL command.
protected String	query
protected static Pattern	RETURN_PATTERN
protected boolean	valid

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

parameterModeIn, parameterModeInOut, parameterModeOut, parameterModeUnknown, parameterNoNulls, parameterNullable, parameterNullableUnknown

构造器概要

构造器

构造器和说明
CallableParameterMetaData(OceanBaseConnection con, String database, String name, boolean isFunction) Retrieve Callable metaData.

方法概要

限定符和类型	方法和说明
void	generateMetadataFromPrepareResultSet(ServerPrepareResult serverPrepareResult)
String	getDatabase()
String	getName(int param)
com.oceanbase.jdbc.CallParameter	getParam(int index)
String	getParameterClassName(int param)
int	getParameterCount() When it is an Oracle function, return the number of placeholder type parameters in SQL
int	getParameterMode(int param) Get mode info.
int	getParameterType(int param)
String	getParameterTypeName(int param)
com.oceanbase.jdbc.CallParameter	getPlaceholderParam(int index)
int	getPrecision(int param)
String	getProName()
int	getScale(int param)
boolean	hasEmptyPlaceholderParams()
int	isNullable(int param)
boolean	isSigned(int param)
boolean	isWrapperFor(Class<?> iface)
void	readMetadataFromDbIfRequired() Search metaData if not already loaded.
void	readMetadataFromDbIfRequired(String query, String arguments, Boolean isObFunction)
<T> T	unwrap(Class<T> iface)

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

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

字段详细资料

PARAMETER_PATTERN

protected static final Pattern PARAMETER_PATTERN

PARAMETER_PATTERN_MYSQL_MODE_NOT_INFORMATION_SCHEMA

protected static final Pattern PARAMETER_PATTERN_MYSQL_MODE_NOT_INFORMATION_SCHEMA

RETURN_PATTERN

protected static final Pattern RETURN_PATTERN

con

protected final OceanBaseConnection con

isOracleMode

protected boolean isOracleMode

name

protected final String name

placeholderParams

protected List<com.oceanbase.jdbc.CallParameter> placeholderParams

allParams

protected List<com.oceanbase.jdbc.CallParameter> allParams

placeholderToParameterIndexMap

protected int[] placeholderToParameterIndexMap

placeholderToParameterIndexMap[i] = j The assignment placeholderToParameterIndexMap[i] = j indicates that the (i+1)th placeholder in the SQL string corresponds to the (j+1)th parameter in the SQL command. For instance, in the SQL call call test_pro('a',?,10,?), placeholderToParameterIndexMap[0] = 1 means that the first placeholder ? is associated with the second parameter in the SQL call.

obOraclePackageName

protected String obOraclePackageName

obOracleSchema

protected String obOracleSchema

database

protected String database

valid

protected boolean valid

isFunction

protected boolean isFunction

query

protected String query

outputParamSetParamValueException

protected SQLException outputParamSetParamValueException

构造器详细资料

CallableParameterMetaData

public CallableParameterMetaData(OceanBaseConnection con,
                                 String database,
                                 String name,
                                 boolean isFunction)

Retrieve Callable metaData.

参数:

con - connection

database - database name

name - procedure/function name

isFunction - is it a function

方法详细资料

getProName

public String getProName()

getDatabase

public String getDatabase()

readMetadataFromDbIfRequired

public void readMetadataFromDbIfRequired()
                                  throws SQLException

Search metaData if not already loaded.

抛出:

SQLException - if error append during loading metaData

generateMetadataFromPrepareResultSet

public void generateMetadataFromPrepareResultSet(ServerPrepareResult serverPrepareResult)
                                          throws SQLException

抛出:

SQLException

readMetadataFromDbIfRequired

public void readMetadataFromDbIfRequired(String query,
                                         String arguments,
                                         Boolean isObFunction)
                                  throws SQLException

抛出:

SQLException

getParameterCount

public int getParameterCount()

When it is an Oracle function, return the number of placeholder type parameters in SQL

指定者:

getParameterCount 在接口中 ParameterMetaData

返回:

placeholderParams.size

getParam

public com.oceanbase.jdbc.CallParameter getParam(int index)
                                          throws SQLException

抛出:

SQLException

isNullable

public int isNullable(int param)
               throws SQLException

指定者:

isNullable 在接口中 ParameterMetaData

抛出:

SQLException

isSigned

public boolean isSigned(int param)
                 throws SQLException

指定者:

isSigned 在接口中 ParameterMetaData

抛出:

SQLException

getPrecision

public int getPrecision(int param)
                 throws SQLException

指定者:

getPrecision 在接口中 ParameterMetaData

抛出:

SQLException

getScale

public int getScale(int param)
             throws SQLException

指定者:

getScale 在接口中 ParameterMetaData

抛出:

SQLException

getParameterType

public int getParameterType(int param)
                     throws SQLException

指定者:

getParameterType 在接口中 ParameterMetaData

抛出:

SQLException

getParameterTypeName

public String getParameterTypeName(int param)
                            throws SQLException

指定者:

getParameterTypeName 在接口中 ParameterMetaData

抛出:

SQLException

getParameterClassName

public String getParameterClassName(int param)
                             throws SQLException

指定者:

getParameterClassName 在接口中 ParameterMetaData

抛出:

SQLException

getParameterMode

public int getParameterMode(int param)
                     throws SQLException

Get mode info.

• 0 : unknown
• 1 : IN
• 2 : INOUT
• 4 : OUT

指定者:

getParameterMode 在接口中 ParameterMetaData

参数:

param - parameter index

返回:

mode information

抛出:

SQLException - if index is wrong

getName

public String getName(int param)
               throws SQLException

抛出:

SQLException

unwrap

public <T> T unwrap(Class<T> iface)

指定者:

unwrap 在接口中 Wrapper

isWrapperFor

public boolean isWrapperFor(Class<?> iface)

指定者:

isWrapperFor 在接口中 Wrapper

hasEmptyPlaceholderParams

public boolean hasEmptyPlaceholderParams()

getPlaceholderParam

public com.oceanbase.jdbc.CallParameter getPlaceholderParam(int index)