Day 9. Using JDBC to Connect to a Database

Today, you'll learn how to use Java Database Connectivity (JDBC) to connect components of an enterprise application to any data source. JDBC is the standard and unified API to access any data in a tabular form, whether it is a relational database, spreadsheet, or flat file. We'll give a brief account of the JDBC architecture and the different clients and components across all the J2EE tiers that can use it. Using snippet of codes, the JDBC API will be explained. We'll wrap up with an example to highlight the main interfaces and classes of the JDBC. We'll emphasize the fact that JDBC is a vendor-neutral API by running an example in two different environments of application servers, without changes to the sample code.

We'll also discuss features of JDBC such as connection pooling, data sources, SQL queries and updates, and advanced concepts including prepared statements, local transactions, metadata, and batch updates. Finally, we'll explore the built-in features of the API to optimize your access to data sources.

• Learn the rationale behind JDBC

• Explore the JDBC architecture

• Learn the JDBC API's classes and interfaces

• Learn how to connect to a database using JDBC

• Learn how to perform local transactions using JDBC API

• Explore the data manipulation operations of databases using JDBC

• Study query optimization to databases

• Learn how to use batch updates for optimal operations

• Work with metadata for databases and query results

• Work with a practical example to apply what you learned today