天天看点

springJPA对应sql的in语句怎么写

CriteriaBuilder cb = entityManager.getCriteriaBuilder();
CriteriaQuery<Tuple> query = cb.createTupleQuery();
Root<AAA> root = query.from(AAA.class);
Path<int> statusPath = root.get("status");
List<int> list = new ArrayList<int>();
list.add(10);
list.add(11);
list.add(12);
list.add(13);
CriteriaBuilder.In<int> statusIn = cb.in(statusPath);
TypedQuery<Tuple> q = entityManager.createQuery(query);
List<Tuple> result = q.getResultList();
           

继续阅读