MySQL connection tutorials?

[SirVyvin]

Ok so I have searched google for a few days now trying to find a good tutorial and even a good example, and have turned up nothing that just shows a working example (as I learn by seeing a working example of something). I also searched the forums for something and nothing came up that really helped. Can someone give me a link to a site that has a complete working connection example, or to a post in the forums that has a working example, or post one here?

Thanks in advance.

[pbrockway2]

Trail: JDBC(TM) Database Access (The Java™ Tutorials)

[SirVyvin]

I realise it has been a bit, but been very busy with stuff because Christmas is over, finally got back around to this. I took a while trying to understand the trail provided above with no success. So I asked my cousin if he happened to know JDBC and luckily he did and gave me a site that had a great working example for people who learn by those like me.

The tutorial can be found here.

I have posted an example I use myself in case you don't wish to go to the site. Also make sure your database host allows remote connections (won't work otherwise)! You must also have the MySQL JDBC library (?) in your class path. I use Netbeans 6.9.1 so I right click on the project and choose Libraries and add it to the compile tab.

import java.sql.*;

public class HighScores {
    Connection conn = null;

    public HighScores() {
        /*constructor does nothing for my project but you can make it do something*/
    }

    public void connect() {
        try {
            String userName = "your_user";
            String password = "your_pass";
            String dbHost = "your_host" //don't put the 'http://', only put something like www.google.ca, or www.facebook.com
            String dataBase = "your_dataBase"; //database name, not the table
            String url = "jdbc:mysql://" + dbHost + "/" + dataBase;
            Class.forName("com.mysql.jdbc.Driver").newInstance();
            conn = DriverManager.getConnection(url, userName, password);
            System.out.println("Database connection established");
        } catch (Exception e) {
            System.err.println("Cannot connect to database server\n" + e.getMessage());
        }
    }

    public void close() {
        try {
            conn.close();
        } catch (Exception e) {
            System.err.println("If you see this, well, you ****ed up big time let me tell you.\n" + e.getMessage());
        }
    }
}