java.sql.ParameterMetaData is an interface for obtaining parameter information.
Description
java.sql.ParameterMetaData can be used to obtain information about the types and properties of each parameter marker in a PreparedStatement object. For some queries and drivers, data returned by a ParameterMetaData object may be unavailable before the PreparedStatement object is executed.
Some drivers may be unable to provide information about the types and properties for each parameter marker in a 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 |