Java JDCB "no suitable driver found" problem

[christiandb]

Here is my code:

import java.sql.*;
public class test
{
    static Connection con;
    static Statement stmt;
    public static void main(String[] args)
    {
        insertAccount();
    }
    public static Connection getConnection()
    {
        try 
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        } 
        catch(java.lang.ClassNotFoundException e) 
        {
            System.err.print("ClassNotFoundException: ");
            System.err.println(e.getMessage());
        }
        try 
        {
            con = java.sql.DriverManager.getConnection("jdbc:mysql://localhost:3306/bank", "root", "pass");
        } 
        catch(SQLException ex) 
        {
            System.err.println("SQLException: " + ex.getMessage());
        }
        return con;
    }
    public static void insertAccount()
    {
        Connection con = getConnection();
        String newaccount = "INSERT INTO accounts VALUES (null, den Boer, 0)";
        try 
        {
            stmt = con.createStatement();
               stmt.executeUpdate(newaccount);
            stmt.close();
            con.close();
        } 
        catch(SQLException ex) 
        {
            System.err.println("SQLException: " + ex.getMessage());
        }
    System.out.println("Account created succesfully");
    }
}

But I'm getting the following error:

SQLException: No suitable driver found for jdbc:mysql://localhost:3306/bank

Does anyone know the solution for that?

 

[chojrak]

MySQL :: Found the fix!

 

[christiandb]

The import com.mysql cannot be resolved

When I try to import it -.-

 

[christiandb]

Fixed it, had to add the jar file to my libraries and had to change:

            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

to:

            Class.forName("com.mysql.jdbc.Driver");