- 基于jsp的民政养老系统mysql数据库创建语句
- 基于jsp的民政养老系统oracle数据库创建语句
- 基于jsp的民政养老系统sqlserver数据库创建语句
- 基于jsp的民政养老系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 基于jsp的民政养老系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
基于jsp的民政养老系统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_ckrk(
id int primary key auto_increment comment '主键',
productId int comment '货品',
types varchar(100) comment '类型',
showDate varchar(100) comment '标记日期'
) comment '货品出库入库';
床位管理表创建语句如下：
create table t_fjh(
id int primary key auto_increment comment '主键',
lfId int comment '楼房',
fjh varchar(100) comment '房间号'
) comment '床位管理';
费用管理表创建语句如下：
create table t_fy(
id int primary key auto_increment comment '主键',
types varchar(100) comment '类型',
content varchar(100) comment '内容',
num int comment '费用',
showDate varchar(100) comment '标记日期'
) comment '费用管理';
接待管理表创建语句如下：
create table t_jd(
id int primary key auto_increment comment '主键',
types varchar(100) comment '类型',
content varchar(100) comment '内容',
insertDate datetime comment '记录日期'
) comment '接待管理';
老人资料表创建语句如下：
create table t_laoren(
id int primary key auto_increment comment '主键',
laorenName varchar(100) comment '姓名',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
phone varchar(100) comment '电话',
qs varchar(100) comment '亲属联系电话'
) comment '老人资料';
楼房信息表创建语句如下：
create table t_lf(
id int primary key auto_increment comment '主键',
v1 varchar(100) comment '楼房资料',
v2 varchar(100) comment '房间资料'
) comment '楼房信息';
老人信息登记表创建语句如下：
create table t_lrdj(
id int primary key auto_increment comment '主键',
laorenId int comment '老人',
types varchar(100) comment '类型',
content varchar(100) comment '内容',
showDate varchar(100) comment '标记日期'
) comment '老人信息登记';
货品表创建语句如下：
create table t_product(
id int primary key auto_increment comment '主键',
productName varchar(100) comment '货物名称',
kc int comment '库存'
) comment '货品';
员工表创建语句如下：
create table t_yg(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
ygName varchar(100) comment '员工名称',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
phone varchar(100) 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 '床位管理权限'
) comment '员工';
员工信息记录表创建语句如下：
create table t_ygdj(
id int primary key auto_increment comment '主键',
ygId int comment '员工',
types varchar(100) comment '类型',
content varchar(100) comment '内容',
showDate varchar(100) comment '标记日期'
) comment '员工信息记录';
基于jsp的民政养老系统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_ckrk(
id integer,
productId int,
types varchar(100),
showDate varchar(100)
);
--货品出库入库字段加注释
comment on column t_ckrk.id is '主键';
comment on column t_ckrk.productId is '货品';
comment on column t_ckrk.types is '类型';
comment on column t_ckrk.showDate is '标记日期';
--货品出库入库表加注释
comment on table t_ckrk is '货品出库入库';
床位管理表创建语句如下：
create table t_fjh(
id integer,
lfId int,
fjh varchar(100)
);
--床位管理字段加注释
comment on column t_fjh.id is '主键';
comment on column t_fjh.lfId is '楼房';
comment on column t_fjh.fjh is '房间号';
--床位管理表加注释
comment on table t_fjh is '床位管理';
费用管理表创建语句如下：
create table t_fy(
id integer,
types varchar(100),
content varchar(100),
num int,
showDate varchar(100)
);
--费用管理字段加注释
comment on column t_fy.id is '主键';
comment on column t_fy.types is '类型';
comment on column t_fy.content is '内容';
comment on column t_fy.num is '费用';
comment on column t_fy.showDate is '标记日期';
--费用管理表加注释
comment on table t_fy is '费用管理';
接待管理表创建语句如下：
create table t_jd(
id integer,
types varchar(100),
content varchar(100),
insertDate datetime
);
--接待管理字段加注释
comment on column t_jd.id is '主键';
comment on column t_jd.types is '类型';
comment on column t_jd.content is '内容';
comment on column t_jd.insertDate is '记录日期';
--接待管理表加注释
comment on table t_jd is '接待管理';
老人资料表创建语句如下：
create table t_laoren(
id integer,
laorenName varchar(100),
age varchar(100),
sex varchar(100),
phone varchar(100),
qs varchar(100)
);
--老人资料字段加注释
comment on column t_laoren.id is '主键';
comment on column t_laoren.laorenName is '姓名';
comment on column t_laoren.age is '年龄';
comment on column t_laoren.sex is '性别';
comment on column t_laoren.phone is '电话';
comment on column t_laoren.qs is '亲属联系电话';
--老人资料表加注释
comment on table t_laoren is '老人资料';
楼房信息表创建语句如下：
create table t_lf(
id integer,
v1 varchar(100),
v2 varchar(100)
);
--楼房信息字段加注释
comment on column t_lf.id is '主键';
comment on column t_lf.v1 is '楼房资料';
comment on column t_lf.v2 is '房间资料';
--楼房信息表加注释
comment on table t_lf is '楼房信息';
老人信息登记表创建语句如下：
create table t_lrdj(
id integer,
laorenId int,
types varchar(100),
content varchar(100),
showDate varchar(100)
);
--老人信息登记字段加注释
comment on column t_lrdj.id is '主键';
comment on column t_lrdj.laorenId is '老人';
comment on column t_lrdj.types is '类型';
comment on column t_lrdj.content is '内容';
comment on column t_lrdj.showDate is '标记日期';
--老人信息登记表加注释
comment on table t_lrdj is '老人信息登记';
货品表创建语句如下：
create table t_product(
id integer,
productName varchar(100),
kc int
);
--货品字段加注释
comment on column t_product.id is '主键';
comment on column t_product.productName is '货物名称';
comment on column t_product.kc is '库存';
--货品表加注释
comment on table t_product is '货品';
员工表创建语句如下：
create table t_yg(
id integer,
username varchar(100),
password varchar(100),
ygName varchar(100),
age varchar(100),
sex varchar(100),
phone varchar(100),
v1 varchar(100),
v2 varchar(100),
v3 varchar(100),
v4 varchar(100),
v5 varchar(100),
v6 varchar(100)
);
--员工字段加注释
comment on column t_yg.id is '主键';
comment on column t_yg.username is '账号';
comment on column t_yg.password is '密码';
comment on column t_yg.ygName is '员工名称';
comment on column t_yg.age is '年龄';
comment on column t_yg.sex is '性别';
comment on column t_yg.phone is '电话';
comment on column t_yg.v1 is '接待管理权限';
comment on column t_yg.v2 is '费用管理权限';
comment on column t_yg.v3 is '老人管理权限';
comment on column t_yg.v4 is '人事管理权限';
comment on column t_yg.v5 is '仓库管理权限';
comment on column t_yg.v6 is '床位管理权限';
--员工表加注释
comment on table t_yg is '员工';
员工信息记录表创建语句如下：
create table t_ygdj(
id integer,
ygId int,
types varchar(100),
content varchar(100),
showDate varchar(100)
);
--员工信息记录字段加注释
comment on column t_ygdj.id is '主键';
comment on column t_ygdj.ygId is '员工';
comment on column t_ygdj.types is '类型';
comment on column t_ygdj.content is '内容';
comment on column t_ygdj.showDate is '标记日期';
--员工信息记录表加注释
comment on table t_ygdj is '员工信息记录';
oracle特有，对应序列如下：
create sequence s_t_ckrk;
create sequence s_t_fjh;
create sequence s_t_fy;
create sequence s_t_jd;
create sequence s_t_laoren;
create sequence s_t_lf;
create sequence s_t_lrdj;
create sequence s_t_product;
create sequence s_t_yg;
create sequence s_t_ygdj;
基于jsp的民政养老系统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_ckrk(
id int identity(1,1) primary key not null,--主键
productId int,--货品
types varchar(100),--类型
showDate varchar(100)--标记日期
);
床位管理表创建语句如下：
--床位管理表注释
create table t_fjh(
id int identity(1,1) primary key not null,--主键
lfId int,--楼房
fjh varchar(100)--房间号
);
费用管理表创建语句如下：
--费用管理表注释
create table t_fy(
id int identity(1,1) primary key not null,--主键
types varchar(100),--类型
content varchar(100),--内容
num int,--费用
showDate varchar(100)--标记日期
);
接待管理表创建语句如下：
--接待管理表注释
create table t_jd(
id int identity(1,1) primary key not null,--主键
types varchar(100),--类型
content varchar(100),--内容
insertDate datetime--记录日期
);
老人资料表创建语句如下：
--老人资料表注释
create table t_laoren(
id int identity(1,1) primary key not null,--主键
laorenName varchar(100),--姓名
age varchar(100),--年龄
sex varchar(100),--性别
phone varchar(100),--电话
qs varchar(100)--亲属联系电话
);
楼房信息表创建语句如下：
--楼房信息表注释
create table t_lf(
id int identity(1,1) primary key not null,--主键
v1 varchar(100),--楼房资料
v2 varchar(100)--房间资料
);
老人信息登记表创建语句如下：
--老人信息登记表注释
create table t_lrdj(
id int identity(1,1) primary key not null,--主键
laorenId int,--老人
types varchar(100),--类型
content varchar(100),--内容
showDate varchar(100)--标记日期
);
货品表创建语句如下：
--货品表注释
create table t_product(
id int identity(1,1) primary key not null,--主键
productName varchar(100),--货物名称
kc int--库存
);
员工表创建语句如下：
--员工表注释
create table t_yg(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
ygName varchar(100),--员工名称
age varchar(100),--年龄
sex varchar(100),--性别
phone varchar(100),--电话
v1 varchar(100),--接待管理权限
v2 varchar(100),--费用管理权限
v3 varchar(100),--老人管理权限
v4 varchar(100),--人事管理权限
v5 varchar(100),--仓库管理权限
v6 varchar(100)--床位管理权限
);
员工信息记录表创建语句如下：
--员工信息记录表注释
create table t_ygdj(
id int identity(1,1) primary key not null,--主键
ygId int,--员工
types varchar(100),--类型
content varchar(100),--内容
showDate varchar(100)--标记日期
);
登录后主页.jpg?x-oss-process=style/00001)
基于jsp的民政养老系统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_ckrk")
public class Ckrk {
//主键
@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 productId;
//类型
private String types;
//标记日期
private String showDate;
public Integer getProductId() {return productId;}
public void setProductId(Integer productId) {this.productId = productId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getShowDate() {return showDate;}
public void setShowDate(String 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_fjh")
public class Fjh {
//主键
@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 lfId;
//房间号
private String fjh;
public Integer getLfId() {return lfId;}
public void setLfId(Integer lfId) {this.lfId = lfId;}
public String getFjh() {return fjh;}
public void setFjh(String fjh) {this.fjh = fjh;}
}费用管理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_fy")
public class Fy {
//主键
@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 types;
//内容
private String content;
//费用
private Integer num;
//标记日期
private String showDate;
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 Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
public String getShowDate() {return showDate;}
public void setShowDate(String 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_jd")
public class Jd {
//主键
@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 types;
//内容
private String content;
//记录日期
private Date insertDate;
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 Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}老人资料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 laorenName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//亲属联系电话
private String qs;
public String getLaorenName() {return laorenName;}
public void setLaorenName(String laorenName) {this.laorenName = laorenName;}
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 getQs() {return qs;}
public void setQs(String qs) {this.qs = qs;}
}楼房信息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_lf")
public class Lf {
//主键
@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 v2;
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;}
}老人信息登记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_lrdj")
public class Lrdj {
//主键
@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 laorenId;
//类型
private String types;
//内容
private String content;
//标记日期
private String showDate;
public Integer getLaorenId() {return laorenId;}
public void setLaorenId(Integer laorenId) {this.laorenId = laorenId;}
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 getShowDate() {return showDate;}
public void setShowDate(String 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_product")
public class Product {
//主键
@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 productName;
//库存
private Integer kc;
public String getProductName() {return productName;}
public void setProductName(String productName) {this.productName = productName;}
public Integer getKc() {return kc;}
public void setKc(Integer kc) {this.kc = kc;}
}员工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_yg")
public class Yg {
//主键
@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 ygName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//接待管理权限
private String v1;
//费用管理权限
private String v2;
//老人管理权限
private String v3;
//人事管理权限
private String v4;
//仓库管理权限
private String v5;
//床位管理权限
private String v6;
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 getYgName() {return ygName;}
public void setYgName(String ygName) {this.ygName = ygName;}
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 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;}
}员工信息记录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_ygdj")
public class Ygdj {
//主键
@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 ygId;
//类型
private String types;
//内容
private String content;
//标记日期
private String showDate;
public Integer getYgId() {return ygId;}
public void setYgId(Integer ygId) {this.ygId = ygId;}
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 getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
}基于jsp的民政养老系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
货品出库入库javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//货品出库入库
public class Ckrk extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//货品
private Integer productId;
//类型
private String types;
//标记日期
private String showDate;
public Integer getProductId() {return productId;}
public void setProductId(Integer productId) {this.productId = productId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
}床位管理javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//床位管理
public class Fjh extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//楼房
private Integer lfId;
//房间号
private String fjh;
public Integer getLfId() {return lfId;}
public void setLfId(Integer lfId) {this.lfId = lfId;}
public String getFjh() {return fjh;}
public void setFjh(String fjh) {this.fjh = fjh;}
}费用管理javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//费用管理
public class Fy extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//类型
private String types;
//内容
private String content;
//费用
private Integer num;
//标记日期
private String showDate;
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 Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
}接待管理javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//接待管理
public class Jd extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//类型
private String types;
//内容
private String content;
//记录日期
private Date insertDate;
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 Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}老人资料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 laorenName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//亲属联系电话
private String qs;
public String getLaorenName() {return laorenName;}
public void setLaorenName(String laorenName) {this.laorenName = laorenName;}
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 getQs() {return qs;}
public void setQs(String qs) {this.qs = qs;}
}楼房信息javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//楼房信息
public class Lf extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//楼房资料
private String v1;
//房间资料
private String v2;
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;}
}老人信息登记javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//老人信息登记
public class Lrdj extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//老人
private Integer laorenId;
//类型
private String types;
//内容
private String content;
//标记日期
private String showDate;
public Integer getLaorenId() {return laorenId;}
public void setLaorenId(Integer laorenId) {this.laorenId = laorenId;}
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 getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
}货品javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//货品
public class Product extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//货物名称
private String productName;
//库存
private Integer kc;
public String getProductName() {return productName;}
public void setProductName(String productName) {this.productName = productName;}
public Integer getKc() {return kc;}
public void setKc(Integer kc) {this.kc = kc;}
}员工javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//员工
public class Yg 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 ygName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//接待管理权限
private String v1;
//费用管理权限
private String v2;
//老人管理权限
private String v3;
//人事管理权限
private String v4;
//仓库管理权限
private String v5;
//床位管理权限
private String v6;
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 getYgName() {return ygName;}
public void setYgName(String ygName) {this.ygName = ygName;}
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 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;}
}员工信息记录javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//员工信息记录
public class Ygdj extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//员工
private Integer ygId;
//类型
private String types;
//内容
private String content;
//标记日期
private String showDate;
public Integer getYgId() {return ygId;}
public void setYgId(Integer ygId) {this.ygId = ygId;}
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 getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
}