Advertisement
Guest User

Untitled

a guest
May 10th, 2017
114
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.88 KB | None | 0 0
  1.  
  2. private static Connection con;
  3. private static String Host = MySQLConf.getCfg().getString("MySQL.Host");
  4. private static String User = MySQLConf.getCfg().getString("MySQL.User");
  5. private static String Password = MySQLConf.getCfg().getString("MySQL.Password");
  6. private static String Database = MySQLConf.getCfg().getString("MySQL.Database");
  7. private static int Port = MySQLConf.getCfg().getInt("MySQL.Port");
  8.  
  9.  
  10. public static boolean connectMySQL(){
  11. boolean connect = false;
  12.  
  13. try {
  14. con = DriverManager.getConnection("jdbc:mysql://" + Host + ":" + Port + "/" + Database, User, Password);
  15. }catch (SQLException e){
  16. e.printStackTrace();
  17. }
  18. return connect;
  19. }
  20. public static boolean isConnected(){
  21. boolean connect = false;
  22. if(con != null){
  23. connect = true;
  24. }
  25. return connect;
  26. }
  27.  
  28. public static Connection getCon() {
  29. return con;
  30. }
  31. public static void pingMySQLServer() {
  32. Bukkit.getScheduler().runTaskTimerAsynchronously(Main.plugin, new Runnable() {
  33. public void run() {
  34. try {
  35.  
  36. if (MySQL.isConnected()) {
  37. Statement s = MySQL.con.createStatement();
  38.  
  39. s.executeQuery("/* ping */ SELECT 1");
  40. s.close();
  41. Bukkit.getConsoleSender().sendMessage(Variables.getPrefix() + "§3Der MySQL-Server wurde erfolgreich angepingt");
  42. } else {
  43. MySQL.connectMySQL();
  44. }
  45. }
  46. catch (SQLException e) {
  47. Bukkit.getConsoleSender().sendMessage(Variables.getPrefix() + "§cDer MySQL-Server konnte nicht angepingt werden.");
  48. }
  49. }
  50. }, 20L, 20 * 1200);
  51. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement