Thread: connect to mysql database

I'm using the following code to try to establish a connection with my database, I get "Cannot connect to database server" when I run it.

When I debug, I get this list of error but it doesn't effect the build

debug:
Have no file for /usr/lib/jvm/java-6-openjdk/jre/lib/netx.jar
Have no file for /usr/lib/jvm/java-6-openjdk/jre/lib/plugin.jar
Have no file for /usr/lib/jvm/java-6-openjdk/jre/lib/modules/jdk.boot.jar
Called the mysqlconn method!
Cannot connect to database server
BUILD SUCCESSFUL (total time: 0 seconds)

 
import java.sql.*;
 
public class Main {
 
    public static void main(String[] args) {
        mysqlconn();
    }
public static void mysqlconn(){
        System.out.println("Called the mysqlconn method!");
        Connection conn = null;
 
           try
           {
               String userName = "root";
               String password = "password";
               String url = "jdbc:mysql://localhost:3306/test";
               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");
           }
           finally
           {
               if (conn != null)
               {
                   try
                   {
                       conn.close ();
                       System.out.println ("Database connection terminated");
                   }
                   catch (Exception e) { /* ignore close errors */ }
               }
           }
}
 
}

I've changed my code to this, which it doesn't seem to like all that much, it says "throwable print stack should be removed"

catch (Exception e)
           {
               e.printStackTrace();
           }

I ran the code again and got this exception;

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

I'm using netbeans 6.9

tools>library

then I created a new library called mysql and added;

/usr/share/java/mysql-connector-java-5.1.10.jar &
/usr/share/java/mysql-connector-java.jar

still the same deal

What a mission I made that,

In the left hand panel there is the libraries folder, I downloaded mysql-connector-java-5.1.18-bin.jar are save it to disk. The right clicked the libraries folder and select 'Add Jar/folder' and then find the mysql-connector-java-5.1.18-bin.jar and added it.

first I tried doing a similar thing in tools>libraries but this didn't seem to work

Anyway it's working now, what a complete pain, I just wanted to program!