Java Training : JDBC - Java Database Connectivity

JDBC - Java Database Connectivity

Java Training Overview

JDBC is a Java technology for accessing SQL databases. It is a core part of J2EE, and it works with every major database product. This hands-on course covers all the details that you will need to use JDBC to access the information in your databases using Java. It also talks about real world issues in using JDBC.

All labs can be done with the Eclipse IDE or a simple editor, and the lab instructions include detailed directions on both environments.

Java Training Skills Gained

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