Okay this is how you setup MySQL in java:
Updating records example:
Code:
public static void savePunishments(Player p) {
try {
PreparedStatement s = QueryManager.prepareQuery(
"UPDATE p_punishments " +
"SET username=?," +
"muted=?," +
"mutelength=?," +
"arrested=?," +
"jailtime=?\n" +
"WHERE username=\"" + p.username + "\"");
s.setString(1, p.username);
s.setInt(2, p.muteType);
s.setInt(3, p.muteTimer);
s.setInt(4, p.arrested);
s.setInt(5, p.jailTime);
s.execute();
} catch (SQLException ex) {
QueryManager.queryError(ex);
}
}
Insert new records:
Code:
public static void savePunishments(Player p) {
try {
PreparedStatement s = QueryManager.prepareQuery(
"INSERT INTO p_punishments" +
"(username,muted,mutelength,arrested,jailtime) " +
"VALUES(?,?,?,?,?)");
s.setString(1, p.username);
s.setInt(2, p.muteType);
s.setInt(3, p.muteTimer);
s.setInt(4, p.arrested);
s.setInt(5, p.jailTime);
s.execute();
} catch (SQLException ex) {
QueryManager.queryError(ex);
}
}
And finally loading:
Code:
public void loadPunishments(Player p) {
try {
ResultSet set = loadTable("p_punishments", p);
if (set.first()) {
p.muteType = set.getInt("muted");
p.muteTimer = set.getInt("mutelength");
p.arrested = set.getInt("arrested");
p.jailTime = set.getInt("jailtime");
}
} catch (SQLException ex) {
QueryManager.queryError(ex);
}
}