mono afto mou bgazi sto eclipse ...
try (Connection con = L2DatabaseFactory.getInstance().getConnection())
{
PreparedStatement statement = con.prepareStatement(OLYMPIAD_LOAD_NOBLES);
ResultSet rset = statement.executeQuery();
while (rset.next())
{
StatsSet statDat = new StatsSet();
int charId = rset.getInt(CHAR_ID);
statDat.set(CLASS_ID, rset.getInt(CLASS_ID));
statDat.set(CHAR_NAME, rset.getString(CHAR_NAME));
statDat.set(POINTS, rset.getInt(POINTS));
statDat.set(COMP_DONE, rset.getInt(COMP_DONE));
statDat.set("to_save", false);
_nobles.put(charId, statDat);
}
rset.close();
statement.close();
con.close();
}