public static ArrayList<Book> checkBookReservation(ArrayList<BookCopy> bookList) {
		
		try {
			   if(conn == null || conn.isClosed()){
			    conn = DatabaseConnection.getConnection();
			   }
			  } catch (SQLException e1) {
			   // TODO Auto-generated catch block
			   e1.printStackTrace();
			  }
		
		ArrayList<Book> foundReservations = new ArrayList<Book>();
		Statement stmnt = null;
		String sql = "";
		ResultSet res = null;
		
		for(Book b : bookList) {
			try {
				stmnt = conn.createStatement();
				sql = "SELECT * FROM Reservations WHERE product_id = " + b.getBookID() + " AND type = 'boek'";
				res = stmnt.executeQuery(sql);
				if(res.next())
					foundReservations.add(b);
			} catch (SQLException e) {
				System.out.println(e);
			}
		}
		
		
		return foundReservations;
	}