-- Create table 客户信息表(j_customer)
create table J_CUSTOMER
(
KID INTEGER not null,
KNAME VARCHAR2(20),
KPASSWORD VARCHAR2(20),
KQUESTION VARCHAR2(50),
KANSWER VARCHAR2(20),
KCARD VARCHAR2(18),
KEMAIL VARCHAR2(20),
KTEL VARCHAR2(20),
KXINGMING VARCHAR2(20)
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
-- Create/Recreate primary, unique and foreign key constraints
alter table J_CUSTOMER
add constraint PK_KID primary key (KID)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table J_CUSTOMER
add constraint U_KNAME unique (KNAME)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
-- Create table 区域表（j_area）
create table J_AREA
(
QID INTEGER not null,
QNAME VARCHAR2(10)
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
-- Create/Recreate primary, unique and foreign key constraints
alter table J_AREA
add constraint PK_QID primary key (QID)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
-- Create table 地名表（j_place）
create table J_PLACE
(
DID INTEGER not null,
DNAME VARCHAR2(10),
QID INTEGER
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
-- Create/Recreate primary, unique and foreign key constraints
alter table J_PLACE
add constraint PK_JPLACE_DID primary key (DID)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table J_PLACE
add constraint FK_JPLACE_QID_JA_QID foreign key (QID)
references J_AREA (QID);
-- Create table 房地产商信息表（j_company）
create table J_COMPANY
(
CID INTEGER not null,
CNAME VARCHAR2(20),
CPASSWORD VARCHAR2(20),
CMINGZI VARCHAR2(20),
CADDRESS VARCHAR2(50),
CTEL VARCHAR2(20),
CINSTRODUCTION VARCHAR2(200),
CEMAIL VARCHAR2(20),
CFAX VARCHAR2(20),
CPURVIEW NUMBER(1) default 0,
CQUESTION VARCHAR2(50),
CANSWER VARCHAR2(50)
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
-- Create/Recreate primary, unique and foreign key constraints
alter table J_COMPANY
add constraint PK_CID primary key (CID)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
-- Create table 激活码表（j_activation）
create table J_ACTIVATION
(
AID INTEGER not null,
CID INTEGER,
ASTARTIME DATE,
AENDTIME DATE,
ANUMBER VARCHAR2(6)
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
-- Create/Recreate primary, unique and foreign key constraints
alter table J_ACTIVATION
add constraint PK_AID primary key (AID)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table J_ACTIVATION
add constraint FK_JACTIVE_CID_J_COM_CID foreign key (CID)
references J_COMPANY (CID);
-- Create table 楼盘表（j_build）
create table J_BUILD
(
LID INTEGER not null,
LNAME VARCHAR2(20),
LTYPE VARCHAR2(20),
LNUMFLOOR INTEGER,
LCONDITION VARCHAR2(200),
LTRAFFIC VARCHAR2(200),
LAREA FLOAT,
LPRICE FLOAT,
LIMG VARCHAR2(50),
LTIME DATE,
DID INTEGER,
CID INTEGER,
QID INTEGER
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
-- Create/Recreate primary, unique and foreign key constraints
alter table J_BUILD
add constraint PK_LID primary key (LID)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table J_BUILD
add constraint FK_CID_J_COMPANY_CID foreign key (CID)
references J_COMPANY (CID);
alter table J_BUILD
add constraint FK_DID_JPLACE_DID foreign key (DID)
references J_PLACE (DID);
alter table J_BUILD
add constraint FK_QID_JAREA_QID foreign key (QID)
references J_AREA (QID);
-- Create table 套房表（j_house）
create table J_HOUSE
(
HID INTEGER not null,
LID INTEGER,
HFLOOR INTEGER,
HDOOR VARCHAR2(20),
HAREA FLOAT,
HPRICE FLOAT,
HIMG VARCHAR2(50),
HTREND VARCHAR2(10),
HSTATE INTEGER,
HNUMBER INTEGER
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
-- Create/Recreate primary, unique and foreign key constraints
alter table J_HOUSE
add constraint PK_J_HOUSE_HID primary key (HID)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table J_HOUSE
add constraint FK_J_HOUSE_LID_JB_LID foreign key (LID)
references J_BUILD (LID);
-- Create table 评论表（j_review）
create table J_REVIEW
(
PID INTEGER not null,
PDESCRIBE VARCHAR2(200),
KID INTEGER,
LID INTEGER,
PTIME DATE
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
-- Create/Recreate primary, unique and foreign key constraints
alter table J_REVIEW
add constraint PK_PID primary key (PID)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table J_REVIEW
add constraint FK_KID_J_CUSTOMER_KID foreign key (KID)
references J_CUSTOMER (KID);
alter table J_REVIEW
add constraint FK_LID_J_BUILD_LID foreign key (LID)
references J_BUILD (LID);
-- Create table 购房意向表（j_will）
create table J_WILL
(
WID INTEGER not null,
DID INTEGER,
QID INTEGER,
WTYPE VARCHAR2(20),
WPRICE VARCHAR2(20),
WDOOR VARCHAR2(20),
KID INTEGER
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
-- Create/Recreate primary, unique and foreign key constraints
alter table J_WILL
add constraint PK_WID primary key (WID)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table J_WILL
add constraint FK_JWILL_DID_JPLACE_DID foreign key (DID)
references J_PLACE (DID);
alter table J_WILL
add constraint FK_JWILL_KID_JCUS_KID foreign key (KID)
references J_CUSTOMER (KID);
alter table J_WILL
add constraint FK_JWILL_QID_JAREA_QID foreign key (QID)
references J_AREA (QID);
-- Create table 系统管理员信息表（j_sysadmin）
create table J_SYSADMIN
(
AID INTEGER not null,
ANAME VARCHAR2(20),
APASS VARCHAR2(20)
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
structs 和hiberation的房地产管理系统
需积分: 3 192 浏览量
2009-05-17
13:14:27
上传
评论 1
收藏 3.09MB RAR 举报
structs 和hiberation的房地产管理系统 （715个子文件） 
DoCustomer.class 19KB SmartUpload.class 17KB AdminDao.class 10KB CompanyManage.class 9KB File.class 6KB AddbuildAction.class 5KB SortForSearchTag2.class 5KB SortForSearchTag.class 4KB ModifybuildAction.class 4KB Xinwen.class 4KB ModifyhouseAction.class 4KB Xuanloupan1Action.class 4KB ChaPlace.class 4KB NewPriceHouseTag.class 4KB XuanloupanAction.class 4KB CustomerSearchHouseAction.class 4KB Upload.class 4KB CustomerBuildSerchAction.class 4KB AddhouseAction.class 4KB AddbuildnameAction.class 4KB CaddviewAction.class 3KB Findquyu.class 3KB Build.class 3KB ChaArea.class 3KB Company.class 3KB XuanAction.class 3KB ModifyfindAction.class 3KB WillsDeleteAction.class 3KB CshowviewAction.class 3KB AreaSelect.class 3KB GonggaoAction.class 3KB XinwenAction.class 3KB ViewbuildnameAction.class 3KB CompanyRegist.class 3KB ModifyAction.class 3KB CregistForm.class 3KB ShowwillsAction.class 3KB XuqiuAction.class 3KB CshowHouseAction.class 3KB BuildForm.class 3KB AdminSelectAction.class 3KB CustomerSelectAction.class 3KB PlacardSelectAction.class 3KB CompanySelectAction.class 3KB XinwenSelectAction.class 3KB CustomerWillneedAction.class 3KB Chaplacard.class 3KB FindbuildAction.class 3KB AreaDeleteAction.class 3KB CustomerBuildSerch2Action.class 3KB PlaUpdateAction.class 3KB XinUpdateAction.class 2KB PlaceInsertAction.class 2KB Customer.class 2KB HibernateSessionFactory.class 2KB SysAdminLoginAction.class 2KB AdminLoginAction.class 2KB HouseForm.class 2KB RegisterForm.class 2KB ModifyCustomerInfoAction.class 2KB House.class 2KB PlaUpdateForm.class 2KB XinUpdateForm.class 2KB XiugaiAction.class 2KB ChagonggaoAction.class 2KB CregistAction.class 2KB CompanyForget.class 2KB ChanewsAction.class 2KB ComDeleteAction.class 2KB PlaDeleteAction.class 2KB XinDeleteAction.class 2KB CuDeleteAction.class 2KB PagefenAction.class 2KB GaimiAction.class 2KB ComSelectAllAction.class 2KB ResetPasswordAction.class 2KB PassUpdateAction.class 2KB AdPassUpdateAction.class 2KB RegisterAction.class 2KB DeletebuildAction.class 2KB GaizlAction.class 2KB GszlAction.class 2KB PlaSelectAllAction.class 2KB CuSelectAllAction.class 2KB Will.class 2KB XinSelectAllAction.class 2KB Request.class 2KB Files.class 2KB ReviewForm.class 2KB WillneedForm.class 2KB ActivationidAction.class 2KB PlacardInsertAction.class 2KB CustomerLoginAction.class 2KB XinwenInsertAction.class 2KB Xuqiu.class 2KB CloginAction.class 2KB CustomerResetPasswordAction.class 2KB GetPasswordAction.class 2KB AdminLoginFilter.class 2KB SysLoginFilter.class 2KB共 715 条
- 1
- 2
- 3
- 4
- 5
- 6
- 8
评论0
最新资源