MWhyte · November 28, 2022 22:51
diff --git a/basic-select-table-record.java b/basic-select-table-record.java
    List<StaffRecord> staffRecords = context
        .select()
        .from(STAFF)
        .fetchInto(StaffRecord.class);
diff --git a/basic-select.java b/basic-select.java
 Result<Record> fetch = context
    .select()
    .from(STAFF)
    .fetch();
diff --git a/select-with-where-and.java b/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);
diff --git a/select-with-where-not.java b/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);
diff --git a/select-with-where-or.java b/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);
diff --git a/select-with-where.java b/select-with-where.java
    List<StaffRecord> staffRecords = context
        .select()
        .from(STAFF)
        .where(STAFF.LAST_NAME.eq("Hillyer"))
        .fetchInto(StaffRecord.class);
	List<StaffRecord> staffRecords = context
	.select()
	.from(STAFF)
	.fetchInto(StaffRecord.class);
No results found