4vuUAX67

1package com.lobbysystem.mysql;
2
3import java.sql.PreparedStatement;
4import java.sql.ResultSet;
5import java.sql.SQLException;
6import java.util.UUID;
7
8import com.lobbysystem.groups.EnumGroup;
9
10public class MySQLGroupManager {
11
12	/* Created by: Suders
13	 * Date: 15.12.2017
14	 * Time: 19:42:37
15	 * Location: BungeeBanSystem 
16	*/
17	
18	//double sw = (played == 0 && wins == 0 ? 0.0 : Math.ceil(wins*100/played));
19
20	private String table = "Groups";
21	
22	public void createTable() {
23		String sql = "CREATE TABLE IF NOT EXISTS " + table + "(UUID varchar(64), Rang varchar(64));";
24		try {
25			PreparedStatement stmt = MySQLConnection.connection.prepareStatement(sql);
26			stmt.executeUpdate();
27		} catch (SQLException e) {}
28	}
29	
30	public boolean existsPlayer(UUID uuid) {
31		try {
32			ResultSet rs = MySQLConnection.query("SELECT * FROM " + table + " WHERE UUID= '" + uuid + "'");
33			if(rs.next()) {
34				return rs.getString("UUID") != null;
35			}
36			return false;
37		} catch (SQLException e) {
38			e.printStackTrace();
39		}
40		return false;
41	}
42	
43	public void createPlayer(UUID uuid) {
44		if(!existsPlayer(uuid)) {
45			MySQLConnection.update("INSERT INTO " + table + "(UUID, Rang) VALUES ('" + uuid + "', 'SPIELER');");
46		}
47	}
48	
49	public EnumGroup getGroup(UUID uuid) {
50		String i = "SPIELER";
51		if(existsPlayer(uuid)) {
52			try {
53				ResultSet rs = MySQLConnection.query("SELECT * FROM " + table + " WHERE UUID= '" + uuid + "'");
54//				if((!rs.next()) || (rs.getString("Rang") == null));
55				
56				i = rs.getString("Rang");
57			} catch (Exception e) {
58				e.printStackTrace();
59			}
60		}
61		return EnumGroup.valueOf(i);
62	}
63	
64	public void setGroup(UUID uuid, String rang) {
65		MySQLConnection.update("UPDATE " + table + " SET Rang='" + rang + "' WHERE UUID='" + uuid + "'");
66	}
67}