java毕设_基于JSP的医院床位动态合理分配及自助查询系统

基于JSP的医院床位动态合理分配及自助查询系统

基于JSP的医院床位动态合理分配及自助查询系统mysql数据库创建语句
基于JSP的医院床位动态合理分配及自助查询系统oracle数据库创建语句
基于JSP的医院床位动态合理分配及自助查询系统sqlserver数据库创建语句
基于JSP的医院床位动态合理分配及自助查询系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
基于JSP的医院床位动态合理分配及自助查询系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计

基于JSP的医院床位动态合理分配及自助查询系统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_br(
id int primary key auto_increment comment ‘主键’,
username varchar(100) comment ‘账号’,
password varchar(100) comment ‘密码’,
brName varchar(100) comment ‘姓名’,
headPic varchar(100) comment ‘头像’,
phone varchar(100) comment ‘电话’,
sex varchar(100) comment ‘性别’,
lx varchar(100) comment ‘类型’,
age varchar(100) comment ‘年龄’,
address varchar(100) comment ‘地址’,
sfz varchar(100) comment ‘身份证’,
jjlxr varchar(100) comment ‘紧急联系人’,
jjlxfs varchar(100) comment ‘紧急联系人电话’,
status varchar(100) comment ‘状态’
) comment ‘病人’;
SQLCopy
病人记录表创建语句如下：
create table t_brzl(
id int primary key auto_increment comment ‘主键’,
brId int comment ‘病人’,
v1 varchar(100) comment ‘病因’,
v2 varchar(100) comment ‘病情’,
v3 varchar(100) comment ‘主治医生’,
v4 varchar(100) comment ‘用药记录’,
v5 varchar(100) comment ‘反应状态’,
v6 varchar(100) comment ‘体温’,
showDate datetime comment ‘检查日期’
) comment ‘病人记录’;
SQLCopy
用户表创建语句如下：
create table t_customer(
id int primary key auto_increment comment ‘主键’,
username varchar(100) comment ‘账号’,
password varchar(100) comment ‘密码’,
customerName varchar(100) comment ‘姓名’,
phone varchar(100) comment ‘电话’
) comment ‘用户’;
SQLCopy
床位表创建语句如下：
create table t_cw(
id int primary key auto_increment comment ‘主键’,
brId int comment ‘病人’,
hsId int comment ‘负责护士’,
ks varchar(100) comment ‘科室’,
cwName varchar(100) comment ‘姓名’,
lh varchar(100) comment ‘楼号’,
fj varchar(100) comment ‘房间’,
status varchar(100) comment ‘状态’
) comment ‘床位’;
SQLCopy
护士表创建语句如下：
create table t_hs(
id int primary key auto_increment comment ‘主键’,
username varchar(100) comment ‘账号’,
password varchar(100) comment ‘密码’,
hsName varchar(100) comment ‘姓名’,
headPic varchar(100) comment ‘头像’,
phone varchar(100) comment ‘电话’,
age varchar(100) comment ‘年龄’,
sex varchar(100) comment ‘性别’
) comment ‘护士’;
SQLCopy
病人留言表创建语句如下：
create table t_liuyan(
id int primary key auto_increment comment ‘主键’,
brId int comment ‘病人’,
types varchar(100) comment ‘留言类型’,
insertDate datetime comment ‘留言日期’,
content varchar(100) comment ‘留言内容’,
back varchar(100) comment ‘回复’,
status varchar(100) comment ‘状态’
) comment ‘病人留言’;
SQLCopy
床位预定表创建语句如下：
create table t_order(
id int primary key auto_increment comment ‘主键’,
customerId int comment ‘用户’,
title varchar(100) comment ‘预定说明’,
v1 varchar(100) comment ‘病人姓名’,
v2 varchar(100) comment ‘病情说明’,
age varchar(100) comment ‘年龄’,
lx varchar(100) comment ‘类型’,
phone varchar(100) comment ‘电话’,
status varchar(100) comment ‘状态’
) comment ‘床位预定’;
SQLCopy
医院手续表创建语句如下：
create table t_shouxu(
id int primary key auto_increment comment ‘主键’,
brId int comment ‘病人’,
types varchar(100) comment ‘类型’,
hsId int comment ‘负责护士’,
cwId int comment ‘床位’,
showDate datetime comment ‘日期’,
remark varchar(100) comment ‘备注’,
pic varchar(100) comment ‘图片’,
fileUrl varchar(100) comment ‘附件’
) comment ‘医院手续’;
SQLCopy

基于JSP的医院床位动态合理分配及自助查询系统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_br(
id integer,
username varchar(100),
password varchar(100),
brName varchar(100),
headPic varchar(100),
phone varchar(100),
sex varchar(100),
lx varchar(100),
age varchar(100),
address varchar(100),
sfz varchar(100),
jjlxr varchar(100),
jjlxfs varchar(100),
status varchar(100)
);
–病人字段加注释
comment on column t_br.id is ‘主键’;
comment on column t_br.username is ‘账号’;
comment on column t_br.password is ‘密码’;
comment on column t_br.brName is ‘姓名’;
comment on column t_br.headPic is ‘头像’;
comment on column t_br.phone is ‘电话’;
comment on column t_br.sex is ‘性别’;
comment on column t_br.lx is ‘类型’;
comment on column t_br.age is ‘年龄’;
comment on column t_br.address is ‘地址’;
comment on column t_br.sfz is ‘身份证’;
comment on column t_br.jjlxr is ‘紧急联系人’;
comment on column t_br.jjlxfs is ‘紧急联系人电话’;
comment on column t_br.status is ‘状态’;
–病人表加注释
comment on table t_br is ‘病人’;
SQLCopy
病人记录表创建语句如下：
create table t_brzl(
id integer,
brId int,
v1 varchar(100),
v2 varchar(100),
v3 varchar(100),
v4 varchar(100),
v5 varchar(100),
v6 varchar(100),
showDate datetime
);
–病人记录字段加注释
comment on column t_brzl.id is ‘主键’;
comment on column t_brzl.brId is ‘病人’;
comment on column t_brzl.v1 is ‘病因’;
comment on column t_brzl.v2 is ‘病情’;
comment on column t_brzl.v3 is ‘主治医生’;
comment on column t_brzl.v4 is ‘用药记录’;
comment on column t_brzl.v5 is ‘反应状态’;
comment on column t_brzl.v6 is ‘体温’;
comment on column t_brzl.showDate is ‘检查日期’;
–病人记录表加注释
comment on table t_brzl is ‘病人记录’;
SQLCopy
用户表创建语句如下：
create table t_customer(
id integer,
username varchar(100),
password varchar(100),
customerName varchar(100),
phone 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.phone is ‘电话’;
–用户表加注释
comment on table t_customer is ‘用户’;
SQLCopy
床位表创建语句如下：
create table t_cw(
id integer,
brId int,
hsId int,
ks varchar(100),
cwName varchar(100),
lh varchar(100),
fj varchar(100),
status varchar(100)
);
–床位字段加注释
comment on column t_cw.id is ‘主键’;
comment on column t_cw.brId is ‘病人’;
comment on column t_cw.hsId is ‘负责护士’;
comment on column t_cw.ks is ‘科室’;
comment on column t_cw.cwName is ‘姓名’;
comment on column t_cw.lh is ‘楼号’;
comment on column t_cw.fj is ‘房间’;
comment on column t_cw.status is ‘状态’;
–床位表加注释
comment on table t_cw is ‘床位’;
SQLCopy
护士表创建语句如下：
create table t_hs(
id integer,
username varchar(100),
password varchar(100),
hsName varchar(100),
headPic varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100)
);
–护士字段加注释
comment on column t_hs.id is ‘主键’;
comment on column t_hs.username is ‘账号’;
comment on column t_hs.password is ‘密码’;
comment on column t_hs.hsName is ‘姓名’;
comment on column t_hs.headPic is ‘头像’;
comment on column t_hs.phone is ‘电话’;
comment on column t_hs.age is ‘年龄’;
comment on column t_hs.sex