Retrieving and Manipulating Data: The Statement Class and JDBC Exceptions

The Statement class allows a SQL statement to be presented to the database for execution. As part of that process, the Statement class allows suggestions to be sent to the database on how to process the query and how to return the results.

Extensions to the Statement class allow batches of updates to be sent to the database and processed together. The SQL syntax can vary slightly across different databases. The JDBC API provides for escape processing to allow a standard JDBC syntax to be used for various statements (such as stored procedure calls). The JDBC driver is then responsible for providing the correct syntax for these statements before presenting them to the database ...

Get J2EE™ and Beyond: Design, Develop, and Deploy World-Class Java™ Software now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.