private static final String url = "jdbc:mysql://127.0.0.1:3306/mybd?autoReconnect=true&useSSL=false";
private static final String user = "root";
private static final String password = "welcome";

private static Connection con;

public static void connecttodb() {

        // opening database connection to MySQL server
        con = DriverManager.getConnection(url, user, password);

}