spring-data-jpa

最新推荐文章于 2024-07-02 08:41:53 发布

凯歌的博客

最新推荐文章于 2024-07-02 08:41:53 发布

阅读量132

点赞数

分类专栏： java

本文链接：https://blog.csdn.net/kaige8312/article/details/106849286

版权

java 专栏收录该内容

192 篇文章 3 订阅

订阅专栏

ExampleMatcher matcher = ExampleMatcher.matching()
  .withMatcher("firstname", endsWith())
  .withMatcher("lastname", startsWith().ignoreCase());
}

`StringMatcher` options
Matching	Logical result
`DEFAULT` (case-sensitive)	`firstname = ?0`
`DEFAULT` (case-insensitive)	`LOWER(firstname) = LOWER(?0)`
`EXACT` (case-sensitive)	`firstname = ?0`
`EXACT` (case-insensitive)	`LOWER(firstname) = LOWER(?0)`
`STARTING` (case-sensitive)	`firstname like ?0 + '%'`
`STARTING` (case-insensitive)	`LOWER(firstname) like LOWER(?0) + '%'`
`ENDING` (case-sensitive)	`firstname like '%' + ?0`
`ENDING` (case-insensitive)	`LOWER(firstname) like '%' + LOWER(?0)`
`CONTAINING` (case-sensitive)	`firstname like '%' + ?0 + '%'`
`CONTAINING` (case-insensitive)	`LOWER(firstname) like '%' + LOWER(?0) + '%'`

				// 起始日期
				if (startTime != null) {
					predicate.getExpressions()
							.add(cb.greaterThanOrEqualTo(root.get("lastLogin").as(Date.class), startTime));
				}
				// 结束日期
				if (endTime != null) {
					predicate.getExpressions().add(cb.lessThanOrEqualTo(root.get("lastLogin").as(Date.class), endTime));
				}