package me.ase.CommandCheckerBlocker.DBConnect;

import java.sql.*;

public class databaseConnection {
	static private Connection connection;

	public static Connection getConnection() throws ClassNotFoundException, SQLException {
		String host = HOST";
		String user = "USERNAME";
		String db = "DATABASE";
		String pass = "PASSWORD";
		if (connection == null) {
			try {
			Class.forName("com.mysql.jdbc.Driver");
			connection = DriverManager.getConnection("jdbc:mysql://" + host + "/" + db, user, pass);
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		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);
	}

}