更多成品,定做java毕业设计,请咨询管理员qq:2812491287

学生到课率监控系统(go_class_system),优秀java设计

学生到课率监控系统登录注册界面

学生到课率监控系统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_fdy(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号(真实姓名)',
	password varchar(100) comment '密码',
	fdyName varchar(100) comment '辅导员名称',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话'
) comment '辅导员';

课程表创建语句如下:


create table t_kc(
	id int primary key auto_increment comment '主键',
	kcName varchar(100) comment '课程名称',
	num varchar(100) comment '课程编号',
	kcxz varchar(100) comment '课程性质',
	xf varchar(100) comment '学分',
	xs varchar(100) comment '学时',
	sy varchar(100) comment '实验',
	kkxq varchar(100) comment '开课学期',
	jffs varchar(100) comment '记分方式',
	sj varchar(100) comment '时间',
	dd varchar(100) comment '地点'
) comment '课程';

课程上课记录表创建语句如下:


create table t_kcsk(
	id int primary key auto_increment comment '主键',
	kcId int comment '课程',
	studentId int comment '学生',
	types varchar(100) comment '缺课或在课',
	insertDate datetime comment '点名时间',
	bjName varchar(100) comment ''
) comment '课程上课记录';

通知表创建语句如下:


create table t_message(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '标题',
	content varchar(100) comment '内容',
	showDate 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 '姓名',
	bj varchar(100) comment '班级',
	xh varchar(100) comment '学号',
	sex varchar(100) comment '性别',
	age varchar(100) comment '年龄',
	phone varchar(100) comment '电话',
	zw varchar(100) comment '职务',
	zp varchar(100) comment '照片',
	status 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 '老师名称',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone 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_fdy(
	id integer,
	username varchar(100),
	password varchar(100),
	fdyName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100)
);
--辅导员字段加注释
comment on column t_fdy.id is '主键';
comment on column t_fdy.username is '账号(真实姓名)';
comment on column t_fdy.password is '密码';
comment on column t_fdy.fdyName is '辅导员名称';
comment on column t_fdy.age is '年龄';
comment on column t_fdy.sex is '性别';
comment on column t_fdy.phone is '电话';
--辅导员表加注释
comment on table t_fdy is '辅导员';

课程表创建语句如下:


create table t_kc(
	id integer,
	kcName varchar(100),
	num varchar(100),
	kcxz varchar(100),
	xf varchar(100),
	xs varchar(100),
	sy varchar(100),
	kkxq varchar(100),
	jffs varchar(100),
	sj varchar(100),
	dd varchar(100)
);
--课程字段加注释
comment on column t_kc.id is '主键';
comment on column t_kc.kcName is '课程名称';
comment on column t_kc.num is '课程编号';
comment on column t_kc.kcxz is '课程性质';
comment on column t_kc.xf is '学分';
comment on column t_kc.xs is '学时';
comment on column t_kc.sy is '实验';
comment on column t_kc.kkxq is '开课学期';
comment on column t_kc.jffs is '记分方式';
comment on column t_kc.sj is '时间';
comment on column t_kc.dd is '地点';
--课程表加注释
comment on table t_kc is '课程';

课程上课记录表创建语句如下:


create table t_kcsk(
	id integer,
	kcId int,
	studentId int,
	types varchar(100),
	insertDate datetime,
	bjName varchar(100)
);
--课程上课记录字段加注释
comment on column t_kcsk.id is '主键';
comment on column t_kcsk.kcId is '课程';
comment on column t_kcsk.studentId is '学生';
comment on column t_kcsk.types is '缺课或在课';
comment on column t_kcsk.insertDate is '点名时间';
comment on column t_kcsk.bjName is '';
--课程上课记录表加注释
comment on table t_kcsk is '课程上课记录';

通知表创建语句如下:


create table t_message(
	id integer,
	title varchar(100),
	content varchar(100),
	showDate varchar(100)
);
--通知字段加注释
comment on column t_message.id is '主键';
comment on column t_message.title is '标题';
comment on column t_message.content is '内容';
comment on column t_message.showDate is '日期';
--通知表加注释
comment on table t_message is '通知';

学生表创建语句如下:


create table t_student(
	id integer,
	username varchar(100),
	password varchar(100),
	studentName varchar(100),
	bj varchar(100),
	xh varchar(100),
	sex varchar(100),
	age varchar(100),
	phone varchar(100),
	zw varchar(100),
	zp varchar(100),
	status 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.bj is '班级';
comment on column t_student.xh is '学号';
comment on column t_student.sex is '性别';
comment on column t_student.age is '年龄';
comment on column t_student.phone is '电话';
comment on column t_student.zw is '职务';
comment on column t_student.zp is '照片';
comment on column t_student.status 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)
);
--老师字段加注释
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 table t_teacher is '老师';

oracle特有,对应序列如下:


create sequence s_t_fdy;
create sequence s_t_kc;
create sequence s_t_kcsk;
create sequence s_t_message;
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_fdy(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号(真实姓名)
	password varchar(100),--密码
	fdyName varchar(100),--辅导员名称
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100)--电话
);

课程表创建语句如下:


--课程表注释
create table t_kc(
	id int identity(1,1) primary key not null,--主键
	kcName varchar(100),--课程名称
	num varchar(100),--课程编号
	kcxz varchar(100),--课程性质
	xf varchar(100),--学分
	xs varchar(100),--学时
	sy varchar(100),--实验
	kkxq varchar(100),--开课学期
	jffs varchar(100),--记分方式
	sj varchar(100),--时间
	dd varchar(100)--地点
);

课程上课记录表创建语句如下:


--课程上课记录表注释
create table t_kcsk(
	id int identity(1,1) primary key not null,--主键
	kcId int,--课程
	studentId int,--学生
	types varchar(100),--缺课或在课
	insertDate datetime,--点名时间
	bjName varchar(100)--
);

通知表创建语句如下:


--通知表注释
create table t_message(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--标题
	content varchar(100),--内容
	showDate varchar(100)--日期
);

学生表创建语句如下:


--学生表注释
create table t_student(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号(真实姓名)
	password varchar(100),--密码
	studentName varchar(100),--姓名
	bj varchar(100),--班级
	xh varchar(100),--学号
	sex varchar(100),--性别
	age varchar(100),--年龄
	phone varchar(100),--电话
	zw varchar(100),--职务
	zp varchar(100),--照片
	status varchar(100)--
);

老师表创建语句如下:


--老师表注释
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)--电话
);

学生到课率监控系统登录后主页

学生到课率监控系统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_fdy")
public class Fdy {
//主键
@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 fdyName;
//年龄
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 getFdyName() {return fdyName;}
public void setFdyName(String fdyName) {this.fdyName = fdyName;}
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_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 kcName;
//课程编号
private String num;
//课程性质
private String kcxz;
//学分
private String xf;
//学时
private String xs;
//实验
private String sy;
//开课学期
private String kkxq;
//记分方式
private String jffs;
//时间
private String sj;
//地点
private String dd;
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
public String getNum() {return num;}
public void setNum(String num) {this.num = num;}
public String getKcxz() {return kcxz;}
public void setKcxz(String kcxz) {this.kcxz = kcxz;}
public String getXf() {return xf;}
public void setXf(String xf) {this.xf = xf;}
public String getXs() {return xs;}
public void setXs(String xs) {this.xs = xs;}
public String getSy() {return sy;}
public void setSy(String sy) {this.sy = sy;}
public String getKkxq() {return kkxq;}
public void setKkxq(String kkxq) {this.kkxq = kkxq;}
public String getJffs() {return jffs;}
public void setJffs(String jffs) {this.jffs = jffs;}
public String getSj() {return sj;}
public void setSj(String sj) {this.sj = sj;}
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_kcsk")
public class Kcsk {
//主键
@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 kcId;
//学生
private Integer studentId;
//缺课或在课
private String types;
//点名时间
private Date insertDate;
//
private String bjName;
public Integer getKcId() {return kcId;}
public void setKcId(Integer kcId) {this.kcId = kcId;}
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 getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
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_message")
public class Message {
//主键
@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 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 getShowDate() {return showDate;}
public void setShowDate(String 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_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 bj;
//学号
private String xh;
//性别
private String sex;
//年龄
private String age;
//电话
private String phone;
//职务
private String zw;
//照片
private String zp;
//
private String status;
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 getBj() {return bj;}
public void setBj(String bj) {this.bj = bj;}
public String getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getZw() {return zw;}
public void setZw(String zw) {this.zw = zw;}
public String getZp() {return zp;}
public void setZp(String zp) {this.zp = zp;}
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_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;
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;}
}

学生到课率监控系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

辅导员javaBean创建语句如下:


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

//辅导员
public class Fdy  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 fdyName;
//年龄
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 getFdyName() {return fdyName;}
public void setFdyName(String fdyName) {this.fdyName = fdyName;}
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 Kc  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//课程名称
private String kcName;
//课程编号
private String num;
//课程性质
private String kcxz;
//学分
private String xf;
//学时
private String xs;
//实验
private String sy;
//开课学期
private String kkxq;
//记分方式
private String jffs;
//时间
private String sj;
//地点
private String dd;
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
public String getNum() {return num;}
public void setNum(String num) {this.num = num;}
public String getKcxz() {return kcxz;}
public void setKcxz(String kcxz) {this.kcxz = kcxz;}
public String getXf() {return xf;}
public void setXf(String xf) {this.xf = xf;}
public String getXs() {return xs;}
public void setXs(String xs) {this.xs = xs;}
public String getSy() {return sy;}
public void setSy(String sy) {this.sy = sy;}
public String getKkxq() {return kkxq;}
public void setKkxq(String kkxq) {this.kkxq = kkxq;}
public String getJffs() {return jffs;}
public void setJffs(String jffs) {this.jffs = jffs;}
public String getSj() {return sj;}
public void setSj(String sj) {this.sj = sj;}
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 Kcsk  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//课程
private Integer kcId;
//学生
private Integer studentId;
//缺课或在课
private String types;
//点名时间
private Date insertDate;
//
private String bjName;
public Integer getKcId() {return kcId;}
public void setKcId(Integer kcId) {this.kcId = kcId;}
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 getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
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 Message  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 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 getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
}

学生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 bj;
//学号
private String xh;
//性别
private String sex;
//年龄
private String age;
//电话
private String phone;
//职务
private String zw;
//照片
private String zp;
//
private String status;
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 getBj() {return bj;}
public void setBj(String bj) {this.bj = bj;}
public String getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getZw() {return zw;}
public void setZw(String zw) {this.zw = zw;}
public String getZp() {return zp;}
public void setZp(String zp) {this.zp = zp;}
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 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;
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;}
}

评论