MySQLConnection.java

package main.util;

import java.sql.Connection;
import java.sql.DriverManager;

public class MySQLConnection {
    // JDBC driver name and database URL
    static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
    static final String DB_OJOL_URL = "jdbc:mysql://localhost:3306/db_ojol?useSSL=false";

    //  Database credentials
    static final String USER = "root";
    static final String PASS = "iqbal";

    static Connection connection = null;


    public static Connection getOjolConnection() {
        try {
            Class.forName(JDBC_DRIVER).newInstance();
            connection = DriverManager.getConnection(DB_OJOL_URL, USER, PASS);
            return connection;
        } catch (Exception e) {
            System.out.println("Ojol DB Error: " + e.getMessage());
            e.printStackTrace();
        }
        return null;
    }
}