· 8 years ago · Aug 08, 2018, 09:20 PM
1package Mysql;
2
3import java.sql.Connection;
4import java.sql.DriverManager;
5import java.sql.PreparedStatement;
6import java.sql.ResultSet;
7import java.sql.SQLException;
8import java.util.HashMap;
9
10import org.bukkit.Bukkit;
11import org.bukkit.command.ConsoleCommandSender;
12import org.bukkit.entity.Player;
13
14import Main.Main;
15
16public class Loja {
17
18 public static Connection con = null;
19 public static ConsoleCommandSender console = (ConsoleCommandSender) Bukkit.getConsoleSender();
20
21 public static void open() {
22 String url = "jdbc:mysql://localhost:3306/Servidor";
23 String user = "root";
24 String password = "dynastysempre1";
25
26 try {
27 con = DriverManager.getConnection(url, user, password);
28 console.sendMessage("Mysql aberto! ");
29 } catch (SQLException e) {
30 console.sendMessage("Mysql não foi aberta");
31 Main.plugin.getPluginLoader().disablePlugin(Main.getInstance());
32 }
33 }
34
35 public static void close() {
36 if (con != null) {
37 try {
38 con.close();
39 console.sendMessage("Mysql foi desativado");
40 } catch (SQLException e) {
41 console.sendMessage("Mysql Não foi possivel fechar a conexão!");
42 }
43 }
44 }
45
46 public static void createTabela() {
47 if (con != null) {
48 PreparedStatement stm = null;
49 try {
50 stm = con.prepareStatement(
51 "CREATE TABLE IF NOT EXISTS `Loja` (`id` INT NOT NULL AUTO_INCREMENT,`player` VARCHAR(24),`guerreiro` int,`paladino` int,`teleporter` int,`scout` int,`arqueiro` int,`knock` int,`kratos` int,PRIMARY KEY (`id`));");
52 stm.executeUpdate();
53 console.sendMessage("Mysql tabela create con sucesso!");
54 } catch (SQLException e) {
55 console.sendMessage("Mysql tabela nao foi carregada");
56 }
57 }
58 }
59
60 // ----------------- UTILS --------------------
61
62 public static boolean contains(String player) {
63 PreparedStatement stm = null;
64 try {
65 stm = con.prepareStatement("SELECT * FROM `Loja` WHERE `player` = ?");
66 stm.setString(1, player.toLowerCase());
67 ResultSet rs = stm.executeQuery();
68 while (rs.next()) {
69 return true;
70 }
71 return false;
72 } catch (SQLException e) {
73 return false;
74 }
75 }
76
77 public static void setPlayer(String p) {
78
79 PreparedStatement stm = null;
80
81 try {
82 stm = con.prepareStatement("INSERT INTO `Loja`(`player`, `guerreiro`, `paladino`, `teleporter`, `scout`, `arqueiro`, `knock`, `kratos`) VALUES (?,?,?,?,?,?,?,?)");
83 stm.setString(1, p.toLowerCase());
84 stm.setDouble(2, 0);
85 stm.setDouble(3, 0);
86 stm.setDouble(4, 0);
87 stm.setDouble(5, 0);
88 stm.setDouble(6, 0);
89 stm.setDouble(7, 0);
90 stm.setDouble(8, 0);
91 stm.executeUpdate();
92 } catch (SQLException e) {
93 console.sendMessage("Não foi possivel inserir o player: " + p + " no banco de dados!");
94 }
95
96 }
97
98 public static int getGuerreiro(String player){
99 if (contains(player)){
100 PreparedStatement stm = null;
101 try {
102 stm = con.prepareStatement("SELECT * FROM `Loja` WHERE `player` = ?");
103 stm.setString(1, player.toLowerCase());
104 ResultSet rs = stm.executeQuery();
105 while (rs.next()) {
106 return rs.getInt("guerreiro");
107 }
108 return getGuerreiro(player);
109 } catch (SQLException e) {
110 return getGuerreiro(player);
111 }
112 } else {
113 setPlayer(player);
114 return getGuerreiro(player);
115 }
116 }
117
118 public static void setGuerreiro(String player, int s){
119 if (contains(player)){
120 PreparedStatement stm = null;
121 try {
122 stm = con.prepareStatement("UPDATE `Loja` SET `guerreiro` = ? WHERE `player` = ?");
123 stm.setInt(1, s);
124 stm.setString(2, player.toLowerCase());
125 stm.executeUpdate();
126 } catch (SQLException e) {
127 console.sendMessage("Não foi possivel setar o kit guerreiro do jogador: " + player);
128 }
129 } else {
130 setPlayer(player);
131 }
132 }
133 public static int getArqueiro(String player){
134 if (contains(player)){
135 PreparedStatement stm = null;
136 try {
137 stm = con.prepareStatement("SELECT * FROM `Loja` WHERE `player` = ?");
138 stm.setString(1, player.toLowerCase());
139 ResultSet rs = stm.executeQuery();
140 while (rs.next()) {
141 return rs.getInt("arqueiro");
142 }
143 return getArqueiro(player);
144 } catch (SQLException e) {
145 return getArqueiro(player);
146 }
147 } else {
148 setPlayer(player);
149 return getArqueiro(player);
150 }
151 }
152
153 public static void setArqueiro(String player, int s){
154 if (contains(player)){
155 PreparedStatement stm = null;
156 try {
157 stm = con.prepareStatement("UPDATE `Loja` SET `arqueiro` = ? WHERE `player` = ?");
158 stm.setInt(1, s);
159 stm.setString(2, player.toLowerCase());
160 stm.executeUpdate();
161 } catch (SQLException e) {
162 console.sendMessage("Não foi possivel setar o kit arqueiro do jogador: " + player);
163 }
164 } else {
165 setPlayer(player);
166 }
167 }
168
169 public static int getPaladino(String player){
170 if (contains(player)){
171 PreparedStatement stm = null;
172 try {
173 stm = con.prepareStatement("SELECT * FROM `Loja` WHERE `player` = ?");
174 stm.setString(1, player.toLowerCase());
175 ResultSet rs = stm.executeQuery();
176 while (rs.next()) {
177 return rs.getInt("paladino");
178 }
179 return getPaladino(player);
180 } catch (SQLException e) {
181 return getPaladino(player);
182 }
183 } else {
184 setPlayer(player);
185 return getPaladino(player);
186 }
187 }
188
189 public static void setPaladino(String player, int s){
190 if (contains(player)){
191 PreparedStatement stm = null;
192 try {
193 stm = con.prepareStatement("UPDATE `Loja` SET `paladino` = ? WHERE `player` = ?");
194 stm.setInt(1, s);
195 stm.setString(2, player.toLowerCase());
196 stm.executeUpdate();
197 } catch (SQLException e) {
198 console.sendMessage("Não foi possivel setar o kit paladino do jogador: " + player);
199 }
200 } else {
201 setPlayer(player);
202 }
203 }
204
205 public static int getTeleporter(String player){
206 if (contains(player)){
207 PreparedStatement stm = null;
208 try {
209 stm = con.prepareStatement("SELECT * FROM `Loja` WHERE `player` = ?");
210 stm.setString(1, player.toLowerCase());
211 ResultSet rs = stm.executeQuery();
212 while (rs.next()) {
213 return rs.getInt("teleporter");
214 }
215 return getTeleporter(player);
216 } catch (SQLException e) {
217 return getTeleporter(player);
218 }
219 } else {
220 setPlayer(player);
221 return getTeleporter(player);
222 }
223 }
224
225 public static void setTeleporter(String player, int s){
226 if (contains(player)){
227 PreparedStatement stm = null;
228 try {
229 stm = con.prepareStatement("UPDATE `Loja` SET `teleporter` = ? WHERE `player` = ?");
230 stm.setInt(1, s);
231 stm.setString(2, player.toLowerCase());
232 stm.executeUpdate();
233 } catch (SQLException e) {
234 console.sendMessage("Não foi possivel setar o kit teleporter do jogador: " + player);
235 }
236 } else {
237 setPlayer(player);
238 }
239 }
240 public static int getScout(String player){
241 if (contains(player)){
242 PreparedStatement stm = null;
243 try {
244 stm = con.prepareStatement("SELECT * FROM `Loja` WHERE `player` = ?");
245 stm.setString(1, player.toLowerCase());
246 ResultSet rs = stm.executeQuery();
247 while (rs.next()) {
248 return rs.getInt("scout");
249 }
250 return getScout(player);
251 } catch (SQLException e) {
252 return getScout(player);
253 }
254 } else {
255 setPlayer(player);
256 return getScout(player);
257 }
258 }
259
260 public static void setScout(String player, int s){
261 if (contains(player)){
262 PreparedStatement stm = null;
263 try {
264 stm = con.prepareStatement("UPDATE `Loja` SET `scout` = ? WHERE `player` = ?");
265 stm.setInt(1, s);
266 stm.setString(2, player.toLowerCase());
267 stm.executeUpdate();
268 } catch (SQLException e) {
269 console.sendMessage("Não foi possivel setar o kit scout do jogador: " + player);
270 }
271 } else {
272 setPlayer(player);
273 }
274 }
275
276 public static int getKnock(String player){
277 if (contains(player)){
278 PreparedStatement stm = null;
279 try {
280 stm = con.prepareStatement("SELECT * FROM `Loja` WHERE `player` = ?");
281 stm.setString(1, player.toLowerCase());
282 ResultSet rs = stm.executeQuery();
283 while (rs.next()) {
284 return rs.getInt("knock");
285 }
286 return getKnock(player);
287 } catch (SQLException e) {
288 return getKnock(player);
289 }
290 } else {
291 setPlayer(player);
292 return getKnock(player);
293 }
294 }
295
296 public static void setKnock(String player, int s){
297 if (contains(player)){
298 PreparedStatement stm = null;
299 try {
300 stm = con.prepareStatement("UPDATE `Loja` SET `knock` = ? WHERE `player` = ?");
301 stm.setInt(1, s);
302 stm.setString(2, player.toLowerCase());
303 stm.executeUpdate();
304 } catch (SQLException e) {
305 console.sendMessage("Não foi possivel setar o kit knock do jogador: " + player);
306 }
307 } else {
308 setPlayer(player);
309 }
310 }
311
312 public static int getKratos(String player){
313 if (contains(player)){
314 PreparedStatement stm = null;
315 try {
316 stm = con.prepareStatement("SELECT * FROM `Loja` WHERE `player` = ?");
317 stm.setString(1, player.toLowerCase());
318 ResultSet rs = stm.executeQuery();
319 while (rs.next()) {
320 return rs.getInt("kratos");
321 }
322 return getKratos(player);
323 } catch (SQLException e) {
324 return getKratos(player);
325 }
326 } else {
327 setPlayer(player);
328 return getKratos(player);
329 }
330 }
331
332 public static void setKratos(String player, int s){
333 if (contains(player)){
334 PreparedStatement stm = null;
335 try {
336 stm = con.prepareStatement("UPDATE `Loja` SET `kratos` = ? WHERE `player` = ?");
337 stm.setInt(1, s);
338 stm.setString(2, player.toLowerCase());
339 stm.executeUpdate();
340 } catch (SQLException e) {
341 console.sendMessage("Não foi possivel setar o kit kratos do jogador: " + player);
342 }
343 } else {
344 setPlayer(player);
345 }
346 }