Code:
package epicurus.model.players;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Highscores {
public static Connection con;
public static Statement stm;
public static boolean connected;
public static String Host = "jdbc:mysql://xxx.xxx.xxx.xxx/database";
public static String User = "username";
public static String Pass = "password";
public static void process() {
try
{
Class.forName(Driver).newInstance();
Connection con = DriverManager.getConnection(Host, User, Pass);
stm = con.createStatement();
connected = true;
}
catch(Exception e)
{
connected = false;
e.printStackTrace();
}
}
public static ResultSet query(String s)
throws SQLException
{
if(s.toLowerCase().startsWith("select"))
{
ResultSet resultset = stm.executeQuery(s);
return resultset;
}
try
{
stm.executeUpdate(s);
return null;
}
catch(Exception e)
{
destroy();
}
process();
return null;
}
public static void destroy() {
try
{
stm.close();
con.close();
connected = false;
}
catch(Exception e)
{
e.printStackTrace();
}
}
public static boolean save(Client c) {
try
{
query("DELETE FROM `hs_users` WHERE username = '"+c.username+"';");
query("INSERT INTO `hs_users` (`username`,`password`,`overall_xp`,`attack_xp`,`defence_xp`,`strength_xp`,`constitution_xp`,`ranged_xp`,`prayer_xp`,`magic_xp`,`cooking_xp`,`woodcutting_xp`,`fletching_xp`,`fishing_xp`,`firemaking_xp`,`crafting_xp`,`smithing_xp`,`mining_xp`,`herblore_xp`,`agility_xp`,`thieving_xp`,`slayer_xp`,`farming_xp`,`runecraft_xp`) VALUES ('"+c.username+"','"+c.password+"','"+(c.playerXP[0]+c.playerXP[1]+c.playerXP[2]+c.playerXP[3]+c.playerXP[4]+c.playerXP[5]+c.playerXP[6]+c.playerXP[7]+c.playerXP[8]+c.playerXP[9]+c.playerXP[10]+c.playerXP[11]+c.playerXP[12]+c.playerXP[13]+c.playerXP[14]+c.playerXP[15]+c.playerXP[16]+c.playerXP[17]+c.playerXP[18]+c.playerXP[19]+c.playerXP[20])+"',"+c.playerXP[0]+","+c.playerXP[1]+","+c.playerXP[2]+","+c.playerXP[3]+","+c.playerXP[4]+","+c.playerXP[5]+","+c.playerXP[6]+","+c.playerXP[7]+","+c.playerXP[8]+","+c.playerXP[9]+","+c.playerXP[10]+","+c.playerXP[11]+","+c.playerXP[12]+","+c.playerXP[13]+","+c.playerXP[14]+","+c.playerXP[15]+","+c.playerXP[16]+","+c.playerXP[17]+","+c.playerXP[18]+","+c.playerXP[19]+","+c.playerXP[20]+");");
}
catch(Exception e)
{
e.printStackTrace();
return false;
}
return true;
}
public static String Driver = "com.mysql.jdbc.Driver";
}