表
CREATE TABLE TB_HOUR_DATA
(
STAT_DATE DATE NOT NULL,
PATH_ID NUMBER(20) NOT NULL,
VALUE VARCHAR2(512 BYTE),
TYPE NUMBER(1) NOT NULL
)
其中复合主键为(STAT_DATEPATH_IDTYPE)
针对这种情况hibernate(jpa) annotation 映射声明如下:
1、复合主键类HourDataPK
package net.kong.wolf.stat.db.entity;
import java.io.Serializable;
import java.util.Date;
import javax.persistence.Column;
import javax.persistence.Embeddable;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;
@Embeddable
public HourDataPK implements Serializable {
/** *//**
*
*/
private final long serialVersionUID = 1L;
@ManyToOne
@JoinColumn(name = "path_id", nullable = false)
private Path path;
@Column(name = "stat_date")
@Temporal(TemporalType.DATE)
private Date statDate;
private type;
public Path getPath {
path;
}
public void Path(Path path) {
this.path = path;
}
public Date getStatDate {
statDate;
}
public void StatDate(Date statDate) {
this.statDate = statDate;
}
public getType {
type;
}
public void Type( type) {
this.type = type;
}
}
2、实体类HourData:
package net.kong.wolf.stat.db.entity;
import java.io.Serializable;
import javax.persistence.EmbeddedId;
import javax.persistence.Entity;
import javax.persistence.Table;
import net.kong.wolf.stat.core.Text;
@Entity
@Table(name = "TB_HOUR_DATA")
public HourData implements Serializable {
/** *//**
*
*/
private final long serialVersionUID = 1L;
@EmbeddedId
private HourDataPK pk;
private String value;
public String getValue {
value;
}
public void Value(String value) {
this.value = value;
}
public getHours {
parseValue(value);
}
private parseValue(String value) {
result = [24];
for ( i = 0; i < 24; i) {
result[i] = -1;
}
(value null) {
result;
}
String hs = Text.splitCSV(value);
len = Math.min(24, hs.length);
for ( i = 0; i < len; i) {
result[i] = Text.parseInt(hs[i], -1);
}
result;
}
public void Hours( hours) {
tHours = parseValue(value);
StringBuilder sb = StringBuilder;
len = Math.min(24, hours.length);
for ( i = 0; i < len; i) {
sb.append(hours[i] < 0 ? tHours[i] : hours[i]).append(',');
}
sb.deleteCharAt(sb.length - 1);
this.value = sb.toString;
}
public HourDataPK getPk {
pk;
}
public void Pk(HourDataPK pk) {
this.pk = pk;
}
}
最新评论