JPA entityManager.createQuery IN

最新推荐文章于 2022-10-11 11:55:30 发布

千百元

最新推荐文章于 2022-10-11 11:55:30 发布

阅读量1.4k

点赞数

分类专栏： # jpa

本文链接：https://blog.csdn.net/liuming690452074/article/details/112278423

版权

Java JPA 查询实体数据库

关键词由CSDN通过智能技术生成

jpa 专栏收录该内容

22 篇文章

订阅专栏

 QuotationV quotationV = entityManager.createQuery("select e from QuotationV e where e.consignmentId = :consignmentId and e.status not in (?1,?2)", QuotationV.class)
                        .setParameter(1, IOQStates.INVALIDED.name())
                        .setParameter(2, IOQStates.END.name())
                        .setParameter("consignmentId", consignmentEntity.getId()).getSingleResult();

 public List<BaseRuleDto> findByIds(List<Long> ids) {
        List<BaseRules> list = entityManager.createQuery("select e from BaseRules e where e.id in :ids ")
                .setParameter("ids", ids).getResultList();
}

@Override
    public List<Receipt> findByIds(List<Long> ids) {

        List<Receipt> details = entityManager.createQuery("select e from Receipt e where e.id in (:ids) ")
                .setParameter("ids", ids)
                .getResultList();
        return details;

    }