StrQLBuilderJPQLTest.java 文件源码

@Test
   public void subSelectTest() {
StrQLBuilder jpa = StrQLBuilder.createJPQL()
    .select("p.id")
    .from("Person p")
    .where("not exists (:jpa)", StrQLBuilder.createNative()
        .select("1")
        .from("Job j")
        .where("j.id = p.id")
        .and("1 = :val", 1)
        .and("exists (:jpa2)", StrQLBuilder.createNative()
            .select("1")
            .from("Person p")
            .where("1 = :val2", 1)));
TypedQuery<Long> query = jpa.createQuery(entityManager, Long.class);
List<Long> persons = query.getResultList();
assertThat(persons, is(not(empty())));
   }