HighscoresHandler

package ab.model.players;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class HighscoresHandler extends Thread {
    private final String HOST = "venom-ps.com";
    private final String DATABASE = "venompsc_hiscores";
    private final String PASSWORD = "()lucky1";
    private final String USERNAME = "venompsc_lucky";
    private final String PORT = "3306";

    private Player c;
    private Connection con;
    private Statement stmt;
    private long total_level, total_exp;

    public HighscoresHandler(Player c) {
        this.c = c;
        c.inProcess = true;
    }

    private long getTotalLevel() {
        long totallevel = 0L;
        for (int i = 0; i <= 20; i++) {
            if (c.getLevelForXP(c.playerXP[i]) >= 99)
                totallevel += 99;
            else
                totallevel += (double) c.getLevelForXP(c.playerXP[i]);
        }
        return totallevel;
    }

    private long getTotalXp() {
        long totalxp = 0L;
        for (int i = 0; i <= 20; i++) {
            totalxp += (double) c.playerXP[i];
        }
        return totalxp;
    }

    @Override
    public void run() {
        try {
            this.makeConnection();
            this.total_exp = this.getTotalXp();
            if (stmt == null) {
                destroyConnection();
                return;
            }
            ResultSet rs = query("SELECT * FROM `hs_users` WHERE `username`='" + c.playerName + "'");
            int r = 1;

            query("UPDATE hs_users SET attack_xp ='" + c.playerXP[0] + "' WHERE username='" + c.playerName + "'");
          query("UPDATE hs_users SET defence_xp='" + c.playerXP[1] + "' WHERE username='" + c.playerName + "'");
          query("UPDATE hs_users SET strength_xp='" + c.playerXP[2] + "' WHERE username='" + c.playerName + "'");
          query("UPDATE hs_users SET constitution_xp='" + c.playerXP[3] + "' WHERE username='" + c.playerName + "'");
          query("UPDATE hs_users SET ranged_xp='" + c.playerXP[4] + "' WHERE username='" + c.playerName + "'");
          query("UPDATE hs_users SET prayer_xp='" + c.playerXP[5] + "' WHERE username='" + c.playerName + "'");
          query("UPDATE hs_users SET magic_xp='" + c.playerXP[6] + "' WHERE username='" + c.playerName + "'");
          query("UPDATE hs_users SET cooking_xp='" + c.playerXP[7] + "' WHERE username='" + c.playerName + "'");
          query("UPDATE hs_users SET woodcutting_xp='" + c.playerXP[8] + "' WHERE username='" + c.playerName + "'");
          query("UPDATE hs_users SET fletching_xp='" + c.playerXP[9] + "' WHERE username='" + c.playerName + "'");
          query("UPDATE hs_users SET fishing_xp='" + c.playerXP[10] + "' WHERE username='" + c.playerName + "'");
          query("UPDATE hs_users SET firemaking_xp='" + c.playerXP[11] + "' WHERE username='" + c.playerName + "'");
          query("UPDATE hs_users SET crafting_xp='" + c.playerXP[12] + "' WHERE username='" + c.playerName + "'");
          query("UPDATE hs_users SET smithing_xp='" + c.playerXP[13] + "' WHERE username='" + c.playerName + "'");
          query("UPDATE hs_users SET mining_xp='" + c.playerXP[14] + "' WHERE username='" + c.playerName + "'");
          query("UPDATE hs_users SET herblore_xp='" + c.playerXP[15] + "' WHERE username='" + c.playerName + "'");
          query("UPDATE hs_users SET agility_xp='" + c.playerXP[16] + "' WHERE username='" + c.playerName + "'");
          query("UPDATE hs_users SET thieving_xp='" + c.playerXP[17] + "' WHERE username='" + c.playerName + "'");
          query("UPDATE hs_users SET slayer_xp='" + c.playerXP[18] + "' WHERE username='" + c.playerName + "'");
          query("UPDATE hs_users SET farming_xp='" + c.playerXP[19] + "' WHERE username='" + c.playerName + "'");
          query("UPDATE hs_users SET runecrafting_xp='" + c.playerXP[20] + "' WHERE username='" + c.playerName + "'");



                String lvlkc = "lvl_22";
                String lvlxp = "xp_22";
                query("UPDATE hs SET rights='" + c.getRights().getValue() + "', overall_xp='" + this.total_exp + "' WHERE username='" + c.playerName + "'");
                System.out.println("Highscores have been updated for " + c.playerName);
                r = 0;
                c.inProcess = true;
                this.destroyConnection();
                return;
            }
            String name = c.playerName;
            query("INSERT INTO `hs`(`username`) VALUES('" + name + "')");
            HighscoresHandler hh = new HighscoresHandler(c);
            hh.start();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    public ResultSet query(String s) throws SQLException {
        try {
            if (s.toLowerCase().startsWith("select")) {
                ResultSet rs = stmt.executeQuery(s);
                return rs;
            }
            stmt.executeUpdate(s);
            return null;
        } catch (Exception e) {
            e.printStackTrace();
        }
        return null;
    }

    private void destroyConnection() {
        try {
            this.con = null;
            this.stmt = null;
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    private void makeConnection() {
        try {
            Class.forName("com.mysql.jdbc.Driver").newInstance();
            con = DriverManager.getConnection("jdbc:mysql://" + HOST + ":" + PORT + "/" + DATABASE, USERNAME, PASSWORD);
            stmt = con.createStatement();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}