public static ArrayList<MeetingRoom> getAllMeetingRooms(){
			
			try {
				   if(conn == null || conn.isClosed()){
				    conn = DatabaseConnection.getConnection();
				   }
				  } catch (SQLException e1) {
				   // TODO Auto-generated catch block
				   e1.printStackTrace();
				  }
			
			ArrayList<MeetingRoom> meetingList = new ArrayList<MeetingRoom>();
			try {
				Statement stmnt = conn.createStatement();
				String sql = "SELECT * FROM MeetingRooms";
				ResultSet res = stmnt.executeQuery(sql);

				while(res.next()) {
					meetingroom = new MeetingRoom(res.getInt("room_id"), res.getInt("floor"), res.getInt("seats_amount"), res.getString("name"));
					meetingList.add(meetingroom);
				}

			}
			catch(SQLException e) {
				System.out.println(e);
			}
			
			
			return meetingList;
				
			}