public static void editMeetingRoom(MeetingRoom mr){
			
			try {
				   if(conn == null || conn.isClosed()){
				    conn = DatabaseConnection.getConnection();
				   }
				  } catch (SQLException e1) {
				   // TODO Auto-generated catch block
				   e1.printStackTrace();
				  }
			
			try{
				conn.setAutoCommit(false);
				PreparedStatement stmnt = conn.prepareStatement("UPDATE MeetingRooms set floor = ?, seats_amount = ?, name = ? WHERE room_id = ?");
				
				stmnt.setInt(1, mr.getFloor());
				stmnt.setInt(2, mr.getSeatsAmount());
				stmnt.setString(3, mr.getName());
				stmnt.setInt(4, mr.getRoomID());
				
				stmnt.execute();
				conn.commit();
				conn.setAutoCommit(true);
			
			}
			catch(SQLException e){
				System.out.println("update fail!! - " + e);
			}
			
		}