- Understand the JDBC architecture
- Connect to different databases with JDBC
- Understand the JDBC API
- Execute SQL statements using JDBC, and retrieve results
- Call stored procedures from JDBC
- Understand and control transactions with JDBC
- Retrieve information about database structure using DatabaseMetaData
- Use Advanced JDBC features
Hands-On
50% hands-on, 50% lecture
Java Training Course Duration
1 Day
Java Training Course outline
Introduction
- Relational Database and JDBC Overview
- Overview, Table Relationships, Web Based Data Access, JDBC Characteristics
- JDBC Architecture, JDBC API Overview
- DriverManager, JDBC Drivers
- Naming databases with JDBC URLs
- Connecting to a database
- Connection interface, Establishing a connection
- DataBaseMetaData
- Handling Database Exceptions
Data Access
- DAO – Data Access Objects, O-R Mapping, Value Objects
- Processing Database Data
- Executing statements, precompiled statements and stored procedures
- Processing ResultSets,
- Dealing with Null data
- Updating, inserting, retrieving data
- Controlling Transactions
- JDBC Driver Types
- DataSource
- J2EE and DataSource
- Using JNDI
- Connection Pooling
- Overview, Usage, Advantages, Statement Pooling
Advanced Topics
- Other Database Access Technologies
- SQLJ, O-R Mapping Tools, JDO (Java Data Objects), EJB Entity Beans
- Advanced JDBC Features
- Batch Updates, Srollable Result Sets, Rowsets, User Defined Types, BLOBS, CLOB
