- 高校学生会APPmysql数据库创建语句
- 高校学生会APPoracle数据库创建语句
- 高校学生会APPsqlserver数据库创建语句
- 高校学生会APPspring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 高校学生会APPspring+springMVC+mybatis框架对象(javaBean,pojo)设计
高校学生会APP包含的内容:
1、学生会简介，规章制度简介，职能简介
2、学生会成员通讯录
3、部门列表，部门简介，部门职责介绍及部门成员列表
4、日历，日程事务编辑
5、个人资料编辑
6、会议活动等通知发布，任务发布
7、待办，已办任务列表
8、在线请假
9、会议，活动的在线考勤
10、活动在线报名，投票
11、奖惩通报
12、场地申请与批准
13、经费申请与批准
14、学校新闻动态
15、对学校的意见与建议
详见开题报告和文献综述
登录注册界面.jpg?x-oss-process=style/00001)
高校学生会APPmysql数据库版本源码：
超级管理员表创建语句如下：
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_bm(
id int primary key auto_increment comment '主键',
bm varchar(100) comment '部门',
jj varchar(100) comment '简介',
zzjs varchar(100) comment '职责介绍'
) comment '部门';
建议表创建语句如下：
create table t_contact(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
phone varchar(100) comment '联系方式',
content varchar(100) comment '内容',
insertDate datetime comment '日期'
) comment '建议';
用户表创建语句如下：
create table t_customer(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
name varchar(100) comment '姓名',
sex varchar(100) comment '性别',
address varchar(100) comment '地址',
mobile varchar(100) comment '手机',
bmId int comment '部门'
) comment '用户';
规章制度简介表创建语句如下：
create table t_gzzdjj(
id int primary key auto_increment comment '主键',
title varchar(100) comment '规章制度简介'
) comment '规章制度简介';
会议活动在线考勤表创建语句如下：
create table t_hyhdkq(
id int primary key auto_increment comment '主键',
title varchar(100) comment '会议名称',
pic varchar(100) comment '图片',
daDate varchar(100) comment '日期'
) comment '会议活动在线考勤';
会议活动在线考勤记录表创建语句如下：
create table t_hyhdkq_list(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
hyhdkqId int comment '会议',
insertDate datetime comment '日期'
) comment '会议活动在线考勤记录';
奖罚通报表创建语句如下：
create table t_jftb(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
types varchar(100) comment '类型',
title varchar(100) comment '标题',
pic varchar(100) comment '图片',
content varchar(100) comment '内容'
) comment '奖罚通报';
请假表创建语句如下：
create table t_qj(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
title varchar(100) comment '说明',
content varchar(100) comment '理由'
) comment '请假';
日程事务表创建语句如下：
create table t_rcsw(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
title varchar(100) comment '标题',
content varchar(100) comment '内容',
rcDate varchar(100) comment '日程日期'
) comment '日程事务';
申请表创建语句如下：
create table t_sq(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
types varchar(100) comment '类型',
title varchar(100) comment '说明',
pic varchar(100) comment '图片',
content varchar(100) comment '内容',
status varchar(100) comment '状态'
) comment '申请';
通知表创建语句如下：
create table t_tz(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
pic varchar(100) comment '图片',
content varchar(100) comment '内容'
) comment '通知';
我的处理任务表创建语句如下：
create table t_tz_list(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
tzId int comment '通知任务',
status varchar(100) comment '状态',
content varchar(100) comment '内容'
) comment '我的处理任务';
学生会简介表创建语句如下：
create table t_xshjj(
id int primary key auto_increment comment '主键',
title varchar(100) comment '学生会简介'
) comment '学生会简介';
新闻动态表创建语句如下：
create table t_xwdt(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
pic varchar(100) comment '图片',
content varchar(100) comment '内容'
) comment '新闻动态';
职能简介表创建语句如下：
create table t_znjj(
id int primary key auto_increment comment '主键',
title varchar(100) comment '职能简介'
) comment '职能简介';
高校学生会APPoracle数据库版本源码：
超级管理员表创建语句如下：
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_bm(
id integer,
bm varchar(100),
jj varchar(100),
zzjs varchar(100)
);
--部门字段加注释
comment on column t_bm.id is '主键';
comment on column t_bm.bm is '部门';
comment on column t_bm.jj is '简介';
comment on column t_bm.zzjs is '职责介绍';
--部门表加注释
comment on table t_bm is '部门';
建议表创建语句如下：
create table t_contact(
id integer,
customerId int,
phone varchar(100),
content varchar(100),
insertDate datetime
);
--建议字段加注释
comment on column t_contact.id is '主键';
comment on column t_contact.customerId is '用户';
comment on column t_contact.phone is '联系方式';
comment on column t_contact.content is '内容';
comment on column t_contact.insertDate is '日期';
--建议表加注释
comment on table t_contact is '建议';
用户表创建语句如下：
create table t_customer(
id integer,
username varchar(100),
password varchar(100),
name varchar(100),
sex varchar(100),
address varchar(100),
mobile varchar(100),
bmId int
);
--用户字段加注释
comment on column t_customer.id is '主键';
comment on column t_customer.username is '账号';
comment on column t_customer.password is '密码';
comment on column t_customer.name is '姓名';
comment on column t_customer.sex is '性别';
comment on column t_customer.address is '地址';
comment on column t_customer.mobile is '手机';
comment on column t_customer.bmId is '部门';
--用户表加注释
comment on table t_customer is '用户';
规章制度简介表创建语句如下：
create table t_gzzdjj(
id integer,
title varchar(100)
);
--规章制度简介字段加注释
comment on column t_gzzdjj.id is '主键';
comment on column t_gzzdjj.title is '规章制度简介';
--规章制度简介表加注释
comment on table t_gzzdjj is '规章制度简介';
会议活动在线考勤表创建语句如下：
create table t_hyhdkq(
id integer,
title varchar(100),
pic varchar(100),
daDate varchar(100)
);
--会议活动在线考勤字段加注释
comment on column t_hyhdkq.id is '主键';
comment on column t_hyhdkq.title is '会议名称';
comment on column t_hyhdkq.pic is '图片';
comment on column t_hyhdkq.daDate is '日期';
--会议活动在线考勤表加注释
comment on table t_hyhdkq is '会议活动在线考勤';
会议活动在线考勤记录表创建语句如下：
create table t_hyhdkq_list(
id integer,
customerId int,
hyhdkqId int,
insertDate datetime
);
--会议活动在线考勤记录字段加注释
comment on column t_hyhdkq_list.id is '主键';
comment on column t_hyhdkq_list.customerId is '用户';
comment on column t_hyhdkq_list.hyhdkqId is '会议';
comment on column t_hyhdkq_list.insertDate is '日期';
--会议活动在线考勤记录表加注释
comment on table t_hyhdkq_list is '会议活动在线考勤记录';
奖罚通报表创建语句如下：
create table t_jftb(
id integer,
customerId int,
types varchar(100),
title varchar(100),
pic varchar(100),
content varchar(100)
);
--奖罚通报字段加注释
comment on column t_jftb.id is '主键';
comment on column t_jftb.customerId is '用户';
comment on column t_jftb.types is '类型';
comment on column t_jftb.title is '标题';
comment on column t_jftb.pic is '图片';
comment on column t_jftb.content is '内容';
--奖罚通报表加注释
comment on table t_jftb is '奖罚通报';
请假表创建语句如下：
create table t_qj(
id integer,
customerId int,
title varchar(100),
content varchar(100)
);
--请假字段加注释
comment on column t_qj.id is '主键';
comment on column t_qj.customerId is '用户';
comment on column t_qj.title is '说明';
comment on column t_qj.content is '理由';
--请假表加注释
comment on table t_qj is '请假';
日程事务表创建语句如下：
create table t_rcsw(
id integer,
customerId int,
title varchar(100),
content varchar(100),
rcDate varchar(100)
);
--日程事务字段加注释
comment on column t_rcsw.id is '主键';
comment on column t_rcsw.customerId is '用户';
comment on column t_rcsw.title is '标题';
comment on column t_rcsw.content is '内容';
comment on column t_rcsw.rcDate is '日程日期';
--日程事务表加注释
comment on table t_rcsw is '日程事务';
申请表创建语句如下：
create table t_sq(
id integer,
customerId int,
types varchar(100),
title varchar(100),
pic varchar(100),
content varchar(100),
status varchar(100)
);
--申请字段加注释
comment on column t_sq.id is '主键';
comment on column t_sq.customerId is '用户';
comment on column t_sq.types is '类型';
comment on column t_sq.title is '说明';
comment on column t_sq.pic is '图片';
comment on column t_sq.content is '内容';
comment on column t_sq.status is '状态';
--申请表加注释
comment on table t_sq is '申请';
通知表创建语句如下：
create table t_tz(
id integer,
title varchar(100),
pic varchar(100),
content varchar(100)
);
--通知字段加注释
comment on column t_tz.id is '主键';
comment on column t_tz.title is '标题';
comment on column t_tz.pic is '图片';
comment on column t_tz.content is '内容';
--通知表加注释
comment on table t_tz is '通知';
我的处理任务表创建语句如下：
create table t_tz_list(
id integer,
customerId int,
tzId int,
status varchar(100),
content varchar(100)
);
--我的处理任务字段加注释
comment on column t_tz_list.id is '主键';
comment on column t_tz_list.customerId is '用户';
comment on column t_tz_list.tzId is '通知任务';
comment on column t_tz_list.status is '状态';
comment on column t_tz_list.content is '内容';
--我的处理任务表加注释
comment on table t_tz_list is '我的处理任务';
学生会简介表创建语句如下：
create table t_xshjj(
id integer,
title varchar(100)
);
--学生会简介字段加注释
comment on column t_xshjj.id is '主键';
comment on column t_xshjj.title is '学生会简介';
--学生会简介表加注释
comment on table t_xshjj is '学生会简介';
新闻动态表创建语句如下：
create table t_xwdt(
id integer,
title varchar(100),
pic varchar(100),
content varchar(100)
);
--新闻动态字段加注释
comment on column t_xwdt.id is '主键';
comment on column t_xwdt.title is '标题';
comment on column t_xwdt.pic is '图片';
comment on column t_xwdt.content is '内容';
--新闻动态表加注释
comment on table t_xwdt is '新闻动态';
职能简介表创建语句如下：
create table t_znjj(
id integer,
title varchar(100)
);
--职能简介字段加注释
comment on column t_znjj.id is '主键';
comment on column t_znjj.title is '职能简介';
--职能简介表加注释
comment on table t_znjj is '职能简介';
oracle特有，对应序列如下：
create sequence s_t_bm;
create sequence s_t_contact;
create sequence s_t_customer;
create sequence s_t_gzzdjj;
create sequence s_t_hyhdkq;
create sequence s_t_hyhdkq_list;
create sequence s_t_jftb;
create sequence s_t_qj;
create sequence s_t_rcsw;
create sequence s_t_sq;
create sequence s_t_tz;
create sequence s_t_tz_list;
create sequence s_t_xshjj;
create sequence s_t_xwdt;
create sequence s_t_znjj;
高校学生会APPsqlserver数据库版本源码：
超级管理员表创建语句如下：
--超级管理员
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_bm(
id int identity(1,1) primary key not null,--主键
bm varchar(100),--部门
jj varchar(100),--简介
zzjs varchar(100)--职责介绍
);
建议表创建语句如下：
--建议表注释
create table t_contact(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
phone varchar(100),--联系方式
content varchar(100),--内容
insertDate datetime--日期
);
用户表创建语句如下：
--用户表注释
create table t_customer(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
name varchar(100),--姓名
sex varchar(100),--性别
address varchar(100),--地址
mobile varchar(100),--手机
bmId int--部门
);
规章制度简介表创建语句如下：
--规章制度简介表注释
create table t_gzzdjj(
id int identity(1,1) primary key not null,--主键
title varchar(100)--规章制度简介
);
会议活动在线考勤表创建语句如下：
--会议活动在线考勤表注释
create table t_hyhdkq(
id int identity(1,1) primary key not null,--主键
title varchar(100),--会议名称
pic varchar(100),--图片
daDate varchar(100)--日期
);
会议活动在线考勤记录表创建语句如下：
--会议活动在线考勤记录表注释
create table t_hyhdkq_list(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
hyhdkqId int,--会议
insertDate datetime--日期
);
奖罚通报表创建语句如下：
--奖罚通报表注释
create table t_jftb(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
types varchar(100),--类型
title varchar(100),--标题
pic varchar(100),--图片
content varchar(100)--内容
);
请假表创建语句如下：
--请假表注释
create table t_qj(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
title varchar(100),--说明
content varchar(100)--理由
);
日程事务表创建语句如下：
--日程事务表注释
create table t_rcsw(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
title varchar(100),--标题
content varchar(100),--内容
rcDate varchar(100)--日程日期
);
申请表创建语句如下：
--申请表注释
create table t_sq(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
types varchar(100),--类型
title varchar(100),--说明
pic varchar(100),--图片
content varchar(100),--内容
status varchar(100)--状态
);
通知表创建语句如下：
--通知表注释
create table t_tz(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
pic varchar(100),--图片
content varchar(100)--内容
);
我的处理任务表创建语句如下：
--我的处理任务表注释
create table t_tz_list(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
tzId int,--通知任务
status varchar(100),--状态
content varchar(100)--内容
);
学生会简介表创建语句如下：
--学生会简介表注释
create table t_xshjj(
id int identity(1,1) primary key not null,--主键
title varchar(100)--学生会简介
);
新闻动态表创建语句如下：
--新闻动态表注释
create table t_xwdt(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
pic varchar(100),--图片
content varchar(100)--内容
);
职能简介表创建语句如下：
--职能简介表注释
create table t_znjj(
id int identity(1,1) primary key not null,--主键
title varchar(100)--职能简介
);
登录后主页.jpg?x-oss-process=style/00001)
高校学生会APPspring+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_bm")
public class Bm {
//主键
@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 bm;
//简介
private String jj;
//职责介绍
private String zzjs;
public String getBm() {return bm;}
public void setBm(String bm) {this.bm = bm;}
public String getJj() {return jj;}
public void setJj(String jj) {this.jj = jj;}
public String getZzjs() {return zzjs;}
public void setZzjs(String zzjs) {this.zzjs = zzjs;}
}建议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_contact")
public class Contact {
//主键
@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 phone;
//内容
private String content;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
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;}
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_customer")
public class Customer {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码
private String password;
//姓名
private String name;
//性别
private String sex;
//地址
private String address;
//手机
private String mobile;
//部门
private Integer bmId;
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 getName() {return name;}
public void setName(String name) {this.name = name;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getMobile() {return mobile;}
public void setMobile(String mobile) {this.mobile = mobile;}
public Integer getBmId() {return bmId;}
public void setBmId(Integer bmId) {this.bmId = bmId;}
}规章制度简介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_gzzdjj")
public class Gzzdjj {
//主键
@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;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
}会议活动在线考勤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_hyhdkq")
public class Hyhdkq {
//主键
@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 pic;
//日期
private String daDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getDaDate() {return daDate;}
public void setDaDate(String daDate) {this.daDate = daDate;}
}会议活动在线考勤记录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_hyhdkq_list")
public class Hyhdkq_list {
//主键
@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 hyhdkqId;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getHyhdkqId() {return hyhdkqId;}
public void setHyhdkqId(Integer hyhdkqId) {this.hyhdkqId = hyhdkqId;}
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_jftb")
public class Jftb {
//主键
@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 types;
//标题
private String title;
//图片
private String pic;
//内容
private String content;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}请假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_qj")
public class Qj {
//主键
@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;
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;}
}日程事务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_rcsw")
public class Rcsw {
//主键
@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 rcDate;
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 getRcDate() {return rcDate;}
public void setRcDate(String rcDate) {this.rcDate = rcDate;}
}申请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_sq")
public class Sq {
//主键
@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 types;
//说明
private String title;
//图片
private String pic;
//内容
private String content;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public 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_tz")
public class Tz {
//主键
@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 pic;
//内容
private String content;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}我的处理任务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_tz_list")
public class Tz_list {
//主键
@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 tzId;
//状态
private String status;
//内容
private String content;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getTzId() {return tzId;}
public void setTzId(Integer tzId) {this.tzId = tzId;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
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_xshjj")
public class Xshjj {
//主键
@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;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
}新闻动态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_xwdt")
public class Xwdt {
//主键
@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 pic;
//内容
private String content;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}职能简介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_znjj")
public class Znjj {
//主键
@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;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
}高校学生会APPspring+springMVC+mybatis框架对象(javaBean,pojo)设计：
部门javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//部门
public class Bm extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//部门
private String bm;
//简介
private String jj;
//职责介绍
private String zzjs;
public String getBm() {return bm;}
public void setBm(String bm) {this.bm = bm;}
public String getJj() {return jj;}
public void setJj(String jj) {this.jj = jj;}
public String getZzjs() {return zzjs;}
public void setZzjs(String zzjs) {this.zzjs = zzjs;}
}建议javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//建议
public class Contact extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//联系方式
private String phone;
//内容
private String content;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
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;}
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 Customer extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码
private String password;
//姓名
private String name;
//性别
private String sex;
//地址
private String address;
//手机
private String mobile;
//部门
private Integer bmId;
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 getName() {return name;}
public void setName(String name) {this.name = name;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getMobile() {return mobile;}
public void setMobile(String mobile) {this.mobile = mobile;}
public Integer getBmId() {return bmId;}
public void setBmId(Integer bmId) {this.bmId = bmId;}
}规章制度简介javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//规章制度简介
public class Gzzdjj extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//规章制度简介
private String title;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
}会议活动在线考勤javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//会议活动在线考勤
public class Hyhdkq extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//会议名称
private String title;
//图片
private String pic;
//日期
private String daDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getDaDate() {return daDate;}
public void setDaDate(String daDate) {this.daDate = daDate;}
}会议活动在线考勤记录javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//会议活动在线考勤记录
public class Hyhdkq_list extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//会议
private Integer hyhdkqId;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getHyhdkqId() {return hyhdkqId;}
public void setHyhdkqId(Integer hyhdkqId) {this.hyhdkqId = hyhdkqId;}
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 Jftb extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//类型
private String types;
//标题
private String title;
//图片
private String pic;
//内容
private String content;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}请假javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//请假
public class Qj 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;
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;}
}日程事务javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//日程事务
public class Rcsw 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 rcDate;
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 getRcDate() {return rcDate;}
public void setRcDate(String rcDate) {this.rcDate = rcDate;}
}申请javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//申请
public class Sq extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//类型
private String types;
//说明
private String title;
//图片
private String pic;
//内容
private String content;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public 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 Tz extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//图片
private String pic;
//内容
private String content;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}我的处理任务javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//我的处理任务
public class Tz_list extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//通知任务
private Integer tzId;
//状态
private String status;
//内容
private String content;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getTzId() {return tzId;}
public void setTzId(Integer tzId) {this.tzId = tzId;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
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 Xshjj extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生会简介
private String title;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
}新闻动态javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//新闻动态
public class Xwdt extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//图片
private String pic;
//内容
private String content;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}职能简介javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//职能简介
public class Znjj extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//职能简介
private String title;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
}