兴胜路社区居民健康档案管理系统的设计与实现

兴胜路社区居民健康档案管理系统的设计与实现登录注册界面

兴胜路社区居民健康档案管理系统的设计与实现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 '姓名',
	age int comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话',
	pic varchar(100) comment '头像',
	sfz varchar(100) comment '身份证',
	birthday datetime comment '生日',
	fileUrl varchar(100) comment '电子归档'
) comment '居民';

儿童健康表创建语句如下:


create table t_etjk(
	id int primary key auto_increment comment '主键',
	v1 varchar(100) comment '儿童姓名',
	sex varchar(100) comment '性别',
	age varchar(100) comment '年龄',
	v2 varchar(100) comment '接种类型',
	v3 datetime comment '接种时间',
	v4 varchar(100) comment '接种过程',
	v5 varchar(100) comment '监护人',
	v6 varchar(100) comment '监护人联系方式'
) comment '儿童健康';

公告表创建语句如下:


create table t_gg(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '标题',
	types varchar(100) comment '类型',
	pic varchar(100) comment '图片',
	content varchar(100) comment '内容',
	showDate datetime comment '日期'
) comment '公告';

健康档案表创建语句如下:


create table t_jkda(
	id int primary key auto_increment comment '主键',
	customerId int comment '居民',
	jkdaName varchar(100) comment '档案编号',
	types varchar(100) comment '类型',
	content varchar(100) comment '内容',
	pic varchar(100) comment '图片归档',
	fileUrl varchar(100) comment '文件归档',
	showDate datetime comment '整理日期',
	jkz int comment '评估健康值',
	zlr varchar(100) comment '整理人',
	lxfs varchar(100) comment '联系方式'
) comment '健康档案';

居民记事备忘录表创建语句如下:


create table t_jmjs(
	id int primary key auto_increment comment '主键',
	customerId int comment '居民',
	title varchar(100) comment '标题',
	content varchar(100) comment '内容',
	showDate datetime comment '日期'
) comment '居民记事备忘录';

老年人健康表创建语句如下:


create table t_lnrjk(
	id int primary key auto_increment comment '主键',
	v1 varchar(100) comment '姓名',
	sex varchar(100) comment '性别',
	age varchar(100) comment '年龄',
	xq varchar(100) comment '小区',
	v21 varchar(100) comment '体格体温',
	v22 varchar(100) comment '脉搏呼吸',
	v23 varchar(100) comment '视力听力',
	v24 varchar(100) comment '活动能力',
	v3 datetime comment '检查日期',
	remark 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 '电话'
) comment '普通管理员';

体检表创建语句如下:


create table t_tj(
	id int primary key auto_increment comment '主键',
	customerId int comment '居民',
	v1 varchar(100) comment '体检人姓名',
	sfz varchar(100) comment '身份证',
	tx varchar(100) comment '头像',
	sex varchar(100) comment '性别',
	age varchar(100) comment '年龄',
	phone varchar(100) comment '联系方式',
	tjrq datetime comment '体检日期',
	address varchar(100) comment '地址',
	tjbg varchar(100) comment '体检报告',
	status varchar(100) comment '状态',
	remark 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,
	username varchar(100),
	password varchar(100),
	customerName varchar(100),
	age int,
	sex varchar(100),
	phone varchar(100),
	pic varchar(100),
	sfz varchar(100),
	birthday datetime,
	fileUrl 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.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.birthday is '生日';
comment on column t_customer.fileUrl is '电子归档';
--居民表加注释
comment on table t_customer is '居民';

儿童健康表创建语句如下:


create table t_etjk(
	id integer,
	v1 varchar(100),
	sex varchar(100),
	age varchar(100),
	v2 varchar(100),
	v3 datetime,
	v4 varchar(100),
	v5 varchar(100),
	v6 varchar(100)
);
--儿童健康字段加注释
comment on column t_etjk.id is '主键';
comment on column t_etjk.v1 is '儿童姓名';
comment on column t_etjk.sex is '性别';
comment on column t_etjk.age is '年龄';
comment on column t_etjk.v2 is '接种类型';
comment on column t_etjk.v3 is '接种时间';
comment on column t_etjk.v4 is '接种过程';
comment on column t_etjk.v5 is '监护人';
comment on column t_etjk.v6 is '监护人联系方式';
--儿童健康表加注释
comment on table t_etjk is '儿童健康';

公告表创建语句如下:


create table t_gg(
	id integer,
	title varchar(100),
	types varchar(100),
	pic varchar(100),
	content varchar(100),
	showDate datetime
);
--公告字段加注释
comment on column t_gg.id is '主键';
comment on column t_gg.title is '标题';
comment on column t_gg.types is '类型';
comment on column t_gg.pic is '图片';
comment on column t_gg.content is '内容';
comment on column t_gg.showDate is '日期';
--公告表加注释
comment on table t_gg is '公告';

健康档案表创建语句如下:


create table t_jkda(
	id integer,
	customerId int,
	jkdaName varchar(100),
	types varchar(100),
	content varchar(100),
	pic varchar(100),
	fileUrl varchar(100),
	showDate datetime,
	jkz int,
	zlr varchar(100),
	lxfs varchar(100)
);
--健康档案字段加注释
comment on column t_jkda.id is '主键';
comment on column t_jkda.customerId is '居民';
comment on column t_jkda.jkdaName is '档案编号';
comment on column t_jkda.types is '类型';
comment on column t_jkda.content is '内容';
comment on column t_jkda.pic is '图片归档';
comment on column t_jkda.fileUrl is '文件归档';
comment on column t_jkda.showDate is '整理日期';
comment on column t_jkda.jkz is '评估健康值';
comment on column t_jkda.zlr is '整理人';
comment on column t_jkda.lxfs is '联系方式';
--健康档案表加注释
comment on table t_jkda is '健康档案';

居民记事备忘录表创建语句如下:


create table t_jmjs(
	id integer,
	customerId int,
	title varchar(100),
	content varchar(100),
	showDate datetime
);
--居民记事备忘录字段加注释
comment on column t_jmjs.id is '主键';
comment on column t_jmjs.customerId is '居民';
comment on column t_jmjs.title is '标题';
comment on column t_jmjs.content is '内容';
comment on column t_jmjs.showDate is '日期';
--居民记事备忘录表加注释
comment on table t_jmjs is '居民记事备忘录';

老年人健康表创建语句如下:


create table t_lnrjk(
	id integer,
	v1 varchar(100),
	sex varchar(100),
	age varchar(100),
	xq varchar(100),
	v21 varchar(100),
	v22 varchar(100),
	v23 varchar(100),
	v24 varchar(100),
	v3 datetime,
	remark varchar(100)
);
--老年人健康字段加注释
comment on column t_lnrjk.id is '主键';
comment on column t_lnrjk.v1 is '姓名';
comment on column t_lnrjk.sex is '性别';
comment on column t_lnrjk.age is '年龄';
comment on column t_lnrjk.xq is '小区';
comment on column t_lnrjk.v21 is '体格体温';
comment on column t_lnrjk.v22 is '脉搏呼吸';
comment on column t_lnrjk.v23 is '视力听力';
comment on column t_lnrjk.v24 is '活动能力';
comment on column t_lnrjk.v3 is '检查日期';
comment on column t_lnrjk.remark is '备注';
--老年人健康表加注释
comment on table t_lnrjk 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)
);
--普通管理员字段加注释
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 table t_ptadmin is '普通管理员';

体检表创建语句如下:


create table t_tj(
	id integer,
	customerId int,
	v1 varchar(100),
	sfz varchar(100),
	tx varchar(100),
	sex varchar(100),
	age varchar(100),
	phone varchar(100),
	tjrq datetime,
	address varchar(100),
	tjbg varchar(100),
	status varchar(100),
	remark varchar(100)
);
--体检字段加注释
comment on column t_tj.id is '主键';
comment on column t_tj.customerId is '居民';
comment on column t_tj.v1 is '体检人姓名';
comment on column t_tj.sfz is '身份证';
comment on column t_tj.tx is '头像';
comment on column t_tj.sex is '性别';
comment on column t_tj.age is '年龄';
comment on column t_tj.phone is '联系方式';
comment on column t_tj.tjrq is '体检日期';
comment on column t_tj.address is '地址';
comment on column t_tj.tjbg is '体检报告';
comment on column t_tj.status is '状态';
comment on column t_tj.remark is '备注';
--体检表加注释
comment on table t_tj is '体检';

oracle特有,对应序列如下:


create sequence s_t_customer;
create sequence s_t_etjk;
create sequence s_t_gg;
create sequence s_t_jkda;
create sequence s_t_jmjs;
create sequence s_t_lnrjk;
create sequence s_t_ptadmin;
create sequence s_t_tj;

兴胜路社区居民健康档案管理系统的设计与实现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),--姓名
	age int,--年龄
	sex varchar(100),--性别
	phone varchar(100),--电话
	pic varchar(100),--头像
	sfz varchar(100),--身份证
	birthday datetime,--生日
	fileUrl varchar(100)--电子归档
);

儿童健康表创建语句如下:


--儿童健康表注释
create table t_etjk(
	id int identity(1,1) primary key not null,--主键
	v1 varchar(100),--儿童姓名
	sex varchar(100),--性别
	age varchar(100),--年龄
	v2 varchar(100),--接种类型
	v3 datetime,--接种时间
	v4 varchar(100),--接种过程
	v5 varchar(100),--监护人
	v6 varchar(100)--监护人联系方式
);

公告表创建语句如下:


--公告表注释
create table t_gg(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--标题
	types varchar(100),--类型
	pic varchar(100),--图片
	content varchar(100),--内容
	showDate datetime--日期
);

健康档案表创建语句如下:


--健康档案表注释
create table t_jkda(
	id int identity(1,1) primary key not null,--主键
	customerId int,--居民
	jkdaName varchar(100),--档案编号
	types varchar(100),--类型
	content varchar(100),--内容
	pic varchar(100),--图片归档
	fileUrl varchar(100),--文件归档
	showDate datetime,--整理日期
	jkz int,--评估健康值
	zlr varchar(100),--整理人
	lxfs varchar(100)--联系方式
);

居民记事备忘录表创建语句如下:


--居民记事备忘录表注释
create table t_jmjs(
	id int identity(1,1) primary key not null,--主键
	customerId int,--居民
	title varchar(100),--标题
	content varchar(100),--内容
	showDate datetime--日期
);

老年人健康表创建语句如下:


--老年人健康表注释
create table t_lnrjk(
	id int identity(1,1) primary key not null,--主键
	v1 varchar(100),--姓名
	sex varchar(100),--性别
	age varchar(100),--年龄
	xq varchar(100),--小区
	v21 varchar(100),--体格体温
	v22 varchar(100),--脉搏呼吸
	v23 varchar(100),--视力听力
	v24 varchar(100),--活动能力
	v3 datetime,--检查日期
	remark 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)--电话
);

体检表创建语句如下:


--体检表注释
create table t_tj(
	id int identity(1,1) primary key not null,--主键
	customerId int,--居民
	v1 varchar(100),--体检人姓名
	sfz varchar(100),--身份证
	tx varchar(100),--头像
	sex varchar(100),--性别
	age varchar(100),--年龄
	phone varchar(100),--联系方式
	tjrq datetime,--体检日期
	address varchar(100),--地址
	tjbg varchar(100),--体检报告
	status varchar(100),--状态
	remark varchar(100)--备注
);

兴胜路社区居民健康档案管理系统的设计与实现登录后主页

兴胜路社区居民健康档案管理系统的设计与实现spring+springMVC+hibernate框架对象(javaBean,pojo)设计:

居民javaBean创建语句如下:


package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity

//居民
@Table(name = "t_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 Integer age;
//性别
private String sex;
//电话
private String phone;
//头像
private String pic;
//身份证
private String sfz;
//生日
private Date birthday;
//电子归档
private String fileUrl;
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 Integer getAge() {return age;}
public void setAge(Integer 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 Date getBirthday() {return birthday;}
public void setBirthday(Date birthday) {this.birthday = birthday;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
}

儿童健康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_etjk")
public class Etjk {
//主键
@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 v1;
//性别
private String sex;
//年龄
private String age;
//接种类型
private String v2;
//接种时间
private Date v3;
//接种过程
private String v4;
//监护人
private String v5;
//监护人联系方式
private String v6;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public Date getV3() {return v3;}
public void setV3(Date v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
}

公告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_gg")
public class Gg {
//主键
@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 title;
//类型
private String types;
//图片
private String pic;
//内容
private String content;
//日期
private Date showDate;
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 Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}

健康档案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_jkda")
public class Jkda {
//主键
@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 jkdaName;
//类型
private String types;
//内容
private String content;
//图片归档
private String pic;
//文件归档
private String fileUrl;
//整理日期
private Date showDate;
//评估健康值
private Integer jkz;
//整理人
private String zlr;
//联系方式
private String lxfs;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getJkdaName() {return jkdaName;}
public void setJkdaName(String jkdaName) {this.jkdaName = jkdaName;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
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 String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public Integer getJkz() {return jkz;}
public void setJkz(Integer jkz) {this.jkz = jkz;}
public String getZlr() {return zlr;}
public void setZlr(String zlr) {this.zlr = zlr;}
public String getLxfs() {return lxfs;}
public void setLxfs(String lxfs) {this.lxfs = lxfs;}
}

居民记事备忘录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_jmjs")
public class Jmjs {
//主键
@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 Date showDate;
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 Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}

老年人健康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_lnrjk")
public class Lnrjk {
//主键
@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 v1;
//性别
private String sex;
//年龄
private String age;
//小区
private String xq;
//体格体温
private String v21;
//脉搏呼吸
private String v22;
//视力听力
private String v23;
//活动能力
private String v24;
//检查日期
private Date v3;
//备注
private String remark;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getXq() {return xq;}
public void setXq(String xq) {this.xq = xq;}
public String getV21() {return v21;}
public void setV21(String v21) {this.v21 = v21;}
public String getV22() {return v22;}
public void setV22(String v22) {this.v22 = v22;}
public String getV23() {return v23;}
public void setV23(String v23) {this.v23 = v23;}
public String getV24() {return v24;}
public void setV24(String v24) {this.v24 = v24;}
public Date getV3() {return v3;}
public void setV3(Date v3) {this.v3 = v3;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}

普通管理员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;
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;}
}

体检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_tj")
public class Tj {
//主键
@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 v1;
//身份证
private String sfz;
//头像
private String tx;
//性别
private String sex;
//年龄
private String age;
//联系方式
private String phone;
//体检日期
private Date tjrq;
//地址
private String address;
//体检报告
private String tjbg;
//状态
private String status;
//备注
private String remark;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public String getTx() {return tx;}
public void setTx(String tx) {this.tx = tx;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public Date getTjrq() {return tjrq;}
public void setTjrq(Date tjrq) {this.tjrq = tjrq;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getTjbg() {return tjbg;}
public void setTjbg(String tjbg) {this.tjbg = tjbg;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}

兴胜路社区居民健康档案管理系统的设计与实现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 Integer age;
//性别
private String sex;
//电话
private String phone;
//头像
private String pic;
//身份证
private String sfz;
//生日
private Date birthday;
//电子归档
private String fileUrl;
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 Integer getAge() {return age;}
public void setAge(Integer 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 Date getBirthday() {return birthday;}
public void setBirthday(Date birthday) {this.birthday = birthday;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
}

儿童健康javaBean创建语句如下:


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

//儿童健康
public class Etjk  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//儿童姓名
private String v1;
//性别
private String sex;
//年龄
private String age;
//接种类型
private String v2;
//接种时间
private Date v3;
//接种过程
private String v4;
//监护人
private String v5;
//监护人联系方式
private String v6;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public Date getV3() {return v3;}
public void setV3(Date v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
}

公告javaBean创建语句如下:


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

//公告
public class Gg  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//类型
private String types;
//图片
private String pic;
//内容
private String content;
//日期
private Date showDate;
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 Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}

健康档案javaBean创建语句如下:


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

//健康档案
public class Jkda  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//居民
private Integer customerId;
//档案编号
private String jkdaName;
//类型
private String types;
//内容
private String content;
//图片归档
private String pic;
//文件归档
private String fileUrl;
//整理日期
private Date showDate;
//评估健康值
private Integer jkz;
//整理人
private String zlr;
//联系方式
private String lxfs;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getJkdaName() {return jkdaName;}
public void setJkdaName(String jkdaName) {this.jkdaName = jkdaName;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
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 String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public Integer getJkz() {return jkz;}
public void setJkz(Integer jkz) {this.jkz = jkz;}
public String getZlr() {return zlr;}
public void setZlr(String zlr) {this.zlr = zlr;}
public String getLxfs() {return lxfs;}
public void setLxfs(String lxfs) {this.lxfs = lxfs;}
}

居民记事备忘录javaBean创建语句如下:


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

//居民记事备忘录
public class Jmjs  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 Date showDate;
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 Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}

老年人健康javaBean创建语句如下:


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

//老年人健康
public class Lnrjk  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//姓名
private String v1;
//性别
private String sex;
//年龄
private String age;
//小区
private String xq;
//体格体温
private String v21;
//脉搏呼吸
private String v22;
//视力听力
private String v23;
//活动能力
private String v24;
//检查日期
private Date v3;
//备注
private String remark;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getXq() {return xq;}
public void setXq(String xq) {this.xq = xq;}
public String getV21() {return v21;}
public void setV21(String v21) {this.v21 = v21;}
public String getV22() {return v22;}
public void setV22(String v22) {this.v22 = v22;}
public String getV23() {return v23;}
public void setV23(String v23) {this.v23 = v23;}
public String getV24() {return v24;}
public void setV24(String v24) {this.v24 = v24;}
public Date getV3() {return v3;}
public void setV3(Date v3) {this.v3 = v3;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}

普通管理员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;
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;}
}

体检javaBean创建语句如下:


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

//体检
public class Tj  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//居民
private Integer customerId;
//体检人姓名
private String v1;
//身份证
private String sfz;
//头像
private String tx;
//性别
private String sex;
//年龄
private String age;
//联系方式
private String phone;
//体检日期
private Date tjrq;
//地址
private String address;
//体检报告
private String tjbg;
//状态
private String status;
//备注
private String remark;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public String getTx() {return tx;}
public void setTx(String tx) {this.tx = tx;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public Date getTjrq() {return tjrq;}
public void setTjrq(Date tjrq) {this.tjrq = tjrq;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getTjbg() {return tjbg;}
public void setTjbg(String tjbg) {this.tjbg = tjbg;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}

源代码下载点这里

评论