高校学生考勤管理系统设计和实现

高校学生考勤管理系统设计和实现登录注册界面

高校学生考勤管理系统设计和实现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_bj(
	id int primary key auto_increment comment '主键',
	bjName varchar(100) comment '班级'
) comment '班级';

考勤通报表创建语句如下:


create table t_gg(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '标题',
	content varchar(100) comment '说明',
	xm varchar(100) comment '姓名',
	showDate datetime comment '日期'
) comment '考勤通报';

学生考勤表创建语句如下:


create table t_kq(
	id int primary key auto_increment comment '主键',
	studentId int comment '学生',
	types varchar(100) comment '类型',
	showDate datetime comment '日期'
) comment '学生考勤';

老师考勤表创建语句如下:


create table t_lskq(
	id int primary key auto_increment comment '主键',
	teacherId int comment '老师',
	types varchar(100) comment '类型',
	showDate datetime comment '日期'
) comment '老师考勤';

请假表创建语句如下:


create table t_qj(
	id int primary key auto_increment comment '主键',
	studentId int comment '用户',
	title varchar(100) comment '说明',
	qjDate datetime comment '开始日期',
	days int comment '天数',
	status 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 '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话',
	pic varchar(100) comment '头像',
	bjId int comment '班级',
	yxId int comment '院系'
) comment '学生';

老师表创建语句如下:


create table t_teacher(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	teacherName varchar(100) comment '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话',
	pic varchar(100) comment '头像',
	bjId int comment '班级',
	yxId int comment '院系'
) comment '老师';

校领导表创建语句如下:


create table t_xld(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	yldName varchar(100) comment '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话',
	pic varchar(100) comment '头像'
) comment '校领导';

院领导表创建语句如下:


create table t_yld(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	yldName varchar(100) comment '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话',
	pic varchar(100) comment '头像',
	yxId int comment '院系'
) comment '院领导';

院系表创建语句如下:


create table t_yx(
	id int primary key auto_increment comment '主键',
	yxName 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_bj(
	id integer,
	bjName varchar(100)
);
--班级字段加注释
comment on column t_bj.id is '主键';
comment on column t_bj.bjName is '班级';
--班级表加注释
comment on table t_bj is '班级';

考勤通报表创建语句如下:


create table t_gg(
	id integer,
	title varchar(100),
	content varchar(100),
	xm varchar(100),
	showDate datetime
);
--考勤通报字段加注释
comment on column t_gg.id is '主键';
comment on column t_gg.title is '标题';
comment on column t_gg.content is '说明';
comment on column t_gg.xm is '姓名';
comment on column t_gg.showDate is '日期';
--考勤通报表加注释
comment on table t_gg is '考勤通报';

学生考勤表创建语句如下:


create table t_kq(
	id integer,
	studentId int,
	types varchar(100),
	showDate datetime
);
--学生考勤字段加注释
comment on column t_kq.id is '主键';
comment on column t_kq.studentId is '学生';
comment on column t_kq.types is '类型';
comment on column t_kq.showDate is '日期';
--学生考勤表加注释
comment on table t_kq is '学生考勤';

老师考勤表创建语句如下:


create table t_lskq(
	id integer,
	teacherId int,
	types varchar(100),
	showDate datetime
);
--老师考勤字段加注释
comment on column t_lskq.id is '主键';
comment on column t_lskq.teacherId is '老师';
comment on column t_lskq.types is '类型';
comment on column t_lskq.showDate is '日期';
--老师考勤表加注释
comment on table t_lskq is '老师考勤';

请假表创建语句如下:


create table t_qj(
	id integer,
	studentId int,
	title varchar(100),
	qjDate datetime,
	days int,
	status varchar(100)
);
--请假字段加注释
comment on column t_qj.id is '主键';
comment on column t_qj.studentId is '用户';
comment on column t_qj.title is '说明';
comment on column t_qj.qjDate is '开始日期';
comment on column t_qj.days is '天数';
comment on column t_qj.status is '状态';
--请假表加注释
comment on table t_qj is '请假';

学生表创建语句如下:


create table t_student(
	id integer,
	username varchar(100),
	password varchar(100),
	studentName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100),
	pic varchar(100),
	bjId int,
	yxId int
);
--学生字段加注释
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.age is '年龄';
comment on column t_student.sex is '性别';
comment on column t_student.phone is '电话';
comment on column t_student.pic is '头像';
comment on column t_student.bjId is '班级';
comment on column t_student.yxId is '院系';
--学生表加注释
comment on table t_student is '学生';

老师表创建语句如下:


create table t_teacher(
	id integer,
	username varchar(100),
	password varchar(100),
	teacherName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100),
	pic varchar(100),
	bjId int,
	yxId int
);
--老师字段加注释
comment on column t_teacher.id is '主键';
comment on column t_teacher.username is '账号';
comment on column t_teacher.password is '密码';
comment on column t_teacher.teacherName is '姓名';
comment on column t_teacher.age is '年龄';
comment on column t_teacher.sex is '性别';
comment on column t_teacher.phone is '电话';
comment on column t_teacher.pic is '头像';
comment on column t_teacher.bjId is '班级';
comment on column t_teacher.yxId is '院系';
--老师表加注释
comment on table t_teacher is '老师';

校领导表创建语句如下:


create table t_xld(
	id integer,
	username varchar(100),
	password varchar(100),
	yldName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone 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.yldName 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.pic is '头像';
--校领导表加注释
comment on table t_xld is '校领导';

院领导表创建语句如下:


create table t_yld(
	id integer,
	username varchar(100),
	password varchar(100),
	yldName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100),
	pic varchar(100),
	yxId int
);
--院领导字段加注释
comment on column t_yld.id is '主键';
comment on column t_yld.username is '账号';
comment on column t_yld.password is '密码';
comment on column t_yld.yldName is '姓名';
comment on column t_yld.age is '年龄';
comment on column t_yld.sex is '性别';
comment on column t_yld.phone is '电话';
comment on column t_yld.pic is '头像';
comment on column t_yld.yxId is '院系';
--院领导表加注释
comment on table t_yld is '院领导';

院系表创建语句如下:


create table t_yx(
	id integer,
	yxName varchar(100)
);
--院系字段加注释
comment on column t_yx.id is '主键';
comment on column t_yx.yxName is '院系';
--院系表加注释
comment on table t_yx is '院系';

oracle特有,对应序列如下:


create sequence s_t_bj;
create sequence s_t_gg;
create sequence s_t_kq;
create sequence s_t_lskq;
create sequence s_t_qj;
create sequence s_t_student;
create sequence s_t_teacher;
create sequence s_t_xld;
create sequence s_t_yld;
create sequence s_t_yx;

高校学生考勤管理系统设计和实现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_bj(
	id int identity(1,1) primary key not null,--主键
	bjName varchar(100)--班级
);

考勤通报表创建语句如下:


--考勤通报表注释
create table t_gg(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--标题
	content varchar(100),--说明
	xm varchar(100),--姓名
	showDate datetime--日期
);

学生考勤表创建语句如下:


--学生考勤表注释
create table t_kq(
	id int identity(1,1) primary key not null,--主键
	studentId int,--学生
	types varchar(100),--类型
	showDate datetime--日期
);

老师考勤表创建语句如下:


--老师考勤表注释
create table t_lskq(
	id int identity(1,1) primary key not null,--主键
	teacherId int,--老师
	types varchar(100),--类型
	showDate datetime--日期
);

请假表创建语句如下:


--请假表注释
create table t_qj(
	id int identity(1,1) primary key not null,--主键
	studentId int,--用户
	title varchar(100),--说明
	qjDate datetime,--开始日期
	days int,--天数
	status varchar(100)--状态
);

学生表创建语句如下:


--学生表注释
create table t_student(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	studentName varchar(100),--姓名
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100),--电话
	pic varchar(100),--头像
	bjId int,--班级
	yxId int--院系
);

老师表创建语句如下:


--老师表注释
create table t_teacher(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	teacherName varchar(100),--姓名
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100),--电话
	pic varchar(100),--头像
	bjId int,--班级
	yxId int--院系
);

校领导表创建语句如下:


--校领导表注释
create table t_xld(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	yldName varchar(100),--姓名
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100),--电话
	pic varchar(100)--头像
);

院领导表创建语句如下:


--院领导表注释
create table t_yld(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	yldName varchar(100),--姓名
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100),--电话
	pic varchar(100),--头像
	yxId int--院系
);

院系表创建语句如下:


--院系表注释
create table t_yx(
	id int identity(1,1) primary key not null,--主键
	yxName varchar(100)--院系
);

高校学生考勤管理系统设计和实现登录后主页

高校学生考勤管理系统设计和实现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_bj")
public class Bj {
//主键
@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 bjName;
public String getBjName() {return bjName;}
public void setBjName(String bjName) {this.bjName = bjName;}
}

考勤通报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_gg")
public class Gg {
//主键
@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 xm;
//日期
private Date showDate;
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 getXm() {return xm;}
public void setXm(String xm) {this.xm = xm;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}

学生考勤javaBean创建语句如下:


package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity

//学生考勤
@Table(name = "t_kq")
public class Kq {
//主键
@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 studentId;
//类型
private String types;
//日期
private Date showDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}

老师考勤javaBean创建语句如下:


package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity

//老师考勤
@Table(name = "t_lskq")
public class Lskq {
//主键
@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 teacherId;
//类型
private String types;
//日期
private Date showDate;
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}

请假javaBean创建语句如下:


package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity

//请假
@Table(name = "t_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 studentId;
//说明
private String title;
//开始日期
private Date qjDate;
//天数
private Integer days;
//状态
private String status;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Date getQjDate() {return qjDate;}
public void setQjDate(Date qjDate) {this.qjDate = qjDate;}
public Integer getDays() {return days;}
public void setDays(Integer days) {this.days = days;}
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_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 age;
//性别
private String sex;
//电话
private String phone;
//头像
private String pic;
//班级
private Integer bjId;
//院系
private Integer yxId;
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 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 getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Integer getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
public Integer getYxId() {return yxId;}
public void setYxId(Integer yxId) {this.yxId = yxId;}
}

老师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_teacher")
public class Teacher {
//主键
@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 teacherName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//头像
private String pic;
//班级
private Integer bjId;
//院系
private Integer yxId;
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 getTeacherName() {return teacherName;}
public void setTeacherName(String teacherName) {this.teacherName = teacherName;}
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 getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Integer getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
public Integer getYxId() {return yxId;}
public void setYxId(Integer yxId) {this.yxId = yxId;}
}

校领导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 yldName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//头像
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 getYldName() {return yldName;}
public void setYldName(String yldName) {this.yldName = yldName;}
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 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_yld")
public class Yld {
//主键
@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 yldName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//头像
private String pic;
//院系
private Integer yxId;
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 getYldName() {return yldName;}
public void setYldName(String yldName) {this.yldName = yldName;}
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 getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Integer getYxId() {return yxId;}
public void setYxId(Integer yxId) {this.yxId = yxId;}
}

院系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_yx")
public class Yx {
//主键
@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 yxName;
public String getYxName() {return yxName;}
public void setYxName(String yxName) {this.yxName = yxName;}
}

高校学生考勤管理系统设计和实现spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

班级javaBean创建语句如下:


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

//班级
public class Bj  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//班级
private String bjName;
public String getBjName() {return bjName;}
public void setBjName(String bjName) {this.bjName = bjName;}
}

考勤通报javaBean创建语句如下:


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

//考勤通报
public class Gg  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 xm;
//日期
private Date showDate;
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 getXm() {return xm;}
public void setXm(String xm) {this.xm = xm;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}

学生考勤javaBean创建语句如下:


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

//学生考勤
public class Kq  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//类型
private String types;
//日期
private Date showDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}

老师考勤javaBean创建语句如下:


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

//老师考勤
public class Lskq  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//老师
private Integer teacherId;
//类型
private String types;
//日期
private Date showDate;
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}

请假javaBean创建语句如下:


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

//请假
public class Qj  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer studentId;
//说明
private String title;
//开始日期
private Date qjDate;
//天数
private Integer days;
//状态
private String status;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Date getQjDate() {return qjDate;}
public void setQjDate(Date qjDate) {this.qjDate = qjDate;}
public Integer getDays() {return days;}
public void setDays(Integer days) {this.days = days;}
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 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 age;
//性别
private String sex;
//电话
private String phone;
//头像
private String pic;
//班级
private Integer bjId;
//院系
private Integer yxId;
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 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 getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Integer getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
public Integer getYxId() {return yxId;}
public void setYxId(Integer yxId) {this.yxId = yxId;}
}

老师javaBean创建语句如下:


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

//老师
public class Teacher  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 teacherName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//头像
private String pic;
//班级
private Integer bjId;
//院系
private Integer yxId;
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 getTeacherName() {return teacherName;}
public void setTeacherName(String teacherName) {this.teacherName = teacherName;}
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 getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Integer getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
public Integer getYxId() {return yxId;}
public void setYxId(Integer yxId) {this.yxId = yxId;}
}

校领导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 yldName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//头像
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 getYldName() {return yldName;}
public void setYldName(String yldName) {this.yldName = yldName;}
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 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 Yld  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 yldName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//头像
private String pic;
//院系
private Integer yxId;
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 getYldName() {return yldName;}
public void setYldName(String yldName) {this.yldName = yldName;}
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 getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Integer getYxId() {return yxId;}
public void setYxId(Integer yxId) {this.yxId = yxId;}
}

院系javaBean创建语句如下:


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

//院系
public class Yx  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//院系
private String yxName;
public String getYxName() {return yxName;}
public void setYxName(String yxName) {this.yxName = yxName;}
}

源代码下载点这里

评论