private ArrayList<Room> populateRooms() {
		try{
        	openDatabase();
		}catch(Exception e){}
		String query = "SELECT * FROM t8005t2 .rooms";
		ArrayList<Room> rooms = new ArrayList<Room>();
		try {
			stmt = conn.createStatement();
			ResultSet rs = stmt.executeQuery(query);
			while (rs.next()) {
				String roomNumber = rs.getString("roomNumber");
				String roomType = rs.getString("roomType");
				int roomStart = rs.getInt("roomStart");
				int roomEnd = rs.getInt("roomEnd");
				int roomFireBreak = rs.getInt("roomFireBreak");
				int capacity = rs.getInt("capacity");
				Room room = new Room(roomNumber, roomType, roomStart, roomEnd,
						roomFireBreak, capacity);
				rooms.add(room);
			}
		} catch (Exception e) {
			System.err.println("Problem executing populateRooms query");
			System.err.println(e.getMessage());
		}
		try{
        	closeDatabase();
		}catch(Exception e){}
		return rooms;
	}