- 医院信息管理系统mysql数据库创建语句
- 医院信息管理系统oracle数据库创建语句
- 医院信息管理系统sqlserver数据库创建语句
- 医院信息管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 医院信息管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
医院信息管理系统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_customer(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
customerName varchar(100) comment '姓名',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
bs varchar(100) comment '病史',
sfz varchar(100) comment '社保卡',
sbk varchar(100) comment '身份证'
) comment '用户';
住院医生查房记录表创建语句如下：
create table t_fymx(
id int primary key auto_increment comment '主键',
zhuyuanId int comment '住院',
fy int comment '费用',
showDate datetime comment '费用日期',
content varchar(100) comment '内容记录'
) comment '住院医生查房记录';
公告表创建语句如下：
create table t_gg(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
pic varchar(100) comment '图片',
cotnent varchar(100) comment '内容',
showDate datetime comment '日期'
) comment '公告';
挂号表创建语句如下：
create table t_guahao(
id int primary key auto_increment comment '主键',
ksId int comment '科室',
customerId int comment '用户',
ysId int comment '医生',
ypfee int comment '药品费用',
ypmx varchar(100) comment '药品明细',
zfyfee int comment '总费用',
zfymx varchar(100) comment '总费用明细',
zdjl varchar(100) comment '诊断记录',
showDate datetime comment '日期',
status varchar(100) comment ''
) comment '挂号';
科室表创建语句如下：
create table t_ks(
id int primary key auto_increment comment '主键',
ksName varchar(100) comment '科室'
) comment '科室';
药品表创建语句如下：
create table t_yaopin(
id int primary key auto_increment comment '主键',
yaopinName varchar(100) comment '药品名称',
pic varchar(100) comment '图片',
gg varchar(100) comment '规格',
num int comment '当前库存'
) comment '药品';
药品进出详情表创建语句如下：
create table t_yaopinlist(
id int primary key auto_increment comment '主键',
yaopinId int comment '药品名称',
sl int comment '数量',
types varchar(100) comment '类型',
showDate datetime comment '日期',
fzr varchar(100) comment '负责人'
) comment '药品进出详情';
医生表创建语句如下：
create table t_ys(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
ysName varchar(100) comment '姓名',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
js varchar(100) comment '岗位',
ksId int comment '科室'
) comment '医生';
住院表创建语句如下：
create table t_zhuyuan(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
ysId int comment '主治医生',
beginDate datetime comment '住院日期',
endDate datetime comment '出院日期',
yfk int comment '预付款',
zje int comment '总费用',
pic varchar(100) comment '拍照',
status varchar(100) comment '状态',
zhuyuanName varchar(100) comment ''
) comment '住院';
住院医生查房记录表创建语句如下：
create table t_zhuyuanlist(
id int primary key auto_increment comment '主键',
zhuyuanId int comment '住院',
ysId int comment '医生',
showDate datetime comment '查房日期',
content varchar(100) comment '内容记录'
) comment '住院医生查房记录';
医院信息管理系统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_customer(
id integer,
username varchar(100),
password varchar(100),
customerName varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100),
bs varchar(100),
sfz varchar(100),
sbk 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 column t_customer.age is '年龄';
comment on column t_customer.sex is '性别';
comment on column t_customer.bs is '病史';
comment on column t_customer.sfz is '社保卡';
comment on column t_customer.sbk is '身份证';
--用户表加注释
comment on table t_customer is '用户';
住院医生查房记录表创建语句如下：
create table t_fymx(
id integer,
zhuyuanId int,
fy int,
showDate datetime,
content varchar(100)
);
--住院医生查房记录字段加注释
comment on column t_fymx.id is '主键';
comment on column t_fymx.zhuyuanId is '住院';
comment on column t_fymx.fy is '费用';
comment on column t_fymx.showDate is '费用日期';
comment on column t_fymx.content is '内容记录';
--住院医生查房记录表加注释
comment on table t_fymx is '住院医生查房记录';
公告表创建语句如下：
create table t_gg(
id integer,
title varchar(100),
pic varchar(100),
cotnent varchar(100),
showDate datetime
);
--公告字段加注释
comment on column t_gg.id is '主键';
comment on column t_gg.title is '标题';
comment on column t_gg.pic is '图片';
comment on column t_gg.cotnent is '内容';
comment on column t_gg.showDate is '日期';
--公告表加注释
comment on table t_gg is '公告';
挂号表创建语句如下：
create table t_guahao(
id integer,
ksId int,
customerId int,
ysId int,
ypfee int,
ypmx varchar(100),
zfyfee int,
zfymx varchar(100),
zdjl varchar(100),
showDate datetime,
status varchar(100)
);
--挂号字段加注释
comment on column t_guahao.id is '主键';
comment on column t_guahao.ksId is '科室';
comment on column t_guahao.customerId is '用户';
comment on column t_guahao.ysId is '医生';
comment on column t_guahao.ypfee is '药品费用';
comment on column t_guahao.ypmx is '药品明细';
comment on column t_guahao.zfyfee is '总费用';
comment on column t_guahao.zfymx is '总费用明细';
comment on column t_guahao.zdjl is '诊断记录';
comment on column t_guahao.showDate is '日期';
comment on column t_guahao.status is '';
--挂号表加注释
comment on table t_guahao is '挂号';
科室表创建语句如下：
create table t_ks(
id integer,
ksName varchar(100)
);
--科室字段加注释
comment on column t_ks.id is '主键';
comment on column t_ks.ksName is '科室';
--科室表加注释
comment on table t_ks is '科室';
药品表创建语句如下：
create table t_yaopin(
id integer,
yaopinName varchar(100),
pic varchar(100),
gg varchar(100),
num int
);
--药品字段加注释
comment on column t_yaopin.id is '主键';
comment on column t_yaopin.yaopinName is '药品名称';
comment on column t_yaopin.pic is '图片';
comment on column t_yaopin.gg is '规格';
comment on column t_yaopin.num is '当前库存';
--药品表加注释
comment on table t_yaopin is '药品';
药品进出详情表创建语句如下：
create table t_yaopinlist(
id integer,
yaopinId int,
sl int,
types varchar(100),
showDate datetime,
fzr varchar(100)
);
--药品进出详情字段加注释
comment on column t_yaopinlist.id is '主键';
comment on column t_yaopinlist.yaopinId is '药品名称';
comment on column t_yaopinlist.sl is '数量';
comment on column t_yaopinlist.types is '类型';
comment on column t_yaopinlist.showDate is '日期';
comment on column t_yaopinlist.fzr is '负责人';
--药品进出详情表加注释
comment on table t_yaopinlist is '药品进出详情';
医生表创建语句如下：
create table t_ys(
id integer,
username varchar(100),
password varchar(100),
ysName varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100),
js varchar(100),
ksId int
);
--医生字段加注释
comment on column t_ys.id is '主键';
comment on column t_ys.username is '账号';
comment on column t_ys.password is '密码';
comment on column t_ys.ysName is '姓名';
comment on column t_ys.phone is '电话';
comment on column t_ys.age is '年龄';
comment on column t_ys.sex is '性别';
comment on column t_ys.js is '岗位';
comment on column t_ys.ksId is '科室';
--医生表加注释
comment on table t_ys is '医生';
住院表创建语句如下：
create table t_zhuyuan(
id integer,
customerId int,
ysId int,
beginDate datetime,
endDate datetime,
yfk int,
zje int,
pic varchar(100),
status varchar(100),
zhuyuanName varchar(100)
);
--住院字段加注释
comment on column t_zhuyuan.id is '主键';
comment on column t_zhuyuan.customerId is '用户';
comment on column t_zhuyuan.ysId is '主治医生';
comment on column t_zhuyuan.beginDate is '住院日期';
comment on column t_zhuyuan.endDate is '出院日期';
comment on column t_zhuyuan.yfk is '预付款';
comment on column t_zhuyuan.zje is '总费用';
comment on column t_zhuyuan.pic is '拍照';
comment on column t_zhuyuan.status is '状态';
comment on column t_zhuyuan.zhuyuanName is '';
--住院表加注释
comment on table t_zhuyuan is '住院';
住院医生查房记录表创建语句如下：
create table t_zhuyuanlist(
id integer,
zhuyuanId int,
ysId int,
showDate datetime,
content varchar(100)
);
--住院医生查房记录字段加注释
comment on column t_zhuyuanlist.id is '主键';
comment on column t_zhuyuanlist.zhuyuanId is '住院';
comment on column t_zhuyuanlist.ysId is '医生';
comment on column t_zhuyuanlist.showDate is '查房日期';
comment on column t_zhuyuanlist.content is '内容记录';
--住院医生查房记录表加注释
comment on table t_zhuyuanlist is '住院医生查房记录';
oracle特有，对应序列如下：
create sequence s_t_customer;
create sequence s_t_fymx;
create sequence s_t_gg;
create sequence s_t_guahao;
create sequence s_t_ks;
create sequence s_t_yaopin;
create sequence s_t_yaopinlist;
create sequence s_t_ys;
create sequence s_t_zhuyuan;
create sequence s_t_zhuyuanlist;
医院信息管理系统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_customer(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
customerName varchar(100),--姓名
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100),--性别
bs varchar(100),--病史
sfz varchar(100),--社保卡
sbk varchar(100)--身份证
);
住院医生查房记录表创建语句如下：
--住院医生查房记录表注释
create table t_fymx(
id int identity(1,1) primary key not null,--主键
zhuyuanId int,--住院
fy int,--费用
showDate datetime,--费用日期
content varchar(100)--内容记录
);
公告表创建语句如下：
--公告表注释
create table t_gg(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
pic varchar(100),--图片
cotnent varchar(100),--内容
showDate datetime--日期
);
挂号表创建语句如下：
--挂号表注释
create table t_guahao(
id int identity(1,1) primary key not null,--主键
ksId int,--科室
customerId int,--用户
ysId int,--医生
ypfee int,--药品费用
ypmx varchar(100),--药品明细
zfyfee int,--总费用
zfymx varchar(100),--总费用明细
zdjl varchar(100),--诊断记录
showDate datetime,--日期
status varchar(100)--
);
科室表创建语句如下：
--科室表注释
create table t_ks(
id int identity(1,1) primary key not null,--主键
ksName varchar(100)--科室
);
药品表创建语句如下：
--药品表注释
create table t_yaopin(
id int identity(1,1) primary key not null,--主键
yaopinName varchar(100),--药品名称
pic varchar(100),--图片
gg varchar(100),--规格
num int--当前库存
);
药品进出详情表创建语句如下：
--药品进出详情表注释
create table t_yaopinlist(
id int identity(1,1) primary key not null,--主键
yaopinId int,--药品名称
sl int,--数量
types varchar(100),--类型
showDate datetime,--日期
fzr varchar(100)--负责人
);
医生表创建语句如下：
--医生表注释
create table t_ys(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
ysName varchar(100),--姓名
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100),--性别
js varchar(100),--岗位
ksId int--科室
);
住院表创建语句如下：
--住院表注释
create table t_zhuyuan(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
ysId int,--主治医生
beginDate datetime,--住院日期
endDate datetime,--出院日期
yfk int,--预付款
zje int,--总费用
pic varchar(100),--拍照
status varchar(100),--状态
zhuyuanName varchar(100)--
);
住院医生查房记录表创建语句如下：
--住院医生查房记录表注释
create table t_zhuyuanlist(
id int identity(1,1) primary key not null,--主键
zhuyuanId int,--住院
ysId int,--医生
showDate datetime,--查房日期
content varchar(100)--内容记录
);
登录后主页.jpg?x-oss-process=style/00001)
医院信息管理系统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_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;
//年龄
private String age;
//性别
private String sex;
//病史
private String bs;
//社保卡
private String sfz;
//身份证
private String sbk;
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;}
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;}
public String getBs() {return bs;}
public void setBs(String bs) {this.bs = bs;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public String getSbk() {return sbk;}
public void setSbk(String sbk) {this.sbk = sbk;}
}住院医生查房记录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_fymx")
public class Fymx {
//主键
@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 zhuyuanId;
//费用
private Integer fy;
//费用日期
private Date showDate;
//内容记录
private String content;
public Integer getZhuyuanId() {return zhuyuanId;}
public void setZhuyuanId(Integer zhuyuanId) {this.zhuyuanId = zhuyuanId;}
public Integer getFy() {return fy;}
public void setFy(Integer fy) {this.fy = fy;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}公告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_gg")
public class Gg {
//主键
@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 title;
//图片
private String pic;
//内容
private String cotnent;
//日期
private Date showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getCotnent() {return cotnent;}
public void setCotnent(String cotnent) {this.cotnent = cotnent;}
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_guahao")
public class Guahao {
//主键
@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 ksId;
//用户
private Integer customerId;
//医生
private Integer ysId;
//药品费用
private Integer ypfee;
//药品明细
private String ypmx;
//总费用
private Integer zfyfee;
//总费用明细
private String zfymx;
//诊断记录
private String zdjl;
//日期
private Date showDate;
//
private String status;
public Integer getKsId() {return ksId;}
public void setKsId(Integer ksId) {this.ksId = ksId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getYsId() {return ysId;}
public void setYsId(Integer ysId) {this.ysId = ysId;}
public Integer getYpfee() {return ypfee;}
public void setYpfee(Integer ypfee) {this.ypfee = ypfee;}
public String getYpmx() {return ypmx;}
public void setYpmx(String ypmx) {this.ypmx = ypmx;}
public Integer getZfyfee() {return zfyfee;}
public void setZfyfee(Integer zfyfee) {this.zfyfee = zfyfee;}
public String getZfymx() {return zfymx;}
public void setZfymx(String zfymx) {this.zfymx = zfymx;}
public String getZdjl() {return zdjl;}
public void setZdjl(String zdjl) {this.zdjl = zdjl;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
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_ks")
public class Ks {
//主键
@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 ksName;
public String getKsName() {return ksName;}
public void setKsName(String ksName) {this.ksName = ksName;}
}药品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_yaopin")
public class Yaopin {
//主键
@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 yaopinName;
//图片
private String pic;
//规格
private String gg;
//当前库存
private Integer num;
public String getYaopinName() {return yaopinName;}
public void setYaopinName(String yaopinName) {this.yaopinName = yaopinName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getGg() {return gg;}
public void setGg(String gg) {this.gg = gg;}
public Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
}药品进出详情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_yaopinlist")
public class Yaopinlist {
//主键
@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 yaopinId;
//数量
private Integer sl;
//类型
private String types;
//日期
private Date showDate;
//负责人
private String fzr;
public Integer getYaopinId() {return yaopinId;}
public void setYaopinId(Integer yaopinId) {this.yaopinId = yaopinId;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
}医生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_ys")
public class Ys {
//主键
@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 ysName;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//岗位
private String js;
//科室
private Integer ksId;
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 getYsName() {return ysName;}
public void setYsName(String ysName) {this.ysName = ysName;}
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;}
public String getJs() {return js;}
public void setJs(String js) {this.js = js;}
public Integer getKsId() {return ksId;}
public void setKsId(Integer ksId) {this.ksId = ksId;}
}住院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_zhuyuan")
public class Zhuyuan {
//主键
@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 Integer ysId;
//住院日期
private Date beginDate;
//出院日期
private Date endDate;
//预付款
private Integer yfk;
//总费用
private Integer zje;
//拍照
private String pic;
//状态
private String status;
//
private String zhuyuanName;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getYsId() {return ysId;}
public void setYsId(Integer ysId) {this.ysId = ysId;}
public Date getBeginDate() {return beginDate;}
public void setBeginDate(Date beginDate) {this.beginDate = beginDate;}
public Date getEndDate() {return endDate;}
public void setEndDate(Date endDate) {this.endDate = endDate;}
public Integer getYfk() {return yfk;}
public void setYfk(Integer yfk) {this.yfk = yfk;}
public Integer getZje() {return zje;}
public void setZje(Integer zje) {this.zje = zje;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getZhuyuanName() {return zhuyuanName;}
public void setZhuyuanName(String zhuyuanName) {this.zhuyuanName = zhuyuanName;}
}住院医生查房记录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_zhuyuanlist")
public class Zhuyuanlist {
//主键
@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 zhuyuanId;
//医生
private Integer ysId;
//查房日期
private Date showDate;
//内容记录
private String content;
public Integer getZhuyuanId() {return zhuyuanId;}
public void setZhuyuanId(Integer zhuyuanId) {this.zhuyuanId = zhuyuanId;}
public Integer getYsId() {return ysId;}
public void setYsId(Integer ysId) {this.ysId = ysId;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}医院信息管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
用户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;
//年龄
private String age;
//性别
private String sex;
//病史
private String bs;
//社保卡
private String sfz;
//身份证
private String sbk;
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;}
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;}
public String getBs() {return bs;}
public void setBs(String bs) {this.bs = bs;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public String getSbk() {return sbk;}
public void setSbk(String sbk) {this.sbk = sbk;}
}住院医生查房记录javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//住院医生查房记录
public class Fymx extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//住院
private Integer zhuyuanId;
//费用
private Integer fy;
//费用日期
private Date showDate;
//内容记录
private String content;
public Integer getZhuyuanId() {return zhuyuanId;}
public void setZhuyuanId(Integer zhuyuanId) {this.zhuyuanId = zhuyuanId;}
public Integer getFy() {return fy;}
public void setFy(Integer fy) {this.fy = fy;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}公告javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//公告
public class Gg extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//图片
private String pic;
//内容
private String cotnent;
//日期
private Date showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getCotnent() {return cotnent;}
public void setCotnent(String cotnent) {this.cotnent = cotnent;}
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 Guahao extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//科室
private Integer ksId;
//用户
private Integer customerId;
//医生
private Integer ysId;
//药品费用
private Integer ypfee;
//药品明细
private String ypmx;
//总费用
private Integer zfyfee;
//总费用明细
private String zfymx;
//诊断记录
private String zdjl;
//日期
private Date showDate;
//
private String status;
public Integer getKsId() {return ksId;}
public void setKsId(Integer ksId) {this.ksId = ksId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getYsId() {return ysId;}
public void setYsId(Integer ysId) {this.ysId = ysId;}
public Integer getYpfee() {return ypfee;}
public void setYpfee(Integer ypfee) {this.ypfee = ypfee;}
public String getYpmx() {return ypmx;}
public void setYpmx(String ypmx) {this.ypmx = ypmx;}
public Integer getZfyfee() {return zfyfee;}
public void setZfyfee(Integer zfyfee) {this.zfyfee = zfyfee;}
public String getZfymx() {return zfymx;}
public void setZfymx(String zfymx) {this.zfymx = zfymx;}
public String getZdjl() {return zdjl;}
public void setZdjl(String zdjl) {this.zdjl = zdjl;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
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 Ks extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//科室
private String ksName;
public String getKsName() {return ksName;}
public void setKsName(String ksName) {this.ksName = ksName;}
}药品javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//药品
public class Yaopin extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//药品名称
private String yaopinName;
//图片
private String pic;
//规格
private String gg;
//当前库存
private Integer num;
public String getYaopinName() {return yaopinName;}
public void setYaopinName(String yaopinName) {this.yaopinName = yaopinName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getGg() {return gg;}
public void setGg(String gg) {this.gg = gg;}
public Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
}药品进出详情javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//药品进出详情
public class Yaopinlist extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//药品名称
private Integer yaopinId;
//数量
private Integer sl;
//类型
private String types;
//日期
private Date showDate;
//负责人
private String fzr;
public Integer getYaopinId() {return yaopinId;}
public void setYaopinId(Integer yaopinId) {this.yaopinId = yaopinId;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
}医生javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//医生
public class Ys 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 ysName;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//岗位
private String js;
//科室
private Integer ksId;
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 getYsName() {return ysName;}
public void setYsName(String ysName) {this.ysName = ysName;}
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;}
public String getJs() {return js;}
public void setJs(String js) {this.js = js;}
public Integer getKsId() {return ksId;}
public void setKsId(Integer ksId) {this.ksId = ksId;}
}住院javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//住院
public class Zhuyuan extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//主治医生
private Integer ysId;
//住院日期
private Date beginDate;
//出院日期
private Date endDate;
//预付款
private Integer yfk;
//总费用
private Integer zje;
//拍照
private String pic;
//状态
private String status;
//
private String zhuyuanName;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getYsId() {return ysId;}
public void setYsId(Integer ysId) {this.ysId = ysId;}
public Date getBeginDate() {return beginDate;}
public void setBeginDate(Date beginDate) {this.beginDate = beginDate;}
public Date getEndDate() {return endDate;}
public void setEndDate(Date endDate) {this.endDate = endDate;}
public Integer getYfk() {return yfk;}
public void setYfk(Integer yfk) {this.yfk = yfk;}
public Integer getZje() {return zje;}
public void setZje(Integer zje) {this.zje = zje;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getZhuyuanName() {return zhuyuanName;}
public void setZhuyuanName(String zhuyuanName) {this.zhuyuanName = zhuyuanName;}
}住院医生查房记录javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//住院医生查房记录
public class Zhuyuanlist extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//住院
private Integer zhuyuanId;
//医生
private Integer ysId;
//查房日期
private Date showDate;
//内容记录
private String content;
public Integer getZhuyuanId() {return zhuyuanId;}
public void setZhuyuanId(Integer zhuyuanId) {this.zhuyuanId = zhuyuanId;}
public Integer getYsId() {return ysId;}
public void setYsId(Integer ysId) {this.ysId = ysId;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}