source: src/main/java/com/example/medweb/repository/impl/TerminRepositoryImpl.java

package com.example.medweb.repository.impl;

import com.example.medweb.model.Termin;
import com.example.medweb.repository.TerminRepositoryCustom;
import org.springframework.context.annotation.Primary;
import org.springframework.stereotype.Component;

import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import java.util.List;


@Primary
@Component("custom")
public class TerminRepositoryImpl implements TerminRepositoryCustom {

    @PersistenceContext
    private EntityManager entityManager;

    @Override
    public List<Termin> findAllByTerminId(Integer termin_id) {
        return entityManager.createQuery("select o from Termin o where o.termin_id = :termin_id",
                Termin.class).setParameter("termin_id", termin_id).getResultList();
    }

    @Override
    public Termin findByTerminId(Integer termin_id) {
        return entityManager.createQuery("select o from Termin o where o.termin_id = :termin_id",
                Termin.class).setParameter("termin_id", termin_id).setMaxResults(1).getSingleResult();
    }

    @Override
    public void deleteByTerminId(Integer termin_id) {
        entityManager.createQuery("delete from Termin o where o.termin_id = :termin_id");
    }
}