- 医院绩效评定系统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_cz(
id int primary key auto_increment comment '主键',
doctorId int comment '医生',
showDate datetime comment '出诊日期',
czbh varchar(100) comment '出诊编号',
ks varchar(100) comment '',
gh varchar(100) comment '病历编号',
xm varchar(100) comment '姓名',
nl varchar(100) comment '年龄',
xb varchar(100) comment '',
bingy text comment '病因',
yswz text comment '医生问诊'
) comment '出诊';
医生表创建语句如下:
create table t_doctor(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
doctorName varchar(100) comment '姓名',
headPic varchar(100) comment '头像',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '',
zc varchar(100) comment '职称',
zz varchar(100) comment '主治'
) comment '医生';
绩效评定表创建语句如下:
create table t_jixiao(
id int primary key auto_increment comment '主键',
doctorId int comment '医生',
v1 int comment '出诊评分',
v2 int comment '开药评分',
v3 varchar(100) comment '平均分',
yd varchar(100) comment '月度',
py text comment '评语'
) comment '绩效评定';
医生开药表创建语句如下:
create table t_kaiyao(
id int primary key auto_increment comment '主键',
czbh varchar(100) comment '出诊编号',
yaopinName varchar(100) comment '药品',
fee int comment '药品价格',
nums int comment '数量',
yf text comment '用法',
doctorId int comment '医生'
) comment '医生开药';
药品表创建语句如下:
create table t_yaopin(
id int primary key auto_increment comment '主键',
yaopinName varchar(100) comment '药品名称',
pic varchar(100) comment '图片',
fee varchar(100) comment '价格',
nums int comment '数量',
gn text 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_cz(
id integer,
doctorId int,
showDate datetime,
czbh varchar(100),
ks varchar(100),
gh varchar(100),
xm varchar(100),
nl varchar(100),
xb varchar(100),
bingy text,
yswz text
);
--出诊字段加注释
comment on column t_cz.id is '主键';
comment on column t_cz.doctorId is '医生';
comment on column t_cz.showDate is '出诊日期';
comment on column t_cz.czbh is '出诊编号';
comment on column t_cz.ks is '';
comment on column t_cz.gh is '病历编号';
comment on column t_cz.xm is '姓名';
comment on column t_cz.nl is '年龄';
comment on column t_cz.xb is '';
comment on column t_cz.bingy is '病因';
comment on column t_cz.yswz is '医生问诊';
--出诊表加注释
comment on table t_cz is '出诊';
医生表创建语句如下:
create table t_doctor(
id integer,
username varchar(100),
password varchar(100),
doctorName varchar(100),
headPic varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100),
zc varchar(100),
zz varchar(100)
);
--医生字段加注释
comment on column t_doctor.id is '主键';
comment on column t_doctor.username is '账号';
comment on column t_doctor.password is '密码';
comment on column t_doctor.doctorName is '姓名';
comment on column t_doctor.headPic is '头像';
comment on column t_doctor.phone is '电话';
comment on column t_doctor.age is '年龄';
comment on column t_doctor.sex is '';
comment on column t_doctor.zc is '职称';
comment on column t_doctor.zz is '主治';
--医生表加注释
comment on table t_doctor is '医生';
绩效评定表创建语句如下:
create table t_jixiao(
id integer,
doctorId int,
v1 int,
v2 int,
v3 varchar(100),
yd varchar(100),
py text
);
--绩效评定字段加注释
comment on column t_jixiao.id is '主键';
comment on column t_jixiao.doctorId is '医生';
comment on column t_jixiao.v1 is '出诊评分';
comment on column t_jixiao.v2 is '开药评分';
comment on column t_jixiao.v3 is '平均分';
comment on column t_jixiao.yd is '月度';
comment on column t_jixiao.py is '评语';
--绩效评定表加注释
comment on table t_jixiao is '绩效评定';
医生开药表创建语句如下:
create table t_kaiyao(
id integer,
czbh varchar(100),
yaopinName varchar(100),
fee int,
nums int,
yf text,
doctorId int
);
--医生开药字段加注释
comment on column t_kaiyao.id is '主键';
comment on column t_kaiyao.czbh is '出诊编号';
comment on column t_kaiyao.yaopinName is '药品';
comment on column t_kaiyao.fee is '药品价格';
comment on column t_kaiyao.nums is '数量';
comment on column t_kaiyao.yf is '用法';
comment on column t_kaiyao.doctorId is '医生';
--医生开药表加注释
comment on table t_kaiyao is '医生开药';
药品表创建语句如下:
create table t_yaopin(
id integer,
yaopinName varchar(100),
pic varchar(100),
fee varchar(100),
nums int,
gn text
);
--药品字段加注释
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.fee is '价格';
comment on column t_yaopin.nums is '数量';
comment on column t_yaopin.gn is '功能说明';
--药品表加注释
comment on table t_yaopin is '药品';
oracle特有,对应序列如下:
create sequence s_t_cz;
create sequence s_t_doctor;
create sequence s_t_jixiao;
create sequence s_t_kaiyao;
create sequence s_t_yaopin;
医院绩效评定系统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_cz(
id int identity(1,1) primary key not null,--主键
doctorId int,--医生
showDate datetime,--出诊日期
czbh varchar(100),--出诊编号
ks varchar(100),--
gh varchar(100),--病历编号
xm varchar(100),--姓名
nl varchar(100),--年龄
xb varchar(100),--
bingy text,--病因
yswz text--医生问诊
);
医生表创建语句如下:
--医生表注释
create table t_doctor(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
doctorName varchar(100),--姓名
headPic varchar(100),--头像
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100),--
zc varchar(100),--职称
zz varchar(100)--主治
);
绩效评定表创建语句如下:
--绩效评定表注释
create table t_jixiao(
id int identity(1,1) primary key not null,--主键
doctorId int,--医生
v1 int,--出诊评分
v2 int,--开药评分
v3 varchar(100),--平均分
yd varchar(100),--月度
py text--评语
);
医生开药表创建语句如下:
--医生开药表注释
create table t_kaiyao(
id int identity(1,1) primary key not null,--主键
czbh varchar(100),--出诊编号
yaopinName varchar(100),--药品
fee int,--药品价格
nums int,--数量
yf text,--用法
doctorId int--医生
);
药品表创建语句如下:
--药品表注释
create table t_yaopin(
id int identity(1,1) primary key not null,--主键
yaopinName varchar(100),--药品名称
pic varchar(100),--图片
fee varchar(100),--价格
nums int,--数量
gn text--功能说明
);
医院绩效评定系统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_cz")
public class Cz {
//主键
@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 doctorId;
//出诊日期
private Date showDate;
//出诊编号
private String czbh;
//
private String ks;
//病历编号
private String gh;
//姓名
private String xm;
//年龄
private String nl;
//
private String xb;
//病因
private String bingy;
//医生问诊
private String yswz;
public Long getDoctorId() {return doctorId;}
public void setDoctorId(Long doctorId) {this.doctorId = doctorId;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getCzbh() {return czbh;}
public void setCzbh(String czbh) {this.czbh = czbh;}
public String getKs() {return ks;}
public void setKs(String ks) {this.ks = ks;}
public String getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
public String getXm() {return xm;}
public void setXm(String xm) {this.xm = xm;}
public String getNl() {return nl;}
public void setNl(String nl) {this.nl = nl;}
public String getXb() {return xb;}
public void setXb(String xb) {this.xb = xb;}
public String getBingy() {return bingy;}
public void setBingy(String bingy) {this.bingy = bingy;}
public String getYswz() {return yswz;}
public void setYswz(String yswz) {this.yswz = yswz;}
}
医生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_doctor")
public class Doctor {
//主键
@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 doctorName;
//头像
private String headPic;
//电话
private String phone;
//年龄
private String age;
//
private String sex;
//职称
private String zc;
//主治
private String zz;
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 getDoctorName() {return doctorName;}
public void setDoctorName(String doctorName) {this.doctorName = doctorName;}
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;}
public String getZc() {return zc;}
public void setZc(String zc) {this.zc = zc;}
public String getZz() {return zz;}
public void setZz(String zz) {this.zz = zz;}
}
绩效评定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_jixiao")
public class Jixiao {
//主键
@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 doctorId;
//出诊评分
private Integer v1;
//开药评分
private Integer v2;
//平均分
private String v3;
//月度
private String yd;
//评语
private String py;
public Long getDoctorId() {return doctorId;}
public void setDoctorId(Long doctorId) {this.doctorId = doctorId;}
public Integer getV1() {return v1;}
public void setV1(Integer v1) {this.v1 = v1;}
public Integer getV2() {return v2;}
public void setV2(Integer v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getYd() {return yd;}
public void setYd(String yd) {this.yd = yd;}
public String getPy() {return py;}
public void setPy(String py) {this.py = py;}
}
医生开药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_kaiyao")
public class Kaiyao {
//主键
@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 czbh;
//药品
private String yaopinName;
//药品价格
private Integer fee;
//数量
private Integer nums;
//用法
private String yf;
//医生
private Long doctorId;
public String getCzbh() {return czbh;}
public void setCzbh(String czbh) {this.czbh = czbh;}
public String getYaopinName() {return yaopinName;}
public void setYaopinName(String yaopinName) {this.yaopinName = yaopinName;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public Integer getNums() {return nums;}
public void setNums(Integer nums) {this.nums = nums;}
public String getYf() {return yf;}
public void setYf(String yf) {this.yf = yf;}
public Long getDoctorId() {return doctorId;}
public void setDoctorId(Long doctorId) {this.doctorId = doctorId;}
}
药品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 fee;
//数量
private Integer nums;
//功能说明
private String gn;
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 getFee() {return fee;}
public void setFee(String fee) {this.fee = fee;}
public Integer getNums() {return nums;}
public void setNums(Integer nums) {this.nums = nums;}
public String getGn() {return gn;}
public void setGn(String gn) {this.gn = gn;}
}
医院绩效评定系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计:
出诊javaBean创建语句如下:
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//出诊
public class Cz extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//医生
private Long doctorId;
//出诊日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
//出诊编号
private String czbh;
//
private String ks;
//病历编号
private String gh;
//姓名
private String xm;
//年龄
private String nl;
//
private String xb;
//病因
private String bingy;
//医生问诊
private String yswz;
public Long getDoctorId() {return doctorId;}
public void setDoctorId(Long doctorId) {this.doctorId = doctorId;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getCzbh() {return czbh;}
public void setCzbh(String czbh) {this.czbh = czbh;}
public String getKs() {return ks;}
public void setKs(String ks) {this.ks = ks;}
public String getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
public String getXm() {return xm;}
public void setXm(String xm) {this.xm = xm;}
public String getNl() {return nl;}
public void setNl(String nl) {this.nl = nl;}
public String getXb() {return xb;}
public void setXb(String xb) {this.xb = xb;}
public String getBingy() {return bingy;}
public void setBingy(String bingy) {this.bingy = bingy;}
public String getYswz() {return yswz;}
public void setYswz(String yswz) {this.yswz = yswz;}
}
医生javaBean创建语句如下:
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//医生
public class Doctor 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 doctorName;
//头像
private String headPic;
//电话
private String phone;
//年龄
private String age;
//
private String sex;
//职称
private String zc;
//主治
private String zz;
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 getDoctorName() {return doctorName;}
public void setDoctorName(String doctorName) {this.doctorName = doctorName;}
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;}
public String getZc() {return zc;}
public void setZc(String zc) {this.zc = zc;}
public String getZz() {return zz;}
public void setZz(String zz) {this.zz = zz;}
}
绩效评定javaBean创建语句如下:
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//绩效评定
public class Jixiao extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//医生
private Long doctorId;
//出诊评分
private Integer v1;
//开药评分
private Integer v2;
//平均分
private String v3;
//月度
@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
private String yd;
//评语
private String py;
public Long getDoctorId() {return doctorId;}
public void setDoctorId(Long doctorId) {this.doctorId = doctorId;}
public Integer getV1() {return v1;}
public void setV1(Integer v1) {this.v1 = v1;}
public Integer getV2() {return v2;}
public void setV2(Integer v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getYd() {return yd;}
public void setYd(String yd) {this.yd = yd;}
public String getPy() {return py;}
public void setPy(String py) {this.py = py;}
}
医生开药javaBean创建语句如下:
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//医生开药
public class Kaiyao extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//出诊编号
private String czbh;
//药品
private String yaopinName;
//药品价格
private Integer fee;
//数量
private Integer nums;
//用法
private String yf;
//医生
private Long doctorId;
public String getCzbh() {return czbh;}
public void setCzbh(String czbh) {this.czbh = czbh;}
public String getYaopinName() {return yaopinName;}
public void setYaopinName(String yaopinName) {this.yaopinName = yaopinName;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public Integer getNums() {return nums;}
public void setNums(Integer nums) {this.nums = nums;}
public String getYf() {return yf;}
public void setYf(String yf) {this.yf = yf;}
public Long getDoctorId() {return doctorId;}
public void setDoctorId(Long doctorId) {this.doctorId = doctorId;}
}
药品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 fee;
//数量
private Integer nums;
//功能说明
private String gn;
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 getFee() {return fee;}
public void setFee(String fee) {this.fee = fee;}
public Integer getNums() {return nums;}
public void setNums(Integer nums) {this.nums = nums;}
public String getGn() {return gn;}
public void setGn(String gn) {this.gn = gn;}
}