Java Tutorial/JPA/Query Parameter
EJB QL Date Value As Parameter
File: Main.java
<source lang="java">
import java.util.Date; import javax.persistence.EntityManager; import javax.persistence.EntityManagerFactory; import javax.persistence.Persistence; import javax.persistence.TemporalType; public class Main {
static EntityManagerFactory emf = Persistence.createEntityManagerFactory("JPAService"); static EntityManager em = emf.createEntityManager(); public static void main(String[] a) throws Exception { em.getTransaction().begin(); Date start = new Date(); Date end = new Date(); em.createQuery("SELECT e " + "FROM Student e " + "WHERE e.startDate BETWEEN :start AND :end") .setParameter("start", start, TemporalType.DATE) .setParameter("end", end, TemporalType.DATE).getResultList(); em.getTransaction().rumit(); em.close(); emf.close(); Helper.checkData(); }
}</source>