package MySQL;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;



public class MySQL {

	public static String host = "mysql.mc-host24.de";
	public static String database = "coins";
	public static String username = "db_111737";
	public static String password = "4660f7b65e";
	public static Connection con;

	public static void connect() {
		if(!isConnected()) {
			try {
				con = DriverManager.getConnection("jdbc:mysql://" + host + ":3306/" + database, username, password);
				System.out.println(main.main.prefix + "§c MySQl§7 verbunden.");
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}

	}

	public static void disconnect() {
		if(isConnected()) {
			try {
				con.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			System.out.println(main.main.prefix + "§c MySQl§7 getrennt.");
		}
	}

	public static boolean isConnected(){
		return (con != null);
	}
	public static void createTable() {
		try {
			PreparedStatement st = con.prepareStatement("CREATE TABLE IF NOT EXISTS coinsTable (UUID VARCHAR(100), coins INT(16))");
			st.executeUpdate();


		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

}