자바객체지향쿼링 jOOQ

1 개요

Java Object Oriented Querying; jOOQ

자바 객체지향 쿼링

• 자바용 경량 ORM 라이브러리
• 액티브 레코드 패턴

2 예시

• SQL

  -- 매진된 책의 저자 선택
  SELECT * FROM AUTHOR a
        WHERE EXISTS (SELECT 1
                   FROM BOOK
                  WHERE BOOK.STATUS = 'SOLD OUT'
                    AND BOOK.AUTHOR_ID = a.ID);

• jOOQ DSL #1

  create.selectFrom(table("AUTHOR").as("a"))
        .where(exists(selectOne()
                     .from(table("BOOK"))
                     .where(field("BOOK.STATUS").equal(field("BOOK_STATUS.SOLD_OUT")))
                     .and(field("BOOK.AUTHOR_ID").equal(field("AUTHOR.ID")))));

• jOOQ DSL #2

  final Author a = AUTHOR.as("a");

  create.selectFrom(a)
        .where(exists(selectOne()
                     .from(BOOK)
                     .where(BOOK.STATUS.equal(BOOK_STATUS.SOLD_OUT))
                     .and(BOOK.AUTHOR_ID.equal(a.ID))));

3 참고 자료

• https://en.wikipedia.org/wiki/Java_Object_Oriented_Querying