引用自:https://www.jianshu.com/u/9c5cb1ee4c46
| Keyword |
Sample |
JPQL snippet |
| And |
findByLastnameAndFirstname |
… where x.lastname = ?1 and x.firstname = ?2 |
| Or |
findByLastnameOrFirstname |
… where x.lastname = ?1 or x.firstname = ?2 |
| Is,Equals |
findByFirstnameIs,findByFirstnameEquals |
… where x.firstname = ?1 |
| Between |
findByStartDateBetween |
… where x.startDate between ?1 and ?2 |
| LessThan |
findByAgeLessThan |
… where x.age < ?1 |
| LessThanEqual |
findByAgeLessThanEqual |
… where x.age ⇐ ?1 |
| GreaterThan |
findByAgeGreaterThan |
… where x.age > ?1 |
| GreaterThanEqual |
findByAgeGreaterThanEqual |
… where x.age >= ?1 |
| After |
findByStartDateAfter |
… where x.startDate > ?1 |
| Before |
findByStartDateBefore |
… where x.startDate < ?1 |
| IsNull |
findByAgeIsNull |
… where x.age is null |
| IsNotNull,NotNull |
findByAge(Is)NotNull |
… where x.age not null |
| Like |
findByFirstnameLike |
… where x.firstname like ?1 |
| NotLike |
findByFirstnameNotLike |
… where x.firstname not like ?1 |
| StartingWith |
findByFirstnameStartingWith |
… where x.firstname like ?1 (parameter bound with appended %) |
| EndingWith |
findByFirstnameEndingWith |
… where x.firstname like ?1 (parameter bound with prepended %) |
| Containing |
findByFirstnameContaining |
… where x.firstname like ?1 (parameter bound wrapped in %) |
| OrderBy |
findByAgeOrderByLastnameDesc |
… where x.age = ?1 order by x.lastname desc |
| Not |
findByLastnameNot |
… where x.lastname <> ?1 |
| In |
findByAgeIn(Collection ages) |
… where x.age in ?1 |
| NotIn |
findByAgeNotIn(Collectionage) |
… where x.age not in ?1 |
| TRUE |
findByActiveTrue() |
… where x.active = true |
| FALSE |
findByActiveFalse() |
… where x.active = false |
| IgnoreCase |
findByFirstnameIgnoreCase |
… where UPPER(x.firstame) = UPPER(?1) |
实例
public Page<BugInfoDto> getAll(BugInfoDto bugInfoDto) {
Assert.notNull(bugInfoDto, "参数不能为空");
List<Sort.Order> orderList = new ArrayList<>();
orderList.add(new Sort.Order(Sort.Direction.ASC, "priority"));
orderList.add(new Sort.Order(Sort.Direction.DESC, "id"));
Sort sort = Sort.by(orderList);
Pageable pageable = PageRequest.of(bugInfoDto.getPageNumber(), bugInfoDto.getPageSize(), sort);
Page<BugInfo> bugInfo = bugInfoRepository.findByTitleContainingAndPriorityAndStatusAndHandler(bugInfoDto.getTitle(), bugInfoDto.getPriority(), bugInfoDto.getStatus(), bugInfoDto.getHandler(), pageable);
ModelMapper modelMapper = new ModelMapper();
Page<BugInfoDto> result = modelMapper.map(bugInfo, new TypeToken<List<BugInfoDto>>() {
}.getType());
return result;
}
网友评论