private void load() {
Connection con = null;
PreparedStatement pstm = null;
ResultSet rs = null;
try {
con = L1DatabaseFactory.getInstance().getConnection();
pstm = con.prepareStatement("SELECT * FROM castle");
rs = pstm.executeQuery();
L1Castle castle = null;
while (rs.next()) {
castle = new L1Castle(rs.getInt(1), rs.getString(2));
castle.setWarTime(timestampToCalendar((Timestamp) rs.getObject(3)));
castle.setTaxRate(rs.getInt(4));
castle.setPublicMoney(rs.getInt(5));
castle.setPublicReadyMoney(rs.getInt(6));
castle.setShowMoney(rs.getInt(7));
castle.setWarBaseTime(rs.getInt(8));
castle.setCastleSecurity(rs.getInt(9));
// castle.setTimeBase(timestampToCalendar((Timestamp) rs
// .getObject(9)));
_castles.put(castle.getId(), castle);
}
} catch (SQLException e) {
_log.log(Level.SEVERE, e.getLocalizedMessage(), e);
} finally {
SQLUtil.close(rs);
SQLUtil.close(pstm);
SQLUtil.close(con);
}
}
