connection Java/MySQL

[user78]

Hi all, I'm writing my first java program on Ubuntu system.
I installed on Ubuntu system the libmysql-java package, I writed my program and then I compiled it, but I have the following message in running it:

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
	at java.net.URLClassLoader$1.run(URLClassLoader.java:217)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.net.URLClassLoader.findClass(URLClassLoader.java:205)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:321)
	at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:294)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:266)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Class.java:186)
	at Primo.main(Primo.java:9)

My program is the following:

import java.sql.*;

class Primo {

  public static void main(String[] args) {
    try {
      Class.forName("com.mysql.jdbc.Driver");
      Connection conn = DriverManager.getConnection("dbname", "root", "mypasswd");
      Statement cmd = conn.createStatement();
      String query = "SELECT * from mytable;";
      ResultSet res = cmd.executeQuery(query);
      while (res.next()) {
        System.out.println(res.getString("Codice"));
      }
    }
    catch (ClassNotFoundException e) {
      e.printStackTrace();
    }
    catch (SQLException e) {
      e.printStackTrace();
    }
  }

}

[eRaaaa]

You need the MySQL JDBC Driver (in classpath) first
MySQL :: Download Connector/J