ConnectionManager.java

package example;

import com.mysql.jdbc.Driver;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.Properties;

public class ConnectionManager {

    static Connection con;
    static String url;

    public static Connection getConnection() {
        // work
//        url = "jdbc:mysql://127.0.0.1:3306/mydb?user=root&password=1234";
        url = "jdbc:mysql://127.0.0.1:3306/mydb";
       //home
//        url = "jdbc:mysql://127.0.0.1:3306/mydb?user=user&password=1234";
//        url = "jdbc:mysql://127.0.0.1:3306/mydb";
        try {

//            try {
//                Class.forName("com.mysql.jdbc.Driver");
//            } catch (ClassNotFoundException e) {
//                System.out.println("\nDriver not found....\n");
//                e.printStackTrace();
//            }

            Driver dr = new com.mysql.jdbc.Driver();
            Properties properties = new Properties();
            properties.put("user","root");
//            properties.put("user","user");
            properties.put("password","1234");

            con = dr. connect(url,properties);

//            con = DriverManager.getConnection(url);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return con;
    }
}