public class MySQL {


	public static String username;
	public static String password;
	public static String database;
	public static String host;
	public static String port;
	public static Connection con;



	public static void connect() {

		if(!isConnected()) {
			try {
				con = DriverManager.getConnection("jdbc:mysql://"+ host + ":3306/" + database, username, password);
			} catch (SQLException e) {
				e.printStackTrace();
				System.out.println("[FEHLER]: " + e.getMessage());
			}
		}
	}

    public static void close() {
		if(isConnected()) {
			try {
				con.close();
				Bukkit.getConsoleSender().sendMessage(Main.getInstance().prefix+"MySQL Verbindung verloren oder unterbrochen!");
			} catch (SQLException e) {
				e.printStackTrace();
				System.out.println("[FEHLER]: " + e.getMessage());
			}

		}
	}

    public static boolean isConnected() {
    	return con != null;
    }


    public static void createTable() {
    	/*
    	 *
    	 * Syntax: Spielername, UUID, Ende, Grund
    	 *
    	 */
    	if(isConnected()) {
    		try {
				con.createStatement().executeUpdate("CREATE TABLE IF NOT EXISTS BannedPlayers(Spielername VARCHAR(100), UUID VARCHAR(100), Ende VARCHAR(100), Grund VARCHAR(100))");
			} catch (SQLException e) {
				e.printStackTrace();
				System.out.println("[FEHLER]: " + e.getMessage());
			}
    	}
    }


    public static void update(String qry) {
    	if(isConnected()) {
    		try {
				con.createStatement().executeUpdate(qry);
			} catch (SQLException e) {
				e.printStackTrace();
				System.out.println("[FEHLER]: " + e.getMessage());
			}
    	}
    }

    public static ResultSet getResult(String qry) {
    	if(isConnected()) {
    		try {
				return con.createStatement().executeQuery(qry);
			} catch (SQLException e) {
				e.printStackTrace();
				System.out.println("[FEHLER]: " + e.getMessage());
			}
    	}
    	return null;
    }
}