· 9 years ago · Feb 03, 2017, 09:20 PM
1
2package skywars.kenny.db;
3
4import com.mysql.jdbc.PreparedStatement;
5
6import java.sql.DriverManager;
7import java.sql.ResultSet;
8import java.sql.SQLException;
9import java.util.UUID;
10
11/**
12 * @author PrinzKenny1 on 30.06.2016 at 17:33:17
13 * <p>
14 * Nexus Team
15 * <p>
16 * Copyright by Calvin Mende
17 */
18public class db {
19
20 static final String tablegame = dbmain2.database;
21 static String tablekits = "nick";
22
23 //////////////////////////////////////////////
24 ////// CREATE USER TO MAKE IT EASIER//////
25 //////////////////////////////////////////////
26
27 public static void createUser(UUID uuid, String name, String nick) {
28 try {
29 PreparedStatement ps = (PreparedStatement) dbmain2.getConnection().prepareStatement("INSERT INTO `"
30 + tablegame + "` (`uuid`, `name`, `nick`) VALUES (?,?,?) ON DUPLICATE KEY UPDATE uuid=?");
31 ps.setString(1, uuid.toString());
32 ps.setString(2, name);
33 ps.setString(3, nick);
34 ps.setString(4, uuid.toString());
35 ps.executeUpdate();
36 } catch (SQLException e) {
37 e.printStackTrace();
38 }
39 }
40
41 /////////////////////////////////////
42 //////// IS EXIST ABFRAGE//////////
43 /////////////////////////////////////
44
45 public static boolean isUserExists(UUID uuid) {
46 try {
47 PreparedStatement ps;
48 if (!dbmain2.isConnected()) {
49 dbmain2.connect();
50 }
51 ps = (PreparedStatement) dbmain2.getConnection()
52 .prepareStatement("SELECT * FROM " + tablegame + " WHERE UUID = ?");
53 ps.setString(1, uuid.toString());
54 ResultSet rs = ps.executeQuery();
55 return rs.first();
56 } catch (SQLException e) {
57 try {
58 dbmain2.con = DriverManager.getConnection("jdbc:mysql://" + dbmain2.host + ":" + dbmain2.port + "/"
59 + dbmain2.database + "?autoReconnect=true", dbmain2.username, dbmain2.password);
60 PreparedStatement ps;
61 if (!dbmain2.isConnected()) {
62 dbmain2.connect();
63 }
64 ps = (PreparedStatement) dbmain2.getConnection()
65 .prepareStatement("SELECT * FROM " + tablegame + " WHERE UUID = ?");
66 ps.setString(1, uuid.toString());
67 ResultSet rs = ps.executeQuery();
68 return rs.first();
69 } catch (SQLException e1) {
70 e1.printStackTrace();
71 }
72 }
73 return false;
74 }
75
76 /////////////////////////////////////
77 //////// IF DB EXIST ABFRAGE///////
78 /////////////////////////////////////
79
80 public static void isTabelexist() {
81 PreparedStatement ps;
82 try {
83 if (!dbmain2.isConnected()) {
84 dbmain2.con = DriverManager.getConnection(
85 "jdbc:mysql://" + dbmain2.host + ":" + dbmain2.port + "?autoReconnect=true", dbmain2.username,
86 dbmain2.password);
87 ps = (PreparedStatement) dbmain2.getConnection()
88 .prepareStatement("CREATE DATABASE IF NOT EXISTS " + dbmain2.database);
89 ps.executeUpdate();
90 ps = (PreparedStatement) dbmain2.getConnection().prepareStatement("USE " + dbmain2.database);
91 ps.executeUpdate();
92 ps = (PreparedStatement) dbmain2.getConnection().prepareStatement("CREATE TABLE IF NOT EXISTS `"
93 + tablegame + "` (`UUID` VARCHAR(100), `name` VARCHAR(100), `nick` VARCHAR(100))");
94 ps.executeUpdate();
95 ps.executeUpdate();
96 dbmain2.con.close();
97 dbmain2.con = null;
98 dbmain2.connect();
99 }
100 } catch (SQLException e) {
101 e.printStackTrace();
102 }
103 }
104
105 ////////////////////////////////////////////////////////
106 ////////////////////// METHODEN /////////////////////
107 ////////////////////////////////////////////////////////
108
109 //////////////////////////////////////////
110 ////////// NICK////////////////////////
111 //////////////////////////////////////
112
113 public static void SETNick(UUID uuid, String name, String nick) {
114 if (isUserExists(uuid)) {
115 try {
116 PreparedStatement ps = (PreparedStatement) dbmain2.getConnection()
117 .prepareStatement("UPDATE " + dbmain2.database + " SET nick = ? WHERE UUID = ?");
118 ps.setString(2, uuid.toString());
119 ps.setString(1, nick);
120 ps.executeUpdate();
121 } catch (SQLException e) {
122 e.printStackTrace();
123 }
124 } else {
125 createUser(uuid, name, nick);
126 }
127 }
128
129 public static String GETNick(UUID uuid, String name) {
130 if (isUserExists(uuid)) {
131 try {
132 PreparedStatement ps = (PreparedStatement) dbmain2.getConnection()
133 .prepareStatement("SELECT nick FROM " + dbmain2.database + " WHERE UUID = ?");
134 ps.setString(1, uuid.toString());
135 ResultSet rs = ps.executeQuery();
136 while (rs.next()) {
137 return rs.getString("nick");
138 }
139 } catch (SQLException e) {
140 e.printStackTrace();
141 }
142 } else {
143 createUser(uuid, name, name);
144 }
145 return null;
146 }
147
148 public static void SETName(UUID uuid, String name, String nick) {
149 if (isUserExists(uuid)) {
150 try {
151 PreparedStatement ps = (PreparedStatement) dbmain2.getConnection()
152 .prepareStatement("UPDATE " + dbmain2.database + " SET name = ? WHERE UUID = ?");
153 ps.setString(2, uuid.toString());
154 ps.setString(1, nick);
155 ps.executeUpdate();
156 } catch (SQLException e) {
157 e.printStackTrace();
158 }
159 } else {
160 createUser(uuid, name, nick);
161 }
162 }
163
164 public static String GETName(UUID uuid, String name) {
165 if (isUserExists(uuid)) {
166 try {
167 PreparedStatement ps = (PreparedStatement) dbmain2.getConnection()
168 .prepareStatement("SELECT name FROM " + dbmain2.database + " WHERE UUID = ?");
169 ps.setString(1, uuid.toString());
170 ResultSet rs = ps.executeQuery();
171 while (rs.next()) {
172 return rs.getString("name");
173 }
174 } catch (SQLException e) {
175 e.printStackTrace();
176 }
177 } else {
178 createUser(uuid, name, name);
179 }
180 return null;
181 }
182
183}