dN0UgpXa

1package de.mathematischer.utils;
2
3import java.sql.Connection;
4import java.sql.DriverManager;
5import java.sql.SQLException;
6
7public class MySQL {
8
9	public static Connection connection;
10
11	public static void connect() {
12		if (!isConnected()) {
13			try {
14				connection = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/waterfight?autoReconnect=true",
15						"root", "");
16				System.out.println("MySQL verbunden");
17			} catch (SQLException e) {
18				e.printStackTrace();
19			}
20		}
21
22	}
23
24	public static void disconnect() {
25		if (isConnected()) {
26			try {
27				connection.close();
28			} catch (SQLException e) {
29				e.printStackTrace();
30			}
31			System.out.println("MySQL getrennt");
32		}
33
34	}
35
36	public static boolean isConnected() {
37		return (connection != null);
38	}
39
40	public static void createTable() {
41		try {
42			connection.prepareStatement(
43					"CREATE TABLE IF NOT EXISTS userdaten (UUID VARCHAR(100), slot0 INT(16), slot1 INT(16), slot2 INT(16), slot3 INT(16), slot4 INT(16), slot5 INT(16), slot6 INT(16), slot7 INT(16), slot8 INT(16))")
44					.executeUpdate();
45		} catch (SQLException e) {
46
47			e.printStackTrace();
48		}
49	}
50
51}
52