Dynamic parameters Dynamic parametersIN (? or dynamic) parametersPrepared statementsuse of dynamic parameters in? (dynamic parameter)in prepared statements

You can prepare statements that are allowed to have parameters for which the value is not specified when the statement is prepared using PreparedStatement methods in the JDBC API. These parameters are called dynamic parameters and are represented by a ?.

The JDBC API documents refer to dynamic parameters as IN, INOUT, or OUT parameters. In SQL, they are always IN parameters.

supports the interface ParameterMetaData, new in JDBC 3.0. This interface describes the number, type, and properties of prepared statement parameters. See the for more information.

You must specify values for them before executing the statement. The values specified must match the types expected.