电子病历管理系统的设计与实现(dianzibingli),优秀java设计

电子病历管理系统的设计与实现登录注册界面

电子病历管理系统的设计与实现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_bl(
	id int primary key auto_increment comment '主键',
	br int comment '病人',
	blbh varchar(100) comment '病历编号',
	ksId int comment '科室',
	v1 varchar(100) comment '日期',
	v2 varchar(100) comment '内容',
	v3 varchar(100) comment '备注'
) comment '病历';

病历管理员表创建语句如下:


create table t_blgly(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	blglyName varchar(100) comment '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话'
) comment '病历管理员';

病人表创建语句如下:


create table t_br(
	id int primary key auto_increment comment '主键',
	ysId int comment '医生',
	brName varchar(100) comment '姓名',
	v1 varchar(100) comment '性别',
	v2 varchar(100) comment '身份证',
	v3 varchar(100) comment '年龄',
	v4 varchar(100) comment '住址',
	v5 varchar(100) comment '电话'
) comment '病人';

科室表创建语句如下:


create table t_ks(
	id int primary key auto_increment comment '主键',
	ksName 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 '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话',
	v1 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_bl(
	id integer,
	br int,
	blbh varchar(100),
	ksId int,
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100)
);
--病历字段加注释
comment on column t_bl.id is '主键';
comment on column t_bl.br is '病人';
comment on column t_bl.blbh is '病历编号';
comment on column t_bl.ksId is '科室';
comment on column t_bl.v1 is '日期';
comment on column t_bl.v2 is '内容';
comment on column t_bl.v3 is '备注';
--病历表加注释
comment on table t_bl is '病历';

病历管理员表创建语句如下:


create table t_blgly(
	id integer,
	username varchar(100),
	password varchar(100),
	blglyName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100)
);
--病历管理员字段加注释
comment on column t_blgly.id is '主键';
comment on column t_blgly.username is '账号';
comment on column t_blgly.password is '密码';
comment on column t_blgly.blglyName is '姓名';
comment on column t_blgly.age is '年龄';
comment on column t_blgly.sex is '性别';
comment on column t_blgly.phone is '电话';
--病历管理员表加注释
comment on table t_blgly is '病历管理员';

病人表创建语句如下:


create table t_br(
	id integer,
	ysId int,
	brName varchar(100),
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	v4 varchar(100),
	v5 varchar(100)
);
--病人字段加注释
comment on column t_br.id is '主键';
comment on column t_br.ysId is '医生';
comment on column t_br.brName is '姓名';
comment on column t_br.v1 is '性别';
comment on column t_br.v2 is '身份证';
comment on column t_br.v3 is '年龄';
comment on column t_br.v4 is '住址';
comment on column t_br.v5 is '电话';
--病人表加注释
comment on table t_br 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_ys(
	id integer,
	username varchar(100),
	password varchar(100),
	ysName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100),
	v1 varchar(100)
);
--医生字段加注释
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.age is '年龄';
comment on column t_ys.sex is '性别';
comment on column t_ys.phone is '电话';
comment on column t_ys.v1 is '所有病历权限';
--医生表加注释
comment on table t_ys is '医生';

oracle特有,对应序列如下:


create sequence s_t_bl;
create sequence s_t_blgly;
create sequence s_t_br;
create sequence s_t_ks;
create sequence s_t_ys;

电子病历管理系统的设计与实现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_bl(
	id int identity(1,1) primary key not null,--主键
	br int,--病人
	blbh varchar(100),--病历编号
	ksId int,--科室
	v1 varchar(100),--日期
	v2 varchar(100),--内容
	v3 varchar(100)--备注
);

病历管理员表创建语句如下:


--病历管理员表注释
create table t_blgly(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	blglyName varchar(100),--姓名
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100)--电话
);

病人表创建语句如下:


--病人表注释
create table t_br(
	id int identity(1,1) primary key not null,--主键
	ysId int,--医生
	brName varchar(100),--姓名
	v1 varchar(100),--性别
	v2 varchar(100),--身份证
	v3 varchar(100),--年龄
	v4 varchar(100),--住址
	v5 varchar(100)--电话
);

科室表创建语句如下:


--科室表注释
create table t_ks(
	id int identity(1,1) primary key not null,--主键
	ksName varchar(100)--科室
);

医生表创建语句如下:


--医生表注释
create table t_ys(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	ysName varchar(100),--姓名
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100),--电话
	v1 varchar(100)--所有病历权限
);

电子病历管理系统的设计与实现登录后主页

电子病历管理系统的设计与实现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_bl")
public class Bl {
//主键
@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 br;
//病历编号
private String blbh;
//科室
private Integer ksId;
//日期
private String v1;
//内容
private String v2;
//备注
private String v3;
public Integer getBr() {return br;}
public void setBr(Integer br) {this.br = br;}
public String getBlbh() {return blbh;}
public void setBlbh(String blbh) {this.blbh = blbh;}
public Integer getKsId() {return ksId;}
public void setKsId(Integer ksId) {this.ksId = ksId;}
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;}
}

病历管理员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_blgly")
public class Blgly {
//主键
@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 blglyName;
//年龄
private String age;
//性别
private String sex;
//电话
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 getBlglyName() {return blglyName;}
public void setBlglyName(String blglyName) {this.blglyName = blglyName;}
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;}
}

病人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 Integer ysId;
//姓名
private String brName;
//性别
private String v1;
//身份证
private String v2;
//年龄
private String v3;
//住址
private String v4;
//电话
private String v5;
public Integer getYsId() {return ysId;}
public void setYsId(Integer ysId) {this.ysId = ysId;}
public String getBrName() {return brName;}
public void setBrName(String brName) {this.brName = brName;}
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;}
}

科室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_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 age;
//性别
private String sex;
//电话
private String phone;
//所有病历权限
private String v1;
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 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 getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
}

电子病历管理系统的设计与实现spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

病历javaBean创建语句如下:


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

//病历
public class Bl  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//病人
private Integer br;
//病历编号
private String blbh;
//科室
private Integer ksId;
//日期
private String v1;
//内容
private String v2;
//备注
private String v3;
public Integer getBr() {return br;}
public void setBr(Integer br) {this.br = br;}
public String getBlbh() {return blbh;}
public void setBlbh(String blbh) {this.blbh = blbh;}
public Integer getKsId() {return ksId;}
public void setKsId(Integer ksId) {this.ksId = ksId;}
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;}
}

病历管理员javaBean创建语句如下:


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

//病历管理员
public class Blgly  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 blglyName;
//年龄
private String age;
//性别
private String sex;
//电话
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 getBlglyName() {return blglyName;}
public void setBlglyName(String blglyName) {this.blglyName = blglyName;}
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;}
}

病人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 Integer ysId;
//姓名
private String brName;
//性别
private String v1;
//身份证
private String v2;
//年龄
private String v3;
//住址
private String v4;
//电话
private String v5;
public Integer getYsId() {return ysId;}
public void setYsId(Integer ysId) {this.ysId = ysId;}
public String getBrName() {return brName;}
public void setBrName(String brName) {this.brName = brName;}
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;}
}

科室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 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 age;
//性别
private String sex;
//电话
private String phone;
//所有病历权限
private String v1;
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 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 getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
}

源代码下载点这里

评论