The PreparedStatement class provides the following functions:

• Execution of SQL specifying the ? parameter
• Specification of the ? parameter
• Generation and return of the ResultSet object as a search result
• Return of the number of updated rows as an updating result

Because the PreparedStatement class is a subclass of the Statement class, it inherits all of the Statement class functions.

For details about and usage of each method provided with the PreparedStatement class, see the applicable JDBC manual.

All of the notes about the Statement class are applicable to the PreparedStatement class, because the PreparedStatement class is a subclass of the Statement class. The following describes the other notes about the PreparedStatement class.

(a) Specification of the ? parameter

For details about the setXXX method used to set the ? parameter, see 16.3.3(2) Data mapping when the ? parameter is specified. For details about the JDBC SQL types supported by the connected database, see 16.12 Data types and character codes.

(b) Multiple result sets

The function for returning multiple result sets is not available. Therefore, the getMoreResults method unconditionally returns false and closes any currently open result set.