hibernate4+JPA2.1 注解方式 关于oracle的Date字段。很头疼
小南xyz 2016-01-14 11:28:03 数据库是ORACLE,字段类型是Date。
先上实体类
import java.util.Date;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;
@SuppressWarnings("serial")
@Entity
@Table(name = "SYS_ORG_INFO", schema = "ZZ120")
public class SysOrgInfo implements java.io.Serializable {
private String orgId;
private Date createTime;
private Date lastModifyTime;
// Constructors
/** default constructor */
public SysOrgInfo() {
}
/** minimal constructor */
public SysOrgInfo(String orgId) {
this.orgId = orgId;
}
// Property accessors
@Id
@Column(name = "ORG_ID", unique = true, nullable = false, length = 8)
public String getOrgId() {
return this.orgId;
}
public void setOrgId(String orgId) {
this.orgId = orgId;
}
@Temporal(TemporalType.DATE)
@Column(name = "CREATE_TIME", length = 27)
public Date getCreateTime() {
return this.createTime;
}
public void setCreateTime(Date createTime) {
this.createTime = createTime;
}
@Temporal(TemporalType.DATE)
@Column(name = "LAST_MODIFY_TIME", length = 27)
public Date getLastModifyTime() {
return this.lastModifyTime;
}
public void setLastModifyTime(Date lastModifyTime) {
this.lastModifyTime = lastModifyTime;
}
}
@Temporal(TemporalType.DATE)这个地方如果我写成TIMESTAMP
启动的时候报错:Wrong column type in ZZ120.SYS_ORG_INFO for column CREATE_TIME. Found: date, expected: timestamp
@Temporal(TemporalType.DATE)又获取不到时分秒
现在我暂时的应急方法是写两个属性一个映射@Temporal(TemporalType.DATE)
一个映射@Temporal(TemporalType.TIME),并且把,updatable = false,insertable = false
不过这方法也太笨了
我想实现的目标是获取数据库里面的 日期+时分秒
各位高手指点