public static ArrayList<Reservation> searchByMemberID(int memberID) {
		
		try {
			   if(conn == null || conn.isClosed()){
			    conn = DatabaseConnection.getConnection();
			   }
			  } catch (SQLException e1) {
			   // TODO Auto-generated catch block
			   e1.printStackTrace();
			  }
		
		ArrayList<Reservation> reservations = new ArrayList<Reservation>();
		try {
			PreparedStatement stmnt = conn.prepareStatement("SELECT * FROM Reservations WHERE member_id = ?");
			stmnt.setInt(1, memberID);
			
			
			ResultSet res;
			res = stmnt.executeQuery();
			while(res.next()){
				//Date yearEdition, String publicationPlace, String title String genre, String author, String iSBN, String publisher,int bookID
				reservation = new Reservation(res.getInt("product_id"),res.getInt("member_id"), res.getString("type"));
				reservations.add(reservation);
			}
		}
			catch(SQLException e){
				e.printStackTrace();
				
				
			}
		
		return reservations;
	}