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 | JDBC 4 supported in Oracle mode | JDBC 4 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 |