Enterprise Java Development@TOPIC@

Data Access Objects (DAOs)

An Introduction to DAOs, DB Schema, and SQL

Revision: v2013-09-21

2014-03-06 23:57 EST

Copyright © 2014 jim stafford (jcstaff@apl.jhu.edu)

Abstract

This presentation provides and introduction to the Data Access Object (DAO) pattern to encapsulate access to data, database schema used to design data organization in RDBMS systems, and SQL to access the data.

Purpose
1. Goals
2. Objectives
1. Data Access Object (DAO) Pattern
1.1. Context
1.2. Problem
1.3. Forces
1.4. Solution
1.5. DAO Implementation Structure
1.6. Consequences
2. DAO Interface
2.1. DAO Interface
2.2. DAO Exceptions
2.3. DAO Implementation
2.4. DAO Test
3. Data Transfer Object (DTO) Pattern
3.1. Context
3.2. Problem
3.3. Forces
3.4. Solution
3.5. Consequences
4. RDBMS Schema
4.1. RDBMS
4.1.1. Background
4.1.2. Tables/Columns
4.1.3. Constraints
4.1.4. Relationships
4.1.5. Indexes
4.2. Data Definition Language (DDL)
4.2.1. Create Table
4.2.2. Drop Table
4.2.3. Create Foreign Key Constraint
4.2.4. Drop Foreign Key Constraint
4.2.5. Create Index
4.2.6. Drop Index
4.3. DDL Files in Maven Module
5. SQL Basics
5.1. Create/INSERT
5.2. Read/SELECT
5.3. Update/UPDATE
5.4. Delete/DELETE
6. Working with Native SQL
6.1. Java Database Connectivity (JDBC)
6.2. Java Persistence API (JPA) Native SQL