COMPUTING SCIENCE 320

Software Engineering II

Accessing a Database with JDBC

Sample Programs

JDBC_Demo in Java

MakeDB.java by Cay S. Horstmann, Core Java 2, Vol. II -- Advanced Features, p. 227 (c) 2000 Sun Microsystems Press

MakeDB.properties -- configuration file used by MakeDB.java

Data files: Authors.dat     Books.dat     BooksAuthors.dat     Publishers.dat

Links to Other JDBC Information

JDBC Data Access API home page J2SE 5.0 Java SE 6

JDBC Tutorial

MySQL® Connector/J JDBC Driver for MySQL

MySQL Connector/J Documentation - see this page for information about the class name of the driver (which will need to be used in the sample programs given above)

SQL

A Gentle Introduction to SQL

Links to MySQL and InnoDB information

Articles about MySQL

MySQL Reference Manual

Developer Shed Network - A collection of articles and tutorials on the MySQL server and OO database techniques

Using Transactions In MySQL

InnoDB Engine - Reference Manual of InnoDB

Other Tools

O/R Mapping with Hibernate