我这里使用的是hibernate操作的数据库,改成jdbc之类的效果是一样的,
1首先看一个实体类
package org.lei.model;
/**
* @author renlei
* @E-mail:renlei0109@yeah.net
* @version 创建时间:2014-5-9 下午1:06:07 简单说明
* 持久化类
*/
public class DateType {
//标示符
private long id ;
//日期
private java.sql.Date date;
//时间
private java.sql.Time time;
//时间戳
private java.sql.Timestamp timestamp;
//时间戳
private java.util.Calendar calendar;
//日期
private java.util.Calendar calendar_date;
public long getId() {
return id;
}
public void setId(long id) {
this.id = id;
}
public java.sql.Date getDate() {
return date;
}
public void setDate(java.sql.Date date) {
this.date = date;
}
public java.sql.Time getTime() {
return time;
}
public void setTime(java.sql.Time time) {
this.time = time;
}
public java.sql.Timestamp getTimestamp() {
return timestamp;
}
public void setTimestamp(java.sql.Timestamp timestamp) {
this.timestamp = timestamp;
}
public java.util.Calendar getCalendar() {
return calendar;
}
public void setCalendar(java.util.Calendar calendar) {
this.calendar = calendar;
}
public java.util.Calendar getCalendar_date() {
return calendar_date;
}
public void setCalendar_date(java.util.Calendar calendar_date) {
this.calendar_date = calendar_date;
}
}
里面定义了常用的各种sql的日期时间,
2hibernate的映射文件
如果采用的不是hibernate操作数据库的可以忽略这一部分
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<!-- 指定类和对象的表 -->
<class name = "org.lei.model.DateType" table="datetype">
<!-- 指定主键 -->
<id name ="id" type="long">
<!-- 定义主键生成方式 -->
<generator class ="native"/>
</id>
<!-- 定义各个字段 -->
<property name="date" type="date" column = "d_date"/>
<property name ="time" type="time" column="d_time"/>
<property name ="timestamp" type="timestamp" column="d_timestamp"/>
<property name ="calendar" type="calendar" column="d_calendar"/>
<property name ="calendar_date" type="calendar_date" column="calendar_date"/>
</class>
</hibernate-mapping>
3看看如何使用
DateType dateType = new DateType();
dateType.setDate(new java.sql.Date(new java.util.Date().getTime()));
dateType.setTimestamp(new Timestamp(new java.util.Date().getTime()));
dateType.setTime(new Time(new java.util.Date().getTime()));