- 社区养老服务管理系统设计与实现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_fuwugongdan(
id int primary key auto_increment comment '主键',
ptadminId int comment '服务人员',
gdbh varchar(100) comment '服务工单编号',
tuandui varchar(100) comment '所属团队',
fwgdName varchar(100) comment '服务工单标题',
content varchar(100) comment '服务工单内容',
fwdd varchar(100) comment '服务地点',
showDate datetime comment '服务日期',
remark varchar(100) comment '备注',
status varchar(100) comment '状态',
hf varchar(100) comment '回访'
) comment '服务工单';
服务站表创建语句如下：
create table t_fuwuzhan(
id int primary key auto_increment comment '主键',
title varchar(100) comment '服务站名称',
fzr varchar(100) comment '负责人',
remark varchar(100) comment '备注',
wz varchar(100) comment '位置'
) comment '服务站';
服务项目表创建语句如下：
create table t_fwxm(
id int primary key auto_increment comment '主键',
title varchar(100) comment '服务项目',
remark varchar(100) comment '备注'
) comment '服务项目';
活动发布表创建语句如下：
create table t_hdfb(
id int primary key auto_increment comment '主键',
hdlxId int comment '活动类型',
hdfbName varchar(100) comment '活动名称',
dd varchar(100) comment '地点',
showDate datetime comment '活动日期',
remark varchar(100) comment '备注',
hdry varchar(100) comment '活动人员'
) comment '活动发布';
活动类型表创建语句如下：
create table t_hdlx(
id int primary key auto_increment comment '主键',
hdlxName varchar(100) comment '活动类型名称'
) comment '活动类型';
街道辖区表创建语句如下：
create table t_jiedao(
id int primary key auto_increment comment '主键',
title varchar(100) comment '名称',
fzr varchar(100) comment '负责人',
remark varchar(100) comment '备注',
wz varchar(100) comment '位置'
) comment '街道辖区';
老人就诊记录表创建语句如下：
create table t_jiuzhen(
id int primary key auto_increment comment '主键',
laorenbh varchar(100) comment '老人编号',
ghlx varchar(100) comment '挂号类型',
ys varchar(100) comment '医生',
showDate datetime comment '就诊时间',
remark varchar(100) comment '就诊备注'
) comment '老人就诊记录';
老人表创建语句如下：
create table t_laoren(
id int primary key auto_increment comment '主键',
laorenbh varchar(100) comment '编号',
laorenName varchar(100) comment '姓名',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
bs varchar(100) comment '病史',
sfz varchar(100) comment '身份证',
sex varchar(100) comment '性别'
) comment '老人';
通知信息表创建语句如下：
create table t_message(
id int primary key auto_increment comment '主键',
title varchar(100) comment '通知标题',
showDate datetime comment '通知时间',
pic varchar(100) 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 '姓名',
bh varchar(100) comment '编号',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别'
) comment '服务人员';
体检表创建语句如下：
create table t_tijian(
id int primary key auto_increment comment '主键',
laorenbh varchar(100) comment '老人编号',
showDate datetime comment '体检时间',
v1 varchar(100) comment '身高',
v2 varchar(100) comment '体重',
v3 varchar(100) comment '血压',
v4 varchar(100) comment '尿检',
v5 varchar(100) comment '血检',
v6 varchar(100) comment '拍片',
v7 varchar(100) comment '骨头检查',
remark varchar(100) comment '备注'
) comment '体检';
投诉处理回访表创建语句如下：
create table t_tscl(
id int primary key auto_increment comment '主键',
tsnr varchar(100) comment '投诉内容',
remark varchar(100) comment '处理回访内容',
tssjDate datetime comment '投诉时间',
clsj datetime comment '处理时间'
) comment '投诉处理回访';
老人兴趣爱好表创建语句如下：
create table t_xingqu(
id int primary key auto_increment comment '主键',
laorenbh varchar(100) comment '老人编号',
xingquName varchar(100) comment '老人兴趣'
) comment '老人兴趣爱好';
老人用药记录表创建语句如下：
create table t_yongyao(
id int primary key auto_increment comment '主键',
laorenbh varchar(100) comment '老人编号',
ypname varchar(100) comment '药品名称',
jl varchar(100) comment '计量',
ys varchar(100) comment '医生',
showDate datetime 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_fuwugongdan(
id integer,
ptadminId int,
gdbh varchar(100),
tuandui varchar(100),
fwgdName varchar(100),
content varchar(100),
fwdd varchar(100),
showDate datetime,
remark varchar(100),
status varchar(100),
hf varchar(100)
);
--服务工单字段加注释
comment on column t_fuwugongdan.id is '主键';
comment on column t_fuwugongdan.ptadminId is '服务人员';
comment on column t_fuwugongdan.gdbh is '服务工单编号';
comment on column t_fuwugongdan.tuandui is '所属团队';
comment on column t_fuwugongdan.fwgdName is '服务工单标题';
comment on column t_fuwugongdan.content is '服务工单内容';
comment on column t_fuwugongdan.fwdd is '服务地点';
comment on column t_fuwugongdan.showDate is '服务日期';
comment on column t_fuwugongdan.remark is '备注';
comment on column t_fuwugongdan.status is '状态';
comment on column t_fuwugongdan.hf is '回访';
--服务工单表加注释
comment on table t_fuwugongdan is '服务工单';
服务站表创建语句如下：
create table t_fuwuzhan(
id integer,
title varchar(100),
fzr varchar(100),
remark varchar(100),
wz varchar(100)
);
--服务站字段加注释
comment on column t_fuwuzhan.id is '主键';
comment on column t_fuwuzhan.title is '服务站名称';
comment on column t_fuwuzhan.fzr is '负责人';
comment on column t_fuwuzhan.remark is '备注';
comment on column t_fuwuzhan.wz is '位置';
--服务站表加注释
comment on table t_fuwuzhan is '服务站';
服务项目表创建语句如下：
create table t_fwxm(
id integer,
title varchar(100),
remark varchar(100)
);
--服务项目字段加注释
comment on column t_fwxm.id is '主键';
comment on column t_fwxm.title is '服务项目';
comment on column t_fwxm.remark is '备注';
--服务项目表加注释
comment on table t_fwxm is '服务项目';
活动发布表创建语句如下：
create table t_hdfb(
id integer,
hdlxId int,
hdfbName varchar(100),
dd varchar(100),
showDate datetime,
remark varchar(100),
hdry varchar(100)
);
--活动发布字段加注释
comment on column t_hdfb.id is '主键';
comment on column t_hdfb.hdlxId is '活动类型';
comment on column t_hdfb.hdfbName is '活动名称';
comment on column t_hdfb.dd is '地点';
comment on column t_hdfb.showDate is '活动日期';
comment on column t_hdfb.remark is '备注';
comment on column t_hdfb.hdry is '活动人员';
--活动发布表加注释
comment on table t_hdfb is '活动发布';
活动类型表创建语句如下：
create table t_hdlx(
id integer,
hdlxName varchar(100)
);
--活动类型字段加注释
comment on column t_hdlx.id is '主键';
comment on column t_hdlx.hdlxName is '活动类型名称';
--活动类型表加注释
comment on table t_hdlx is '活动类型';
街道辖区表创建语句如下：
create table t_jiedao(
id integer,
title varchar(100),
fzr varchar(100),
remark varchar(100),
wz varchar(100)
);
--街道辖区字段加注释
comment on column t_jiedao.id is '主键';
comment on column t_jiedao.title is '名称';
comment on column t_jiedao.fzr is '负责人';
comment on column t_jiedao.remark is '备注';
comment on column t_jiedao.wz is '位置';
--街道辖区表加注释
comment on table t_jiedao is '街道辖区';
老人就诊记录表创建语句如下：
create table t_jiuzhen(
id integer,
laorenbh varchar(100),
ghlx varchar(100),
ys varchar(100),
showDate datetime,
remark varchar(100)
);
--老人就诊记录字段加注释
comment on column t_jiuzhen.id is '主键';
comment on column t_jiuzhen.laorenbh is '老人编号';
comment on column t_jiuzhen.ghlx is '挂号类型';
comment on column t_jiuzhen.ys is '医生';
comment on column t_jiuzhen.showDate is '就诊时间';
comment on column t_jiuzhen.remark is '就诊备注';
--老人就诊记录表加注释
comment on table t_jiuzhen is '老人就诊记录';
老人表创建语句如下：
create table t_laoren(
id integer,
laorenbh varchar(100),
laorenName varchar(100),
phone varchar(100),
age varchar(100),
bs varchar(100),
sfz varchar(100),
sex varchar(100)
);
--老人字段加注释
comment on column t_laoren.id is '主键';
comment on column t_laoren.laorenbh is '编号';
comment on column t_laoren.laorenName is '姓名';
comment on column t_laoren.phone is '电话';
comment on column t_laoren.age is '年龄';
comment on column t_laoren.bs is '病史';
comment on column t_laoren.sfz is '身份证';
comment on column t_laoren.sex is '性别';
--老人表加注释
comment on table t_laoren is '老人';
通知信息表创建语句如下：
create table t_message(
id integer,
title varchar(100),
showDate datetime,
pic varchar(100),
remark varchar(100)
);
--通知信息字段加注释
comment on column t_message.id is '主键';
comment on column t_message.title is '通知标题';
comment on column t_message.showDate is '通知时间';
comment on column t_message.pic is '图片';
comment on column t_message.remark is '通知内容';
--通知信息表加注释
comment on table t_message is '通知信息';
服务人员表创建语句如下：
create table t_ptadmin(
id integer,
username varchar(100),
password varchar(100),
ptadminName varchar(100),
bh varchar(100),
age varchar(100),
sex 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.bh is '编号';
comment on column t_ptadmin.age is '年龄';
comment on column t_ptadmin.sex is '性别';
--服务人员表加注释
comment on table t_ptadmin is '服务人员';
体检表创建语句如下：
create table t_tijian(
id integer,
laorenbh varchar(100),
showDate datetime,
v1 varchar(100),
v2 varchar(100),
v3 varchar(100),
v4 varchar(100),
v5 varchar(100),
v6 varchar(100),
v7 varchar(100),
remark varchar(100)
);
--体检字段加注释
comment on column t_tijian.id is '主键';
comment on column t_tijian.laorenbh is '老人编号';
comment on column t_tijian.showDate is '体检时间';
comment on column t_tijian.v1 is '身高';
comment on column t_tijian.v2 is '体重';
comment on column t_tijian.v3 is '血压';
comment on column t_tijian.v4 is '尿检';
comment on column t_tijian.v5 is '血检';
comment on column t_tijian.v6 is '拍片';
comment on column t_tijian.v7 is '骨头检查';
comment on column t_tijian.remark is '备注';
--体检表加注释
comment on table t_tijian is '体检';
投诉处理回访表创建语句如下：
create table t_tscl(
id integer,
tsnr varchar(100),
remark varchar(100),
tssjDate datetime,
clsj datetime
);
--投诉处理回访字段加注释
comment on column t_tscl.id is '主键';
comment on column t_tscl.tsnr is '投诉内容';
comment on column t_tscl.remark is '处理回访内容';
comment on column t_tscl.tssjDate is '投诉时间';
comment on column t_tscl.clsj is '处理时间';
--投诉处理回访表加注释
comment on table t_tscl is '投诉处理回访';
老人兴趣爱好表创建语句如下：
create table t_xingqu(
id integer,
laorenbh varchar(100),
xingquName varchar(100)
);
--老人兴趣爱好字段加注释
comment on column t_xingqu.id is '主键';
comment on column t_xingqu.laorenbh is '老人编号';
comment on column t_xingqu.xingquName is '老人兴趣';
--老人兴趣爱好表加注释
comment on table t_xingqu is '老人兴趣爱好';
老人用药记录表创建语句如下：
create table t_yongyao(
id integer,
laorenbh varchar(100),
ypname varchar(100),
jl varchar(100),
ys varchar(100),
showDate datetime,
remark varchar(100)
);
--老人用药记录字段加注释
comment on column t_yongyao.id is '主键';
comment on column t_yongyao.laorenbh is '老人编号';
comment on column t_yongyao.ypname is '药品名称';
comment on column t_yongyao.jl is '计量';
comment on column t_yongyao.ys is '医生';
comment on column t_yongyao.showDate is '用药时间';
comment on column t_yongyao.remark is '备注';
--老人用药记录表加注释
comment on table t_yongyao is '老人用药记录';
oracle特有，对应序列如下：
create sequence s_t_fuwugongdan;
create sequence s_t_fuwuzhan;
create sequence s_t_fwxm;
create sequence s_t_hdfb;
create sequence s_t_hdlx;
create sequence s_t_jiedao;
create sequence s_t_jiuzhen;
create sequence s_t_laoren;
create sequence s_t_message;
create sequence s_t_ptadmin;
create sequence s_t_tijian;
create sequence s_t_tscl;
create sequence s_t_xingqu;
create sequence s_t_yongyao;
社区养老服务管理系统设计与实现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_fuwugongdan(
id int identity(1,1) primary key not null,--主键
ptadminId int,--服务人员
gdbh varchar(100),--服务工单编号
tuandui varchar(100),--所属团队
fwgdName varchar(100),--服务工单标题
content varchar(100),--服务工单内容
fwdd varchar(100),--服务地点
showDate datetime,--服务日期
remark varchar(100),--备注
status varchar(100),--状态
hf varchar(100)--回访
);
服务站表创建语句如下：
--服务站表注释
create table t_fuwuzhan(
id int identity(1,1) primary key not null,--主键
title varchar(100),--服务站名称
fzr varchar(100),--负责人
remark varchar(100),--备注
wz varchar(100)--位置
);
服务项目表创建语句如下：
--服务项目表注释
create table t_fwxm(
id int identity(1,1) primary key not null,--主键
title varchar(100),--服务项目
remark varchar(100)--备注
);
活动发布表创建语句如下：
--活动发布表注释
create table t_hdfb(
id int identity(1,1) primary key not null,--主键
hdlxId int,--活动类型
hdfbName varchar(100),--活动名称
dd varchar(100),--地点
showDate datetime,--活动日期
remark varchar(100),--备注
hdry varchar(100)--活动人员
);
活动类型表创建语句如下：
--活动类型表注释
create table t_hdlx(
id int identity(1,1) primary key not null,--主键
hdlxName varchar(100)--活动类型名称
);
街道辖区表创建语句如下：
--街道辖区表注释
create table t_jiedao(
id int identity(1,1) primary key not null,--主键
title varchar(100),--名称
fzr varchar(100),--负责人
remark varchar(100),--备注
wz varchar(100)--位置
);
老人就诊记录表创建语句如下：
--老人就诊记录表注释
create table t_jiuzhen(
id int identity(1,1) primary key not null,--主键
laorenbh varchar(100),--老人编号
ghlx varchar(100),--挂号类型
ys varchar(100),--医生
showDate datetime,--就诊时间
remark varchar(100)--就诊备注
);
老人表创建语句如下：
--老人表注释
create table t_laoren(
id int identity(1,1) primary key not null,--主键
laorenbh varchar(100),--编号
laorenName varchar(100),--姓名
phone varchar(100),--电话
age varchar(100),--年龄
bs varchar(100),--病史
sfz varchar(100),--身份证
sex varchar(100)--性别
);
通知信息表创建语句如下：
--通知信息表注释
create table t_message(
id int identity(1,1) primary key not null,--主键
title varchar(100),--通知标题
showDate datetime,--通知时间
pic varchar(100),--图片
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),--姓名
bh varchar(100),--编号
age varchar(100),--年龄
sex varchar(100)--性别
);
体检表创建语句如下：
--体检表注释
create table t_tijian(
id int identity(1,1) primary key not null,--主键
laorenbh varchar(100),--老人编号
showDate datetime,--体检时间
v1 varchar(100),--身高
v2 varchar(100),--体重
v3 varchar(100),--血压
v4 varchar(100),--尿检
v5 varchar(100),--血检
v6 varchar(100),--拍片
v7 varchar(100),--骨头检查
remark varchar(100)--备注
);
投诉处理回访表创建语句如下：
--投诉处理回访表注释
create table t_tscl(
id int identity(1,1) primary key not null,--主键
tsnr varchar(100),--投诉内容
remark varchar(100),--处理回访内容
tssjDate datetime,--投诉时间
clsj datetime--处理时间
);
老人兴趣爱好表创建语句如下：
--老人兴趣爱好表注释
create table t_xingqu(
id int identity(1,1) primary key not null,--主键
laorenbh varchar(100),--老人编号
xingquName varchar(100)--老人兴趣
);
老人用药记录表创建语句如下：
--老人用药记录表注释
create table t_yongyao(
id int identity(1,1) primary key not null,--主键
laorenbh varchar(100),--老人编号
ypname varchar(100),--药品名称
jl varchar(100),--计量
ys varchar(100),--医生
showDate datetime,--用药时间
remark 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_fuwugongdan")
public class Fuwugongdan {
//主键
@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 ptadminId;
//服务工单编号
private String gdbh;
//所属团队
private String tuandui;
//服务工单标题
private String fwgdName;
//服务工单内容
private String content;
//服务地点
private String fwdd;
//服务日期
private Date showDate;
//备注
private String remark;
//状态
private String status;
//回访
private String hf;
public Integer getPtadminId() {return ptadminId;}
public void setPtadminId(Integer ptadminId) {this.ptadminId = ptadminId;}
public String getGdbh() {return gdbh;}
public void setGdbh(String gdbh) {this.gdbh = gdbh;}
public String getTuandui() {return tuandui;}
public void setTuandui(String tuandui) {this.tuandui = tuandui;}
public String getFwgdName() {return fwgdName;}
public void setFwgdName(String fwgdName) {this.fwgdName = fwgdName;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getFwdd() {return fwdd;}
public void setFwdd(String fwdd) {this.fwdd = fwdd;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getHf() {return hf;}
public void setHf(String hf) {this.hf = hf;}
}服务站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_fuwuzhan")
public class Fuwuzhan {
//主键
@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 fzr;
//备注
private String remark;
//位置
private String wz;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public String getWz() {return wz;}
public void setWz(String wz) {this.wz = wz;}
}服务项目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_fwxm")
public class Fwxm {
//主键
@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 remark;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
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_hdfb")
public class Hdfb {
//主键
@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 hdlxId;
//活动名称
private String hdfbName;
//地点
private String dd;
//活动日期
private Date showDate;
//备注
private String remark;
//活动人员
private String hdry;
public Integer getHdlxId() {return hdlxId;}
public void setHdlxId(Integer hdlxId) {this.hdlxId = hdlxId;}
public String getHdfbName() {return hdfbName;}
public void setHdfbName(String hdfbName) {this.hdfbName = hdfbName;}
public String getDd() {return dd;}
public void setDd(String dd) {this.dd = dd;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public String getHdry() {return hdry;}
public void setHdry(String hdry) {this.hdry = hdry;}
}活动类型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_hdlx")
public class Hdlx {
//主键
@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 hdlxName;
public String getHdlxName() {return hdlxName;}
public void setHdlxName(String hdlxName) {this.hdlxName = hdlxName;}
}街道辖区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_jiedao")
public class Jiedao {
//主键
@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 fzr;
//备注
private String remark;
//位置
private String wz;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public String getWz() {return wz;}
public void setWz(String wz) {this.wz = wz;}
}老人就诊记录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_jiuzhen")
public class Jiuzhen {
//主键
@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 laorenbh;
//挂号类型
private String ghlx;
//医生
private String ys;
//就诊时间
private Date showDate;
//就诊备注
private String remark;
public String getLaorenbh() {return laorenbh;}
public void setLaorenbh(String laorenbh) {this.laorenbh = laorenbh;}
public String getGhlx() {return ghlx;}
public void setGhlx(String ghlx) {this.ghlx = ghlx;}
public String getYs() {return ys;}
public void setYs(String ys) {this.ys = ys;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
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_laoren")
public class Laoren {
//主键
@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 laorenbh;
//姓名
private String laorenName;
//电话
private String phone;
//年龄
private String age;
//病史
private String bs;
//身份证
private String sfz;
//性别
private String sex;
public String getLaorenbh() {return laorenbh;}
public void setLaorenbh(String laorenbh) {this.laorenbh = laorenbh;}
public String getLaorenName() {return laorenName;}
public void setLaorenName(String laorenName) {this.laorenName = laorenName;}
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 getBs() {return bs;}
public void setBs(String bs) {this.bs = bs;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
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_message")
public class Message {
//主键
@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 Date showDate;
//图片
private String pic;
//通知内容
private String remark;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
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 bh;
//年龄
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 getPtadminName() {return ptadminName;}
public void setPtadminName(String ptadminName) {this.ptadminName = ptadminName;}
public String getBh() {return bh;}
public void setBh(String bh) {this.bh = bh;}
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_tijian")
public class Tijian {
//主键
@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 laorenbh;
//体检时间
private Date showDate;
//身高
private String v1;
//体重
private String v2;
//血压
private String v3;
//尿检
private String v4;
//血检
private String v5;
//拍片
private String v6;
//骨头检查
private String v7;
//备注
private String remark;
public String getLaorenbh() {return laorenbh;}
public void setLaorenbh(String laorenbh) {this.laorenbh = laorenbh;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
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 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;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
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_tscl")
public class Tscl {
//主键
@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 tsnr;
//处理回访内容
private String remark;
//投诉时间
private Date tssjDate;
//处理时间
private Date clsj;
public String getTsnr() {return tsnr;}
public void setTsnr(String tsnr) {this.tsnr = tsnr;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public Date getTssjDate() {return tssjDate;}
public void setTssjDate(Date tssjDate) {this.tssjDate = tssjDate;}
public Date getClsj() {return clsj;}
public void setClsj(Date clsj) {this.clsj = clsj;}
}老人兴趣爱好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_xingqu")
public class Xingqu {
//主键
@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 laorenbh;
//老人兴趣
private String xingquName;
public String getLaorenbh() {return laorenbh;}
public void setLaorenbh(String laorenbh) {this.laorenbh = laorenbh;}
public String getXingquName() {return xingquName;}
public void setXingquName(String xingquName) {this.xingquName = xingquName;}
}老人用药记录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_yongyao")
public class Yongyao {
//主键
@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 laorenbh;
//药品名称
private String ypname;
//计量
private String jl;
//医生
private String ys;
//用药时间
private Date showDate;
//备注
private String remark;
public String getLaorenbh() {return laorenbh;}
public void setLaorenbh(String laorenbh) {this.laorenbh = laorenbh;}
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 String getYs() {return ys;}
public void setYs(String ys) {this.ys = ys;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
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 Fuwugongdan extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//服务人员
private Integer ptadminId;
//服务工单编号
private String gdbh;
//所属团队
private String tuandui;
//服务工单标题
private String fwgdName;
//服务工单内容
private String content;
//服务地点
private String fwdd;
//服务日期
private Date showDate;
//备注
private String remark;
//状态
private String status;
//回访
private String hf;
public Integer getPtadminId() {return ptadminId;}
public void setPtadminId(Integer ptadminId) {this.ptadminId = ptadminId;}
public String getGdbh() {return gdbh;}
public void setGdbh(String gdbh) {this.gdbh = gdbh;}
public String getTuandui() {return tuandui;}
public void setTuandui(String tuandui) {this.tuandui = tuandui;}
public String getFwgdName() {return fwgdName;}
public void setFwgdName(String fwgdName) {this.fwgdName = fwgdName;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getFwdd() {return fwdd;}
public void setFwdd(String fwdd) {this.fwdd = fwdd;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getHf() {return hf;}
public void setHf(String hf) {this.hf = hf;}
}服务站javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//服务站
public class Fuwuzhan extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//服务站名称
private String title;
//负责人
private String fzr;
//备注
private String remark;
//位置
private String wz;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public String getWz() {return wz;}
public void setWz(String wz) {this.wz = wz;}
}服务项目javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//服务项目
public class Fwxm extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//服务项目
private String title;
//备注
private String remark;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
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 Hdfb extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//活动类型
private Integer hdlxId;
//活动名称
private String hdfbName;
//地点
private String dd;
//活动日期
private Date showDate;
//备注
private String remark;
//活动人员
private String hdry;
public Integer getHdlxId() {return hdlxId;}
public void setHdlxId(Integer hdlxId) {this.hdlxId = hdlxId;}
public String getHdfbName() {return hdfbName;}
public void setHdfbName(String hdfbName) {this.hdfbName = hdfbName;}
public String getDd() {return dd;}
public void setDd(String dd) {this.dd = dd;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public String getHdry() {return hdry;}
public void setHdry(String hdry) {this.hdry = hdry;}
}活动类型javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//活动类型
public class Hdlx extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//活动类型名称
private String hdlxName;
public String getHdlxName() {return hdlxName;}
public void setHdlxName(String hdlxName) {this.hdlxName = hdlxName;}
}街道辖区javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//街道辖区
public class Jiedao extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//名称
private String title;
//负责人
private String fzr;
//备注
private String remark;
//位置
private String wz;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public String getWz() {return wz;}
public void setWz(String wz) {this.wz = wz;}
}老人就诊记录javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//老人就诊记录
public class Jiuzhen extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//老人编号
private String laorenbh;
//挂号类型
private String ghlx;
//医生
private String ys;
//就诊时间
private Date showDate;
//就诊备注
private String remark;
public String getLaorenbh() {return laorenbh;}
public void setLaorenbh(String laorenbh) {this.laorenbh = laorenbh;}
public String getGhlx() {return ghlx;}
public void setGhlx(String ghlx) {this.ghlx = ghlx;}
public String getYs() {return ys;}
public void setYs(String ys) {this.ys = ys;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
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 Laoren extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//编号
private String laorenbh;
//姓名
private String laorenName;
//电话
private String phone;
//年龄
private String age;
//病史
private String bs;
//身份证
private String sfz;
//性别
private String sex;
public String getLaorenbh() {return laorenbh;}
public void setLaorenbh(String laorenbh) {this.laorenbh = laorenbh;}
public String getLaorenName() {return laorenName;}
public void setLaorenName(String laorenName) {this.laorenName = laorenName;}
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 getBs() {return bs;}
public void setBs(String bs) {this.bs = bs;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
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 Message extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//通知标题
private String title;
//通知时间
private Date showDate;
//图片
private String pic;
//通知内容
private String remark;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
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 bh;
//年龄
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 getPtadminName() {return ptadminName;}
public void setPtadminName(String ptadminName) {this.ptadminName = ptadminName;}
public String getBh() {return bh;}
public void setBh(String bh) {this.bh = bh;}
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 Tijian extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//老人编号
private String laorenbh;
//体检时间
private Date showDate;
//身高
private String v1;
//体重
private String v2;
//血压
private String v3;
//尿检
private String v4;
//血检
private String v5;
//拍片
private String v6;
//骨头检查
private String v7;
//备注
private String remark;
public String getLaorenbh() {return laorenbh;}
public void setLaorenbh(String laorenbh) {this.laorenbh = laorenbh;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
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 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;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
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 Tscl extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//投诉内容
private String tsnr;
//处理回访内容
private String remark;
//投诉时间
private Date tssjDate;
//处理时间
private Date clsj;
public String getTsnr() {return tsnr;}
public void setTsnr(String tsnr) {this.tsnr = tsnr;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public Date getTssjDate() {return tssjDate;}
public void setTssjDate(Date tssjDate) {this.tssjDate = tssjDate;}
public Date getClsj() {return clsj;}
public void setClsj(Date clsj) {this.clsj = clsj;}
}老人兴趣爱好javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//老人兴趣爱好
public class Xingqu extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//老人编号
private String laorenbh;
//老人兴趣
private String xingquName;
public String getLaorenbh() {return laorenbh;}
public void setLaorenbh(String laorenbh) {this.laorenbh = laorenbh;}
public String getXingquName() {return xingquName;}
public void setXingquName(String xingquName) {this.xingquName = xingquName;}
}老人用药记录javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//老人用药记录
public class Yongyao extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//老人编号
private String laorenbh;
//药品名称
private String ypname;
//计量
private String jl;
//医生
private String ys;
//用药时间
private Date showDate;
//备注
private String remark;
public String getLaorenbh() {return laorenbh;}
public void setLaorenbh(String laorenbh) {this.laorenbh = laorenbh;}
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 String getYs() {return ys;}
public void setYs(String ys) {this.ys = ys;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}