- 基于javaEE的宜州市精准扶贫管理系统的设计与实现mysql数据库创建语句
- 基于javaEE的宜州市精准扶贫管理系统的设计与实现oracle数据库创建语句
- 基于javaEE的宜州市精准扶贫管理系统的设计与实现sqlserver数据库创建语句
- 基于javaEE的宜州市精准扶贫管理系统的设计与实现spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 基于javaEE的宜州市精准扶贫管理系统的设计与实现spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
基于javaEE的宜州市精准扶贫管理系统的设计与实现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 '主键',
czId int comment '村镇',
username varchar(100) comment '账号',
password varchar(100) comment '密码 ',
customerName varchar(100) comment '姓名',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
phone varchar(100) comment '电话',
address varchar(100) comment '住址'
) comment '贫困人员';
村镇表创建语句如下：
create table t_cz(
id int primary key auto_increment comment '主键',
czName varchar(100) comment '村镇',
bgsdh varchar(100) comment '办公室电话'
) comment '村镇';
扶贫搬迁表创建语句如下：
create table t_fpbq(
id int primary key auto_increment comment '主键',
customerId int comment '贫困人员',
v1 varchar(100) comment '源住址',
v2 varchar(100) comment '新住址',
v3 varchar(100) comment '合同文件',
v4 varchar(100) comment '负责人',
v5 varchar(100) comment '联系电话',
showDate varchar(100) comment '搬迁时间段',
content varchar(100) comment '详细内容记录',
status varchar(100) comment '状态'
) comment '扶贫搬迁';
技能创业培训表创建语句如下：
create table t_jnpx(
id int primary key auto_increment comment '主键',
customerId int comment '贫困人员',
v1 varchar(100) comment '培训标题',
v2 varchar(100) comment '培训文档',
v3 varchar(100) comment '培训地点',
v4 varchar(100) comment '培训讲师',
v5 varchar(100) comment '联系电话',
showDate varchar(100) comment '培训时间段',
content varchar(100) comment '详细内容记录',
status varchar(100) comment '状态'
) comment '技能创业培训';
教学资助表创建语句如下：
create table t_jxzz(
id int primary key auto_increment comment '主键',
customerId int comment '贫困人员',
title varchar(100) comment '简单说明',
v1 varchar(100) comment '类型',
fee int comment '资助金额',
v4 varchar(100) comment '负责人',
v5 varchar(100) comment '联系电话',
showDate datetime comment '资助时间',
content varchar(100) comment '备忘录'
) comment '教学资助';
贫困需求表创建语句如下：
create table t_pkxq(
id int primary key auto_increment comment '主键',
customerId int comment '贫困人员',
title varchar(100) comment '简单说明',
content varchar(100) comment '详细内容',
fileUrl varchar(100) comment '附件',
showDate datetime 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_xmzz(
id int primary key auto_increment comment '主键',
customerId int comment '贫困人员',
title varchar(100) comment '项目名称',
fee int comment '资助金额',
v4 varchar(100) comment '负责人',
v5 varchar(100) comment '联系电话',
showDate datetime comment '资助时间',
content varchar(100) comment '备忘录',
remark varchar(100) comment '进度监控',
status varchar(100) comment '状态'
) comment '项目资助';
资金分配表创建语句如下：
create table t_zjfp(
id int primary key auto_increment comment '主键',
customerId int comment '贫困人员',
pkxqId int comment '平困需求',
fee varchar(100) comment '分配金额',
content varchar(100) comment '详细说明',
czr varchar(100) comment '操作人',
showDate datetime comment '操作日期'
) comment '资金分配';
基于javaEE的宜州市精准扶贫管理系统的设计与实现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,
czId int,
username varchar(100),
password varchar(100),
customerName varchar(100),
age varchar(100),
sex varchar(100),
phone varchar(100),
address varchar(100)
);
--贫困人员字段加注释
comment on column t_customer.id is '主键';
comment on column t_customer.czId 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.address is '住址';
--贫困人员表加注释
comment on table t_customer is '贫困人员';
村镇表创建语句如下：
create table t_cz(
id integer,
czName varchar(100),
bgsdh varchar(100)
);
--村镇字段加注释
comment on column t_cz.id is '主键';
comment on column t_cz.czName is '村镇';
comment on column t_cz.bgsdh is '办公室电话';
--村镇表加注释
comment on table t_cz is '村镇';
扶贫搬迁表创建语句如下：
create table t_fpbq(
id integer,
customerId int,
v1 varchar(100),
v2 varchar(100),
v3 varchar(100),
v4 varchar(100),
v5 varchar(100),
showDate varchar(100),
content varchar(100),
status varchar(100)
);
--扶贫搬迁字段加注释
comment on column t_fpbq.id is '主键';
comment on column t_fpbq.customerId is '贫困人员';
comment on column t_fpbq.v1 is '源住址';
comment on column t_fpbq.v2 is '新住址';
comment on column t_fpbq.v3 is '合同文件';
comment on column t_fpbq.v4 is '负责人';
comment on column t_fpbq.v5 is '联系电话';
comment on column t_fpbq.showDate is '搬迁时间段';
comment on column t_fpbq.content is '详细内容记录';
comment on column t_fpbq.status is '状态';
--扶贫搬迁表加注释
comment on table t_fpbq is '扶贫搬迁';
技能创业培训表创建语句如下：
create table t_jnpx(
id integer,
customerId int,
v1 varchar(100),
v2 varchar(100),
v3 varchar(100),
v4 varchar(100),
v5 varchar(100),
showDate varchar(100),
content varchar(100),
status varchar(100)
);
--技能创业培训字段加注释
comment on column t_jnpx.id is '主键';
comment on column t_jnpx.customerId is '贫困人员';
comment on column t_jnpx.v1 is '培训标题';
comment on column t_jnpx.v2 is '培训文档';
comment on column t_jnpx.v3 is '培训地点';
comment on column t_jnpx.v4 is '培训讲师';
comment on column t_jnpx.v5 is '联系电话';
comment on column t_jnpx.showDate is '培训时间段';
comment on column t_jnpx.content is '详细内容记录';
comment on column t_jnpx.status is '状态';
--技能创业培训表加注释
comment on table t_jnpx is '技能创业培训';
教学资助表创建语句如下：
create table t_jxzz(
id integer,
customerId int,
title varchar(100),
v1 varchar(100),
fee int,
v4 varchar(100),
v5 varchar(100),
showDate datetime,
content varchar(100)
);
--教学资助字段加注释
comment on column t_jxzz.id is '主键';
comment on column t_jxzz.customerId is '贫困人员';
comment on column t_jxzz.title is '简单说明';
comment on column t_jxzz.v1 is '类型';
comment on column t_jxzz.fee is '资助金额';
comment on column t_jxzz.v4 is '负责人';
comment on column t_jxzz.v5 is '联系电话';
comment on column t_jxzz.showDate is '资助时间';
comment on column t_jxzz.content is '备忘录';
--教学资助表加注释
comment on table t_jxzz is '教学资助';
贫困需求表创建语句如下：
create table t_pkxq(
id integer,
customerId int,
title varchar(100),
content varchar(100),
fileUrl varchar(100),
showDate datetime
);
--贫困需求字段加注释
comment on column t_pkxq.id is '主键';
comment on column t_pkxq.customerId is '贫困人员';
comment on column t_pkxq.title is '简单说明';
comment on column t_pkxq.content is '详细内容';
comment on column t_pkxq.fileUrl is '附件';
comment on column t_pkxq.showDate is '记录日期';
--贫困需求表加注释
comment on table t_pkxq 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_xmzz(
id integer,
customerId int,
title varchar(100),
fee int,
v4 varchar(100),
v5 varchar(100),
showDate datetime,
content varchar(100),
remark varchar(100),
status varchar(100)
);
--项目资助字段加注释
comment on column t_xmzz.id is '主键';
comment on column t_xmzz.customerId is '贫困人员';
comment on column t_xmzz.title is '项目名称';
comment on column t_xmzz.fee is '资助金额';
comment on column t_xmzz.v4 is '负责人';
comment on column t_xmzz.v5 is '联系电话';
comment on column t_xmzz.showDate is '资助时间';
comment on column t_xmzz.content is '备忘录';
comment on column t_xmzz.remark is '进度监控';
comment on column t_xmzz.status is '状态';
--项目资助表加注释
comment on table t_xmzz is '项目资助';
资金分配表创建语句如下：
create table t_zjfp(
id integer,
customerId int,
pkxqId int,
fee varchar(100),
content varchar(100),
czr varchar(100),
showDate datetime
);
--资金分配字段加注释
comment on column t_zjfp.id is '主键';
comment on column t_zjfp.customerId is '贫困人员';
comment on column t_zjfp.pkxqId is '平困需求';
comment on column t_zjfp.fee is '分配金额';
comment on column t_zjfp.content is '详细说明';
comment on column t_zjfp.czr is '操作人';
comment on column t_zjfp.showDate is '操作日期';
--资金分配表加注释
comment on table t_zjfp is '资金分配';
oracle特有，对应序列如下：
create sequence s_t_customer;
create sequence s_t_cz;
create sequence s_t_fpbq;
create sequence s_t_jnpx;
create sequence s_t_jxzz;
create sequence s_t_pkxq;
create sequence s_t_ptadmin;
create sequence s_t_xmzz;
create sequence s_t_zjfp;
基于javaEE的宜州市精准扶贫管理系统的设计与实现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,--主键
czId int,--村镇
username varchar(100),--账号
password varchar(100),--密码
customerName varchar(100),--姓名
age varchar(100),--年龄
sex varchar(100),--性别
phone varchar(100),--电话
address varchar(100)--住址
);
村镇表创建语句如下：
--村镇表注释
create table t_cz(
id int identity(1,1) primary key not null,--主键
czName varchar(100),--村镇
bgsdh varchar(100)--办公室电话
);
扶贫搬迁表创建语句如下：
--扶贫搬迁表注释
create table t_fpbq(
id int identity(1,1) primary key not null,--主键
customerId int,--贫困人员
v1 varchar(100),--源住址
v2 varchar(100),--新住址
v3 varchar(100),--合同文件
v4 varchar(100),--负责人
v5 varchar(100),--联系电话
showDate varchar(100),--搬迁时间段
content varchar(100),--详细内容记录
status varchar(100)--状态
);
技能创业培训表创建语句如下：
--技能创业培训表注释
create table t_jnpx(
id int identity(1,1) primary key not null,--主键
customerId int,--贫困人员
v1 varchar(100),--培训标题
v2 varchar(100),--培训文档
v3 varchar(100),--培训地点
v4 varchar(100),--培训讲师
v5 varchar(100),--联系电话
showDate varchar(100),--培训时间段
content varchar(100),--详细内容记录
status varchar(100)--状态
);
教学资助表创建语句如下：
--教学资助表注释
create table t_jxzz(
id int identity(1,1) primary key not null,--主键
customerId int,--贫困人员
title varchar(100),--简单说明
v1 varchar(100),--类型
fee int,--资助金额
v4 varchar(100),--负责人
v5 varchar(100),--联系电话
showDate datetime,--资助时间
content varchar(100)--备忘录
);
贫困需求表创建语句如下：
--贫困需求表注释
create table t_pkxq(
id int identity(1,1) primary key not null,--主键
customerId int,--贫困人员
title varchar(100),--简单说明
content varchar(100),--详细内容
fileUrl varchar(100),--附件
showDate datetime--记录日期
);
普通管理员表创建语句如下：
--普通管理员表注释
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_xmzz(
id int identity(1,1) primary key not null,--主键
customerId int,--贫困人员
title varchar(100),--项目名称
fee int,--资助金额
v4 varchar(100),--负责人
v5 varchar(100),--联系电话
showDate datetime,--资助时间
content varchar(100),--备忘录
remark varchar(100),--进度监控
status varchar(100)--状态
);
资金分配表创建语句如下：
--资金分配表注释
create table t_zjfp(
id int identity(1,1) primary key not null,--主键
customerId int,--贫困人员
pkxqId int,--平困需求
fee varchar(100),--分配金额
content varchar(100),--详细说明
czr varchar(100),--操作人
showDate datetime--操作日期
);
登录后主页.jpg?x-oss-process=style/00001)
基于javaEE的宜州市精准扶贫管理系统的设计与实现spring+springMVC+hibernate框架对象(javaBean,pojo)设计：
贫困人员javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//贫困人员
@Table(name = "t_customer")
public class Customer {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//村镇
private Integer czId;
//账号
private String username;
//密码
private String password;
//姓名
private String customerName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//住址
private String address;
public Integer getCzId() {return czId;}
public void setCzId(Integer czId) {this.czId = czId;}
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
public String 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 getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
}村镇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_cz")
public class Cz {
//主键
@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 czName;
//办公室电话
private String bgsdh;
public String getCzName() {return czName;}
public void setCzName(String czName) {this.czName = czName;}
public String getBgsdh() {return bgsdh;}
public void setBgsdh(String bgsdh) {this.bgsdh = bgsdh;}
}扶贫搬迁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_fpbq")
public class Fpbq {
//主键
@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 v2;
//合同文件
private String v3;
//负责人
private String v4;
//联系电话
private String v5;
//搬迁时间段
private String showDate;
//详细内容记录
private String content;
//状态
private String status;
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 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 getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}技能创业培训javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//技能创业培训
@Table(name = "t_jnpx")
public class Jnpx {
//主键
@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 v2;
//培训地点
private String v3;
//培训讲师
private String v4;
//联系电话
private String v5;
//培训时间段
private String showDate;
//详细内容记录
private String content;
//状态
private String status;
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 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 getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}教学资助javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//教学资助
@Table(name = "t_jxzz")
public class Jxzz {
//主键
@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 v1;
//资助金额
private Integer fee;
//负责人
private String v4;
//联系电话
private String v5;
//资助时间
private Date showDate;
//备忘录
private String content;
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 getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
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 Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}贫困需求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_pkxq")
public class Pkxq {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//贫困人员
private Integer customerId;
//简单说明
private String title;
//详细内容
private String content;
//附件
private String fileUrl;
//记录日期
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 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;}
}普通管理员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_xmzz")
public class Xmzz {
//主键
@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 Integer fee;
//负责人
private String v4;
//联系电话
private String v5;
//资助时间
private Date showDate;
//备忘录
private String content;
//进度监控
private String remark;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
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 Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public 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;}
}资金分配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_zjfp")
public class Zjfp {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//贫困人员
private Integer customerId;
//平困需求
private Integer pkxqId;
//分配金额
private String fee;
//详细说明
private String content;
//操作人
private String czr;
//操作日期
private Date showDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getPkxqId() {return pkxqId;}
public void setPkxqId(Integer pkxqId) {this.pkxqId = pkxqId;}
public String getFee() {return fee;}
public void setFee(String fee) {this.fee = fee;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getCzr() {return czr;}
public void setCzr(String czr) {this.czr = czr;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}基于javaEE的宜州市精准扶贫管理系统的设计与实现spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
贫困人员javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//贫困人员
public class Customer extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//村镇
private Integer czId;
//账号
private String username;
//密码
private String password;
//姓名
private String customerName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//住址
private String address;
public Integer getCzId() {return czId;}
public void setCzId(Integer czId) {this.czId = czId;}
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
public String 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 getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
}村镇javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//村镇
public class Cz extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//村镇
private String czName;
//办公室电话
private String bgsdh;
public String getCzName() {return czName;}
public void setCzName(String czName) {this.czName = czName;}
public String getBgsdh() {return bgsdh;}
public void setBgsdh(String bgsdh) {this.bgsdh = bgsdh;}
}扶贫搬迁javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//扶贫搬迁
public class Fpbq 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 v2;
//合同文件
private String v3;
//负责人
private String v4;
//联系电话
private String v5;
//搬迁时间段
private String showDate;
//详细内容记录
private String content;
//状态
private String status;
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 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 getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}技能创业培训javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//技能创业培训
public class Jnpx 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 v2;
//培训地点
private String v3;
//培训讲师
private String v4;
//联系电话
private String v5;
//培训时间段
private String showDate;
//详细内容记录
private String content;
//状态
private String status;
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 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 getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}教学资助javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//教学资助
public class Jxzz 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 v1;
//资助金额
private Integer fee;
//负责人
private String v4;
//联系电话
private String v5;
//资助时间
private Date showDate;
//备忘录
private String content;
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 getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
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 Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}贫困需求javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//贫困需求
public class Pkxq extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//贫困人员
private Integer customerId;
//简单说明
private String title;
//详细内容
private String content;
//附件
private String fileUrl;
//记录日期
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 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;}
}普通管理员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 Xmzz 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 Integer fee;
//负责人
private String v4;
//联系电话
private String v5;
//资助时间
private Date showDate;
//备忘录
private String content;
//进度监控
private String remark;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
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 Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public 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;}
}资金分配javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//资金分配
public class Zjfp extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//贫困人员
private Integer customerId;
//平困需求
private Integer pkxqId;
//分配金额
private String fee;
//详细说明
private String content;
//操作人
private String czr;
//操作日期
private Date showDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getPkxqId() {return pkxqId;}
public void setPkxqId(Integer pkxqId) {this.pkxqId = pkxqId;}
public String getFee() {return fee;}
public void setFee(String fee) {this.fee = fee;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getCzr() {return czr;}
public void setCzr(String czr) {this.czr = czr;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}