- 山西大医院档案管理信息系统的设计与实现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 '主键',
deptId int comment '部门',
customerName varchar(100) comment '姓名',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
phone varchar(100) comment '电话',
pic varchar(100) comment '头像',
sfz varchar(100) comment '身份证',
types varchar(100) comment '身份',
fileUrl varchar(100) comment '文件',
status varchar(100) comment '状态'
) comment '人事档案';
财务档案表创建语句如下：
create table t_cwda(
id int primary key auto_increment comment '主键',
deptId int comment '部门',
title varchar(100) comment '编号',
pic varchar(100) comment '图片',
content varchar(100) comment '详细说明',
fileUrl varchar(100) comment '文件',
status varchar(100) comment '状态'
) comment '财务档案';
部门表创建语句如下：
create table t_dept(
id int primary key auto_increment comment '主键',
deptName varchar(100) comment '部门名称'
) comment '部门';
普通管理员表创建语句如下：
create table t_ptadmin(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码 ',
ptadminName varchar(100) comment '姓名',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
phone varchar(100) comment '电话',
js varchar(100) comment '角色',
deptId int comment '部门'
) comment '普通管理员';
文书档案表创建语句如下：
create table t_wsda(
id int primary key auto_increment comment '主键',
deptId int comment '部门',
title varchar(100) comment '书名',
types varchar(100) comment '科研@教学@后勤',
pic varchar(100) comment '图片',
content varchar(100) comment '内容描述',
wz varchar(100) comment '存放位置',
fileUrl varchar(100) comment '文件',
status varchar(100) comment '状态'
) comment '文书档案';
医疗档案表创建语句如下：
create table t_ylda(
id int primary key auto_increment comment '主键',
deptId int comment '部门',
title varchar(100) comment '编号',
pic varchar(100) comment '图片',
content varchar(100) comment '详细说明',
fileUrl varchar(100) comment '文件',
status varchar(100) comment '状态'
) comment '医疗档案';
医疗档案借阅记录表创建语句如下：
create table t_yldajy(
id int primary key auto_increment comment '主键',
yldaId int comment '医疗档案',
jyr varchar(100) comment '借阅人',
showDate datetime comment '借阅时间',
content varchar(100) comment '详细说明',
backDate datetime comment '归还时间',
status 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_customer(
id integer,
deptId int,
customerName varchar(100),
age varchar(100),
sex varchar(100),
phone varchar(100),
pic varchar(100),
sfz varchar(100),
types varchar(100),
fileUrl varchar(100),
status varchar(100)
);
--人事档案字段加注释
comment on column t_customer.id is '主键';
comment on column t_customer.deptId is '部门';
comment on column t_customer.customerName is '姓名';
comment on column t_customer.age is '年龄';
comment on column t_customer.sex is '性别';
comment on column t_customer.phone is '电话';
comment on column t_customer.pic is '头像';
comment on column t_customer.sfz is '身份证';
comment on column t_customer.types is '身份';
comment on column t_customer.fileUrl is '文件';
comment on column t_customer.status is '状态';
--人事档案表加注释
comment on table t_customer is '人事档案';
财务档案表创建语句如下：
create table t_cwda(
id integer,
deptId int,
title varchar(100),
pic varchar(100),
content varchar(100),
fileUrl varchar(100),
status varchar(100)
);
--财务档案字段加注释
comment on column t_cwda.id is '主键';
comment on column t_cwda.deptId is '部门';
comment on column t_cwda.title is '编号';
comment on column t_cwda.pic is '图片';
comment on column t_cwda.content is '详细说明';
comment on column t_cwda.fileUrl is '文件';
comment on column t_cwda.status is '状态';
--财务档案表加注释
comment on table t_cwda is '财务档案';
部门表创建语句如下：
create table t_dept(
id integer,
deptName varchar(100)
);
--部门字段加注释
comment on column t_dept.id is '主键';
comment on column t_dept.deptName is '部门名称';
--部门表加注释
comment on table t_dept is '部门';
普通管理员表创建语句如下：
create table t_ptadmin(
id integer,
username varchar(100),
password varchar(100),
ptadminName varchar(100),
age varchar(100),
sex varchar(100),
phone varchar(100),
js varchar(100),
deptId int
);
--普通管理员字段加注释
comment on column t_ptadmin.id is '主键';
comment on column t_ptadmin.username is '账号';
comment on column t_ptadmin.password is '密码 ';
comment on column t_ptadmin.ptadminName is '姓名';
comment on column t_ptadmin.age is '年龄';
comment on column t_ptadmin.sex is '性别';
comment on column t_ptadmin.phone is '电话';
comment on column t_ptadmin.js is '角色';
comment on column t_ptadmin.deptId is '部门';
--普通管理员表加注释
comment on table t_ptadmin is '普通管理员';
文书档案表创建语句如下：
create table t_wsda(
id integer,
deptId int,
title varchar(100),
types varchar(100),
pic varchar(100),
content varchar(100),
wz varchar(100),
fileUrl varchar(100),
status varchar(100)
);
--文书档案字段加注释
comment on column t_wsda.id is '主键';
comment on column t_wsda.deptId is '部门';
comment on column t_wsda.title is '书名';
comment on column t_wsda.types is '科研@教学@后勤';
comment on column t_wsda.pic is '图片';
comment on column t_wsda.content is '内容描述';
comment on column t_wsda.wz is '存放位置';
comment on column t_wsda.fileUrl is '文件';
comment on column t_wsda.status is '状态';
--文书档案表加注释
comment on table t_wsda is '文书档案';
医疗档案表创建语句如下：
create table t_ylda(
id integer,
deptId int,
title varchar(100),
pic varchar(100),
content varchar(100),
fileUrl varchar(100),
status varchar(100)
);
--医疗档案字段加注释
comment on column t_ylda.id is '主键';
comment on column t_ylda.deptId is '部门';
comment on column t_ylda.title is '编号';
comment on column t_ylda.pic is '图片';
comment on column t_ylda.content is '详细说明';
comment on column t_ylda.fileUrl is '文件';
comment on column t_ylda.status is '状态';
--医疗档案表加注释
comment on table t_ylda is '医疗档案';
医疗档案借阅记录表创建语句如下：
create table t_yldajy(
id integer,
yldaId int,
jyr varchar(100),
showDate datetime,
content varchar(100),
backDate datetime,
status varchar(100)
);
--医疗档案借阅记录字段加注释
comment on column t_yldajy.id is '主键';
comment on column t_yldajy.yldaId is '医疗档案';
comment on column t_yldajy.jyr is '借阅人';
comment on column t_yldajy.showDate is '借阅时间';
comment on column t_yldajy.content is '详细说明';
comment on column t_yldajy.backDate is '归还时间';
comment on column t_yldajy.status is '状态';
--医疗档案借阅记录表加注释
comment on table t_yldajy is '医疗档案借阅记录';
oracle特有，对应序列如下：
create sequence s_t_customer;
create sequence s_t_cwda;
create sequence s_t_dept;
create sequence s_t_ptadmin;
create sequence s_t_wsda;
create sequence s_t_ylda;
create sequence s_t_yldajy;
山西大医院档案管理信息系统的设计与实现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,--主键
deptId int,--部门
customerName varchar(100),--姓名
age varchar(100),--年龄
sex varchar(100),--性别
phone varchar(100),--电话
pic varchar(100),--头像
sfz varchar(100),--身份证
types varchar(100),--身份
fileUrl varchar(100),--文件
status varchar(100)--状态
);
财务档案表创建语句如下：
--财务档案表注释
create table t_cwda(
id int identity(1,1) primary key not null,--主键
deptId int,--部门
title varchar(100),--编号
pic varchar(100),--图片
content varchar(100),--详细说明
fileUrl varchar(100),--文件
status varchar(100)--状态
);
部门表创建语句如下：
--部门表注释
create table t_dept(
id int identity(1,1) primary key not null,--主键
deptName varchar(100)--部门名称
);
普通管理员表创建语句如下：
--普通管理员表注释
create table t_ptadmin(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
ptadminName varchar(100),--姓名
age varchar(100),--年龄
sex varchar(100),--性别
phone varchar(100),--电话
js varchar(100),--角色
deptId int--部门
);
文书档案表创建语句如下：
--文书档案表注释
create table t_wsda(
id int identity(1,1) primary key not null,--主键
deptId int,--部门
title varchar(100),--书名
types varchar(100),--科研@教学@后勤
pic varchar(100),--图片
content varchar(100),--内容描述
wz varchar(100),--存放位置
fileUrl varchar(100),--文件
status varchar(100)--状态
);
医疗档案表创建语句如下：
--医疗档案表注释
create table t_ylda(
id int identity(1,1) primary key not null,--主键
deptId int,--部门
title varchar(100),--编号
pic varchar(100),--图片
content varchar(100),--详细说明
fileUrl varchar(100),--文件
status varchar(100)--状态
);
医疗档案借阅记录表创建语句如下：
--医疗档案借阅记录表注释
create table t_yldajy(
id int identity(1,1) primary key not null,--主键
yldaId int,--医疗档案
jyr varchar(100),--借阅人
showDate datetime,--借阅时间
content varchar(100),--详细说明
backDate datetime,--归还时间
status varchar(100)--状态
);
登录后主页.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 Integer deptId;
//姓名
private String customerName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//头像
private String pic;
//身份证
private String sfz;
//身份
private String types;
//文件
private String fileUrl;
//状态
private String status;
public Integer getDeptId() {return deptId;}
public void setDeptId(Integer deptId) {this.deptId = deptId;}
public String getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
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 getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
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_cwda")
public class Cwda {
//主键
@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 deptId;
//编号
private String title;
//图片
private String pic;
//详细说明
private String content;
//文件
private String fileUrl;
//状态
private String status;
public Integer getDeptId() {return deptId;}
public void setDeptId(Integer deptId) {this.deptId = deptId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
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_dept")
public class Dept {
//主键
@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 deptName;
public String getDeptName() {return deptName;}
public void setDeptName(String deptName) {this.deptName = deptName;}
}普通管理员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_ptadmin")
public class Ptadmin {
//主键
@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 ptadminName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//角色
private String js;
//部门
private Integer deptId;
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 getPtadminName() {return ptadminName;}
public void setPtadminName(String ptadminName) {this.ptadminName = ptadminName;}
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 getJs() {return js;}
public void setJs(String js) {this.js = js;}
public Integer getDeptId() {return deptId;}
public void setDeptId(Integer deptId) {this.deptId = deptId;}
}文书档案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_wsda")
public class Wsda {
//主键
@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 deptId;
//书名
private String title;
//科研@教学@后勤
private String types;
//图片
private String pic;
//内容描述
private String content;
//存放位置
private String wz;
//文件
private String fileUrl;
//状态
private String status;
public Integer getDeptId() {return deptId;}
public void setDeptId(Integer deptId) {this.deptId = deptId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getWz() {return wz;}
public void setWz(String wz) {this.wz = wz;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
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_ylda")
public class Ylda {
//主键
@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 deptId;
//编号
private String title;
//图片
private String pic;
//详细说明
private String content;
//文件
private String fileUrl;
//状态
private String status;
public Integer getDeptId() {return deptId;}
public void setDeptId(Integer deptId) {this.deptId = deptId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
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_yldajy")
public class Yldajy {
//主键
@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 yldaId;
//借阅人
private String jyr;
//借阅时间
private Date showDate;
//详细说明
private String content;
//归还时间
private Date backDate;
//状态
private String status;
public Integer getYldaId() {return yldaId;}
public void setYldaId(Integer yldaId) {this.yldaId = yldaId;}
public String getJyr() {return jyr;}
public void setJyr(String jyr) {this.jyr = jyr;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getBackDate() {return backDate;}
public void setBackDate(Date backDate) {this.backDate = backDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}山西大医院档案管理信息系统的设计与实现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 Integer deptId;
//姓名
private String customerName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//头像
private String pic;
//身份证
private String sfz;
//身份
private String types;
//文件
private String fileUrl;
//状态
private String status;
public Integer getDeptId() {return deptId;}
public void setDeptId(Integer deptId) {this.deptId = deptId;}
public String getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
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 getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
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 Cwda extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//部门
private Integer deptId;
//编号
private String title;
//图片
private String pic;
//详细说明
private String content;
//文件
private String fileUrl;
//状态
private String status;
public Integer getDeptId() {return deptId;}
public void setDeptId(Integer deptId) {this.deptId = deptId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
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 Dept extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//部门名称
private String deptName;
public String getDeptName() {return deptName;}
public void setDeptName(String deptName) {this.deptName = deptName;}
}普通管理员javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//普通管理员
public class Ptadmin 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 ptadminName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//角色
private String js;
//部门
private Integer deptId;
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 getPtadminName() {return ptadminName;}
public void setPtadminName(String ptadminName) {this.ptadminName = ptadminName;}
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 getJs() {return js;}
public void setJs(String js) {this.js = js;}
public Integer getDeptId() {return deptId;}
public void setDeptId(Integer deptId) {this.deptId = deptId;}
}文书档案javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//文书档案
public class Wsda extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//部门
private Integer deptId;
//书名
private String title;
//科研@教学@后勤
private String types;
//图片
private String pic;
//内容描述
private String content;
//存放位置
private String wz;
//文件
private String fileUrl;
//状态
private String status;
public Integer getDeptId() {return deptId;}
public void setDeptId(Integer deptId) {this.deptId = deptId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getWz() {return wz;}
public void setWz(String wz) {this.wz = wz;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
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 Ylda extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//部门
private Integer deptId;
//编号
private String title;
//图片
private String pic;
//详细说明
private String content;
//文件
private String fileUrl;
//状态
private String status;
public Integer getDeptId() {return deptId;}
public void setDeptId(Integer deptId) {this.deptId = deptId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
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 Yldajy extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//医疗档案
private Integer yldaId;
//借阅人
private String jyr;
//借阅时间
private Date showDate;
//详细说明
private String content;
//归还时间
private Date backDate;
//状态
private String status;
public Integer getYldaId() {return yldaId;}
public void setYldaId(Integer yldaId) {this.yldaId = yldaId;}
public String getJyr() {return jyr;}
public void setJyr(String jyr) {this.jyr = jyr;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getBackDate() {return backDate;}
public void setBackDate(Date backDate) {this.backDate = backDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}