Lecture 2
Introducing JDBC
The Standard Query Language (SQL)
Data Manipulation Language
Data Definition Language
JDBC Framework
The JDBC Driver Manager
JDBC Driver Types
Type 1 Drivers JDBC-ODBC Bridges
Type 2 Drivers Native-API + Java Driver
Type 3 Drivers JDBC-Middleware Pure Java Driver
Type 4 Drivers Pure Java Drivers
Result Sets and Cursors
A JDBC Primer
Create a Connection to the database vi the driver
SQL Statements
Execute the Statement
Result Sets
Prepared Statements
Using the JDBC MetaData Interface
JDBC Transactions
Using Transactions
Rolling Back Transactions
Transactions and Performance Implications
Transaction Isolation Modes
Stored Procedures
Incompatibilities
Why Use Stored Procedures?
Using Stored Procedures
Email: mark@cs.uchicago.edu
Home Page: http://www.cs.uchicago.edu/~mark/527/
Download presentation source