我正在尝试使用Spring JPA规范创建全文搜索。我试图完成的查询如下所示。
SELECT * FROM Station WHERE MATCH(Slogan, Description) AGAINST('searchText' IN BOOLEAN MODE);如何在允许传入"searchText“值的Spring JPA规范中编写此查询?到目前为止,这就是我的尝试。
public static Specification<Station> fullTextSearch(String searchText) {
if (searchText == null) {
return null;
}
return (Root<Station> root, CriteriaQuery<?> query, CriteriaBuilder cb) -> {
List<Predicate> predicates = new ArrayList<>();
Expression<Double> match = cb.function("match", Double.class,
root.get("description"),
cb.parameter(String.class, "searchText"));
// TODO: How do I set "searchText"?????
predicates.add(cb.greaterThan(match, 0.));
return cb.and(predicates.toArray(new Predicate[]{}));
};
}然后可以通过调用以下命令来使用它:
Specifications<Station> spec = Specifications.where(StationSpecifications.fullTextSearch(query));
stationRepository.findAll(spec, pageable);我第一次尝试使用的文章:http://pavelmakhov.com/2016/09/jpa-custom-function
发布于 2018-01-10 01:31:59
我提出的解决方案并不理想,但它是基于@dimirsen的建议。可分页对象被添加到查询中,并按预期工作。
@Query(value = "SELECT * FROM Station s WHERE MATCH(s.slogan, s.description) AGAINST(?1 IN BOOLEAN MODE) ORDER BY ?#{#pageable}",
countQuery = "SELECT * FROM Station s WHERE MATCH(s.slogan, s.description) AGAINST(?1 IN BOOLEAN MODE)",
nativeQuery = true)
Page<Station> fullTextSearch(String searchText, Pageable pageable);发布于 2018-01-09 17:14:30
看起来Jpa规范API不允许这样做。方法toPredicate(根目录,CriteriaQuery查询,CriteriaBuilder cb)有一个查询参数,它不允许注入参数,它不兼容。而且你没有访问entityManager的权限。如何使用原生MySQL查询(请注意nativeQuery = true ):
@Query(value = "SELECT * FROM accounts WHERE (COALESCE(first_name,'') LIKE %:firstName% AND COALESCE(last_name,'') LIKE %:lastName%)", nativeQuery = true)
public List<Account> searchByFirstnameAndLastname(@Param("firstName")String firstName,@Param("lastName")String lastName);https://stackoverflow.com/questions/48160832
复制相似问题