· 9 years ago · Nov 23, 2016, 01:50 PM
1public boolean playerExists(String uuid) {
2 try {
3 ResultSet rs = query("SELECT * FROM PlayerFiles WHERE UUID='" + uuid + "'");
4 if (rs.next()) {
5 return rs.getString("UUID") != null;
6 }
7 return false;
8 } catch (SQLException e) {
9 e.printStackTrace();
10 }
11
12 return false;
13 }
14
15
16public void createTable() {
17 try {
18 con.createStatement().executeUpdate(
19 "CREATE TABLE IF NOT EXISTS PlayerFiles(UUID VARCHAR(50), Quests VARCHAR(5), Guthaben VARCHAR(7), Level VARCHAR(3), EXP VARCHAR(10), TA VARCHAR(3), PvPWins VARCHAR(4), WAW VARCHAR(4), MAW VARCHAR(4))");
20 } catch (SQLException e) {
21 e.printStackTrace();
22 }
23 }
24
25
26public ResultSet query(String qry) {
27 ResultSet rs = null;
28
29 try {
30 Statement st = con.createStatement();
31 st.executeQuery(qry);
32 } catch (SQLException ex) {
33 connect();
34 ex.printStackTrace();
35 }
36
37 return rs;
38 }