jpa,JPA,EntityManager,JPAQueryFactory

   jpa条件查询,or,and 使用


　　 @Autowired
    private EntityManager entityManager;

    @Test
    public void test01() {

        CriteriaBuilder cb = entityManager.getCriteriaBuilder();
        CriteriaQuery<UserPO> query = cb.createQuery(UserPO.class);
        Root<UserPO> root = query.from(UserPO.class);
        Predicate id = cb.equal(root.get("id"), 2);
        Predicate id1 = cb.like(root.get("name"), "%现场%");
        Predicate or = cb.or(id, id1);
        query.where(or);
        List<UserPO> resultList = entityManager.createQuery(query).getResultList();
        resultList.forEach(r -> {
            r.setAccount("123");
        });
        System.out.println(one);
        System.out.println(resultList);

    }

JPAQueryFactory用法

        QUserPO userPO = QUserPO.userPO;
        JPAQuery<UserPO> query = jpaQueryFactory.select(QUserPO.userPO).from(userPO);
        BooleanExpression c = userPO.id.eq(2).or(userPO.id.eq(1)).or(userPO.id.eq(3));
        JPAQuery<UserPO> where = query.where(c);
        List<UserPO> fetch = where.fetch();
        System.out.println(fetch);