A claim plugin based on FTB Chunks
keii.dev
1package dev.keii.keiichunks.saveload;
2
3import dev.keii.keiichunks.DatabaseConnector;
4
5import javax.annotation.Nullable;
6import java.sql.Connection;
7import java.sql.ResultSet;
8import java.sql.SQLException;
9import java.sql.Statement;
10
11public class User {
12 public long id;
13 public String uuid;
14 public String timestamp;
15 public int claimPower;
16
17 public User(long id, String uuid, String timestamp, int claimPower)
18 {
19 this.id = id;
20 this.uuid = uuid;
21 this.timestamp = timestamp;
22 this.claimPower = claimPower;
23 }
24
25 @Nullable
26 public static String getUUIDFromID(int id)
27 {
28 try {
29 Connection connection = DatabaseConnector.getConnection();
30 Statement statement = connection.createStatement();
31
32 String sql = "SELECT * FROM user WHERE id = " + id;
33 ResultSet userResultSet = statement.executeQuery(sql);
34
35 if (!userResultSet.next()) {
36 userResultSet.close();
37 statement.close();
38 connection.close();
39 return null;
40 }
41
42 String uuid = userResultSet.getString("uuid");
43
44 userResultSet.close();
45 statement.close();
46 connection.close();
47 return uuid;
48 } catch (SQLException e) {
49 e.printStackTrace();
50 }
51
52 return null;
53 }
54
55 @Nullable
56 public static String getNicknameFromId(int id)
57 {
58 try {
59 Connection connection = DatabaseConnector.getConnection();
60 Statement statement = connection.createStatement();
61
62 String sql = "SELECT * FROM user WHERE id = " + id;
63 ResultSet userResultSet = statement.executeQuery(sql);
64
65 if (!userResultSet.next()) {
66 userResultSet.close();
67 statement.close();
68 connection.close();
69 return null;
70 }
71
72 String nickname = userResultSet.getString("nickname");
73
74 userResultSet.close();
75 statement.close();
76 connection.close();
77 return nickname;
78 } catch (SQLException e) {
79 e.printStackTrace();
80 }
81
82 return null;
83 }
84
85 @Nullable
86 public static String getNicknameFromUUID(String uuid)
87 {
88 try {
89 Connection connection = DatabaseConnector.getConnection();
90 Statement statement = connection.createStatement();
91
92 String sql = "SELECT * FROM user WHERE uuid = \"" + uuid + "\"";
93 ResultSet userResultSet = statement.executeQuery(sql);
94
95 if (!userResultSet.next()) {
96 userResultSet.close();
97 statement.close();
98 connection.close();
99 return null;
100 }
101
102 String nickname = userResultSet.getString("nickname");
103
104 userResultSet.close();
105 statement.close();
106 connection.close();
107 return nickname;
108 } catch (SQLException e) {
109 e.printStackTrace();
110 }
111
112 return null;
113 }
114}