private MySQLFile mySQLFile = System.getPlugin().getMySQLFile();

    private String host = "";
    private String databse = "";
    private  String user = "";
    private String password = "";

    private Connection connection;

    public MySQL(String host,String database,String user,String password){
        this.host = host;
        this.databse = database;
        this.user = user;
        this.password = password;

        connect();
    }

    public MySQL(String host,String database,String user){
        this.host = host;
        this.databse = database;
        this.user = user;

        connect();
    }

    public MySQL(){

        this.host = mySQLFile.getHost();
        this.databse = mySQLFile.getDatabase();
        this.user = mySQLFile.getUser();
        this.password = mySQLFile.getPassword();

        connect();
    }

    private void connect(){

        try {
            Class.forName("com.mysql.jdbc.Driver");
            connection = DriverManager.getConnection("jdbc:mysql://"+host+":3306/"+databse+"?autoReconnect=true",user,password);
            Bukkit.getConsoleSender().sendMessage(System.PREFIX+"§aEs wurde eine Verbindung hergestellt.");
            createTable();
        } catch (Exception e) {
            Bukkit.getConsoleSender().sendMessage( System.PREFIX+"§4Es gab einen Fehler!");
            // e.printStackTrace();
        }

    }

    public void disconnect(){
        try {
            if (connection != null){
                connection.close();
                Bukkit.getConsoleSender().sendMessage(System.PREFIX+"§aDie Verbindung wurde getrennt!");
            }
        } catch (SQLException ex){
            ex.printStackTrace();
        }
    }

    private void createTable(){
        try {
            connection.prepareStatement("CREATE TABLE IF NOT EXISTS rp (uuid VARCHAR(150), level INT(16))").executeUpdate();
            Bukkit.getConsoleSender().sendMessage(System.PREFIX+"§aEs wurde eine Tabelle erstellt.");
        } catch (SQLException e) {
            Bukkit.getConsoleSender().sendMessage(System.PREFIX+"§4Es gab einen Fehler bei der erstellung der Tabelle!");
            // e.printStackTrace();
        }
    }

    public Connection getConnection() {
        return connection;
    }

    public boolean isConnected(){
        return (connection != null);
    }

    public void update(String qry){

        try {
            Statement st = connection.createStatement();
            st.executeUpdate(qry);
            st.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    public void updatePREPARE(String qry){

        try {
            PreparedStatement st = connection.prepareStatement(qry);
            st.executeUpdate(qry);
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    public ResultSet getResult(String qry){
        try {
            PreparedStatement st = connection.prepareStatement(qry);
            return st.executeQuery();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return null;
    }

    public ResultSet query(String qry){
        ResultSet rs = null;
        try {
            Statement st = connection.createStatement();
            rs = st.executeQuery(qry);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return rs;
    }