package me.ase.CommandCheckerBlocker.DBConnect;

import java.sql.*;

public class DatabaseConnection {
    static private Connection connection;

    public static Connection getConnection() throws Exception {
        String host = "HOST";
        String user = "USERNAME";
        String db = "DB";
        String pass = "PASSWORD";
        if (connection == null) {
            Class.forName("com.mysql.jdbc.Driver");
            connection = DriverManager.getConnection("jdbc:mysql://" + host + "/" + db, user, pass);
        }
        return connection;

    }

    public static void setData(String string) throws Exception {
        DatabaseConnection.getConnection().createStatement().executeUpdate(string);
    }

    public static ResultSet getData(String string) throws Exception {
        return DatabaseConnection.getConnection().createStatement().executeQuery(string);
    }

}