- 学生会管理系统mysql数据库创建语句
- 学生会管理系统oracle数据库创建语句
- 学生会管理系统sqlserver数据库创建语句
- 学生会管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 学生会管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
学生会管理系统mysql数据库版本源码：
超级管理员表创建语句如下：
create table t_admin(
id int primary key auto_increment comment '主键',
username varchar(100) comment '超级管理员账号',
password varchar(100) comment '超级管理员密码'
) comment '超级管理员';
insert into t_admin(username,password) values('admin','123456');
部门表创建语句如下：
create table t_bm(
id int primary key auto_increment comment '主键',
bmName varchar(100) comment '部门名称',
pic varchar(100) comment '部门图片',
ptadminId int comment '普通管理员',
content text comment '相关工作',
cy text comment '部门成员'
) comment '部门';
系统公告表创建语句如下：
create table t_gonggao(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
content text comment '内容',
insertDate datetime comment '发起日期'
) comment '系统公告';
活动表创建语句如下：
create table t_hd(
id int primary key auto_increment comment '主键',
hdName varchar(100) comment '活动名称',
bmId int comment '所属部门',
content text comment '活动内容',
showDate datetime comment '活动日期',
dd varchar(100) comment '活动地点'
) comment '活动';
会议表创建语句如下：
create table t_hy(
id int primary key auto_increment comment '主键',
hyName varchar(100) comment '会议名称',
bmId int comment '所属部门',
content text comment '会议内容',
showDate datetime comment '会议日期',
dd varchar(100) comment '会议地点'
) comment '会议';
普通管理员表创建语句如下：
create table t_ptadmin(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '',
gh varchar(100) comment '工号'
) comment '普通管理员';
用户表创建语句如下：
create table t_student(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
studentName varchar(100) comment '姓名',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '',
xh varchar(100) comment '学号',
xb varchar(100) comment '系部'
) comment '用户';
部门通知表创建语句如下：
create table t_tongzhi(
id int primary key auto_increment comment '主键',
bmId int comment '部门',
title text comment '内容',
insertDate datetime comment '发起日期'
) comment '部门通知';
意见留言表创建语句如下：
create table t_yj(
id int primary key auto_increment comment '主键',
studentId int comment '学生',
content text comment '意见',
insertDate datetime comment '发起日期',
bmId int comment '部门',
back text comment '回复',
status varchar(100) comment '状态'
) comment '意见留言';
资金去向表创建语句如下：
create table t_zjqx(
id int primary key auto_increment comment '主键',
hyName varchar(100) comment '去向名称',
bmId int comment '所属部门',
content text comment '详细说明',
showDate datetime comment '发生日期',
lx varchar(100) comment '',
fee int comment '金额',
fzr varchar(100) comment '负责人',
lxdh varchar(100) comment '联系电话'
) comment '资金去向';
学生会管理系统oracle数据库版本源码：
超级管理员表创建语句如下：
create table t_admin(
id integer,
username varchar(100),
password varchar(100)
);
insert into t_admin(id,username,password) values(1,'admin','123456');
--超级管理员字段加注释
comment on column t_admin.id is '主键';
comment on column t_admin.username is '超级管理员账号';
comment on column t_admin.password is '超级管理员密码';
--超级管理员表加注释
comment on table t_admin is '超级管理员';
部门表创建语句如下：
create table t_bm(
id integer,
bmName varchar(100),
pic varchar(100),
ptadminId int,
content text,
cy text
);
--部门字段加注释
comment on column t_bm.id is '主键';
comment on column t_bm.bmName is '部门名称';
comment on column t_bm.pic is '部门图片';
comment on column t_bm.ptadminId is '普通管理员';
comment on column t_bm.content is '相关工作';
comment on column t_bm.cy is '部门成员';
--部门表加注释
comment on table t_bm is '部门';
系统公告表创建语句如下：
create table t_gonggao(
id integer,
title varchar(100),
content text,
insertDate datetime
);
--系统公告字段加注释
comment on column t_gonggao.id is '主键';
comment on column t_gonggao.title is '标题';
comment on column t_gonggao.content is '内容';
comment on column t_gonggao.insertDate is '发起日期';
--系统公告表加注释
comment on table t_gonggao is '系统公告';
活动表创建语句如下：
create table t_hd(
id integer,
hdName varchar(100),
bmId int,
content text,
showDate datetime,
dd varchar(100)
);
--活动字段加注释
comment on column t_hd.id is '主键';
comment on column t_hd.hdName is '活动名称';
comment on column t_hd.bmId is '所属部门';
comment on column t_hd.content is '活动内容';
comment on column t_hd.showDate is '活动日期';
comment on column t_hd.dd is '活动地点';
--活动表加注释
comment on table t_hd is '活动';
会议表创建语句如下：
create table t_hy(
id integer,
hyName varchar(100),
bmId int,
content text,
showDate datetime,
dd varchar(100)
);
--会议字段加注释
comment on column t_hy.id is '主键';
comment on column t_hy.hyName is '会议名称';
comment on column t_hy.bmId is '所属部门';
comment on column t_hy.content is '会议内容';
comment on column t_hy.showDate is '会议日期';
comment on column t_hy.dd is '会议地点';
--会议表加注释
comment on table t_hy is '会议';
普通管理员表创建语句如下：
create table t_ptadmin(
id integer,
username varchar(100),
password varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100),
gh 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.phone is '电话';
comment on column t_ptadmin.age is '年龄';
comment on column t_ptadmin.sex is '';
comment on column t_ptadmin.gh is '工号';
--普通管理员表加注释
comment on table t_ptadmin is '普通管理员';
用户表创建语句如下：
create table t_student(
id integer,
username varchar(100),
password varchar(100),
studentName varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100),
xh varchar(100),
xb varchar(100)
);
--用户字段加注释
comment on column t_student.id is '主键';
comment on column t_student.username is '账号';
comment on column t_student.password is '密码';
comment on column t_student.studentName is '姓名';
comment on column t_student.phone is '电话';
comment on column t_student.age is '年龄';
comment on column t_student.sex is '';
comment on column t_student.xh is '学号';
comment on column t_student.xb is '系部';
--用户表加注释
comment on table t_student is '用户';
部门通知表创建语句如下：
create table t_tongzhi(
id integer,
bmId int,
title text,
insertDate datetime
);
--部门通知字段加注释
comment on column t_tongzhi.id is '主键';
comment on column t_tongzhi.bmId is '部门';
comment on column t_tongzhi.title is '内容';
comment on column t_tongzhi.insertDate is '发起日期';
--部门通知表加注释
comment on table t_tongzhi is '部门通知';
意见留言表创建语句如下：
create table t_yj(
id integer,
studentId int,
content text,
insertDate datetime,
bmId int,
back text,
status varchar(100)
);
--意见留言字段加注释
comment on column t_yj.id is '主键';
comment on column t_yj.studentId is '学生';
comment on column t_yj.content is '意见';
comment on column t_yj.insertDate is '发起日期';
comment on column t_yj.bmId is '部门';
comment on column t_yj.back is '回复';
comment on column t_yj.status is '状态';
--意见留言表加注释
comment on table t_yj is '意见留言';
资金去向表创建语句如下：
create table t_zjqx(
id integer,
hyName varchar(100),
bmId int,
content text,
showDate datetime,
lx varchar(100),
fee int,
fzr varchar(100),
lxdh varchar(100)
);
--资金去向字段加注释
comment on column t_zjqx.id is '主键';
comment on column t_zjqx.hyName is '去向名称';
comment on column t_zjqx.bmId is '所属部门';
comment on column t_zjqx.content is '详细说明';
comment on column t_zjqx.showDate is '发生日期';
comment on column t_zjqx.lx is '';
comment on column t_zjqx.fee is '金额';
comment on column t_zjqx.fzr is '负责人';
comment on column t_zjqx.lxdh is '联系电话';
--资金去向表加注释
comment on table t_zjqx is '资金去向';
oracle特有，对应序列如下：
create sequence s_t_bm;
create sequence s_t_gonggao;
create sequence s_t_hd;
create sequence s_t_hy;
create sequence s_t_ptadmin;
create sequence s_t_student;
create sequence s_t_tongzhi;
create sequence s_t_yj;
create sequence s_t_zjqx;
学生会管理系统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_bm(
id int identity(1,1) primary key not null,--主键
bmName varchar(100),--部门名称
pic varchar(100),--部门图片
ptadminId int,--普通管理员
content text,--相关工作
cy text--部门成员
);
系统公告表创建语句如下：
--系统公告表注释
create table t_gonggao(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
content text,--内容
insertDate datetime--发起日期
);
活动表创建语句如下：
--活动表注释
create table t_hd(
id int identity(1,1) primary key not null,--主键
hdName varchar(100),--活动名称
bmId int,--所属部门
content text,--活动内容
showDate datetime,--活动日期
dd varchar(100)--活动地点
);
会议表创建语句如下：
--会议表注释
create table t_hy(
id int identity(1,1) primary key not null,--主键
hyName varchar(100),--会议名称
bmId int,--所属部门
content text,--会议内容
showDate datetime,--会议日期
dd varchar(100)--会议地点
);
普通管理员表创建语句如下：
--普通管理员表注释
create table t_ptadmin(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100),--
gh varchar(100)--工号
);
用户表创建语句如下：
--用户表注释
create table t_student(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
studentName varchar(100),--姓名
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100),--
xh varchar(100),--学号
xb varchar(100)--系部
);
部门通知表创建语句如下：
--部门通知表注释
create table t_tongzhi(
id int identity(1,1) primary key not null,--主键
bmId int,--部门
title text,--内容
insertDate datetime--发起日期
);
意见留言表创建语句如下：
--意见留言表注释
create table t_yj(
id int identity(1,1) primary key not null,--主键
studentId int,--学生
content text,--意见
insertDate datetime,--发起日期
bmId int,--部门
back text,--回复
status varchar(100)--状态
);
资金去向表创建语句如下：
--资金去向表注释
create table t_zjqx(
id int identity(1,1) primary key not null,--主键
hyName varchar(100),--去向名称
bmId int,--所属部门
content text,--详细说明
showDate datetime,--发生日期
lx varchar(100),--
fee int,--金额
fzr varchar(100),--负责人
lxdh varchar(100)--联系电话
);
登录后主页.jpg?x-oss-process=style/00001)
学生会管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计：
部门javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//部门
@Table(name = "t_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 bmName;
//部门图片
private String pic;
//普通管理员
private Long ptadminId;
//相关工作
private String content;
//部门成员
private String cy;
public String getBmName() {return bmName;}
public void setBmName(String bmName) {this.bmName = bmName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Long getPtadminId() {return ptadminId;}
public void setPtadminId(Long ptadminId) {this.ptadminId = ptadminId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getCy() {return cy;}
public void setCy(String cy) {this.cy = cy;}
}系统公告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_gonggao")
public class Gonggao {
//主键
@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 Date insertDate;
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 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_hd")
public class Hd {
//主键
@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 hdName;
//所属部门
private Long bmId;
//活动内容
private String content;
//活动日期
private Date showDate;
//活动地点
private String dd;
public String getHdName() {return hdName;}
public void setHdName(String hdName) {this.hdName = hdName;}
public Long getBmId() {return bmId;}
public void setBmId(Long bmId) {this.bmId = bmId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getDd() {return dd;}
public void setDd(String dd) {this.dd = dd;}
}会议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_hy")
public class Hy {
//主键
@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 hyName;
//所属部门
private Long bmId;
//会议内容
private String content;
//会议日期
private Date showDate;
//会议地点
private String dd;
public String getHyName() {return hyName;}
public void setHyName(String hyName) {this.hyName = hyName;}
public Long getBmId() {return bmId;}
public void setBmId(Long bmId) {this.bmId = bmId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getDd() {return dd;}
public void setDd(String dd) {this.dd = dd;}
}普通管理员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 phone;
//年龄
private String age;
//
private String sex;
//工号
private String gh;
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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
}用户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_student")
public class Student {
//主键
@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 studentName;
//电话
private String phone;
//年龄
private String age;
//
private String sex;
//学号
private String xh;
//系部
private String xb;
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 getStudentName() {return studentName;}
public void setStudentName(String studentName) {this.studentName = studentName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
public String getXb() {return xb;}
public void setXb(String xb) {this.xb = xb;}
}部门通知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_tongzhi")
public class Tongzhi {
//主键
@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 Long bmId;
//内容
private String title;
//发起日期
private Date insertDate;
public Long getBmId() {return bmId;}
public void setBmId(Long bmId) {this.bmId = bmId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
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_yj")
public class Yj {
//主键
@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 Long studentId;
//意见
private String content;
//发起日期
private Date insertDate;
//部门
private Long bmId;
//回复
private String back;
//状态
private String status;
public Long getStudentId() {return studentId;}
public void setStudentId(Long studentId) {this.studentId = studentId;}
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;}
public Long getBmId() {return bmId;}
public void setBmId(Long bmId) {this.bmId = bmId;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
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_zjqx")
public class Zjqx {
//主键
@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 hyName;
//所属部门
private Long bmId;
//详细说明
private String content;
//发生日期
private Date showDate;
//
private String lx;
//金额
private Integer fee;
//负责人
private String fzr;
//联系电话
private String lxdh;
public String getHyName() {return hyName;}
public void setHyName(String hyName) {this.hyName = hyName;}
public Long getBmId() {return bmId;}
public void setBmId(Long bmId) {this.bmId = bmId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getLx() {return lx;}
public void setLx(String lx) {this.lx = lx;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
public String getLxdh() {return lxdh;}
public void setLxdh(String lxdh) {this.lxdh = lxdh;}
}学生会管理系统spring+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 bmName;
//部门图片
private String pic;
//普通管理员
private Long ptadminId;
//相关工作
private String content;
//部门成员
private String cy;
public String getBmName() {return bmName;}
public void setBmName(String bmName) {this.bmName = bmName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Long getPtadminId() {return ptadminId;}
public void setPtadminId(Long ptadminId) {this.ptadminId = ptadminId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getCy() {return cy;}
public void setCy(String cy) {this.cy = cy;}
}系统公告javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//系统公告
public class Gonggao 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 Date insertDate;
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 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 Hd extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//活动名称
private String hdName;
//所属部门
private Long bmId;
//活动内容
private String content;
//活动日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
//活动地点
private String dd;
public String getHdName() {return hdName;}
public void setHdName(String hdName) {this.hdName = hdName;}
public Long getBmId() {return bmId;}
public void setBmId(Long bmId) {this.bmId = bmId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getDd() {return dd;}
public void setDd(String dd) {this.dd = dd;}
}会议javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//会议
public class Hy extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//会议名称
private String hyName;
//所属部门
private Long bmId;
//会议内容
private String content;
//会议日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
//会议地点
private String dd;
public String getHyName() {return hyName;}
public void setHyName(String hyName) {this.hyName = hyName;}
public Long getBmId() {return bmId;}
public void setBmId(Long bmId) {this.bmId = bmId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getDd() {return dd;}
public void setDd(String dd) {this.dd = dd;}
}普通管理员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 phone;
//年龄
private String age;
//
private String sex;
//工号
private String gh;
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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
}用户javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//用户
public class Student 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 studentName;
//电话
private String phone;
//年龄
private String age;
//
private String sex;
//学号
private String xh;
//系部
private String xb;
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 getStudentName() {return studentName;}
public void setStudentName(String studentName) {this.studentName = studentName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
public String getXb() {return xb;}
public void setXb(String xb) {this.xb = xb;}
}部门通知javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//部门通知
public class Tongzhi extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//部门
private Long bmId;
//内容
private String title;
//发起日期
private Date insertDate;
public Long getBmId() {return bmId;}
public void setBmId(Long bmId) {this.bmId = bmId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
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 Yj extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Long studentId;
//意见
private String content;
//发起日期
private Date insertDate;
//部门
private Long bmId;
//回复
private String back;
//状态
private String status;
public Long getStudentId() {return studentId;}
public void setStudentId(Long studentId) {this.studentId = studentId;}
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;}
public Long getBmId() {return bmId;}
public void setBmId(Long bmId) {this.bmId = bmId;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
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 Zjqx extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//去向名称
private String hyName;
//所属部门
private Long bmId;
//详细说明
private String content;
//发生日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
//
private String lx;
//金额
private Integer fee;
//负责人
private String fzr;
//联系电话
private String lxdh;
public String getHyName() {return hyName;}
public void setHyName(String hyName) {this.hyName = hyName;}
public Long getBmId() {return bmId;}
public void setBmId(Long bmId) {this.bmId = bmId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getLx() {return lx;}
public void setLx(String lx) {this.lx = lx;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
public String getLxdh() {return lxdh;}
public void setLxdh(String lxdh) {this.lxdh = lxdh;}
}