Advertisement
Guest User

Untitled

a guest
Apr 26th, 2018
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.41 KB | None | 0 0
  1. package fr.happytony.overplugin.sql;
  2.  
  3. import java.sql.PreparedStatement;
  4. import java.sql.SQLException;
  5. import org.bukkit.entity.Player;
  6.  
  7. public class SQL
  8. {
  9. private java.sql.Connection connection;
  10. private String urlbase;
  11. private String host;
  12. private String database;
  13. private String user;
  14. private String pass;
  15.  
  16. public SQL(String urlbase, String host, String database, String user, String pass)
  17. {
  18. this.urlbase = urlbase;
  19. this.host = host;
  20. this.database = database;
  21. this.user = user;
  22. this.pass = pass;
  23. }
  24.  
  25. public void connection()
  26. {
  27. if (!isConnected())
  28. {
  29. try
  30. {
  31. connection = java.sql.DriverManager.getConnection(urlbase + host + "/" + database, user, pass);
  32. System.out.println("Base de données connecter !");
  33. } catch (SQLException e) {
  34. e.printStackTrace();
  35. }
  36. }
  37. }
  38.  
  39. public void disconnect() {
  40. if (isConnected()) {
  41. try
  42. {
  43. connection.close();
  44. System.out.println("Base de données déconnecter !");
  45. } catch (SQLException e) {
  46. e.printStackTrace();
  47. }
  48. }
  49. }
  50.  
  51.  
  52. public java.sql.Connection getConnection()
  53. {
  54. return connection;
  55. }
  56.  
  57. public boolean isConnected() {
  58. return connection != null;
  59. }
  60.  
  61. public void createAccount(Player player)
  62. {
  63. if (!hasAccount(player)) {
  64. try
  65. {
  66. PreparedStatement q = connection.prepareStatement("INSERT INTO joueurs(uuid, coins, grade) VALUES (?,?,?)");
  67. q.setString(1, player.getUniqueId().toString());
  68. q.setInt(2, 1000);
  69. q.setString(3, "joueur");
  70. q.execute();
  71. q.close();
  72. }
  73. catch (SQLException e) {
  74. e.printStackTrace();
  75. }
  76. }
  77. }
  78.  
  79. public boolean hasAccount(Player player)
  80. {
  81. try
  82. {
  83. PreparedStatement q = connection.prepareStatement("SELECT uuid FROM joueurs WHERE uuid = ?");
  84. q.setString(1, player.getUniqueId().toString());
  85. java.sql.ResultSet resultat = q.executeQuery();
  86. boolean hasAccount = resultat.next();
  87. q.close();
  88. return hasAccount;
  89. }
  90. catch (SQLException e)
  91. {
  92. e.printStackTrace();
  93. }
  94.  
  95. return false;
  96. }
  97.  
  98. public int getBalance(Player player) {
  99. return 0;
  100. }
  101.  
  102. public void addMoney(Player player, int account) {}
  103.  
  104. public void removeMoney(Player player, int amount) {}
  105. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement