租房管理系统的设计与实现mysql数据库创建语句
租房管理系统的设计与实现oracle数据库创建语句
租房管理系统的设计与实现sqlserver数据库创建语句
租房管理系统的设计与实现spring+springMVC+hibernate框架对象(javaBean,pojo)设计
租房管理系统的设计与实现spring+springMVC+mybatis框架对象(javaBean,pojo)设计
租房管理系统的设计与实现登录注册界面
租房管理系统的设计与实现mysql数据库版本源码:
超级管理员表创建语句如下:
create table t_admin(
id int primary key auto_increment comment ‘主键’,
username varchar(100) comment ‘超级管理员账号’,
password varchar(100) comment ‘超级管理员密码’
) comment ‘超级管理员’;
insert into t_admin(username,password) values(‘admin’,‘123456’);
SQLCopy
用户表创建语句如下:
create table t_customer(
id int primary key auto_increment comment ‘主键’,
username varchar(100) comment ‘账号’,
password varchar(100) comment ‘密码’,
customerName varchar(100) comment ‘姓名’,
headPic varchar(100) comment ‘头像’,
email varchar(100) comment ‘邮箱’,
phone varchar(100) comment ‘电话’,
sfz varchar(100) comment ‘身份证’
) comment ‘用户’;
SQLCopy
财务表创建语句如下:
create table t_cw(
id int primary key auto_increment comment ‘主键’,
types varchar(100) comment ‘金额类型’,
rzcz varchar(100) comment ‘入账出账’,
showDate datetime comment ‘日期’,
fee int comment ‘金额’,
content varchar(100) comment ‘详细记录’
) comment ‘财务’;
SQLCopy
房屋表创建语句如下:
create table t_fw(
id int primary key auto_increment comment ‘主键’,
fwName varchar(100) comment ‘房屋编号’,
lx varchar(100) comment ‘类型’,
sl int comment ‘面积’,
dz varchar(100) comment ‘地址’,
pic varchar(100) comment ‘图片’
) comment ‘房屋’;
SQLCopy
合同表创建语句如下:
create table t_ht(
id int primary key auto_increment comment ‘主键’,
htName varchar(100) comment ‘合同编号’,
fwName varchar(100) comment ‘房屋编号’,
customer1Id int comment ‘房东’,
customer2Id int comment ‘租户’,
beginDate datetime comment ‘开始日期’,
endDate datetime comment ‘结束日期’,
fee int comment ‘合同金额’,
content varchar(100) comment ‘详细内容’,
yj int comment ‘押金’,
pic varchar(100) comment ‘拍照’,
fileUrl varchar(100) comment ‘合同附件’,
status varchar(100) comment ‘状态’
) comment ‘合同’;
SQLCopy
普通管理员表创建语句如下:
create table t_ptadmin(
id int primary key auto_increment comment ‘主键’,
username varchar(100) comment ‘账号’,
password varchar(100) comment ‘密码’,
ptadminName varchar(100) comment ‘姓名’,
email varchar(100) comment ‘邮箱’,
phone varchar(100) comment ‘电话’
) comment ‘普通管理员’;
SQLCopy
预定单表创建语句如下:
create table t_ydd(
id int primary key auto_increment comment ‘主键’,
fwName varchar(100) comment ‘房屋编号’,
customer2Id int comment ‘租户’,
yd int comment ‘预定金额’,
insertDate datetime comment ‘发起日期’,
endDate datetime comment ‘结束日期’
) comment ‘预定单’;
SQLCopy
租房管理系统的设计与实现oracle数据库版本源码:
超级管理员表创建语句如下:
create table t_admin(
id integer,
username varchar(100),
password varchar(100)
);
insert into t_admin(id,username,password) values(1,‘admin’,‘123456’);
–超级管理员字段加注释
comment on column t_admin.id is ‘主键’;
comment on column t_admin.username is ‘超级管理员账号’;
comment on column t_admin.password is ‘超级管理员密码’;
–超级管理员表加注释
comment on table t_admin is ‘超级管理员’;
SQLCopy
用户表创建语句如下:
create table t_customer(
id integer,
username varchar(100),
password varchar(100),
customerName varchar(100),
headPic varchar(100),
email varchar(100),
phone varchar(100),
sfz varchar(100)
);
–用户字段加注释
comment on column t_customer.id is ‘主键’;
comment on column t_customer.username is ‘账号’;
comment on column t_customer.password is ‘密码’;
comment on column t_customer.customerName is ‘姓名’;
comment on column t_customer.headPic is ‘头像’;
comment on column t_customer.email is ‘邮箱’;
comment on column t_customer.phone is ‘电话’;
comment on column t_customer.sfz is ‘身份证’;
–用户表加注释
comment on table t_customer is ‘用户’;
SQLCopy
财务表创建语句如下:
create table t_cw(
id integer,
types varchar(100),
rzcz varchar(100),
showDate datetime,
fee int,
content varchar(100)
);
–财务字段加注释
comment on column t_cw.id is ‘主键’;
comment on column t_cw.types is ‘金额类型’;
comment on column t_cw.rzcz is ‘入账出账’;
comment on column t_cw.showDate is ‘日期’;
comment on column t_cw.fee is ‘金额’;
comment on column t_cw.content is ‘详细记录’;
–财务表加注释
comment on table t_cw is ‘财务’;
SQLCopy
房屋表创建语句如下:
create table t_fw(
id integer,
fwName varchar(100),
lx varchar(100),
sl int,
dz varchar(100),
pic varchar(100)
);
–房屋字段加注释
comment on column t_fw.id is ‘主键’;
comment on column t_fw.fwName is ‘房屋编号’;
comment on column t_fw.lx is ‘类型’;
comment on column t_fw.sl is ‘面积’;
comment on column t_fw.dz is ‘地址’;
comment on column t_fw.pic is ‘图片’;
–房屋表加注释
comment on table t_fw is ‘房屋’;
SQLCopy
合同表创建语句如下:
create table t_ht(
id integer,
htName varchar(100),
fwName varchar(100),
customer1Id int,
customer2Id int,
beginDate datetime,
endDate datetime,
fee int,
content varchar(100),
yj int,
pic varchar(100),
fileUrl varchar(100),
status varchar(100)
);
–合同字段加注释
comment on column t_ht.id is ‘主键’;
comment on column t_ht.htName is ‘合同编号’;
co