public static ArrayList<MeetingRoom> searchRoomByName(String name) {
			try {
				   if(conn == null || conn.isClosed()){
				    conn = DatabaseConnection.getConnection();
				   }
				  } catch (SQLException e1) {
				   // TODO Auto-generated catch block
				   e1.printStackTrace();
				  }
			
			ArrayList<MeetingRoom> rooms = new ArrayList<MeetingRoom>();
			try {
				PreparedStatement stmnt = conn.prepareStatement("SELECT * FROM MeetingRooms WHERE name LIKE ? ");
				stmnt.setString(1, "%" + name + "%");
				ResultSet res;
				res = stmnt.executeQuery();
				while(res.next()) {
					meetingroom = new MeetingRoom(res.getInt("room_id"), res.getInt("floor"),res.getInt("seats_amount"), res.getString("name"));
					rooms.add(meetingroom);
				}
			}
				catch(SQLException e){
					e.printStackTrace();
					
					
				}
			
			return rooms;
		}