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); } }