import java.sql.Statement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;

public class Connect {
    Connection conn = null;
    private final String userName;
    private final String password;
    private final String url;

    public Connect() {
        userName = "root";
        password = "mypassword";
        url = "jdbc://mysql://localhost:3307/minecraft_server";
        try {
            Class.forName("com.mysql.jdbc.Driver").newInstance();
            conn = DriverManager.getConnection(url, userName, password);
            System.out.println("[Connect] Database connection established");
        } catch (Exception e) {
            System.err.println("[Connect] Cannot connect to databse server");
        } finally {
            if (conn != null) {
                try {
                    conn.close();
                    System.out.println("[Connect] Database connection terminated");
                } catch (Exception e) {
                }
            }
        }
    }

    public ResultSet runQuery(String SQL) {
        ResultSet retSet = null;

        try {
            Statement s = conn.createStatement();
            s.executeQuery(SQL);
            retSet = s.getResultSet();
        } catch (Exception e) {
            System.err.println("[Connect] Failed to execute query");
        }

        return (retSet);
    }
}