java.sql.ParameterMetaData

2023-12-14 07:26:05  Updated

java.sql.ParameterMetaData is an interface for obtaining parameter information.

Description

java.sql.ParameterMetaData can be used to obtain the type and property information of each parameter marker in a relevant PreparedStatement object. For some queries and drivers, data returned by the ParameterMetaData object may be unavailable before PreparedStatement is executed.

Some drivers may be unable to provide the type and property information for each parameter marker in a relevant CallableStatement object.

Methods

Method Return type Supported in Oracle mode? Supported in MySQL mode?
getParameterCount() int Yes Yes
isNullable(int param) int Yes Yes
isSigned(int param) Boolean Yes Yes
getPrecision(int param) int Yes Yes
getScale(int param) int Yes Yes
getParameterType(int param) int No No
getParameterTypeName(int param) String Yes Yes
getParameterClassName(int param) String Yes Yes
getParameterMode(int param) int Yes Yes

Contact Us