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

---

The MySQL Relational database - training course - Structure, Installation, Administration, Database Design and Programming through SQL The MySQL Relational database - Structure, Installation, Administration, Database Design and Programming through SQL This course introduces you to the ... http://www.wellho.net/course/mqfull.html  [course]

Deploying Java applications on Linux and Unix - training course - Learn to install and support applications under Linux/Unix with Apache, Tomcat and MySQL Deploying Java applications on Linux and Unix - Learn to install and support applications under Linux/Unix with Apache, Tomcat and MySQL This course is ... http://www.wellho.net/course/ajfull.html  [course]

Java Programming for the Web - training course - Learn to write server- or client-side applications in Java. Java Programming for the Web - Learn to write server- or client-side applications in Java. This course introduces you to the Java programming language, ... http://www.wellho.net/course/jpfull.html  [course]

Java Extra - training course - Subjects not covered on regular public courses! Java Extra - Subjects not covered on regular public courses! Individual Java users will need different advanced topics depending on their application. ... http://www.wellho.net/course/jxfull.html  [course]

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 ... http://www.wellho.net/mouth/515_MySQL-an-FAQ.html  [short article]

Class to perform a MySQL table insert public class J850_jdbc { public static String insert(String name, String group, String born) { java.sql.Connection conn = linktodata(); ... http://www.wellho.net/resources/ex.php4?item=j811/J850_jdbc.java  [code sample]

Connecting to a MySQL database public class jdbc1 { public static void main(String [] args) { java.sql.Connection conn = null; System.out.println("SQL Test"); ... http://www.wellho.net/resources/ex.php4?item=j811/jdbc1.java  [code sample]

---

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

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