学生实验室考勤管理系统的设计

学生实验室考勤管理系统的设计登录注册界面

学生实验室考勤管理系统的设计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_kq(
	id int primary key auto_increment comment '主键',
	customerId int comment '学生',
	showDate datetime comment '月份',
	v1 int comment '旷课次数',
	v2 int comment '迟到次数',
	v3 int comment '病假次数',
	v4 int comment '事假次数',
	qq varchar(100) comment '是否全勤'
) comment '考勤';

请假表创建语句如下:


create table t_qj(
	id int primary key auto_increment comment '主键',
	studentId int comment '学生',
	title varchar(100) comment '标题',
	qjbeginDate datetime comment '开始时间',
	qjendDate datetime comment '结束时间',
	content varchar(100) comment '说明',
	types varchar(100) comment '类型',
	status varchar(100) comment '状态',
	teacherId int comment '审批老师'
) comment '请假';

学生表创建语句如下:


create table t_student(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '学号',
	password varchar(100) comment '密码',
	bjId int comment '班级',
	studentName varchar(100) comment '姓名',
	phone varchar(100) comment '电话',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	pic varchar(100) 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 '姓名',
	phone varchar(100) comment '电话',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	pic 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_kq(
	id integer,
	customerId int,
	showDate datetime,
	v1 int,
	v2 int,
	v3 int,
	v4 int,
	qq varchar(100)
);
--考勤字段加注释
comment on column t_kq.id is '主键';
comment on column t_kq.customerId is '学生';
comment on column t_kq.showDate is '月份';
comment on column t_kq.v1 is '旷课次数';
comment on column t_kq.v2 is '迟到次数';
comment on column t_kq.v3 is '病假次数';
comment on column t_kq.v4 is '事假次数';
comment on column t_kq.qq is '是否全勤';
--考勤表加注释
comment on table t_kq is '考勤';

请假表创建语句如下:


create table t_qj(
	id integer,
	studentId int,
	title varchar(100),
	qjbeginDate datetime,
	qjendDate datetime,
	content varchar(100),
	types varchar(100),
	status varchar(100),
	teacherId int
);
--请假字段加注释
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.qjbeginDate is '开始时间';
comment on column t_qj.qjendDate is '结束时间';
comment on column t_qj.content is '说明';
comment on column t_qj.types is '类型';
comment on column t_qj.status is '状态';
comment on column t_qj.teacherId is '审批老师';
--请假表加注释
comment on table t_qj is '请假';

学生表创建语句如下:


create table t_student(
	id integer,
	username varchar(100),
	password varchar(100),
	bjId int,
	studentName varchar(100),
	phone varchar(100),
	age varchar(100),
	sex varchar(100),
	pic 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.bjId 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.pic is '头像';
--学生表加注释
comment on table t_student is '学生';

老师表创建语句如下:


create table t_teacher(
	id integer,
	username varchar(100),
	password varchar(100),
	teacherName varchar(100),
	phone varchar(100),
	age varchar(100),
	sex varchar(100),
	pic varchar(100)
);
--老师字段加注释
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.phone is '电话';
comment on column t_teacher.age is '年龄';
comment on column t_teacher.sex is '性别';
comment on column t_teacher.pic is '头像';
--老师表加注释
comment on table t_teacher is '老师';

oracle特有,对应序列如下:


create sequence s_t_bj;
create sequence s_t_kq;
create sequence s_t_qj;
create sequence s_t_student;
create sequence s_t_teacher;

学生实验室考勤管理系统的设计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_kq(
	id int identity(1,1) primary key not null,--主键
	customerId int,--学生
	showDate datetime,--月份
	v1 int,--旷课次数
	v2 int,--迟到次数
	v3 int,--病假次数
	v4 int,--事假次数
	qq varchar(100)--是否全勤
);

请假表创建语句如下:


--请假表注释
create table t_qj(
	id int identity(1,1) primary key not null,--主键
	studentId int,--学生
	title varchar(100),--标题
	qjbeginDate datetime,--开始时间
	qjendDate datetime,--结束时间
	content varchar(100),--说明
	types varchar(100),--类型
	status varchar(100),--状态
	teacherId int--审批老师
);

学生表创建语句如下:


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

老师表创建语句如下:


--老师表注释
create table t_teacher(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	teacherName varchar(100),--姓名
	phone varchar(100),--电话
	age varchar(100),--年龄
	sex varchar(100),--性别
	pic 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_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 customerId;
//月份
private Date showDate;
//旷课次数
private Integer v1;
//迟到次数
private Integer v2;
//病假次数
private Integer v3;
//事假次数
private Integer v4;
//是否全勤
private String qq;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public Integer getV1() {return v1;}
public void setV1(Integer v1) {this.v1 = v1;}
public Integer getV2() {return v2;}
public void setV2(Integer v2) {this.v2 = v2;}
public Integer getV3() {return v3;}
public void setV3(Integer v3) {this.v3 = v3;}
public Integer getV4() {return v4;}
public void setV4(Integer v4) {this.v4 = v4;}
public String getQq() {return qq;}
public void setQq(String qq) {this.qq = qq;}
}

请假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 qjbeginDate;
//结束时间
private Date qjendDate;
//说明
private String content;
//类型
private String types;
//状态
private String status;
//审批老师
private Integer teacherId;
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 getQjbeginDate() {return qjbeginDate;}
public void setQjbeginDate(Date qjbeginDate) {this.qjbeginDate = qjbeginDate;}
public Date getQjendDate() {return qjendDate;}
public void setQjendDate(Date qjendDate) {this.qjendDate = qjendDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
}

学生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 Integer bjId;
//姓名
private String studentName;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//头像
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 Integer getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
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 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_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 phone;
//年龄
private String age;
//性别
private String sex;
//头像
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 getTeacherName() {return teacherName;}
public void setTeacherName(String teacherName) {this.teacherName = teacherName;}
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 getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}

学生实验室考勤管理系统的设计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 Kq  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer customerId;
//月份
private Date showDate;
//旷课次数
private Integer v1;
//迟到次数
private Integer v2;
//病假次数
private Integer v3;
//事假次数
private Integer v4;
//是否全勤
private String qq;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public Integer getV1() {return v1;}
public void setV1(Integer v1) {this.v1 = v1;}
public Integer getV2() {return v2;}
public void setV2(Integer v2) {this.v2 = v2;}
public Integer getV3() {return v3;}
public void setV3(Integer v3) {this.v3 = v3;}
public Integer getV4() {return v4;}
public void setV4(Integer v4) {this.v4 = v4;}
public String getQq() {return qq;}
public void setQq(String qq) {this.qq = qq;}
}

请假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 qjbeginDate;
//结束时间
private Date qjendDate;
//说明
private String content;
//类型
private String types;
//状态
private String status;
//审批老师
private Integer teacherId;
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 getQjbeginDate() {return qjbeginDate;}
public void setQjbeginDate(Date qjbeginDate) {this.qjbeginDate = qjbeginDate;}
public Date getQjendDate() {return qjendDate;}
public void setQjendDate(Date qjendDate) {this.qjendDate = qjendDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
}

学生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 Integer bjId;
//姓名
private String studentName;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//头像
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 Integer getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
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 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 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 phone;
//年龄
private String age;
//性别
private String sex;
//头像
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 getTeacherName() {return teacherName;}
public void setTeacherName(String teacherName) {this.teacherName = teacherName;}
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 getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}

源代码下载点这里

评论