How to link java in intelliJ to MYSQL databases

I realized that I haven't actually installed the JDBC driver or Connector/J. I think that is why it isn't working. I get this error: java.sql.SQLException: No suitable driver found for jdbc:mysql://localhos:3306/pops at java.sql.DriverManager.getConnection(DriverManager.java:689) at java.sql.DriverManager.getConnection(DriverManager.java:247) at com.pops101.Main.main(Main.java:19) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at com.intellij.rt.execution.application.AppMain.main(AppMain.java:144)

I am struggling with the Connector/J installation. Do I have to alter my class path? I can't seem to find a simple tutorial on how to do this.

This is the code I had:

package com.pops101;

import java.sql.SQLException; import java.sql.*;

public class Main { private static String username = "root"; private static String password = "indigoblueMYSQL01"; private static String connectionString = "jdbc:mysql://localhos:3306/pops"; private static Connection connection; private static Statement command; private static ResultSet data;

public static void main(String[] args)
{
    try
    {
        connection = DriverManager.getConnection(connectionString, username, password);
        command = connection.createStatement();
        command.execute("INSERT INTO details VALUES ('Shan','FERG')");
    }
    catch(SQLException sqle)
    {
        sqle.printStackTrace();
    }
}

}

Are you using Hibernate (with Spring)? (The course is out in February, it looks like.) It connects Java and SQL through Java Annotations.

Thanks Lukas. That course is exactly the kind of thing I need. I will look out for it.