?? ?? ? ??? ????? ????. ??? ??????? ? ??? ?? ???? ? ????.

?? 1?? ?? JOOQ? Hibernate? ?? ????? ??? ???? ???? ??? ??? ?????. ???? ????? ??? ?????.

1. JOOQ? ???? ??? ??? ?? ?? ??? ? ??? Hibernate? ??? ????!
2. Hibernate? ?? ??? ?? ??? ??? ????? JOOQ? ???? ?? ?? ??????!
3. Hibernate ???? ?? ???? ?? ?? ????. JOOQ??? ?? ???? ???? ?? ? ????(?????, ??? ?????)!
4. JOOQ? ??? ?? "??"? ???? ????!

?? JOOQ? ??? ?????(?? Hibernate? ?? ?????? ?? ?????)?? ????? ?? ?? ??????. ?? ??? ?????. ???? ??? ???? SQL? ???? ??? ??? ???? ??? ?????.

??? Hibernate? ??? ??? ?? JOOQ? ???? ?? ?? ???? ??? ??? ??? ??? ??????? ??? ??? ??? NoSQL? ???? ??? ??? ????. ???? ? ???? ??? ?? ???? ?? ?? ??? ? ??????.

??? ? ? ??? ???? ?? ??? ?? ??? ??? ?????. ? ???? ??? ??? ??? ??? ???. ??? ??? ??? ????:

1. ???? ????? ??????
2. ??? ?? ???? ??????
3. Hibernate? JOOQ? ????? ?? ??? ??????
4. ? ??? ?? ??? ???? ???, ??? ??? ? ????

?? ????

??????? ???? ?? ???? ???? ??? ???? ???? ?????. ??? ??? ?? ???? ??? ?? ?????? ??? SQL ?? ???? ?????. ????? ???? ? ???? ???? ??? ???? ??? ?????? ?????.

???? ??? ??? ????? ??? ? ?? ??????? ????? ??? ?????(???? ?? ?? ??? ???????). ???? ???? ??? ?? ??? ???? ??? ??? ????(SQL? JDBI ??).

@Service
@RequiredArgsConstructor
public class TalkService {
    private final Jdbi jdbi;

    public TalkSubmittedResult submitTalk(Long speakerId, String title) {
        var talkId = jdbi.inTransaction(handle -> {
            // Count the number of accepted talks by the speaker
            var acceptedTalksCount =
                handle.select("SELECT count(*) FROM talk WHERE speaker_id = :id AND status = 'ACCEPTED'")
                    .bind("id", speakerId)
                    .mapTo(Long.class)
                    .one();
            // Check if the speaker is experienced
            var experienced = acceptedTalksCount >= 10;
            // Determine the maximum allowable number of submitted talks
            var maxSubmittedTalksCount = experienced ? 5 : 3;
            var submittedTalksCount =
                handle.select("SELECT count(*) FROM talk WHERE speaker_id = :id AND status = 'SUBMITTED'")
                    .bind("id", speakerId)
                    .mapTo(Long.class)
                    .one();
            // If the maximum number of submitted talks is exceeded, throw an exception
            if (submittedTalksCount >= maxSubmittedTalksCount) {
                throw new CannotSubmitTalkException("Submitted talks count is maximum: " + maxSubmittedTalksCount);
            }
            return handle.createUpdate(
                    "INSERT INTO talk (speaker_id, status, title) " +
                    "VALUES (:id, 'SUBMITTED', :title)"
                ).bind("id", speakerId)
                   .bind("title", title)
                   .executeAndReturnGeneratedKeys("id")
                   .mapTo(Long.class)
                   .one();
        });
        return new TalkSubmittedResult(talkId);
    }
}

? ?????:

1. ???? ?? ??? ?? ?? ?????.
2. ?? ?? ?? ??? ????? ?????.
3. ?? ?? ???? SUBMITTED ??? ? ??? ????.

???? ???? ?? ??? ??? ???? ?? ?? ???? ??? ?????.

? ?? ??? ??:

1. ???? SQL? ???? ?? ?????. ??? ?? ?? ??? ?? ?? ??? ? ????.
2. ???????? ??? ???? ?????.
3. JOOQ? ???? ? ??? ?? ????? ?? ???? ???? ??? ? ????!

??:

1. ?? ??????? ???? ??? ????? ?? ??????. ?? ???(??? ? ? ???)? ?????.
2. ???? ??? ?? ? ?? ??? ???? ??? ??? ??? ? ????.
3. ?? ??? ??? ???, ?? ???? ???? ?? ??? ?? ??? ??? ? ????.

? ?? ??? ???? ??? ??? ? ???? ??? ???? ?? ?? ??? ??? ?? ?? ???? ??????. ??? ???? ? ? ??? ????. ???? ??? ?????.

??? ??

??? ?? ??? ????? ? ?? ???? ??? SQL ??? ?? ???? ???? ????. ?? ??? ???? ??? ???? ?? ???? ???? ??? ??(Java, ???? ????)? ?????.

? ????? ?? ??? ??? ??? ???? ?? ???? ????. ??? ???? ?? ??? ?? ??? ?? ??? ?????.

???? ????(???)? ??? ??? ???? ?? ?? ?????? ??? ???? ??? ???.

?? ???? ?? ?? ??? ???? ?? ??? ??? ???? ?????? ???? ?? ??? ???? ?? ? ????. ???? ???? ??? ???? ?? ??? ?? ??? ?? ???? ?? ??? ?? ???? ????.

?? ?? ??? ??? ??? Speaker ? Talk ???? ?? ????? ?? ??? ??? ??? ????.

@Service
@RequiredArgsConstructor
public class TalkService {
    private final Jdbi jdbi;

    public TalkSubmittedResult submitTalk(Long speakerId, String title) {
        var talkId = jdbi.inTransaction(handle -> {
            // Count the number of accepted talks by the speaker
            var acceptedTalksCount =
                handle.select("SELECT count(*) FROM talk WHERE speaker_id = :id AND status = 'ACCEPTED'")
                    .bind("id", speakerId)
                    .mapTo(Long.class)
                    .one();
            // Check if the speaker is experienced
            var experienced = acceptedTalksCount >= 10;
            // Determine the maximum allowable number of submitted talks
            var maxSubmittedTalksCount = experienced ? 5 : 3;
            var submittedTalksCount =
                handle.select("SELECT count(*) FROM talk WHERE speaker_id = :id AND status = 'SUBMITTED'")
                    .bind("id", speakerId)
                    .mapTo(Long.class)
                    .one();
            // If the maximum number of submitted talks is exceeded, throw an exception
            if (submittedTalksCount >= maxSubmittedTalksCount) {
                throw new CannotSubmitTalkException("Submitted talks count is maximum: " + maxSubmittedTalksCount);
            }
            return handle.createUpdate(
                    "INSERT INTO talk (speaker_id, status, title) " +
                    "VALUES (:id, 'SUBMITTED', :title)"
                ).bind("id", speakerId)
                   .bind("title", title)
                   .executeAndReturnGeneratedKeys("id")
                   .mapTo(Long.class)
                   .one();
        });
        return new TalkSubmittedResult(talkId);
    }
}

??? Speaker ????? ?? ??? ?? ???? ??? ???? ????. ?????? ?? ??? ????? ??? ??? ???? ??? ??? ? ????.

? ??? ?????? ????:

@AllArgsConstructor
public class Speaker {
    private Long id;
    private String firstName;
    private String lastName;
    private List<Talk> talks;

    public Talk submitTalk(String title) {
        boolean experienced = countTalksByStatus(Status.ACCEPTED) >= 10;
        int maxSubmittedTalksCount = experienced ? 3 : 5;
        if (countTalksByStatus(Status.SUBMITTED) >= maxSubmittedTalksCount) {
            throw new CannotSubmitTalkException(
              "Submitted talks count is maximum: " + maxSubmittedTalksCount);
        }
        Talk talk = Talk.newTalk(this, Status.SUBMITTED, title);
        talks.add(talk);
        return talk;
    }

    private long countTalksByStatus(Talk.Status status) {
        return talks.stream().filter(t -> t.getStatus().equals(status)).count();
    }
}

@AllArgsConstructor
public class Talk {
    private Long id;
    private Speaker speaker;
    private Status status;
    private String title;
    private int talkNumber;

    void setStatus(Function<Status, Status> fnStatus) {
        this.status = fnStatus.apply(this.status);
    }

    public enum Status {
        SUBMITTED, ACCEPTED, REJECTED
    }
}

??? ??? ?? SpeakerService? ??? ? ????.

public interface SpeakerRepository {
    Speaker findById(Long id);
    void save(Speaker speaker);
}

??? ??? ??:

1. ??? ??? ?? ?? ??(?: ??????)? ??? ?????. ?? ?? ?? ?? ???? ?? ?? ???? ? ????.
2. ???? ??? ??? ?? ?? ?? ????? ????. ?? ???? ???? ?? ??? ?? ?????? ??? ??? ???? ??? ?? ?????.
3. ??? ?? ??? ??? ??? ???? ?? ? ???? ?? ? ???? ?????(???? ??? ?? ?? ?? ?? ????? ??? ? ??).
4. ??? ??? ??? ? ??? ??? ? ????. ??? ?? ???? ??? ?? ??? ?? ? ??? ???? ?????(??? ???? ??? ? ??? ??? ? ??).

??? ??? ??? ????. ??? ? ?? ??? ??? ????. ????? ??? ?? ??? ?? ???? ??? ?? ???(Domain-Driven Design)? ?? ???? ? ??? ?? ???? ??? ????? ??????.

??? ??? ??? ??????? ??? ?? ?? ?? ?????. ?, ???? ??? ??????

?? ?? ???. Hibernate(?? ? ?? Spring Data JPA)? ???? ??? ?????. ??? ??? ORM ?????? ???? ?? ??? ??? ??? ???. ? ??? ??? ??????

?? ??

SpeakerRepository? ???? ?? JDBI? ?????.

@Service
@RequiredArgsConstructor
public class TalkService {
    private final Jdbi jdbi;

    public TalkSubmittedResult submitTalk(Long speakerId, String title) {
        var talkId = jdbi.inTransaction(handle -> {
            // Count the number of accepted talks by the speaker
            var acceptedTalksCount =
                handle.select("SELECT count(*) FROM talk WHERE speaker_id = :id AND status = 'ACCEPTED'")
                    .bind("id", speakerId)
                    .mapTo(Long.class)
                    .one();
            // Check if the speaker is experienced
            var experienced = acceptedTalksCount >= 10;
            // Determine the maximum allowable number of submitted talks
            var maxSubmittedTalksCount = experienced ? 5 : 3;
            var submittedTalksCount =
                handle.select("SELECT count(*) FROM talk WHERE speaker_id = :id AND status = 'SUBMITTED'")
                    .bind("id", speakerId)
                    .mapTo(Long.class)
                    .one();
            // If the maximum number of submitted talks is exceeded, throw an exception
            if (submittedTalksCount >= maxSubmittedTalksCount) {
                throw new CannotSubmitTalkException("Submitted talks count is maximum: " + maxSubmittedTalksCount);
            }
            return handle.createUpdate(
                    "INSERT INTO talk (speaker_id, status, title) " +
                    "VALUES (:id, 'SUBMITTED', :title)"
                ).bind("id", speakerId)
                   .bind("title", title)
                   .executeAndReturnGeneratedKeys("id")
                   .mapTo(Long.class)
                   .one();
        });
        return new TalkSubmittedResult(talkId);
    }
}

?? ??? ?????. ? ???? ?? JOOQ ?? JDBI? ?? SQL ?????? ???? ??????? ???? ??? ??? ?????.

???(??? ? ????) ? ???? ? ?? ?? ? ????. ??? ??????:

1. ???? ???? ?? ??? ????? ??? ?? ???? ?????.
2. ?? ???? ???? ???? ??? ????? ? ? ?? ??? ????. ?? ??? ??(? ?? E2E ????)?? ?????.
3. ?? ??? ?? ??? ????. Hibernate ??? ???? ????. ??? ??????? ??? ?? ??? ??????.

?? ?? ??? ???

??? ?? ????? ?? ? ?? ?? ????? ??? ?? ? ???????.

1. ??? ??? ??? ???? ? ?? ????.
2. ?? ??? ??? ? ??? ??? ? ????(JPA/Hibernate? ???).
3. ?? ??(?? ??)? ?? ?? ??? ??? ??? ??? ??? ???? ?? ???? ?? ???? ???.
4. ?? ?? ??? ??? ?? ? ????(???, ??? ?).
5. ?? ??? ?? ???? ?? ????(DynamicUpdate ??)? ?? ??? ??? ?? ??? UPDATE ?? ??? ??? ???? ???.

?? ???? ??? ??? ??? ???? ?? ?? ??? ?? ???? ???.

??? ? ??? ??? ????? ?? ???? (????!) Hibernate? ??? ?????? ????? ?? ? ??? ??? ???? ? ????.

JOOQ? Hibernate? ??

JOOQ? SQL ?? ?? ? ?? ??? ?? ??? ?????. ?? ??? ???? ?? ?? ??? ? ??? ???. ?????? ????? ?? ??? ???? ??? ???? ? ??? ???? ?? ??? ?? ?????(????? ??).

Hibernate? ??? ??? ??? ??????? ????? ? ??? ???? ??(???????? ???? ?? ?? ??? ??? ???? ??)? ?????.

???? Hibernate? ? ????? JOOQ? ? ??? ???? ?? ?? ?? ????. ??? ??? ??? ???? ???????. ??? ??????? ???? ???? ????? ???? ??? ?? JOOQ? ??? ?? ?? ???? ?????. ??? ??? ?? ??? ???? ?? ?? ??? ???? ??? ?? ??? ???? ?? ??? ???? ???? ???. ??, ???? ? ?? Hibernate ??? ???? ? ??? ????? ??? ??? ????. ??? ???? ???? ??-?????? ??? ?? ??? ??? ?? ???? ??? ??? ?? ?????.

??? ?? Hibernate? JOOQ? ??? CQRS? ? ???? ?????. CREATE/UPDATE/DELETE ??? ?? ??? ???? ??????(?? ? ??? ??)? ????. ??? Hibernate? ???? ??? ????. ??? ???? ?? ?? ???? ????. ??? JOOQ? ?????. Hibernate?? ??? ??? ???? ????? ?? ?? ????.

JOOQ? DAO? ??????

?????. JOOQ? ???? ???????? ???? ???? ?? ?? ??? ??? DAO? ??? ? ????. ???? ???? ???? ??? DAO? ??? ?? ????. ?? JOOQ? Hibernate? ??? setter? ???? ?? ? ?? DAO? ?? ?? ???? ???? ??? ? ?? ???? ?????. ?????? ?? ????

??? ???? ??? ??? ? ????. ??? ???? ???? ???? ?? ?? ??? ????. ??? ?????.

1. ????? ?? ??? ????. ManyToOne, OneToMany? ????. ?????? ?? ??? ???? ?? ??? ?? ? ??????.
2. ???? ????? ?????. ?? ?? ??? ??? ? ????.
3. ???? DAO? ?? ????? ??? ??? ?? ??? ? ??? ?? ?????. ?? ??, ??? ? ??? ????, ?? ???? ??? ?????, ??? Embeddable? ????? ?? ???? ????? ?? ??? ???? ??? ??????. ?, ???? ?? ??? ????? ???? ??? ? ??? ??? ?? ??? ???? ????(??? ?? ???? ??? ????? ????).

??? ??? ??? ??? ????? ???? ???? ???. Hibernate? ??? ??? ?? ??? ???? ???? ????. ??, JOOQ? ???? ?? JDBI?? ? ???? ? ??? ??? ???? ??????.

JOOQ? ???? Lukas Eder? ??? ????? DAO? ??? ??? ???? ??? ??? ?? ?? ???? ??? ?????? ?????? ??????.

??

?? ????? ?????. ?? Hibernate? ??? ??? ??? ??? ??????? ?????. ??? ?? ???? JOOQ? ? ???? ??? ?? ??? ?? ?????. ? ??? ?? ??? Hibernate? JOOQ? ???? ???? ????. ??? ??? ??? ????? ??? ?? ???? ??? ? ????.

???? ?? ???? ???? ??? ??? ??? ??????. ???? ?? ????!

??

1. JDBI
2. ?? ????
3. ??? ??
4. ? ?? – Spring Boot ? Hibernate? ??? ??? ??? ??
5. ??? ??
6. ? ??
7. JPA ????
8. JPA ?? ????
9. CQRS
10. Lukas Eder: DAO? ? ???, ? ???

? ??? JOOQ? Hibernate? ???? ????. ??? ??? ??? ?????? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!