fGTsyS1K

1package de.kasiux.gungame.mysql;
2
3import java.sql.Connection;
4import java.sql.DriverManager;
5import java.sql.SQLException;
6
7import org.bukkit.Bukkit;
8
9public class MySQL {
10
11	private static String host = "localhost";
12	private static String port = "3306";
13	private static String database = "gungame";
14	private static String username = "root";
15	private static String password = "";
16	private static Connection con;
17
18	public static void connect() {
19		if (!(isConnected())) {
20			try {
21				con = (Connection) DriverManager.getConnection("jdbc:mysql://" + host + ":" + port + "/" + database,
22						username, password);
23				Bukkit.getConsoleSender().sendMessage("§aGunGame: MySQL aktiv");
24			} catch (SQLException e) {
25				Bukkit.shutdown();
26			}
27		}
28	}
29
30	public static void disconnect() {
31		if (isConnected()) {
32			try {
33				con.close();
34				Bukkit.getConsoleSender().sendMessage("§aGunGame: MySQL abgebrochen");
35			} catch (SQLException e) {
36
37			}
38		}
39	}
40
41	private static boolean isConnected() {
42		return con != null;
43	}
44
45	public static Connection getConnection() {
46		return con;
47	}
48
49	public static void prepareMySQL() {
50		try {
51			connect();
52			getConnection()
53					.prepareStatement(
54							"CREATE TABLE IF NOT EXISTS gungame (UUID VARCHAR(40), PlayerName VARCHAR(20), Kills INT(100), Deaths INT(100), Coins INT(100))")
55					.execute();
56		} catch (SQLException e) {
57			Bukkit.shutdown();
58		}
59	}
60}