学生考勤管理系统(xf22tfhdul)_mysql_oracle代码分享

• 学生考勤管理系统mysql数据库创建语句
• 学生考勤管理系统oracle数据库创建语句
• 学生考勤管理系统sqlserver数据库创建语句
• 学生考勤管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
• 学生考勤管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计

学生考勤管理系统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 '主键',
	bjbh varchar(100) comment '班级编号',
	bjName varchar(100) comment '班级名称',
	zy varchar(100) comment '专业',
	bzr varchar(100) comment '班主任',
	bz varchar(100) comment '班长',
	rs varchar(100) comment '人数'
) comment '班级';

课程表创建语句如下：

create table t_kc(
	id int primary key auto_increment comment '主键',
	kcbh varchar(100) comment '课程编号',
	kcName varchar(100) comment '课程名称',
	rkls varchar(100) comment '任课老师'
) comment '课程';

考勤表创建语句如下：

create table t_kq(
	id int primary key auto_increment comment '主键',
	xh varchar(100) comment '学号',
	kcbh varchar(100) comment '课程编号',
	showDate varchar(100) comment '考勤日期',
	remark text comment '考勤记录'
) comment '考勤';

考勤人员表创建语句如下：

create table t_ptadmin(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	ptadminName varchar(100) comment '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '',
	phone varchar(100) comment '电话'
) comment '考勤人员';

请销假表创建语句如下：

create table t_qxj(
	id int primary key auto_increment comment '主键',
	xh varchar(100) comment '学号',
	qjjl text comment '请假记录',
	qjrq datetime comment '请假日期',
	xjjl text comment '销假记录',
	xjrq datetime comment '销假日期'
) comment '请销假';

学生表创建语句如下：

create table t_student(
	id int primary key auto_increment comment '主键',
	xh varchar(100) comment '学号',
	studentName varchar(100) comment '姓名',
	sex varchar(100) comment '',
	birthday varchar(100) comment '出生日期',
	lxfs varchar(100) comment '联系方式',
	bjbh 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,
	bjbh varchar(100),
	bjName varchar(100),
	zy varchar(100),
	bzr varchar(100),
	bz varchar(100),
	rs varchar(100)
);
--班级字段加注释
comment on column t_bj.id is '主键';
comment on column t_bj.bjbh is '班级编号';
comment on column t_bj.bjName is '班级名称';
comment on column t_bj.zy is '专业';
comment on column t_bj.bzr is '班主任';
comment on column t_bj.bz is '班长';
comment on column t_bj.rs is '人数';
--班级表加注释
comment on table t_bj is '班级';

课程表创建语句如下：

create table t_kc(
	id integer,
	kcbh varchar(100),
	kcName varchar(100),
	rkls varchar(100)
);
--课程字段加注释
comment on column t_kc.id is '主键';
comment on column t_kc.kcbh is '课程编号';
comment on column t_kc.kcName is '课程名称';
comment on column t_kc.rkls is '任课老师';
--课程表加注释
comment on table t_kc is '课程';

考勤表创建语句如下：

create table t_kq(
	id integer,
	xh varchar(100),
	kcbh varchar(100),
	showDate varchar(100),
	remark text
);
--考勤字段加注释
comment on column t_kq.id is '主键';
comment on column t_kq.xh is '学号';
comment on column t_kq.kcbh is '课程编号';
comment on column t_kq.showDate is '考勤日期';
comment on column t_kq.remark is '考勤记录';
--考勤表加注释
comment on table t_kq is '考勤';

考勤人员表创建语句如下：

create table t_ptadmin(
	id integer,
	username varchar(100),
	password varchar(100),
	ptadminName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100)
);
--考勤人员字段加注释
comment on column t_ptadmin.id is '主键';
comment on column t_ptadmin.username is '账号';
comment on column t_ptadmin.password is '密码';
comment on column t_ptadmin.ptadminName is '姓名';
comment on column t_ptadmin.age is '年龄';
comment on column t_ptadmin.sex is '';
comment on column t_ptadmin.phone is '电话';
--考勤人员表加注释
comment on table t_ptadmin is '考勤人员';

请销假表创建语句如下：

create table t_qxj(
	id integer,
	xh varchar(100),
	qjjl text,
	qjrq datetime,
	xjjl text,
	xjrq datetime
);
--请销假字段加注释
comment on column t_qxj.id is '主键';
comment on column t_qxj.xh is '学号';
comment on column t_qxj.qjjl is '请假记录';
comment on column t_qxj.qjrq is '请假日期';
comment on column t_qxj.xjjl is '销假记录';
comment on column t_qxj.xjrq is '销假日期';
--请销假表加注释
comment on table t_qxj is '请销假';

学生表创建语句如下：

create table t_student(
	id integer,
	xh varchar(100),
	studentName varchar(100),
	sex varchar(100),
	birthday varchar(100),
	lxfs varchar(100),
	bjbh varchar(100)
);
--学生字段加注释
comment on column t_student.id is '主键';
comment on column t_student.xh is '学号';
comment on column t_student.studentName is '姓名';
comment on column t_student.sex is '';
comment on column t_student.birthday is '出生日期';
comment on column t_student.lxfs is '联系方式';
comment on column t_student.bjbh is '班级编号';
--学生表加注释
comment on table t_student is '学生';

oracle特有，对应序列如下：

create sequence s_t_bj;
create sequence s_t_kc;
create sequence s_t_kq;
create sequence s_t_ptadmin;
create sequence s_t_qxj;
create sequence s_t_student;

学生考勤管理系统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,--主键
	bjbh varchar(100),--班级编号
	bjName varchar(100),--班级名称
	zy varchar(100),--专业
	bzr varchar(100),--班主任
	bz varchar(100),--班长
	rs varchar(100)--人数
);

课程表创建语句如下：

--课程表注释
create table t_kc(
	id int identity(1,1) primary key not null,--主键
	kcbh varchar(100),--课程编号
	kcName varchar(100),--课程名称
	rkls varchar(100)--任课老师
);

考勤表创建语句如下：

--考勤表注释
create table t_kq(
	id int identity(1,1) primary key not null,--主键
	xh varchar(100),--学号
	kcbh varchar(100),--课程编号
	showDate varchar(100),--考勤日期
	remark text--考勤记录
);

考勤人员表创建语句如下：

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

请销假表创建语句如下：

--请销假表注释
create table t_qxj(
	id int identity(1,1) primary key not null,--主键
	xh varchar(100),--学号
	qjjl text,--请假记录
	qjrq datetime,--请假日期
	xjjl text,--销假记录
	xjrq datetime--销假日期
);

学生表创建语句如下：

--学生表注释
create table t_student(
	id int identity(1,1) primary key not null,--主键
	xh varchar(100),--学号
	studentName varchar(100),--姓名
	sex varchar(100),--
	birthday varchar(100),--出生日期
	lxfs varchar(100),--联系方式
	bjbh 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 bjbh;
//班级名称
private String bjName;
//专业
private String zy;
//班主任
private String bzr;
//班长
private String bz;
//人数
private String rs;
public String getBjbh() {return bjbh;}
public void setBjbh(String bjbh) {this.bjbh = bjbh;}
public String getBjName() {return bjName;}
public void setBjName(String bjName) {this.bjName = bjName;}
public String getZy() {return zy;}
public void setZy(String zy) {this.zy = zy;}
public String getBzr() {return bzr;}
public void setBzr(String bzr) {this.bzr = bzr;}
public String getBz() {return bz;}
public void setBz(String bz) {this.bz = bz;}
public String getRs() {return rs;}
public void setRs(String rs) {this.rs = rs;}
}

课程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_kc")
public class Kc {
//主键
@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 kcbh;
//课程名称
private String kcName;
//任课老师
private String rkls;
public String getKcbh() {return kcbh;}
public void setKcbh(String kcbh) {this.kcbh = kcbh;}
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
public String getRkls() {return rkls;}
public void setRkls(String rkls) {this.rkls = rkls;}
}

考勤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 String xh;
//课程编号
private String kcbh;
//考勤日期
private String showDate;
//考勤记录
private String remark;
public String getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
public String getKcbh() {return kcbh;}
public void setKcbh(String kcbh) {this.kcbh = kcbh;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}

考勤人员javaBean创建语句如下：

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

//考勤人员
@Table(name = "t_ptadmin")
public class Ptadmin {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码
private String password;
//姓名
private String ptadminName;
//年龄
private String age;
//
private String sex;
//电话
private String phone;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getPtadminName() {return ptadminName;}
public void setPtadminName(String ptadminName) {this.ptadminName = ptadminName;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}

请销假javaBean创建语句如下：

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

//请销假
@Table(name = "t_qxj")
public class Qxj {
//主键
@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 xh;
//请假记录
private String qjjl;
//请假日期
private Date qjrq;
//销假记录
private String xjjl;
//销假日期
private Date xjrq;
public String getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
public String getQjjl() {return qjjl;}
public void setQjjl(String qjjl) {this.qjjl = qjjl;}
public Date getQjrq() {return qjrq;}
public void setQjrq(Date qjrq) {this.qjrq = qjrq;}
public String getXjjl() {return xjjl;}
public void setXjjl(String xjjl) {this.xjjl = xjjl;}
public Date getXjrq() {return xjrq;}
public void setXjrq(Date xjrq) {this.xjrq = xjrq;}
}

学生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 xh;
//姓名
private String studentName;
//
private String sex;
//出生日期
private String birthday;
//联系方式
private String lxfs;
//班级编号
private String bjbh;
public String getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
public String getStudentName() {return studentName;}
public void setStudentName(String studentName) {this.studentName = studentName;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getBirthday() {return birthday;}
public void setBirthday(String birthday) {this.birthday = birthday;}
public String getLxfs() {return lxfs;}
public void setLxfs(String lxfs) {this.lxfs = lxfs;}
public String getBjbh() {return bjbh;}
public void setBjbh(String bjbh) {this.bjbh = bjbh;}
}

学生考勤管理系统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 bjbh;
//班级名称
private String bjName;
//专业
private String zy;
//班主任
private String bzr;
//班长
private String bz;
//人数
private String rs;
public String getBjbh() {return bjbh;}
public void setBjbh(String bjbh) {this.bjbh = bjbh;}
public String getBjName() {return bjName;}
public void setBjName(String bjName) {this.bjName = bjName;}
public String getZy() {return zy;}
public void setZy(String zy) {this.zy = zy;}
public String getBzr() {return bzr;}
public void setBzr(String bzr) {this.bzr = bzr;}
public String getBz() {return bz;}
public void setBz(String bz) {this.bz = bz;}
public String getRs() {return rs;}
public void setRs(String rs) {this.rs = rs;}
}

课程javaBean创建语句如下：

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

//课程
public class Kc  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//课程编号
private String kcbh;
//课程名称
private String kcName;
//任课老师
private String rkls;
public String getKcbh() {return kcbh;}
public void setKcbh(String kcbh) {this.kcbh = kcbh;}
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
public String getRkls() {return rkls;}
public void setRkls(String rkls) {this.rkls = rkls;}
}

考勤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 String xh;
//课程编号
private String kcbh;
//考勤日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private String showDate;
//考勤记录
private String remark;
public String getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
public String getKcbh() {return kcbh;}
public void setKcbh(String kcbh) {this.kcbh = kcbh;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}

考勤人员javaBean创建语句如下：

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

//考勤人员
public class Ptadmin  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码
private String password;
//姓名
private String ptadminName;
//年龄
private String age;
//
private String sex;
//电话
private String phone;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getPtadminName() {return ptadminName;}
public void setPtadminName(String ptadminName) {this.ptadminName = ptadminName;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}

请销假javaBean创建语句如下：

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

//请销假
public class Qxj  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学号
private String xh;
//请假记录
private String qjjl;
//请假日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date qjrq;
//销假记录
private String xjjl;
//销假日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date xjrq;
public String getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
public String getQjjl() {return qjjl;}
public void setQjjl(String qjjl) {this.qjjl = qjjl;}
public Date getQjrq() {return qjrq;}
public void setQjrq(Date qjrq) {this.qjrq = qjrq;}
public String getXjjl() {return xjjl;}
public void setXjjl(String xjjl) {this.xjjl = xjjl;}
public Date getXjrq() {return xjrq;}
public void setXjrq(Date xjrq) {this.xjrq = xjrq;}
}

学生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 xh;
//姓名
private String studentName;
//
private String sex;
//出生日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private String birthday;
//联系方式
private String lxfs;
//班级编号
private String bjbh;
public String getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
public String getStudentName() {return studentName;}
public void setStudentName(String studentName) {this.studentName = studentName;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getBirthday() {return birthday;}
public void setBirthday(String birthday) {this.birthday = birthday;}
public String getLxfs() {return lxfs;}
public void setLxfs(String lxfs) {this.lxfs = lxfs;}
public String getBjbh() {return bjbh;}
public void setBjbh(String bjbh) {this.bjbh = bjbh;}
}