Advertisement
Guest User

Untitled

a guest
Jul 9th, 2016
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.85 KB | None | 0 0
  1. package me.robin.main;
  2.  
  3. import java.sql.Connection;
  4. import java.sql.DriverManager;
  5. import java.sql.PreparedStatement;
  6. import java.sql.ResultSet;
  7. import java.sql.SQLException;
  8. import java.util.UUID;
  9.  
  10. import org.bukkit.entity.Player;
  11.  
  12. public class MySQL {
  13.  
  14. public static String host = "";
  15. public static int port = 3306;
  16. public static String database = "";
  17. public static String username = "";
  18. public static String password = "";
  19.  
  20. private static Connection con;
  21.  
  22. public static boolean connect() {
  23.  
  24. try {
  25. con = DriverManager.getConnection("jdbc:mysql://" + host + ":" + port + "/" + database, username, password);
  26. return true;
  27. } catch (SQLException e) {
  28. System.err.println(e.getMessage());
  29. }
  30.  
  31. return false;
  32.  
  33. }
  34.  
  35. public static Connection getConnection() {
  36. return con;
  37. }
  38.  
  39. public static boolean isConnected() {
  40. return con != null;
  41. }
  42.  
  43. public static boolean existsPlayer(UUID uuid) {
  44. if(isConnected())
  45. if(!connect())
  46. return false;
  47. try {
  48.  
  49. PreparedStatement ps = con.prepareStatement("SELECT ? FROM ?");
  50. ps.setString(1, "UUID");
  51. ps.setString(1, "rangliste");
  52.  
  53.  
  54. ResultSet rs = ps.executeQuery();
  55. while(rs.next())
  56. if(rs.getString("UUID").equals(uuid.toString()))
  57.  
  58. return true;
  59. } catch (SQLException e) {
  60.  
  61.  
  62.  
  63. e.printStackTrace();
  64. }
  65.  
  66. return false;
  67. }
  68.  
  69. public static boolean createPlayer(Player p) {
  70. if(isConnected())
  71. if(!connect())
  72. return false;
  73.  
  74. try {
  75.  
  76. PreparedStatement ps = con.prepareStatement("INSERT INTO ? (?,?,?) VALUES (?,?,?)");
  77. int i = 1;
  78. ps.setString(i++, "rangliste");
  79. ps.setString(i++, "UUID");
  80. ps.setString(i++, "Spieler");
  81. ps.setString(i++, "Kills");
  82. ps.setString(i++, "Tode");
  83. ps.setString(i++, p.getUniqueId().toString());
  84. ps.setString(i++, p.getName());
  85. ps.setInt(i++, 0);
  86. ps.setInt(i++, 0);
  87.  
  88. ps.executeQuery();
  89.  
  90. } catch (SQLException e) {
  91.  
  92. e.printStackTrace();
  93. }
  94.  
  95.  
  96.  
  97. return false;
  98.  
  99. }
  100.  
  101. public static int getKills(Player p) {
  102. if(isConnected())
  103. if(!connect())
  104. return -1;
  105.  
  106. if(!existsPlayer(p.getUniqueId()))
  107. if(!createPlayer(p));
  108. return -1;
  109. }
  110.  
  111. public static int getDeaths(Player p) {
  112. if(isConnected())
  113. if(!connect())
  114. return -1;
  115.  
  116. if(!existsPlayer(p.getUniqueId()))
  117. if(!createPlayer(p));
  118. return -1;
  119.  
  120. try {
  121.  
  122. PreparedStatement ps = con.prepareStatement("SELECT ?,? FROM ? WHERE ?,? =?,?");
  123. ps.setString(1, "Kills");
  124. ps.setString(3, "Deaths");
  125. ps.setString(4, "rangliste");
  126. ps.setString(5, "UUID");
  127. ps.setString(6, p.getUniqueId().toString());
  128.  
  129. ResultSet rs = ps.executeQuery();
  130. while(rs.next())
  131. return rs.getInt("Kills");
  132.  
  133. return -1;
  134.  
  135. ResultSet rs1 = ps.executeQuery();
  136. while(rs1.next())
  137. return rs1.getInt("Deaths");
  138.  
  139. return -1;
  140.  
  141. } catch (SQLException e) {
  142. e.printStackTrace();
  143.  
  144. }
  145. return -1;
  146.  
  147.  
  148. }
  149.  
  150. public static void setKills(Player p, int kills) {
  151. if(isConnected())
  152. if(!connect())
  153. return;
  154.  
  155. if(existsPlayer(p.getUniqueId()))
  156. if(!createPlayer(p))
  157. return;
  158.  
  159. public static void setDeaths(Player p, int deaths) {
  160. if(isConnected())
  161. if(!connect())
  162. return;
  163.  
  164. if(existsPlayer(p.getUniqueId()))
  165. if(!createPlayer(p))
  166. return;
  167.  
  168. try {
  169.  
  170. PreparedStatement ps = con.prepareStatement("UPDATE ? SET ? = ?");
  171. ps.setString(1, "rangliste");
  172. ps.setString(2, "Kills");
  173. ps.setString(3, "Tode");
  174. ps.setInt(4, kills);
  175. ps.setInt(5, deaths);
  176.  
  177. ps.executeQuery();
  178.  
  179. } catch (SQLException e) {
  180. e.printStackTrace();
  181. }
  182. }
  183. }
  184. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement