Wednesday February 15, 2006 Weblog
Wednesday February 15, 2006 How to use date in persistence In today's post I would like to describe how to use date data type in persistence class and then in queries. We very often use java.util.Date or java.util.Calendar objects in Java, these types can be used in persistence as well. In persistence class you can use Temporal annotation for specifying how the date property should be persisted. Without using Temporal annotation the property is persisted as TIMESTAMP. The TemporalType defines the mapping for temporal type, i.e. DATE, TIME, TIMESTAMP. The example is below:
@Temporal(TemporalType.TIME)
public Date getDueTime(){
return dueDate;
}
In this example dueDate will be persisted as java.sql.Date. Now, this property will be used in query. We should use setParameter in Entitymanager class and specify TemporalType for query like:
ListPosted by pblaha ( Feb 15 2006, 09:19:49 AM CET ) PermalinkcurrentPlans = em.createQuery("SELECT a FROM Plan a WHERE a.creationTime <= :time"). setParameter("time", new Date(), TemporalType.TIME).getResultList();
Comments:
Post a Comment:
Comments are closed for this entry.
