Archief - [PROG][JAVA] Probleem met Mysql/Java

import java.sql.*; 

public class JBDCSample { 

 public static void main (java.lang.String[] args) { 
   try { 
     // This is where we load the driver 

             //instancieer de mysql connector en connect naar de db over tcp/ip
            Class.forName("com.mysql.jdbc.Driver");
  } 
   catch (ClassNotFoundException e) { 
     System.out.println("Unable to load Driver Class"); 
     return; 
   } 

   try { 
     // All database access is within a try/catch block. Connect to database, 
     // specifying particular database, username, and password 
    // Connection con = DriverManager.getConnection("jdbc:odbc:odbcNaam", "user", "wachtwoord"); 
           Connection con = DriverManager.getConnection("jdbc:mysql://192.168.0.2","javauser","javauser"); 
     // Create and execute an SQL Statement 
     Statement stmt = con.createStatement(); 
     ResultSet rs = stmt.executeQuery("SELECT * FROM Players"); 

     // Display the SQL Results 
     while(rs.next()) { 
       System.out.println(rs.getString("Name")); 
     } 

     // Make sure our database resources are released 
     rs.close(  ); 
     stmt.close(  ); 
     con.close(  ); 

     } 
     catch (SQLException se) { 
       // Inform user of any SQL errors 
       System.out.println("SQL Exception: " + se.getMessage(  )); 
       se.printStackTrace(System.out); 
      } 
    } 
}

C:\>set CLASSPATH
classpath=C:\Java\; C:\Java\mysqlconnector.jar;