public HouseTable() {
Connection con = null;
PreparedStatement pstm = null;
ResultSet rs = null;
try {
con = L1DatabaseFactory.getInstance().getConnection();
pstm = con.prepareStatement("SELECT * FROM house ORDER BY house_id");
rs = pstm.executeQuery();
L1House house = null;
while (rs.next()) {
house = new L1House();
house.setHouseId(rs.getInt(1));
house.setHouseName(rs.getString(2));
house.setHouseArea(rs.getInt(3));
house.setLocation(rs.getString(4));
house.setKeeperId(rs.getInt(5));
house.setOnSale(rs.getInt(6) == 1 ? true : false);
house.setPurchaseBasement(rs.getInt(7) == 1 ? true : false);
house.setTaxDeadline(timestampToCalendar((Timestamp) rs.getObject(8)));
_house.put(house.getHouseId(), house);
}
} catch (SQLException e) {
_log.log(Level.SEVERE, e.getLocalizedMessage(), e);
} finally {
SQLUtil.close(rs);
SQLUtil.close(pstm);
SQLUtil.close(con);
}
}
