基于SSM框架的教代会提案管理系统的设计和实现

设计和实现基于SSM框架的教代会提案管理系统。
对提案的填写、发布、审核、通过等流程进行调查分析,
结合软件工程方法和数据库技术等专业知识,利用JDBC、JSP、JS、MySQL数据库,
SSM框架等编程语言和工具,实现一个切实可用的教代会提案管理系统。

2.拟解决的主要问题:
1)需求分析,理解每种角色的工作与整个提案管理的工作流程
2)用户类型和用户权限划分
确定代表、工会、部门负责人、校领导不同的权限和各自允许进行的操作。
3)系统在设计时考虑到功能的可扩展性与维护的方便性,以达到后续功能开发,减少修改的难度。
4)测试方法的选择:测试方法和测试用例的选择。
5)软件界面设计:根据工作流程设计合理的、友好的人机界面。
6)系统运行稳定,具有强大的数据处理功能。
7)存储用户信息。
8)系统功能模块设计与实现
代表角色功能模块:1.填写新提案,2.查看被退回的提案,3.处理提案征求意见,4.查看已提交的提案。
工会角色功能模块:1.查看待立案的提案,2.查看被退回的提案,3.查看已立案的提案。 
部门负责人角色功能模块:1.查看待处理的提案,2.查看已处理的提案。
校领导角色功能模块:1.查看待立案的提案,2.查看处理中的提案,3.查看已完结的
提案。

基于SSM框架的教代会提案管理系统的设计和实现登录注册界面

基于SSM框架的教代会提案管理系统的设计和实现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_bmfzr(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	bmfzrName varchar(100) comment '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话',
	idcard varchar(100) comment '身份证',
	address varchar(100) comment '住址',
	pic varchar(100) comment '图片'
) comment '部门负责人';

代表表创建语句如下:


create table t_db(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	dbName varchar(100) comment '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话',
	idcard varchar(100) comment '身份证',
	address varchar(100) comment '住址',
	pic varchar(100) comment '图片'
) comment '代表';

工会表创建语句如下:


create table t_gh(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	ghName varchar(100) comment '工会名称',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话',
	idcard varchar(100) comment '身份证',
	address varchar(100) comment '住址',
	pic varchar(100) comment '图片'
) comment '工会';

新提案表创建语句如下:


create table t_order(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '标题',
	content varchar(100) comment '内容',
	fileUrl varchar(100) comment '附件',
	dbId int comment '代表',
	insertDate datetime comment '发起日期',
	ghContent varchar(100) comment '工会处理意见',
	bmfzrContent varchar(100) comment '部门负责人处理意见',
	status varchar(100) comment '状态'
) comment '新提案';

普通管理员表创建语句如下:


create table t_ptadmin(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	ptadminName varchar(100) comment '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话'
) comment '普通管理员';

校领导表创建语句如下:


create table t_xld(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	xldName varchar(100) comment '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话',
	idcard varchar(100) comment '身份证',
	address varchar(100) comment '住址',
	pic varchar(100) comment '图片'
) comment '校领导';

提案征求意见表创建语句如下:


create table t_zqyj(
	id int primary key auto_increment comment '主键',
	dbId int comment '代表',
	xm varchar(100) comment '姓名',
	phone varchar(100) comment '联系方式',
	content varchar(100) comment '内容'
) comment '提案征求意见';

基于SSM框架的教代会提案管理系统的设计和实现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_bmfzr(
	id integer,
	username varchar(100),
	password varchar(100),
	bmfzrName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100),
	idcard varchar(100),
	address varchar(100),
	pic varchar(100)
);
--部门负责人字段加注释
comment on column t_bmfzr.id is '主键';
comment on column t_bmfzr.username is '账号';
comment on column t_bmfzr.password is '密码';
comment on column t_bmfzr.bmfzrName is '姓名';
comment on column t_bmfzr.age is '年龄';
comment on column t_bmfzr.sex is '性别';
comment on column t_bmfzr.phone is '电话';
comment on column t_bmfzr.idcard is '身份证';
comment on column t_bmfzr.address is '住址';
comment on column t_bmfzr.pic is '图片';
--部门负责人表加注释
comment on table t_bmfzr is '部门负责人';

代表表创建语句如下:


create table t_db(
	id integer,
	username varchar(100),
	password varchar(100),
	dbName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100),
	idcard varchar(100),
	address varchar(100),
	pic varchar(100)
);
--代表字段加注释
comment on column t_db.id is '主键';
comment on column t_db.username is '账号';
comment on column t_db.password is '密码';
comment on column t_db.dbName is '姓名';
comment on column t_db.age is '年龄';
comment on column t_db.sex is '性别';
comment on column t_db.phone is '电话';
comment on column t_db.idcard is '身份证';
comment on column t_db.address is '住址';
comment on column t_db.pic is '图片';
--代表表加注释
comment on table t_db is '代表';

工会表创建语句如下:


create table t_gh(
	id integer,
	username varchar(100),
	password varchar(100),
	ghName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100),
	idcard varchar(100),
	address varchar(100),
	pic varchar(100)
);
--工会字段加注释
comment on column t_gh.id is '主键';
comment on column t_gh.username is '账号';
comment on column t_gh.password is '密码';
comment on column t_gh.ghName is '工会名称';
comment on column t_gh.age is '年龄';
comment on column t_gh.sex is '性别';
comment on column t_gh.phone is '电话';
comment on column t_gh.idcard is '身份证';
comment on column t_gh.address is '住址';
comment on column t_gh.pic is '图片';
--工会表加注释
comment on table t_gh is '工会';

新提案表创建语句如下:


create table t_order(
	id integer,
	title varchar(100),
	content varchar(100),
	fileUrl varchar(100),
	dbId int,
	insertDate datetime,
	ghContent varchar(100),
	bmfzrContent varchar(100),
	status varchar(100)
);
--新提案字段加注释
comment on column t_order.id is '主键';
comment on column t_order.title is '标题';
comment on column t_order.content is '内容';
comment on column t_order.fileUrl is '附件';
comment on column t_order.dbId is '代表';
comment on column t_order.insertDate is '发起日期';
comment on column t_order.ghContent is '工会处理意见';
comment on column t_order.bmfzrContent is '部门负责人处理意见';
comment on column t_order.status is '状态';
--新提案表加注释
comment on table t_order 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_xld(
	id integer,
	username varchar(100),
	password varchar(100),
	xldName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100),
	idcard varchar(100),
	address varchar(100),
	pic varchar(100)
);
--校领导字段加注释
comment on column t_xld.id is '主键';
comment on column t_xld.username is '账号';
comment on column t_xld.password is '密码';
comment on column t_xld.xldName is '姓名';
comment on column t_xld.age is '年龄';
comment on column t_xld.sex is '性别';
comment on column t_xld.phone is '电话';
comment on column t_xld.idcard is '身份证';
comment on column t_xld.address is '住址';
comment on column t_xld.pic is '图片';
--校领导表加注释
comment on table t_xld is '校领导';

提案征求意见表创建语句如下:


create table t_zqyj(
	id integer,
	dbId int,
	xm varchar(100),
	phone varchar(100),
	content varchar(100)
);
--提案征求意见字段加注释
comment on column t_zqyj.id is '主键';
comment on column t_zqyj.dbId is '代表';
comment on column t_zqyj.xm is '姓名';
comment on column t_zqyj.phone is '联系方式';
comment on column t_zqyj.content is '内容';
--提案征求意见表加注释
comment on table t_zqyj is '提案征求意见';

oracle特有,对应序列如下:


create sequence s_t_bmfzr;
create sequence s_t_db;
create sequence s_t_gh;
create sequence s_t_order;
create sequence s_t_ptadmin;
create sequence s_t_xld;
create sequence s_t_zqyj;

基于SSM框架的教代会提案管理系统的设计和实现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_bmfzr(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	bmfzrName varchar(100),--姓名
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100),--电话
	idcard varchar(100),--身份证
	address varchar(100),--住址
	pic varchar(100)--图片
);

代表表创建语句如下:


--代表表注释
create table t_db(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	dbName varchar(100),--姓名
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100),--电话
	idcard varchar(100),--身份证
	address varchar(100),--住址
	pic varchar(100)--图片
);

工会表创建语句如下:


--工会表注释
create table t_gh(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	ghName varchar(100),--工会名称
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100),--电话
	idcard varchar(100),--身份证
	address varchar(100),--住址
	pic varchar(100)--图片
);

新提案表创建语句如下:


--新提案表注释
create table t_order(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--标题
	content varchar(100),--内容
	fileUrl varchar(100),--附件
	dbId int,--代表
	insertDate datetime,--发起日期
	ghContent varchar(100),--工会处理意见
	bmfzrContent varchar(100),--部门负责人处理意见
	status varchar(100)--状态
);

普通管理员表创建语句如下:


--普通管理员表注释
create table t_ptadmin(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	ptadminName varchar(100),--姓名
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100)--电话
);

校领导表创建语句如下:


--校领导表注释
create table t_xld(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	xldName varchar(100),--姓名
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100),--电话
	idcard varchar(100),--身份证
	address varchar(100),--住址
	pic varchar(100)--图片
);

提案征求意见表创建语句如下:


--提案征求意见表注释
create table t_zqyj(
	id int identity(1,1) primary key not null,--主键
	dbId int,--代表
	xm varchar(100),--姓名
	phone varchar(100),--联系方式
	content varchar(100)--内容
);

基于SSM框架的教代会提案管理系统的设计和实现登录后主页

基于SSM框架的教代会提案管理系统的设计和实现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_bmfzr")
public class Bmfzr {
//主键
@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 bmfzrName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//身份证
private String idcard;
//住址
private String address;
//图片
private String pic;
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 getBmfzrName() {return bmfzrName;}
public void setBmfzrName(String bmfzrName) {this.bmfzrName = bmfzrName;}
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 getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}

代表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_db")
public class Db {
//主键
@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 dbName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//身份证
private String idcard;
//住址
private String address;
//图片
private String pic;
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 getDbName() {return dbName;}
public void setDbName(String dbName) {this.dbName = dbName;}
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 getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}

工会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_gh")
public class Gh {
//主键
@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 ghName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//身份证
private String idcard;
//住址
private String address;
//图片
private String pic;
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 getGhName() {return ghName;}
public void setGhName(String ghName) {this.ghName = ghName;}
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 getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}

新提案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_order")
public class Order {
//主键
@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 content;
//附件
private String fileUrl;
//代表
private Integer dbId;
//发起日期
private Date insertDate;
//工会处理意见
private String ghContent;
//部门负责人处理意见
private String bmfzrContent;
//状态
private String status;
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 Integer getDbId() {return dbId;}
public void setDbId(Integer dbId) {this.dbId = dbId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getGhContent() {return ghContent;}
public void setGhContent(String ghContent) {this.ghContent = ghContent;}
public String getBmfzrContent() {return bmfzrContent;}
public void setBmfzrContent(String bmfzrContent) {this.bmfzrContent = bmfzrContent;}
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_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_xld")
public class Xld {
//主键
@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 xldName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//身份证
private String idcard;
//住址
private String address;
//图片
private String pic;
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 getXldName() {return xldName;}
public void setXldName(String xldName) {this.xldName = xldName;}
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 getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}

提案征求意见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_zqyj")
public class Zqyj {
//主键
@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 dbId;
//姓名
private String xm;
//联系方式
private String phone;
//内容
private String content;
public Integer getDbId() {return dbId;}
public void setDbId(Integer dbId) {this.dbId = dbId;}
public String getXm() {return xm;}
public void setXm(String xm) {this.xm = xm;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}

基于SSM框架的教代会提案管理系统的设计和实现spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

部门负责人javaBean创建语句如下:


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

//部门负责人
public class Bmfzr  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 bmfzrName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//身份证
private String idcard;
//住址
private String address;
//图片
private String pic;
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 getBmfzrName() {return bmfzrName;}
public void setBmfzrName(String bmfzrName) {this.bmfzrName = bmfzrName;}
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 getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}

代表javaBean创建语句如下:


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

//代表
public class Db  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 dbName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//身份证
private String idcard;
//住址
private String address;
//图片
private String pic;
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 getDbName() {return dbName;}
public void setDbName(String dbName) {this.dbName = dbName;}
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 getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}

工会javaBean创建语句如下:


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

//工会
public class Gh  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 ghName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//身份证
private String idcard;
//住址
private String address;
//图片
private String pic;
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 getGhName() {return ghName;}
public void setGhName(String ghName) {this.ghName = ghName;}
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 getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}

新提案javaBean创建语句如下:


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

//新提案
public class Order  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//内容
private String content;
//附件
private String fileUrl;
//代表
private Integer dbId;
//发起日期
private Date insertDate;
//工会处理意见
private String ghContent;
//部门负责人处理意见
private String bmfzrContent;
//状态
private String status;
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 Integer getDbId() {return dbId;}
public void setDbId(Integer dbId) {this.dbId = dbId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getGhContent() {return ghContent;}
public void setGhContent(String ghContent) {this.ghContent = ghContent;}
public String getBmfzrContent() {return bmfzrContent;}
public void setBmfzrContent(String bmfzrContent) {this.bmfzrContent = bmfzrContent;}
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 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 Xld  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 xldName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//身份证
private String idcard;
//住址
private String address;
//图片
private String pic;
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 getXldName() {return xldName;}
public void setXldName(String xldName) {this.xldName = xldName;}
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 getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}

提案征求意见javaBean创建语句如下:


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

//提案征求意见
public class Zqyj  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//代表
private Integer dbId;
//姓名
private String xm;
//联系方式
private String phone;
//内容
private String content;
public Integer getDbId() {return dbId;}
public void setDbId(Integer dbId) {this.dbId = dbId;}
public String getXm() {return xm;}
public void setXm(String xm) {this.xm = xm;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}

源代码下载点这里

评论