- 基于JSP的医院床位动态合理分配及自助查询系统mysql数据库创建语句
- 基于JSP的医院床位动态合理分配及自助查询系统oracle数据库创建语句
- 基于JSP的医院床位动态合理分配及自助查询系统sqlserver数据库创建语句
- 基于JSP的医院床位动态合理分配及自助查询系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 基于JSP的医院床位动态合理分配及自助查询系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
基于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');
病人表创建语句如下：
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 '病人';
病人记录表创建语句如下：
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 '病人记录';
用户表创建语句如下：
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 '用户';
床位表创建语句如下：
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 '床位';
护士表创建语句如下：
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 '护士';
病人留言表创建语句如下：
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 '病人留言';
床位预定表创建语句如下：
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 '床位预定';
医院手续表创建语句如下：
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 '医院手续';
基于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 '超级管理员';
病人表创建语句如下：
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 '病人';
病人记录表创建语句如下：
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 '病人记录';
用户表创建语句如下：
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 '用户';
床位表创建语句如下：
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 '床位';
护士表创建语句如下：
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 is '性别';
--护士表加注释
comment on table t_hs is '护士';
病人留言表创建语句如下：
create table t_liuyan(
id integer,
brId int,
types varchar(100),
insertDate datetime,
content varchar(100),
back varchar(100),
status varchar(100)
);
--病人留言字段加注释
comment on column t_liuyan.id is '主键';
comment on column t_liuyan.brId is '病人';
comment on column t_liuyan.types is '留言类型';
comment on column t_liuyan.insertDate is '留言日期';
comment on column t_liuyan.content is '留言内容';
comment on column t_liuyan.back is '回复';
comment on column t_liuyan.status is '状态';
--病人留言表加注释
comment on table t_liuyan is '病人留言';
床位预定表创建语句如下：
create table t_order(
id integer,
customerId int,
title varchar(100),
v1 varchar(100),
v2 varchar(100),
age varchar(100),
lx varchar(100),
phone varchar(100),
status varchar(100)
);
--床位预定字段加注释
comment on column t_order.id is '主键';
comment on column t_order.customerId is '用户';
comment on column t_order.title is '预定说明';
comment on column t_order.v1 is '病人姓名';
comment on column t_order.v2 is '病情说明';
comment on column t_order.age is '年龄';
comment on column t_order.lx is '类型';
comment on column t_order.phone is '电话';
comment on column t_order.status is '状态';
--床位预定表加注释
comment on table t_order is '床位预定';
医院手续表创建语句如下：
create table t_shouxu(
id integer,
brId int,
types varchar(100),
hsId int,
cwId int,
showDate datetime,
remark varchar(100),
pic varchar(100),
fileUrl varchar(100)
);
--医院手续字段加注释
comment on column t_shouxu.id is '主键';
comment on column t_shouxu.brId is '病人';
comment on column t_shouxu.types is '类型';
comment on column t_shouxu.hsId is '负责护士';
comment on column t_shouxu.cwId is '床位';
comment on column t_shouxu.showDate is '日期';
comment on column t_shouxu.remark is '备注';
comment on column t_shouxu.pic is '图片';
comment on column t_shouxu.fileUrl is '附件';
--医院手续表加注释
comment on table t_shouxu is '医院手续';
oracle特有，对应序列如下：
create sequence s_t_br;
create sequence s_t_brzl;
create sequence s_t_customer;
create sequence s_t_cw;
create sequence s_t_hs;
create sequence s_t_liuyan;
create sequence s_t_order;
create sequence s_t_shouxu;
基于JSP的医院床位动态合理分配及自助查询系统sqlserver数据库版本源码：
超级管理员表创建语句如下：
--超级管理员
create table t_admin(
id int identity(1,1) primary key not null,--主键
username varchar(100),--超级管理员账号
password varchar(100)--超级管理员密码
);
insert into t_admin(username,password) values('admin','123456');
病人表创建语句如下：
--病人表注释
create table t_br(
id int identity(1,1) primary key not null,--主键
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)--状态
);
病人记录表创建语句如下：
--病人记录表注释
create table t_brzl(
id int identity(1,1) primary key not null,--主键
brId int,--病人
v1 varchar(100),--病因
v2 varchar(100),--病情
v3 varchar(100),--主治医生
v4 varchar(100),--用药记录
v5 varchar(100),--反应状态
v6 varchar(100),--体温
showDate datetime--检查日期
);
用户表创建语句如下：
--用户表注释
create table t_customer(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
customerName varchar(100),--姓名
phone varchar(100)--电话
);
床位表创建语句如下：
--床位表注释
create table t_cw(
id int identity(1,1) primary key not null,--主键
brId int,--病人
hsId int,--负责护士
ks varchar(100),--科室
cwName varchar(100),--姓名
lh varchar(100),--楼号
fj varchar(100),--房间
status varchar(100)--状态
);
护士表创建语句如下：
--护士表注释
create table t_hs(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
hsName varchar(100),--姓名
headPic varchar(100),--头像
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100)--性别
);
病人留言表创建语句如下：
--病人留言表注释
create table t_liuyan(
id int identity(1,1) primary key not null,--主键
brId int,--病人
types varchar(100),--留言类型
insertDate datetime,--留言日期
content varchar(100),--留言内容
back varchar(100),--回复
status varchar(100)--状态
);
床位预定表创建语句如下：
--床位预定表注释
create table t_order(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
title varchar(100),--预定说明
v1 varchar(100),--病人姓名
v2 varchar(100),--病情说明
age varchar(100),--年龄
lx varchar(100),--类型
phone varchar(100),--电话
status varchar(100)--状态
);
医院手续表创建语句如下：
--医院手续表注释
create table t_shouxu(
id int identity(1,1) primary key not null,--主键
brId int,--病人
types varchar(100),--类型
hsId int,--负责护士
cwId int,--床位
showDate datetime,--日期
remark varchar(100),--备注
pic varchar(100),--图片
fileUrl varchar(100)--附件
);
登录后主页.jpg?x-oss-process=style/00001)
基于JSP的医院床位动态合理分配及自助查询系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计：
病人javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//病人
@Table(name = "t_br")
public class Br {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码
private String password;
//姓名
private String brName;
//头像
private String headPic;
//电话
private String phone;
//性别
private String sex;
//类型
private String lx;
//年龄
private String age;
//地址
private String address;
//身份证
private String sfz;
//紧急联系人
private String jjlxr;
//紧急联系人电话
private String jjlxfs;
//状态
private String status;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getBrName() {return brName;}
public void setBrName(String brName) {this.brName = brName;}
public String getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getLx() {return lx;}
public void setLx(String lx) {this.lx = lx;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public String getJjlxr() {return jjlxr;}
public void setJjlxr(String jjlxr) {this.jjlxr = jjlxr;}
public String getJjlxfs() {return jjlxfs;}
public void setJjlxfs(String jjlxfs) {this.jjlxfs = jjlxfs;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}病人记录javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//病人记录
@Table(name = "t_brzl")
public class Brzl {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//病人
private Integer brId;
//病因
private String v1;
//病情
private String v2;
//主治医生
private String v3;
//用药记录
private String v4;
//反应状态
private String v5;
//体温
private String v6;
//检查日期
private Date showDate;
public Integer getBrId() {return brId;}
public void setBrId(Integer brId) {this.brId = brId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}用户javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//用户
@Table(name = "t_customer")
public class Customer {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码
private String password;
//姓名
private String customerName;
//电话
private String phone;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}床位javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//床位
@Table(name = "t_cw")
public class Cw {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//病人
private Integer brId;
//负责护士
private Integer hsId;
//科室
private String ks;
//姓名
private String cwName;
//楼号
private String lh;
//房间
private String fj;
//状态
private String status;
public Integer getBrId() {return brId;}
public void setBrId(Integer brId) {this.brId = brId;}
public Integer getHsId() {return hsId;}
public void setHsId(Integer hsId) {this.hsId = hsId;}
public String getKs() {return ks;}
public void setKs(String ks) {this.ks = ks;}
public String getCwName() {return cwName;}
public void setCwName(String cwName) {this.cwName = cwName;}
public String getLh() {return lh;}
public void setLh(String lh) {this.lh = lh;}
public String getFj() {return fj;}
public void setFj(String fj) {this.fj = fj;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}护士javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//护士
@Table(name = "t_hs")
public class Hs {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码
private String password;
//姓名
private String hsName;
//头像
private String headPic;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getHsName() {return hsName;}
public void setHsName(String hsName) {this.hsName = hsName;}
public String getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
}病人留言javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//病人留言
@Table(name = "t_liuyan")
public class Liuyan {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//病人
private Integer brId;
//留言类型
private String types;
//留言日期
private Date insertDate;
//留言内容
private String content;
//回复
private String back;
//状态
private String status;
public Integer getBrId() {return brId;}
public void setBrId(Integer brId) {this.brId = brId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}床位预定javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//床位预定
@Table(name = "t_order")
public class Order {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//预定说明
private String title;
//病人姓名
private String v1;
//病情说明
private String v2;
//年龄
private String age;
//类型
private String lx;
//电话
private String phone;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getLx() {return lx;}
public void setLx(String lx) {this.lx = lx;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}医院手续javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//医院手续
@Table(name = "t_shouxu")
public class Shouxu {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//病人
private Integer brId;
//类型
private String types;
//负责护士
private Integer hsId;
//床位
private Integer cwId;
//日期
private Date showDate;
//备注
private String remark;
//图片
private String pic;
//附件
private String fileUrl;
public Integer getBrId() {return brId;}
public void setBrId(Integer brId) {this.brId = brId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Integer getHsId() {return hsId;}
public void setHsId(Integer hsId) {this.hsId = hsId;}
public Integer getCwId() {return cwId;}
public void setCwId(Integer cwId) {this.cwId = cwId;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
}基于JSP的医院床位动态合理分配及自助查询系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
病人javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//病人
public class Br extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码
private String password;
//姓名
private String brName;
//头像
private String headPic;
//电话
private String phone;
//性别
private String sex;
//类型
private String lx;
//年龄
private String age;
//地址
private String address;
//身份证
private String sfz;
//紧急联系人
private String jjlxr;
//紧急联系人电话
private String jjlxfs;
//状态
private String status;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getBrName() {return brName;}
public void setBrName(String brName) {this.brName = brName;}
public String getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getLx() {return lx;}
public void setLx(String lx) {this.lx = lx;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public String getJjlxr() {return jjlxr;}
public void setJjlxr(String jjlxr) {this.jjlxr = jjlxr;}
public String getJjlxfs() {return jjlxfs;}
public void setJjlxfs(String jjlxfs) {this.jjlxfs = jjlxfs;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}病人记录javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//病人记录
public class Brzl extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//病人
private Integer brId;
//病因
private String v1;
//病情
private String v2;
//主治医生
private String v3;
//用药记录
private String v4;
//反应状态
private String v5;
//体温
private String v6;
//检查日期
private Date showDate;
public Integer getBrId() {return brId;}
public void setBrId(Integer brId) {this.brId = brId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}用户javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//用户
public class Customer extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码
private String password;
//姓名
private String customerName;
//电话
private String phone;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}床位javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//床位
public class Cw extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//病人
private Integer brId;
//负责护士
private Integer hsId;
//科室
private String ks;
//姓名
private String cwName;
//楼号
private String lh;
//房间
private String fj;
//状态
private String status;
public Integer getBrId() {return brId;}
public void setBrId(Integer brId) {this.brId = brId;}
public Integer getHsId() {return hsId;}
public void setHsId(Integer hsId) {this.hsId = hsId;}
public String getKs() {return ks;}
public void setKs(String ks) {this.ks = ks;}
public String getCwName() {return cwName;}
public void setCwName(String cwName) {this.cwName = cwName;}
public String getLh() {return lh;}
public void setLh(String lh) {this.lh = lh;}
public String getFj() {return fj;}
public void setFj(String fj) {this.fj = fj;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}护士javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//护士
public class Hs extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码
private String password;
//姓名
private String hsName;
//头像
private String headPic;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getHsName() {return hsName;}
public void setHsName(String hsName) {this.hsName = hsName;}
public String getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
}病人留言javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//病人留言
public class Liuyan extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//病人
private Integer brId;
//留言类型
private String types;
//留言日期
private Date insertDate;
//留言内容
private String content;
//回复
private String back;
//状态
private String status;
public Integer getBrId() {return brId;}
public void setBrId(Integer brId) {this.brId = brId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}床位预定javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//床位预定
public class Order extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//预定说明
private String title;
//病人姓名
private String v1;
//病情说明
private String v2;
//年龄
private String age;
//类型
private String lx;
//电话
private String phone;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getLx() {return lx;}
public void setLx(String lx) {this.lx = lx;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}医院手续javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//医院手续
public class Shouxu extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//病人
private Integer brId;
//类型
private String types;
//负责护士
private Integer hsId;
//床位
private Integer cwId;
//日期
private Date showDate;
//备注
private String remark;
//图片
private String pic;
//附件
private String fileUrl;
public Integer getBrId() {return brId;}
public void setBrId(Integer brId) {this.brId = brId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Integer getHsId() {return hsId;}
public void setHsId(Integer hsId) {this.hsId = hsId;}
public Integer getCwId() {return cwId;}
public void setCwId(Integer cwId) {this.cwId = cwId;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
}