Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private static Connection con;
- private static String Host = MySQLConf.getCfg().getString("MySQL.Host");
- private static String User = MySQLConf.getCfg().getString("MySQL.User");
- private static String Password = MySQLConf.getCfg().getString("MySQL.Password");
- private static String Database = MySQLConf.getCfg().getString("MySQL.Database");
- private static int Port = MySQLConf.getCfg().getInt("MySQL.Port");
- public static boolean connectMySQL(){
- boolean connect = false;
- try {
- con = DriverManager.getConnection("jdbc:mysql://" + Host + ":" + Port + "/" + Database, User, Password);
- }catch (SQLException e){
- e.printStackTrace();
- }
- return connect;
- }
- public static boolean isConnected(){
- boolean connect = false;
- if(con != null){
- connect = true;
- }
- return connect;
- }
- public static Connection getCon() {
- return con;
- }
- public static void pingMySQLServer() {
- Bukkit.getScheduler().runTaskTimerAsynchronously(Main.plugin, new Runnable() {
- public void run() {
- try {
- if (MySQL.isConnected()) {
- Statement s = MySQL.con.createStatement();
- s.executeQuery("/* ping */ SELECT 1");
- s.close();
- Bukkit.getConsoleSender().sendMessage(Variables.getPrefix() + "§3Der MySQL-Server wurde erfolgreich angepingt");
- } else {
- MySQL.connectMySQL();
- }
- }
- catch (SQLException e) {
- Bukkit.getConsoleSender().sendMessage(Variables.getPrefix() + "§cDer MySQL-Server konnte nicht angepingt werden.");
- }
- }
- }, 20L, 20 * 1200);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement