Hibernate_javabean_hbm.xml 配制
来源:百度文库 编辑:神马文学网 时间:2024/04/29 00:55:10
public class Fieldsinfo{
//栏目ID主键
private long fieldId;
//属性
private String name;
//上级栏目(自身ID外键)
private Fieldsinfo superField;
//(外键系统)
private SystemInfo systemId;
//下集子栏目集合
private Set
get and set 方法
}
二:hbm.xml
SEQ_FIELDSINFO
栏目fieldsinfo与自身关联,也与所性系统关联
三:数据库(oracle)建表为:
create table FIELDSINFO
(
FIELDID NUMBER not null,
NAME VARCHAR2(50),
SUPERFIELD NUMBER,
SYSTEMID NUMBER,
)
四:(oracle)添加主键及外键:
主键
alter table FIELDSINFO
add constraint FIELDSPRIMARY primary key (FIELDID)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
外键
alter table FIELDSINFO
add constraint FIELDFORSYS foreign key (SYSTEMID)
references SYSTEMINFO (SID);
(oracle)主键自动增长标识
-- Create sequence
create sequence SEQ_FIELDSINFO
minvalue 1
maxvalue 999999999999999999999999999
start with 601
increment by 1
cache 20;
(oracle database)