MySQLClass

package me.mistercat.plugin.mysql;
import java.io.File;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import org.bukkit.Bukkit;
import org.bukkit.configuration.file.FileConfiguration;

import me.mistercat.plugin.Main;
import me.mistercat.plugin.util.FileManager;

public class MySQL {

    private static String HOST = "";
    private static String DATABASE = "";
    private static String USER = "";
    private static String PASSWORD = "";

    private static Connection con;

    public static void createMySQLFile(String path){
            File f = FileManager.createNewFile("mysql.yml", path);
            FileConfiguration cfg = FileManager.getConfiguration("mysql.yml", path);
            cfg.options().copyDefaults(true);
            cfg.addDefault("username", "root");
            cfg.addDefault("password", "password");
            cfg.addDefault("database", "localhost");
            cfg.addDefault("host", "host");
            try {
                    cfg.save(f);
            } catch (IOException e) {
                    e.printStackTrace();
            }
            HOST = cfg.getString("host");
            DATABASE = cfg.getString("database");
            USER = cfg.getString("user");
            PASSWORD = cfg.getString("password");
    }

    public static boolean isConnected(){
            return con == null;
    }

    public static void connect(){
            try {
                    con = DriverManager.getConnection("jdbc:mysql://"+HOST+":3306/"+DATABASE+"?autoReconnect=true", USER,PASSWORD);
                    Bukkit.getConsoleSender().sendMessage(Main.pr+"§2Verbindung zu MySQL aufgebaut!");
            } catch (SQLException e) {
                    Bukkit.getConsoleSender().sendMessage(Main.pr+"§cVerbindung zu MySQL nicht aufgebaut! ERROR: "+e.getMessage());
            }
    }
    public static void close(){
            try {
                    if(con != null){
                    con.close();
                    con = null;
                    Bukkit.getConsoleSender().sendMessage(Main.pr+"§2Verbindung zu MySQL geschlossen!");
                    }else{
                            Bukkit.getConsoleSender().sendMessage(Main.pr+"§2Verbindung zu MySQL nicht geschlossen! Grund: nicht aktiv!");

                    }
            } catch (SQLException e) {
                    Bukkit.getConsoleSender().sendMessage(Main.pr+"§cVerbindung zu MySQL geschlossen! ERROR: "+e.getMessage());
            }
    }

    public static void update(String qry){
            try {
                    Statement st = con.createStatement();
                    st.executeQuery(qry);
                    st.close();
            } catch (SQLException e) {
                    e.printStackTrace();
            }
    }
    public static ResultSet getResult(String qry){
            ResultSet rs = null;
            try {
                    Statement st = con.createStatement();
                    rs = st.executeQuery(qry);

            } catch (SQLException e) {
                    e.printStackTrace();
            }
            return rs;
    }

}