JPA教程 - JPA日期映射到时间示例
我们可以将Java Date类型值映射到数据库中的TIME类型列。
@Temporal(TemporalType.TIME) private java.util.Date dob;
例子
下面的代码来自Person.java。
package cn.w3cschool.common;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;@Entity
public class Person {@Idprivate long id;private String name;@Temporal(TemporalType.TIME)private java.util.Date dob;public Person() {}public Person(String name) {this.name = name;}public java.util.Date getDob() {return dob;}public void setDob(java.util.Date dob) {this.dob = dob;}public Long getId() {return id;}public void setId(Long id) {this.id = id;}public String getName() {return name;}public void setName(String name) {this.name = name;}public String toString() {return "\n\nID:" + id + "\nName:" + name + "\n\n"+"Dob"+dob;}
}
下面的代码来自PersonDaoImpl.java。
package cn.w3cschool.common;import java.util.Calendar;
import java.util.List;import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;import org.springframework.transaction.annotation.Transactional;@Transactional
public class PersonDaoImpl {public void test(){Person p1 = new Person("Tom");p1.setId(1L);p1.setDob(Calendar.getInstance().getTime());Person p2 = new Person("Jack");p2.setId(2L);save(p1);save(p2);listAll();}private void listAll(){List<Person> persons = getAll();for (Person person : persons) {System.out.println(person);}}@PersistenceContextprivate EntityManager em;public Long save(Person person) {em.persist(person);return person.getId();}public List<Person>getAll() {return em.createQuery("SELECT p FROM Person p", Person.class).getResultList();}}
以下代码来自App.java。
package cn.w3cschool.common;import org.springframework.context.support.ClassPathXmlApplicationContext;public class App {public static void main(String[] args) {ClassPathXmlApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml");PersonDaoImpl dao = (PersonDaoImpl) context.getBean("personDao");dao.test();context.close();Helper.checkData();}
}
上面的代码生成以下结果。
以下是数据库表转储。
Table Name: PERSONRow:Column Name: ID,Column Type: BIGINT:Column Value: 1Column Name: DOB,Column Type: TIME:Column Value: 13:59:34Column Name: NAME,Column Type: VARCHAR:Column Value: TomRow:Column Name: ID,Column Type: BIGINT:Column Value: 2Column Name: DOB,Column Type: TIME:Column Value: nullColumn Name: NAME,Column Type: VARCHAR:Column Value: Jack
以上