hibernate 如何构建具有多列的CriteriaQuery predicate IN子句？

yzckvree 于 2022-11-14 发布在其他

关注(0)|答案(1)|浏览(134)

给定CriteriaQuery中使用的Predicate，例如：

Predicate predicate = root.get(MyTable.col1).in("col1Val1", "col1Val2");

是否可以将其扩展为使用多个AND字段，例如与下面的SQL相同？

SELECT *
FROM MyTable
WHERE (col1, col2, col3) IN (
    ("col1Val1", "col2Val1", "col3Val1"),
    ("col1Val2", "col2Val2", "col3Val2")
);

Hibernate

来源：https://stackoverflow.com/questions/40471832/how-to-build-a-criteriaquery-predicate-in-clause-with-multiple-columns

1条答案

按热度按时间

muk1a3rh1#

不是很优雅的方法，使用JPA标准构建器

Path<String> col1Path=root.get("col1");
    Path<String> col2Path=root.get("col2");
    Path<String> col3Path=root.get("col3");

    Predicate p0=criteriaBuilder.concat(col1Path,col2Path,col3Path)
         .in("col1Val1"||"col2Val1"||"col3Val1",
              "col1Val2"|| "col2Val2"|| "col3Val2");

第二种方法

Path<String> col1Path=root.get("col1");
    Path<String> col2Path=root.get("col2");
    Path<String> col3Path=root.get("col3");

    Predicate p1=criteriaBuilder.or(
          criteriaBuilder.and(criteriaBuilder.equal(col1Path,"col1Val1"),
                              criteriaBuilder.equal(col2Path,"col2Val1"),
                              criteriaBuilder.equal(col3Path,"col3Val1") 
                              ), 
          criteriaBuilder.and(criteriaBuilder.equal(col1Path,"col1Val2"),
                   criteriaBuilder.equal(col2Path,"col2Val2"),
                   criteriaBuilder.equal(col3Path,"col3Val2") 
                   )
           );

赞(0）回复(0）举报 2022-11-14

我来回答

hibernate 如何构建具有多列的CriteriaQuery predicate IN子句？

1条答案

相关问题

热门标签

最新问答