病案归档管理系统(xba16)_mysql

病案归档管理系统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');

病人表创建语句如下：


create table t_bingren(
	id int primary key auto_increment comment '主键',
	xm varchar(100) comment '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '',
	phone varchar(100) comment '电话',
	sr varchar(100) comment '生日',
	sfz varchar(100) comment '身份证',
	bs text comment '病史',
	ywgm text comment '药物过敏'
) comment '病人';

门诊表创建语句如下：


create table t_mz(
	id int primary key auto_increment comment '主键',
	bingrenId int comment '病人',
	showDate datetime comment '看病日期',
	ys varchar(100) comment '医生',
	ks varchar(100) comment '',
	jg text comment '诊断结果',
	pic varchar(100) comment '拍照',
	yaopin text comment '用药明细',
	fee int comment '价格',
	status varchar(100) comment '状态'
) comment '门诊';

档案申请表创建语句如下：


create table t_order(
	id int primary key auto_increment comment '主键',
	customerId int comment '申请人',
	title varchar(100) comment '申请标题',
	bingrenId int comment '病人',
	content text comment '说明',
	insertDate datetime comment '申请日期',
	status varchar(100) comment '状态',
	remark text comment '回复'
) comment '档案申请';

住院表创建语句如下：


create table t_zy(
	id int primary key auto_increment comment '主键',
	bingrenId int comment '病人',
	zybh varchar(100) comment '住院编号',
	showDate datetime comment '住院日期',
	endDate datetime comment '结束日期',
	ys varchar(100) comment '责任医生',
	cw varchar(100) comment '床位',
	zfy int comment '总费用',
	cyxj text comment '出院小结',
	status varchar(100) comment '状态'
) comment '住院';

住院明细表创建语句如下：


create table t_zylist(
	id int primary key auto_increment comment '主键',
	bingrenId int comment '病人',
	zyId int comment '住院主键',
	insertDate datetime comment '治疗日期',
	yaopin text comment '药品使用明细',
	yisheng varchar(100) comment '当日医生',
	jieguo text comment '检查结果',
	zt text comment '病人状态描述',
	fy int 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_bingren(
	id integer,
	xm varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100),
	sr varchar(100),
	sfz varchar(100),
	bs text,
	ywgm text
);
--病人字段加注释
comment on column t_bingren.id is '主键';
comment on column t_bingren.xm is '姓名';
comment on column t_bingren.age is '年龄';
comment on column t_bingren.sex is '';
comment on column t_bingren.phone is '电话';
comment on column t_bingren.sr is '生日';
comment on column t_bingren.sfz is '身份证';
comment on column t_bingren.bs is '病史';
comment on column t_bingren.ywgm is '药物过敏';
--病人表加注释
comment on table t_bingren is '病人';

门诊表创建语句如下：


create table t_mz(
	id integer,
	bingrenId int,
	showDate datetime,
	ys varchar(100),
	ks varchar(100),
	jg text,
	pic varchar(100),
	yaopin text,
	fee int,
	status varchar(100)
);
--门诊字段加注释
comment on column t_mz.id is '主键';
comment on column t_mz.bingrenId is '病人';
comment on column t_mz.showDate is '看病日期';
comment on column t_mz.ys is '医生';
comment on column t_mz.ks is '';
comment on column t_mz.jg is '诊断结果';
comment on column t_mz.pic is '拍照';
comment on column t_mz.yaopin is '用药明细';
comment on column t_mz.fee is '价格';
comment on column t_mz.status is '状态';
--门诊表加注释
comment on table t_mz is '门诊';

档案申请表创建语句如下：


create table t_order(
	id integer,
	customerId int,
	title varchar(100),
	bingrenId int,
	content text,
	insertDate datetime,
	status varchar(100),
	remark text
);
--档案申请字段加注释
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.bingrenId is '病人';
comment on column t_order.content is '说明';
comment on column t_order.insertDate is '申请日期';
comment on column t_order.status is '状态';
comment on column t_order.remark is '回复';
--档案申请表加注释
comment on table t_order is '档案申请';

住院表创建语句如下：


create table t_zy(
	id integer,
	bingrenId int,
	zybh varchar(100),
	showDate datetime,
	endDate datetime,
	ys varchar(100),
	cw varchar(100),
	zfy int,
	cyxj text,
	status varchar(100)
);
--住院字段加注释
comment on column t_zy.id is '主键';
comment on column t_zy.bingrenId is '病人';
comment on column t_zy.zybh is '住院编号';
comment on column t_zy.showDate is '住院日期';
comment on column t_zy.endDate is '结束日期';
comment on column t_zy.ys is '责任医生';
comment on column t_zy.cw is '床位';
comment on column t_zy.zfy is '总费用';
comment on column t_zy.cyxj is '出院小结';
comment on column t_zy.status is '状态';
--住院表加注释
comment on table t_zy is '住院';

住院明细表创建语句如下：


create table t_zylist(
	id integer,
	bingrenId int,
	zyId int,
	insertDate datetime,
	yaopin text,
	yisheng varchar(100),
	jieguo text,
	zt text,
	fy int
);
--住院明细字段加注释
comment on column t_zylist.id is '主键';
comment on column t_zylist.bingrenId is '病人';
comment on column t_zylist.zyId is '住院主键';
comment on column t_zylist.insertDate is '治疗日期';
comment on column t_zylist.yaopin is '药品使用明细';
comment on column t_zylist.yisheng is '当日医生';
comment on column t_zylist.jieguo is '检查结果';
comment on column t_zylist.zt is '病人状态描述';
comment on column t_zylist.fy is '当日费用';
--住院明细表加注释
comment on table t_zylist is '住院明细';

oracle特有，对应序列如下：


create sequence s_t_bingren;
create sequence s_t_mz;
create sequence s_t_order;
create sequence s_t_zy;
create sequence s_t_zylist;

病案归档管理系统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_bingren(
	id int identity(1,1) primary key not null,--主键
	xm varchar(100),--姓名
	age varchar(100),--年龄
	sex varchar(100),--
	phone varchar(100),--电话
	sr varchar(100),--生日
	sfz varchar(100),--身份证
	bs text,--病史
	ywgm text--药物过敏
);

门诊表创建语句如下：


--门诊表注释
create table t_mz(
	id int identity(1,1) primary key not null,--主键
	bingrenId int,--病人
	showDate datetime,--看病日期
	ys varchar(100),--医生
	ks varchar(100),--
	jg text,--诊断结果
	pic varchar(100),--拍照
	yaopin text,--用药明细
	fee int,--价格
	status varchar(100)--状态
);

档案申请表创建语句如下：


--档案申请表注释
create table t_order(
	id int identity(1,1) primary key not null,--主键
	customerId int,--申请人
	title varchar(100),--申请标题
	bingrenId int,--病人
	content text,--说明
	insertDate datetime,--申请日期
	status varchar(100),--状态
	remark text--回复
);

住院表创建语句如下：


--住院表注释
create table t_zy(
	id int identity(1,1) primary key not null,--主键
	bingrenId int,--病人
	zybh varchar(100),--住院编号
	showDate datetime,--住院日期
	endDate datetime,--结束日期
	ys varchar(100),--责任医生
	cw varchar(100),--床位
	zfy int,--总费用
	cyxj text,--出院小结
	status varchar(100)--状态
);

住院明细表创建语句如下：


--住院明细表注释
create table t_zylist(
	id int identity(1,1) primary key not null,--主键
	bingrenId int,--病人
	zyId int,--住院主键
	insertDate datetime,--治疗日期
	yaopin text,--药品使用明细
	yisheng varchar(100),--当日医生
	jieguo text,--检查结果
	zt text,--病人状态描述
	fy int--当日费用
);

病案归档管理系统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_bingren")
public class Bingren {
//主键
@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 xm;
//年龄
private String age;
//
private String sex;
//电话
private String phone;
//生日
private String sr;
//身份证
private String sfz;
//病史
private String bs;
//药物过敏
private String ywgm;
public String getXm() {return xm;}
public void setXm(String xm) {this.xm = xm;}
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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getSr() {return sr;}
public void setSr(String sr) {this.sr = sr;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public String getBs() {return bs;}
public void setBs(String bs) {this.bs = bs;}
public String getYwgm() {return ywgm;}
public void setYwgm(String ywgm) {this.ywgm = ywgm;}
}

门诊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_mz")
public class Mz {
//主键
@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 Long bingrenId;
//看病日期
private Date showDate;
//医生
private String ys;
//
private String ks;
//诊断结果
private String jg;
//拍照
private String pic;
//用药明细
private String yaopin;
//价格
private Integer fee;
//状态
private String status;
public Long getBingrenId() {return bingrenId;}
public void setBingrenId(Long bingrenId) {this.bingrenId = bingrenId;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getYs() {return ys;}
public void setYs(String ys) {this.ys = ys;}
public String getKs() {return ks;}
public void setKs(String ks) {this.ks = ks;}
public String getJg() {return jg;}
public void setJg(String jg) {this.jg = jg;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getYaopin() {return yaopin;}
public void setYaopin(String yaopin) {this.yaopin = yaopin;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
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 Long customerId;
//申请标题
private String title;
//病人
private Long bingrenId;
//说明
private String content;
//申请日期
private Date insertDate;
//状态
private String status;
//回复
private String remark;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Long getBingrenId() {return bingrenId;}
public void setBingrenId(Long bingrenId) {this.bingrenId = bingrenId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}

住院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_zy")
public class Zy {
//主键
@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 Long bingrenId;
//住院编号
private String zybh;
//住院日期
private Date showDate;
//结束日期
private Date endDate;
//责任医生
private String ys;
//床位
private String cw;
//总费用
private Integer zfy;
//出院小结
private String cyxj;
//状态
private String status;
public Long getBingrenId() {return bingrenId;}
public void setBingrenId(Long bingrenId) {this.bingrenId = bingrenId;}
public String getZybh() {return zybh;}
public void setZybh(String zybh) {this.zybh = zybh;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public Date getEndDate() {return endDate;}
public void setEndDate(Date endDate) {this.endDate = endDate;}
public String getYs() {return ys;}
public void setYs(String ys) {this.ys = ys;}
public String getCw() {return cw;}
public void setCw(String cw) {this.cw = cw;}
public Integer getZfy() {return zfy;}
public void setZfy(Integer zfy) {this.zfy = zfy;}
public String getCyxj() {return cyxj;}
public void setCyxj(String cyxj) {this.cyxj = cyxj;}
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_zylist")
public class Zylist {
//主键
@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 Long bingrenId;
//住院主键
private Long zyId;
//治疗日期
private Date insertDate;
//药品使用明细
private String yaopin;
//当日医生
private String yisheng;
//检查结果
private String jieguo;
//病人状态描述
private String zt;
//当日费用
private Integer fy;
public Long getBingrenId() {return bingrenId;}
public void setBingrenId(Long bingrenId) {this.bingrenId = bingrenId;}
public Long getZyId() {return zyId;}
public void setZyId(Long zyId) {this.zyId = zyId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getYaopin() {return yaopin;}
public void setYaopin(String yaopin) {this.yaopin = yaopin;}
public String getYisheng() {return yisheng;}
public void setYisheng(String yisheng) {this.yisheng = yisheng;}
public String getJieguo() {return jieguo;}
public void setJieguo(String jieguo) {this.jieguo = jieguo;}
public String getZt() {return zt;}
public void setZt(String zt) {this.zt = zt;}
public Integer getFy() {return fy;}
public void setFy(Integer fy) {this.fy = fy;}
}

病案归档管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：

病人javaBean创建语句如下：


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//病人
public class Bingren  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//姓名
private String xm;
//年龄
private String age;
//
private String sex;
//电话
private String phone;
//生日
@DateTimeFormat(pattern = "yyyy-MM-dd")
private String sr;
//身份证
private String sfz;
//病史
private String bs;
//药物过敏
private String ywgm;
public String getXm() {return xm;}
public void setXm(String xm) {this.xm = xm;}
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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getSr() {return sr;}
public void setSr(String sr) {this.sr = sr;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public String getBs() {return bs;}
public void setBs(String bs) {this.bs = bs;}
public String getYwgm() {return ywgm;}
public void setYwgm(String ywgm) {this.ywgm = ywgm;}
}

门诊javaBean创建语句如下：


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//门诊
public class Mz  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//病人
private Long bingrenId;
//看病日期
private Date showDate;
//医生
private String ys;
//
private String ks;
//诊断结果
private String jg;
//拍照
private String pic;
//用药明细
private String yaopin;
//价格
private Integer fee;
//状态
private String status;
public Long getBingrenId() {return bingrenId;}
public void setBingrenId(Long bingrenId) {this.bingrenId = bingrenId;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getYs() {return ys;}
public void setYs(String ys) {this.ys = ys;}
public String getKs() {return ks;}
public void setKs(String ks) {this.ks = ks;}
public String getJg() {return jg;}
public void setJg(String jg) {this.jg = jg;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getYaopin() {return yaopin;}
public void setYaopin(String yaopin) {this.yaopin = yaopin;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
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 Long customerId;
//申请标题
private String title;
//病人
private Long bingrenId;
//说明
private String content;
//申请日期
private Date insertDate;
//状态
private String status;
//回复
private String remark;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Long getBingrenId() {return bingrenId;}
public void setBingrenId(Long bingrenId) {this.bingrenId = bingrenId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}

住院javaBean创建语句如下：


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//住院
public class Zy  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//病人
private Long bingrenId;
//住院编号
private String zybh;
//住院日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
//结束日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date endDate;
//责任医生
private String ys;
//床位
private String cw;
//总费用
private Integer zfy;
//出院小结
private String cyxj;
//状态
private String status;
public Long getBingrenId() {return bingrenId;}
public void setBingrenId(Long bingrenId) {this.bingrenId = bingrenId;}
public String getZybh() {return zybh;}
public void setZybh(String zybh) {this.zybh = zybh;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public Date getEndDate() {return endDate;}
public void setEndDate(Date endDate) {this.endDate = endDate;}
public String getYs() {return ys;}
public void setYs(String ys) {this.ys = ys;}
public String getCw() {return cw;}
public void setCw(String cw) {this.cw = cw;}
public Integer getZfy() {return zfy;}
public void setZfy(Integer zfy) {this.zfy = zfy;}
public String getCyxj() {return cyxj;}
public void setCyxj(String cyxj) {this.cyxj = cyxj;}
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 Zylist  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//病人
private Long bingrenId;
//住院主键
private Long zyId;
//治疗日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date insertDate;
//药品使用明细
private String yaopin;
//当日医生
private String yisheng;
//检查结果
private String jieguo;
//病人状态描述
private String zt;
//当日费用
private Integer fy;
public Long getBingrenId() {return bingrenId;}
public void setBingrenId(Long bingrenId) {this.bingrenId = bingrenId;}
public Long getZyId() {return zyId;}
public void setZyId(Long zyId) {this.zyId = zyId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getYaopin() {return yaopin;}
public void setYaopin(String yaopin) {this.yaopin = yaopin;}
public String getYisheng() {return yisheng;}
public void setYisheng(String yisheng) {this.yisheng = yisheng;}
public String getJieguo() {return jieguo;}
public void setJieguo(String jieguo) {this.jieguo = jieguo;}
public String getZt() {return zt;}
public void setZt(String zt) {this.zt = zt;}
public Integer getFy() {return fy;}
public void setFy(Integer fy) {this.fy = fy;}
}

病案归档管理系统(xba16)_mysql_oracle代码分享

病案归档管理系统mysql数据库版本源码：

病案归档管理系统oracle数据库版本源码：

病案归档管理系统sqlserver数据库版本源码：

病案归档管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计：

病案归档管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：

相关毕业设计源码

评论