Home Accessibility Courses Twitter The Mouth Facebook Resources Site Map About Us Contact
For 2023 (and 2024 ...) - we are now fully retired from IT training.
We have made many, many friends over 25 years of teaching about Python, Tcl, Perl, PHP, Lua, Java, C and C++ - and MySQL, Linux and Solaris/SunOS too. Our training notes are now very much out of date, but due to upward compatability most of our examples remain operational and even relevant ad you are welcome to make us if them "as seen" and at your own risk.

Lisa and I (Graham) now live in what was our training centre in Melksham - happy to meet with former delegates here - but do check ahead before coming round. We are far from inactive - rather, enjoying the times that we are retired but still healthy enough in mind and body to be active!

I am also active in many other area and still look after a lot of web sites - you can find an index ((here))

Well House Consultants
You are on the site of Well House Consultants who provide Open Source Training Courses and business hotel accommodation. You are welcome to browse and use our resources subject to our copyright statement and to add in links from your pages to ours.
Other subject areas - resources
Java Resources
Well House Manor Resources
Perl Resources
Python Resources
PHP Resources
Object Orientation and General topics
MySQL Resources
Linux / LAMP / Tomcat Resources
Well House Consultants Resources
Extras Resources
C and C++ Resources
Ruby Resources
Tcl/Tk Resources
Web and Intranet Resources
Java module J811
JDBC - Relational Database Access
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 articles
Interfacing applications to a MySQL database engine

Articles and tips on this subjectupdated
3046Java 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 ...
2861MySQL 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 Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 Server version: 5.1.48 MySQL Community ...
2154Bean 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 ...
515MySQL - 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
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
Maggie.java   MySQL Database Connection and Query
Oralink.java   Connecting to an Oracle database
jdbc1.java   Connecting to a MySQL database
make_J850.java   Create table for J850 series of demos
Background information
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
Interfacing MySQL to Java.
Using JDBC to access other databases.
Using JDBC on the Web.
Example: Managing a table of information about a population.
Example: A more general table management Servlet.
Enhancing our examples.
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,Ruby, Lua, 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 700 books on the subjects on which we teach. These books are available for reference at our training centre.

You can Add a comment or ranking to this page

© WELL HOUSE CONSULTANTS LTD., 2024: 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
PH: 01144 1225 708225 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho

PAGE: http://www.wellho.net/resources/J811.html • PAGE BUILT: Sun Oct 11 14:50:09 2020 • BUILD SYSTEM: JelliaJamb