Spring Data Provider Add-on

A data provider for Spring Data with support for paging and filtering

An easy way to connect a Vaadin Grid to a Spring backend.

Only requires you to implement

protected Page fetchFromBackEnd(Query<T, Object> query, Pageable pageable) protected int sizeInBackEnd(Query<T, Object> query) protected List getDefaultSortOrders()

and deals with paging internally.

Sample code

private UserService userService;

@Override
protected Page<User> fetchFromBackEnd(Query<User, Object> query, Pageable pageable) {
	return getUserService().findAnyMatching(getOptionalFilter(), pageable);
}

@Override
protected int sizeInBackEnd(Query<User, Object> query) {
	return (int) getUserService().countAnyMatching(getOptionalFilter());
}

@Override
protected List<QuerySortOrder> getDefaultSortOrders() {
	List<QuerySortOrder> sortOrders = new ArrayList<>();
	sortOrders.add(new QuerySortOrder("email", SortDirection.ASCENDING));
	return sortOrders;
}

public interface PersonRepository extends JpaRepository<Person, Long> {
    Page<Person> findByNameLikeIgnoreCase(String nameFilter, Pageable pageable);
    long countByNameLikeIgnoreCase(String nameFilter);
}

FilterablePageableDataProvider<Person, Object> dataProvider = new FilterablePageableDataProvider<Person, Object>() {
    @Override
    protected Page<Person> fetchFromBackEnd(Query<Person, Object> query, Pageable pageable) {
        return repo.findByNameLikeIgnoreCase(getRepoFilter(), pageable);
    }

    @Override
    protected int sizeInBackEnd(Query<Person, Object> query) {
        return (int) repo.countByNameLikeIgnoreCase(getRepoFilter());
    }

    private String getRepoFilter() {
        String filter = getOptionalFilter().orElse("");
        return "%" + filter + "%";
    }

    @Override
    protected List<QuerySortOrder> getDefaultSortOrders() {
        return Sort.asc("name").build();
    }
}

Links

• Issue Tracker
• Source Code

Compatibility