JOOQ Cheat Sheet

basic-select-table-record.java

    List<StaffRecord> staffRecords = context
        .select()
        .from(STAFF)
        .fetchInto(StaffRecord.class);

basic-select.java

Result<Record> fetch = context
    .select()
    .from(STAFF)
    .fetch();

select-with-where-and.java

    List<StaffRecord> staffRecords = context
        .select()
        .from(STAFF)
        .where(STAFF.FIRST_NAME.eq("Mike"))
        .and(STAFF.LAST_NAME.eq("Hillyer"))
        .fetchInto(StaffRecord.class);

select-with-where-not.java

    List<StaffRecord> staffRecords = context
        .select()
        .from(STAFF)
        .where(STAFF.FIRST_NAME.eq("Mike"))
        .andNot(STAFF.FIRST_NAME.eq("Jon"))
        .fetchInto(StaffRecord.class);

select-with-where-or.java

    List<StaffRecord> staffRecords = context
        .select()
        .from(STAFF)
        .where(STAFF.FIRST_NAME.eq("Mike"))
        .or(STAFF.FIRST_NAME.eq("Jon"))
        .fetchInto(StaffRecord.class);

select-with-where.java

    List<StaffRecord> staffRecords = context
        .select()
        .from(STAFF)
        .where(STAFF.LAST_NAME.eq("Hillyer"))
        .fetchInto(StaffRecord.class);