Java - JDBC - Relational Database Access

JDBC - Relational Database Access - Java module J811

Java accesses relational databases, such as Oracle and MySQL, through JDBC classes. A manager class which oversees the process is provided with the Java distribution, but you'll also need to obtain a driver class to talk to the specific database of your choice. Using MySQL as an example, this module takes you through the sourcing, configuration and use of JDBC so that you can access data in a relational database from within your Java application.

This topic is presented on public courses MySQL, Java Programming for the Web, Java Extra, Deploying Java Applications on Linux / Unix

Examples from our training material

J850_jdbc.java	Class to perform a MySQL table insert
J850insert.java	Servlet that adds a MySQL table row
J850select.java	Servlet to run a MySQL select (jdbc)
J850sjdbc.java	Generic database insert and select code (MySQL demo)
J850staff.java	Servlet to insert into and report on a table
Oralink.java	Connecting to an Oracle database
jdbc1.java	Connecting to a MySQL database
make_J850.java	Create table for J850 series of demos

Specialist books

Opentalk forum discussions related to this topic

insert and select datetime in GMT timezone
MySQL Java PreparedStatement Quoting

Background information

This module is available under an Open Training Notes License for free download from http://www.training-notes.co.uk.

Topics covered in this module

The JDBC Interface.
Driver managers and drivers.
Type 1, 2, 3 and 4 drivers.
How odbc, jdbc and SQL relate.
Obtaining and installing JDBC drivers.
Example - a MySQL jdbc driver class.
Connection to a database in Java.
Running enquiries against a relational database.

Course links

The following web pages are used as references / examples in this module

[Link] No Title
(at http://industry.java.sun.com/products/jdbc/drivers)

We check these links from time to time with a spider written in PHP. Latest full check was on Saturday, 12th June 2004. Titles are extracted from the web pages listed.

Complete learning

If you are looking for a complete course and not just a information on a single subject, visit our Listing and schedule page.

Well House Consultants specialise in training courses in Java,Python, Perl, PHP, and MySQL. We run Private Courses throughout the UK (and beyond for longer courses), and Public Courses at our training centre in Melksham, Wiltshire, England. It's surprisingly cost effective to come on our public courses - even if you live in a different country or continent to us.

We have a technical library of over 600 books on the subjects on which we teach. These books are available for reference at our training centre. Also available is the Opentalk Forum for discussion of technical questions.