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 = (Connection) DriverManager.getConnection("jdbc:mysql://" + host + ":"+ port + "/" + database, username, password);
				Bukkit.getConsoleSender().sendMessage(Main.getInstance().prefix + "MySQL Verbindung aufgebaut!");
			} catch (SQLException e) {
				e.printStackTrace();
			}

		}

	}

	public static void close() {

		if(isConnected()) {
			try {
				con.close();
				Bukkit.getConsoleSender().sendMessage(Main.getInstance().prefix + "MySQL Verbindung geschlossen!");
			} catch (SQLException e) {

				e.printStackTrace();
			}

		}

	}

	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 MoneySystem (Spielername VARCHAR(100), UUID VARCHAR(100), Money DOUBLE)");
			} catch (SQLException e) {
				e.printStackTrace();
			}

		}
	}

	public static void update(String qry) {

		if(isConnected()) {


			try {
				con.createStatement().executeUpdate(qry);
			} catch (SQLException e) {
				e.printStackTrace();
			}

		}

	}

	public static ResultSet getResult(String qry) {

		if(isConnected()) {

			try {
				return con.createStatement().executeQuery(qry);
			} catch (SQLException e) {
				e.printStackTrace();
			}

		}
		return null;

	}