- 医院药物管理信息系统的设计与开发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 '姓名',
jzh varchar(100) comment '就诊号',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
zdjb varchar(100) comment '重大疾病',
gmyw varchar(100) 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 '姓名',
gh varchar(100) comment '工号',
ks varchar(100) comment '科室',
zc varchar(100) comment '职称'
) comment '医生';
药房管理员表创建语句如下：
create table t_yaofang(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
yaofangName varchar(100) comment '姓名',
gh varchar(100) comment '工号'
) comment '药房管理员';
药物表创建语句如下：
create table t_yaowu(
id int primary key auto_increment comment '主键',
yaoName varchar(100) comment '药物名称',
ywbh varchar(100) comment '药物编号',
szm varchar(100) comment '首字母',
num int comment '在库量',
v1 varchar(100) comment '成分说明',
v2 varchar(100) comment '治疗疾病',
v3 varchar(100) comment '剂量',
v4 varchar(100) comment '可能致敏物',
yl int comment '用药量（输入数字）',
dw varchar(100) comment '用量单位'
) comment '药物';
药物进出记录表创建语句如下：
create table t_yaowulist(
id int primary key auto_increment comment '主键',
yaowuId int comment '药品',
types varchar(100) comment '出库入库',
nums int comment '数量',
insertDate datetime comment '日期',
fzr varchar(100) comment '负责人'
) comment '药物进出记录';
药物单表创建语句如下：
create table t_ywd(
id int primary key auto_increment comment '主键',
doctorId int comment '医生',
customerId int comment '患者',
ywdName varchar(100) comment '药物单说明',
insertDate datetime comment '日期',
STATUS varchar(100) comment '状态'
) comment '药物单';
药物单列表表创建语句如下：
create table t_ywdlist(
id int primary key auto_increment comment '主键',
ywdId int comment '药物单',
yaowuId int comment '药品',
sl int comment '数量',
syjl 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_customer(
id integer,
username varchar(100),
password varchar(100),
customerName varchar(100),
jzh varchar(100),
age varchar(100),
sex varchar(100),
zdjb varchar(100),
gmyw 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.jzh is '就诊号';
comment on column t_customer.age is '年龄';
comment on column t_customer.sex is '性别';
comment on column t_customer.zdjb is '重大疾病';
comment on column t_customer.gmyw is '过敏药物';
--患者表加注释
comment on table t_customer is '患者';
医生表创建语句如下：
create table t_doctor(
id integer,
username varchar(100),
password varchar(100),
doctorName varchar(100),
gh varchar(100),
ks varchar(100),
zc 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.gh is '工号';
comment on column t_doctor.ks is '科室';
comment on column t_doctor.zc is '职称';
--医生表加注释
comment on table t_doctor is '医生';
药房管理员表创建语句如下：
create table t_yaofang(
id integer,
username varchar(100),
password varchar(100),
yaofangName varchar(100),
gh varchar(100)
);
--药房管理员字段加注释
comment on column t_yaofang.id is '主键';
comment on column t_yaofang.username is '账号';
comment on column t_yaofang.password is '密码';
comment on column t_yaofang.yaofangName is '姓名';
comment on column t_yaofang.gh is '工号';
--药房管理员表加注释
comment on table t_yaofang is '药房管理员';
药物表创建语句如下：
create table t_yaowu(
id integer,
yaoName varchar(100),
ywbh varchar(100),
szm varchar(100),
num int,
v1 varchar(100),
v2 varchar(100),
v3 varchar(100),
v4 varchar(100),
yl int,
dw varchar(100)
);
--药物字段加注释
comment on column t_yaowu.id is '主键';
comment on column t_yaowu.yaoName is '药物名称';
comment on column t_yaowu.ywbh is '药物编号';
comment on column t_yaowu.szm is '首字母';
comment on column t_yaowu.num is '在库量';
comment on column t_yaowu.v1 is '成分说明';
comment on column t_yaowu.v2 is '治疗疾病';
comment on column t_yaowu.v3 is '剂量';
comment on column t_yaowu.v4 is '可能致敏物';
comment on column t_yaowu.yl is '用药量（输入数字）';
comment on column t_yaowu.dw is '用量单位';
--药物表加注释
comment on table t_yaowu is '药物';
药物进出记录表创建语句如下：
create table t_yaowulist(
id integer,
yaowuId int,
types varchar(100),
nums int,
insertDate datetime,
fzr varchar(100)
);
--药物进出记录字段加注释
comment on column t_yaowulist.id is '主键';
comment on column t_yaowulist.yaowuId is '药品';
comment on column t_yaowulist.types is '出库入库';
comment on column t_yaowulist.nums is '数量';
comment on column t_yaowulist.insertDate is '日期';
comment on column t_yaowulist.fzr is '负责人';
--药物进出记录表加注释
comment on table t_yaowulist is '药物进出记录';
药物单表创建语句如下：
create table t_ywd(
id integer,
doctorId int,
customerId int,
ywdName varchar(100),
insertDate datetime,
STATUS varchar(100)
);
--药物单字段加注释
comment on column t_ywd.id is '主键';
comment on column t_ywd.doctorId is '医生';
comment on column t_ywd.customerId is '患者';
comment on column t_ywd.ywdName is '药物单说明';
comment on column t_ywd.insertDate is '日期';
comment on column t_ywd.STATUS is '状态';
--药物单表加注释
comment on table t_ywd is '药物单';
药物单列表表创建语句如下：
create table t_ywdlist(
id integer,
ywdId int,
yaowuId int,
sl int,
syjl int
);
--药物单列表字段加注释
comment on column t_ywdlist.id is '主键';
comment on column t_ywdlist.ywdId is '药物单';
comment on column t_ywdlist.yaowuId is '药品';
comment on column t_ywdlist.sl is '数量';
comment on column t_ywdlist.syjl is '使用剂量';
--药物单列表表加注释
comment on table t_ywdlist is '药物单列表';
oracle特有，对应序列如下：
create sequence s_t_customer;
create sequence s_t_doctor;
create sequence s_t_yaofang;
create sequence s_t_yaowu;
create sequence s_t_yaowulist;
create sequence s_t_ywd;
create sequence s_t_ywdlist;
医院药物管理信息系统的设计与开发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),--姓名
jzh varchar(100),--就诊号
age varchar(100),--年龄
sex varchar(100),--性别
zdjb varchar(100),--重大疾病
gmyw varchar(100)--过敏药物
);
医生表创建语句如下：
--医生表注释
create table t_doctor(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
doctorName varchar(100),--姓名
gh varchar(100),--工号
ks varchar(100),--科室
zc varchar(100)--职称
);
药房管理员表创建语句如下：
--药房管理员表注释
create table t_yaofang(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
yaofangName varchar(100),--姓名
gh varchar(100)--工号
);
药物表创建语句如下：
--药物表注释
create table t_yaowu(
id int identity(1,1) primary key not null,--主键
yaoName varchar(100),--药物名称
ywbh varchar(100),--药物编号
szm varchar(100),--首字母
num int,--在库量
v1 varchar(100),--成分说明
v2 varchar(100),--治疗疾病
v3 varchar(100),--剂量
v4 varchar(100),--可能致敏物
yl int,--用药量（输入数字）
dw varchar(100)--用量单位
);
药物进出记录表创建语句如下：
--药物进出记录表注释
create table t_yaowulist(
id int identity(1,1) primary key not null,--主键
yaowuId int,--药品
types varchar(100),--出库入库
nums int,--数量
insertDate datetime,--日期
fzr varchar(100)--负责人
);
药物单表创建语句如下：
--药物单表注释
create table t_ywd(
id int identity(1,1) primary key not null,--主键
doctorId int,--医生
customerId int,--患者
ywdName varchar(100),--药物单说明
insertDate datetime,--日期
STATUS varchar(100)--状态
);
药物单列表表创建语句如下：
--药物单列表表注释
create table t_ywdlist(
id int identity(1,1) primary key not null,--主键
ywdId int,--药物单
yaowuId int,--药品
sl int,--数量
syjl int--使用剂量
);
登录后主页.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 jzh;
//年龄
private String age;
//性别
private String sex;
//重大疾病
private String zdjb;
//过敏药物
private String gmyw;
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 getJzh() {return jzh;}
public void setJzh(String jzh) {this.jzh = jzh;}
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 getZdjb() {return zdjb;}
public void setZdjb(String zdjb) {this.zdjb = zdjb;}
public String getGmyw() {return gmyw;}
public void setGmyw(String gmyw) {this.gmyw = gmyw;}
}医生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 gh;
//科室
private String ks;
//职称
private String zc;
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 getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
public String getKs() {return ks;}
public void setKs(String ks) {this.ks = ks;}
public String getZc() {return zc;}
public void setZc(String zc) {this.zc = zc;}
}药房管理员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_yaofang")
public class Yaofang {
//主键
@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 yaofangName;
//工号
private String gh;
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 getYaofangName() {return yaofangName;}
public void setYaofangName(String yaofangName) {this.yaofangName = yaofangName;}
public String getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
}药物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_yaowu")
public class Yaowu {
//主键
@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 yaoName;
//药物编号
private String ywbh;
//首字母
private String szm;
//在库量
private Integer num;
//成分说明
private String v1;
//治疗疾病
private String v2;
//剂量
private String v3;
//可能致敏物
private String v4;
//用药量（输入数字）
private Integer yl;
//用量单位
private String dw;
public String getYaoName() {return yaoName;}
public void setYaoName(String yaoName) {this.yaoName = yaoName;}
public String getYwbh() {return ywbh;}
public void setYwbh(String ywbh) {this.ywbh = ywbh;}
public String getSzm() {return szm;}
public void setSzm(String szm) {this.szm = szm;}
public Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
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 Integer getYl() {return yl;}
public void setYl(Integer yl) {this.yl = yl;}
public String getDw() {return dw;}
public void setDw(String dw) {this.dw = dw;}
}药物进出记录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_yaowulist")
public class Yaowulist {
//主键
@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 yaowuId;
//出库入库
private String types;
//数量
private Integer nums;
//日期
private Date insertDate;
//负责人
private String fzr;
public Integer getYaowuId() {return yaowuId;}
public void setYaowuId(Integer yaowuId) {this.yaowuId = yaowuId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Integer getNums() {return nums;}
public void setNums(Integer nums) {this.nums = nums;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
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_ywd")
public class Ywd {
//主键
@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 doctorId;
//患者
private Integer customerId;
//药物单说明
private String ywdName;
//日期
private Date insertDate;
//状态
private String STATUS;
public Integer getDoctorId() {return doctorId;}
public void setDoctorId(Integer doctorId) {this.doctorId = doctorId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getYwdName() {return ywdName;}
public void setYwdName(String ywdName) {this.ywdName = ywdName;}
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;}
}药物单列表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_ywdlist")
public class Ywdlist {
//主键
@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 ywdId;
//药品
private Integer yaowuId;
//数量
private Integer sl;
//使用剂量
private Integer syjl;
public Integer getYwdId() {return ywdId;}
public void setYwdId(Integer ywdId) {this.ywdId = ywdId;}
public Integer getYaowuId() {return yaowuId;}
public void setYaowuId(Integer yaowuId) {this.yaowuId = yaowuId;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
public Integer getSyjl() {return syjl;}
public void setSyjl(Integer syjl) {this.syjl = syjl;}
}医院药物管理信息系统的设计与开发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 jzh;
//年龄
private String age;
//性别
private String sex;
//重大疾病
private String zdjb;
//过敏药物
private String gmyw;
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 getJzh() {return jzh;}
public void setJzh(String jzh) {this.jzh = jzh;}
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 getZdjb() {return zdjb;}
public void setZdjb(String zdjb) {this.zdjb = zdjb;}
public String getGmyw() {return gmyw;}
public void setGmyw(String gmyw) {this.gmyw = gmyw;}
}医生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 gh;
//科室
private String ks;
//职称
private String zc;
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 getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
public String getKs() {return ks;}
public void setKs(String ks) {this.ks = ks;}
public String getZc() {return zc;}
public void setZc(String zc) {this.zc = zc;}
}药房管理员javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//药房管理员
public class Yaofang 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 yaofangName;
//工号
private String gh;
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 getYaofangName() {return yaofangName;}
public void setYaofangName(String yaofangName) {this.yaofangName = yaofangName;}
public String getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
}药物javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//药物
public class Yaowu extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//药物名称
private String yaoName;
//药物编号
private String ywbh;
//首字母
private String szm;
//在库量
private Integer num;
//成分说明
private String v1;
//治疗疾病
private String v2;
//剂量
private String v3;
//可能致敏物
private String v4;
//用药量（输入数字）
private Integer yl;
//用量单位
private String dw;
public String getYaoName() {return yaoName;}
public void setYaoName(String yaoName) {this.yaoName = yaoName;}
public String getYwbh() {return ywbh;}
public void setYwbh(String ywbh) {this.ywbh = ywbh;}
public String getSzm() {return szm;}
public void setSzm(String szm) {this.szm = szm;}
public Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
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 Integer getYl() {return yl;}
public void setYl(Integer yl) {this.yl = yl;}
public String getDw() {return dw;}
public void setDw(String dw) {this.dw = dw;}
}药物进出记录javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//药物进出记录
public class Yaowulist extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//药品
private Integer yaowuId;
//出库入库
private String types;
//数量
private Integer nums;
//日期
private Date insertDate;
//负责人
private String fzr;
public Integer getYaowuId() {return yaowuId;}
public void setYaowuId(Integer yaowuId) {this.yaowuId = yaowuId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Integer getNums() {return nums;}
public void setNums(Integer nums) {this.nums = nums;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
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 Ywd extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//医生
private Integer doctorId;
//患者
private Integer customerId;
//药物单说明
private String ywdName;
//日期
private Date insertDate;
//状态
private String STATUS;
public Integer getDoctorId() {return doctorId;}
public void setDoctorId(Integer doctorId) {this.doctorId = doctorId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getYwdName() {return ywdName;}
public void setYwdName(String ywdName) {this.ywdName = ywdName;}
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;}
}药物单列表javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//药物单列表
public class Ywdlist extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//药物单
private Integer ywdId;
//药品
private Integer yaowuId;
//数量
private Integer sl;
//使用剂量
private Integer syjl;
public Integer getYwdId() {return ywdId;}
public void setYwdId(Integer ywdId) {this.ywdId = ywdId;}
public Integer getYaowuId() {return yaowuId;}
public void setYaowuId(Integer yaowuId) {this.yaowuId = yaowuId;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
public Integer getSyjl() {return syjl;}
public void setSyjl(Integer syjl) {this.syjl = syjl;}
}