- 个人健康档案管理系统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 '姓名',
headPic varchar(100) comment '头像',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别'
) comment '用户';
用户申请表创建语句如下：
create table t_sq(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
title varchar(100) comment '申请标题',
content varchar(100) comment '申请内容',
pic varchar(100) comment '图片',
insertDate datetime comment '日期',
back varchar(100) comment '回复',
STATUS varchar(100) comment '状态'
) comment '用户申请';
医院表创建语句如下：
create table t_yy(
id int primary key auto_increment comment '主键',
yyName varchar(100) comment '医院名称',
lx varchar(100) comment '类型',
address varchar(100) comment '地址',
zz varchar(100) comment '医院主治'
) comment '医院';
用户就诊表创建语句如下：
create table t_yyjz(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
yyId int comment '医院',
yyksId int comment '科室',
showDate datetime comment '就诊日期',
ys varchar(100) comment '医生',
bq varchar(100) comment '病情',
back varchar(100) comment '医生诊断内容',
yw varchar(100) comment '药物记录',
fee int comment '金额'
) comment '用户就诊';
医院科室表创建语句如下：
create table t_yyks(
id int primary key auto_increment comment '主键',
yyId int comment '医院',
yyksName varchar(100) comment '科室名称',
content varchar(100) comment '详细说明'
) comment '医院科室';
用户用药表创建语句如下：
create table t_yyyy(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
yyId int comment '医院',
ypName varchar(100) comment '药品名称',
jl varchar(100) comment '剂量',
fee int comment '金额'
) comment '用户用药';
用户住院表创建语句如下：
create table t_yyzy(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
yyId int comment '医院',
showDate datetime comment '住院日期',
ys varchar(100) comment '看护医生',
bq varchar(100) comment '病情',
back varchar(100) comment '医生诊断内容',
yw varchar(100) comment '药物记录',
fee int comment '金额',
cyDate datetime 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),
headPic varchar(100),
phone varchar(100),
age varchar(100),
sex 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.headPic is '头像';
comment on column t_customer.phone is '电话';
comment on column t_customer.age is '年龄';
comment on column t_customer.sex is '性别';
--用户表加注释
comment on table t_customer is '用户';
用户申请表创建语句如下：
create table t_sq(
id integer,
customerId int,
title varchar(100),
content varchar(100),
pic varchar(100),
insertDate datetime,
back varchar(100),
STATUS varchar(100)
);
--用户申请字段加注释
comment on column t_sq.id is '主键';
comment on column t_sq.customerId is '用户';
comment on column t_sq.title is '申请标题';
comment on column t_sq.content is '申请内容';
comment on column t_sq.pic is '图片';
comment on column t_sq.insertDate is '日期';
comment on column t_sq.back is '回复';
comment on column t_sq.STATUS is '状态';
--用户申请表加注释
comment on table t_sq is '用户申请';
医院表创建语句如下：
create table t_yy(
id integer,
yyName varchar(100),
lx varchar(100),
address varchar(100),
zz varchar(100)
);
--医院字段加注释
comment on column t_yy.id is '主键';
comment on column t_yy.yyName is '医院名称';
comment on column t_yy.lx is '类型';
comment on column t_yy.address is '地址';
comment on column t_yy.zz is '医院主治';
--医院表加注释
comment on table t_yy is '医院';
用户就诊表创建语句如下：
create table t_yyjz(
id integer,
customerId int,
yyId int,
yyksId int,
showDate datetime,
ys varchar(100),
bq varchar(100),
back varchar(100),
yw varchar(100),
fee int
);
--用户就诊字段加注释
comment on column t_yyjz.id is '主键';
comment on column t_yyjz.customerId is '用户';
comment on column t_yyjz.yyId is '医院';
comment on column t_yyjz.yyksId is '科室';
comment on column t_yyjz.showDate is '就诊日期';
comment on column t_yyjz.ys is '医生';
comment on column t_yyjz.bq is '病情';
comment on column t_yyjz.back is '医生诊断内容';
comment on column t_yyjz.yw is '药物记录';
comment on column t_yyjz.fee is '金额';
--用户就诊表加注释
comment on table t_yyjz is '用户就诊';
医院科室表创建语句如下：
create table t_yyks(
id integer,
yyId int,
yyksName varchar(100),
content varchar(100)
);
--医院科室字段加注释
comment on column t_yyks.id is '主键';
comment on column t_yyks.yyId is '医院';
comment on column t_yyks.yyksName is '科室名称';
comment on column t_yyks.content is '详细说明';
--医院科室表加注释
comment on table t_yyks is '医院科室';
用户用药表创建语句如下：
create table t_yyyy(
id integer,
customerId int,
yyId int,
ypName varchar(100),
jl varchar(100),
fee int
);
--用户用药字段加注释
comment on column t_yyyy.id is '主键';
comment on column t_yyyy.customerId is '用户';
comment on column t_yyyy.yyId is '医院';
comment on column t_yyyy.ypName is '药品名称';
comment on column t_yyyy.jl is '剂量';
comment on column t_yyyy.fee is '金额';
--用户用药表加注释
comment on table t_yyyy is '用户用药';
用户住院表创建语句如下：
create table t_yyzy(
id integer,
customerId int,
yyId int,
showDate datetime,
ys varchar(100),
bq varchar(100),
back varchar(100),
yw varchar(100),
fee int,
cyDate datetime
);
--用户住院字段加注释
comment on column t_yyzy.id is '主键';
comment on column t_yyzy.customerId is '用户';
comment on column t_yyzy.yyId is '医院';
comment on column t_yyzy.showDate is '住院日期';
comment on column t_yyzy.ys is '看护医生';
comment on column t_yyzy.bq is '病情';
comment on column t_yyzy.back is '医生诊断内容';
comment on column t_yyzy.yw is '药物记录';
comment on column t_yyzy.fee is '金额';
comment on column t_yyzy.cyDate is '出院日期';
--用户住院表加注释
comment on table t_yyzy is '用户住院';
oracle特有，对应序列如下：
create sequence s_t_customer;
create sequence s_t_sq;
create sequence s_t_yy;
create sequence s_t_yyjz;
create sequence s_t_yyks;
create sequence s_t_yyyy;
create sequence s_t_yyzy;
个人健康档案管理系统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),--姓名
headPic varchar(100),--头像
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100)--性别
);
用户申请表创建语句如下：
--用户申请表注释
create table t_sq(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
title varchar(100),--申请标题
content varchar(100),--申请内容
pic varchar(100),--图片
insertDate datetime,--日期
back varchar(100),--回复
STATUS varchar(100)--状态
);
医院表创建语句如下：
--医院表注释
create table t_yy(
id int identity(1,1) primary key not null,--主键
yyName varchar(100),--医院名称
lx varchar(100),--类型
address varchar(100),--地址
zz varchar(100)--医院主治
);
用户就诊表创建语句如下：
--用户就诊表注释
create table t_yyjz(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
yyId int,--医院
yyksId int,--科室
showDate datetime,--就诊日期
ys varchar(100),--医生
bq varchar(100),--病情
back varchar(100),--医生诊断内容
yw varchar(100),--药物记录
fee int--金额
);
医院科室表创建语句如下：
--医院科室表注释
create table t_yyks(
id int identity(1,1) primary key not null,--主键
yyId int,--医院
yyksName varchar(100),--科室名称
content varchar(100)--详细说明
);
用户用药表创建语句如下：
--用户用药表注释
create table t_yyyy(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
yyId int,--医院
ypName varchar(100),--药品名称
jl varchar(100),--剂量
fee int--金额
);
用户住院表创建语句如下：
--用户住院表注释
create table t_yyzy(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
yyId int,--医院
showDate datetime,--住院日期
ys varchar(100),--看护医生
bq varchar(100),--病情
back varchar(100),--医生诊断内容
yw varchar(100),--药物记录
fee int,--金额
cyDate datetime--出院日期
);
登录后主页.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 headPic;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
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 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;}
}用户申请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_sq")
public class Sq {
//主键
@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 String title;
//申请内容
private String content;
//图片
private String pic;
//日期
private Date insertDate;
//回复
private String back;
//状态
private String STATUS;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
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_yy")
public class Yy {
//主键
@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 yyName;
//类型
private String lx;
//地址
private String address;
//医院主治
private String zz;
public String getYyName() {return yyName;}
public void setYyName(String yyName) {this.yyName = yyName;}
public String getLx() {return lx;}
public void setLx(String lx) {this.lx = lx;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
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_yyjz")
public class Yyjz {
//主键
@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 yyId;
//科室
private Integer yyksId;
//就诊日期
private Date showDate;
//医生
private String ys;
//病情
private String bq;
//医生诊断内容
private String back;
//药物记录
private String yw;
//金额
private Integer fee;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getYyId() {return yyId;}
public void setYyId(Integer yyId) {this.yyId = yyId;}
public Integer getYyksId() {return yyksId;}
public void setYyksId(Integer yyksId) {this.yyksId = yyksId;}
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 getBq() {return bq;}
public void setBq(String bq) {this.bq = bq;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
public String getYw() {return yw;}
public void setYw(String yw) {this.yw = yw;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
}医院科室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_yyks")
public class Yyks {
//主键
@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 yyId;
//科室名称
private String yyksName;
//详细说明
private String content;
public Integer getYyId() {return yyId;}
public void setYyId(Integer yyId) {this.yyId = yyId;}
public String getYyksName() {return yyksName;}
public void setYyksName(String yyksName) {this.yyksName = yyksName;}
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_yyyy")
public class Yyyy {
//主键
@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 yyId;
//药品名称
private String ypName;
//剂量
private String jl;
//金额
private Integer fee;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getYyId() {return yyId;}
public void setYyId(Integer yyId) {this.yyId = yyId;}
public String getYpName() {return ypName;}
public void setYpName(String ypName) {this.ypName = ypName;}
public String getJl() {return jl;}
public void setJl(String jl) {this.jl = jl;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
}用户住院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_yyzy")
public class Yyzy {
//主键
@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 yyId;
//住院日期
private Date showDate;
//看护医生
private String ys;
//病情
private String bq;
//医生诊断内容
private String back;
//药物记录
private String yw;
//金额
private Integer fee;
//出院日期
private Date cyDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getYyId() {return yyId;}
public void setYyId(Integer yyId) {this.yyId = yyId;}
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 getBq() {return bq;}
public void setBq(String bq) {this.bq = bq;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
public String getYw() {return yw;}
public void setYw(String yw) {this.yw = yw;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public Date getCyDate() {return cyDate;}
public void setCyDate(Date cyDate) {this.cyDate = cyDate;}
}个人健康档案管理系统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 headPic;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
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 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;}
}用户申请javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//用户申请
public class Sq extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//申请标题
private String title;
//申请内容
private String content;
//图片
private String pic;
//日期
private Date insertDate;
//回复
private String back;
//状态
private String STATUS;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
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 Yy extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//医院名称
private String yyName;
//类型
private String lx;
//地址
private String address;
//医院主治
private String zz;
public String getYyName() {return yyName;}
public void setYyName(String yyName) {this.yyName = yyName;}
public String getLx() {return lx;}
public void setLx(String lx) {this.lx = lx;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
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 Yyjz extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//医院
private Integer yyId;
//科室
private Integer yyksId;
//就诊日期
private Date showDate;
//医生
private String ys;
//病情
private String bq;
//医生诊断内容
private String back;
//药物记录
private String yw;
//金额
private Integer fee;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getYyId() {return yyId;}
public void setYyId(Integer yyId) {this.yyId = yyId;}
public Integer getYyksId() {return yyksId;}
public void setYyksId(Integer yyksId) {this.yyksId = yyksId;}
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 getBq() {return bq;}
public void setBq(String bq) {this.bq = bq;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
public String getYw() {return yw;}
public void setYw(String yw) {this.yw = yw;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
}医院科室javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//医院科室
public class Yyks extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//医院
private Integer yyId;
//科室名称
private String yyksName;
//详细说明
private String content;
public Integer getYyId() {return yyId;}
public void setYyId(Integer yyId) {this.yyId = yyId;}
public String getYyksName() {return yyksName;}
public void setYyksName(String yyksName) {this.yyksName = yyksName;}
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 Yyyy extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//医院
private Integer yyId;
//药品名称
private String ypName;
//剂量
private String jl;
//金额
private Integer fee;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getYyId() {return yyId;}
public void setYyId(Integer yyId) {this.yyId = yyId;}
public String getYpName() {return ypName;}
public void setYpName(String ypName) {this.ypName = ypName;}
public String getJl() {return jl;}
public void setJl(String jl) {this.jl = jl;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
}用户住院javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//用户住院
public class Yyzy extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//医院
private Integer yyId;
//住院日期
private Date showDate;
//看护医生
private String ys;
//病情
private String bq;
//医生诊断内容
private String back;
//药物记录
private String yw;
//金额
private Integer fee;
//出院日期
private Date cyDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getYyId() {return yyId;}
public void setYyId(Integer yyId) {this.yyId = yyId;}
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 getBq() {return bq;}
public void setBq(String bq) {this.bq = bq;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
public String getYw() {return yw;}
public void setYw(String yw) {this.yw = yw;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public Date getCyDate() {return cyDate;}
public void setCyDate(Date cyDate) {this.cyDate = cyDate;}
}