Advertisement
Guest User

Untitled

a guest
Jun 15th, 2018
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.91 KB | None | 0 0
  1. package fr.gaeeya.mysql;
  2.  
  3. import java.sql.DriverManager;
  4. import java.sql.ResultSet;
  5. import java.sql.SQLException;
  6.  
  7. import org.bukkit.Bukkit;
  8. import fr.gaeeya.mysql.Main;
  9.  
  10. import com.mysql.jdbc.Connection;
  11. import com.mysql.jdbc.PreparedStatement;
  12.  
  13. public class MySQL {
  14.  
  15. public static String host = "***";
  16. public static String port = "33551";
  17. public static String database = "***";
  18. public static String username = "Administrateur";
  19. public static String password = "***";
  20.  
  21. public static Connection con;
  22.  
  23. public static boolean isConnected() {
  24. return con != null;
  25. }
  26.  
  27. public static void Connect() {
  28. if(!isConnected()){
  29. try {
  30. con = (Connection) DriverManager.getConnection("jdbc:mysql://" + host + ":" + port + "/" + database + "?autoReconnect=true", username, password);
  31. Bukkit.getConsoleSender().sendMessage(Main.pr + "§aLa connection a ete etablie");
  32. }catch (SQLException e) {
  33. Bukkit.getConsoleSender().sendMessage(Main.pr + "§cLa connectione n'a pas ete etablie !");
  34. }
  35.  
  36. }
  37. }
  38. public static void disconnect() {
  39. try {
  40. con.close();
  41. Bukkit.getConsoleSender().sendMessage("§ala connection aevc la base de données a ete fait avec reussite !");
  42. }catch (SQLException e) {
  43. Bukkit.getConsoleSender().sendMessage("§cLa connection avec la base de donnees n'a pas pus etre abouti !");
  44. }
  45. }
  46.  
  47. public static PreparedStatement getStatement(String sq1) {
  48. if(isConnected()) {
  49. PreparedStatement ps;
  50. try {
  51. ps= (PreparedStatement) con.prepareStatement(sq1);
  52. return ps;
  53. }catch (SQLException e) {
  54. e.printStackTrace();
  55. }
  56. }
  57. return null;
  58. }
  59.  
  60. public static ResultSet getResult(String sq1) {
  61. if(isConnected()) {
  62. PreparedStatement ps;
  63. ResultSet rs;
  64. try {
  65. ps = getStatement(sq1);
  66. rs = ps.executeQuery();
  67. return rs;
  68. }catch (SQLException e) {
  69. e.printStackTrace();
  70. }
  71. }
  72. return null;
  73. }
  74. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement