Exercises, examples and other material relating to training module J811. This topic is presented on public courses MySQL
, Java Programming for the Web
, Java Extra
, Deploying Java Applications on Linux / Unix
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.
Related technical and longer articlesInterfacing applications to a MySQL database engine
|Articles and tips on this subject||updated|
|3046||Java Beans, tag libraries and JSPs - what and why.|
Java Programming - training course! - just completed. We went a long way from the first steps in Java on Monday through to Servlets and Java Server Pages (JSPs) on Friday - and yet in many ways, our course goes full circle. For, through Java Server Pages, you can keep the look and feel of a web site ...
|2861||MySQL and Java - connectivity past, present, and future thoughts|
MySQL has migrated from MySQL AB (1995 to 2008) to Sun (2008 to 2010) to Oracle (from 27 Jan 2010)
wizard:java graham$ /usr/local/mysql/bin/mysql -uwellho -p
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.1.48 MySQL Community ...
|2154||Bean Classes in Java and Java Database Connections|
A class is a bean if it has a constructor that takes no parameters, and if it has methods that start with "get" to read properties, and "set" to set properties. And it's a good idea (!) if the letter after the word get or set is a capital, as this will let it be used within JSP tag libraries. Bean ...
|515||MySQL - an FAQ|
We're becoming a serious MySQL resource, with many technical articles, examples, forum posts and blog entries answering those difficult-to-resolve issues you may have come across. You might like to bookmark (or link to) this page.
Eleven recent articles on MySQL ...
Flashbulb moments - facts that ...
Examples from our training material
Some modules are available for download
as a sample of our material or under an Open Training Notes License
for free download from [here]
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.
If you are looking for a complete course and not just a information on a single subject, visit our Listing and schedule
Well House Consultants specialise in training courses in
. We run
throughout the UK (and beyond for longer courses), and
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 700 books on the subjects on which we teach.
These books are available for reference at our training centre.