/*

This is a current (2010) example in which I have replaced
        Class.forName("org.gjt.mm.mysql.Driver").newInstance();
by
        Class.forName("com.mysql.jdbc.Driver").newInstance();

The server name remains hardwired so that you can see it all in one easy
example, but in practise you would read that from some sort of config
file or from a server setting resource if this was a web server app
runing under Tomcat.

This example uses our image library database ... without a copy of that
database, it won't run, but it coud easily be altered to use your own
database. I have also changed the password, even though our databases
can only be connected to locally from the webservers so it shouldn't be
a problem!

*/

public class Maggie {

public static void main(String [] args) {

        java.sql.Connection conn = null;
        System.out.println("SQL Test");

        try {
                Class.forName("com.mysql.jdbc.Driver").newInstance();
                conn = java.sql.DriverManager.getConnection(
                        "jdbc:mysql://localhost/wellho?user=wellho&password=Summat");

        }
        catch (Exception e) {
                System.out.println(e);
                System.exit(0);
                }

        System.out.println("Connection established");

        try {
                java.sql.Statement s = conn.createStatement();
                java.sql.ResultSet r = s.executeQuery
                        ("SELECT filename, descriptor FROM im_library " +
                                "ORDER BY filename DESC");
                while(r.next()) {
                        System.out.println (
                                r.getString("filename") + " " +
                                r.getString("descriptor") );
                        }
        }
        catch (Exception e) {
                System.out.println(e);
                System.exit(0);
                }
        }
}

/*

---> If you run this without the driver class file on the CLASSPATH, you get:

wizard:java graham$ java Maggie
SQL Test
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
wizard:java graham$

---> If you then run it without the database daemon running, you'll get:

wizard:java graham$ export CLASSPATH=.:mysql-connector-java-5.1.13-bin.jar
wizard:java graham$ java Maggie
SQL Test
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago.
The driver has not received any packets from the server.
wizard:java graham$

---> Starting the daemon locally (on my mac, basic form ...)

wizard:mysql graham$ cd /usr/local/mysql
wizard:mysql graham$ sudo support-files/mysql.server start
Password:
Starting MySQL
. SUCCESS!
wizard:mysql graham$

---> And running the code with everything in place
---> including a big database table ;-) for the query

wizard:java graham$ java Maggie
SQL Test
Connection established
zoomthrough.jpg HS125 zooms through Melksham
zoomed_out.jpg What it really is
zoomed_in.jpg What the dog converts it to
zoom2.jpg We want a train to stop - not zoom through
zone_wide.jpg New Carrollton
zone_narrow.jpg Weymouth
zed08.jpg Wylye Valley, Wiltshire
z403.jpg Public Domain (Free) Zebra picture
z.jpg Pedestrian and cyclist lights
ystradv.jpg Old Railway viaduct, Ystrad Mynach
ysf.jpg Course delegate, Dharhan
ysert.jpg North Eastern railway former HQ, York
[etc]

*/