Java毕业设计_多功能课程管理系统

多功能课程管理系统

多功能课程管理系统mysql数据库创建语句
多功能课程管理系统oracle数据库创建语句
多功能课程管理系统sqlserver数据库创建语句
多功能课程管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
多功能课程管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
高质量编程视频：shangyepingtai.xin

多功能课程管理系统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’);
SQLCopy
班级表创建语句如下：
create table t_bj(
id int primary key auto_increment comment ‘主键’,
bjName varchar(100) comment ‘班级’
) comment ‘班级’;
SQLCopy
课程表创建语句如下：
create table t_kc(
id int primary key auto_increment comment ‘主键’,
teacherId int comment ‘老师’,
kcName varchar(100) comment ‘课程名称’,
kcNum varchar(100) comment ‘课程号’,
zyId int comment ‘专业’,
bjId int comment ‘班级’,
njId int comment ‘年级’,
bxxx varchar(100) comment ‘必修选修’,
xf int comment ‘学分’,
rs int comment ‘人数上线’,
fileUrl varchar(100) comment ‘资料’
) comment ‘课程’;
SQLCopy
课程选课表创建语句如下：
create table t_kclist(
id int primary key auto_increment comment ‘主键’,
kcId int comment ‘课程’,
studentId int comment ‘学生’,
teacherId int comment ‘老师’,
insertDate datetime comment ‘选课日期’,
pf int comment ‘评分’,
df int comment ‘得分’,
back varchar(100) comment ‘评语’
) comment ‘课程选课’;
SQLCopy
年级表创建语句如下：
create table t_nj(
id int primary key auto_increment comment ‘主键’,
njName varchar(100) comment ‘年级’
) comment ‘年级’;
SQLCopy
学生表创建语句如下：
create table t_student(
id int primary key auto_increment comment ‘主键’,
username varchar(100) comment ‘学号’,
password varchar(100) comment ‘密码’,
zyId int comment ‘专业’,
bjId int comment ‘班级’,
njId int comment ‘年级’,
studentName varchar(100) comment ‘姓名’,
headPic varchar(100) comment ‘籍贯’,
phone varchar(100) comment ‘电话’,
age varchar(100) comment ‘年龄’,
sex varchar(100) comment ‘性别’
) comment ‘学生’;
SQLCopy
老师表创建语句如下：
create table t_teacher(
id int primary key auto_increment comment ‘主键’,
username varchar(100) comment ‘工号’,
password varchar(100) comment ‘密码’,
teacherName varchar(100) comment ‘姓名’,
headPic varchar(100) comment ‘籍贯’,
phone varchar(100) comment ‘电话’,
age varchar(100) comment ‘年龄’,
sex varchar(100) comment ‘性别’
) comment ‘老师’;
SQLCopy
选课时间表创建语句如下：
create table t_xksj(
id int primary key auto_increment comment ‘主键’,
showDate datetime comment ‘选课时间’
) comment ‘选课时间’;
SQLCopy
专业表创建语句如下：
create table t_zy(
id int primary key auto_increment comment ‘主键’,
zyName varchar(100) comment ‘专业’
) comment ‘专业’;
SQLCopy

多功能课程管理系统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 ‘超级管理员’;
SQLCopy
班级表创建语句如下：
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 ‘班级’;
SQLCopy
课程表创建语句如下：
create table t_kc(
id integer,
teacherId int,
kcName varchar(100),
kcNum varchar(100),
zyId int,
bjId int,
njId int,
bxxx varchar(100),
xf int,
rs int,
fileUrl varchar(100)
);
–课程字段加注释
comment on column t_kc.id is ‘主键’;
comment on column t_kc.teacherId is ‘老师’;
comment on column t_kc.kcName is ‘课程名称’;
comment on column t_kc.kcNum is ‘课程号’;
comment on column t_kc.zyId is ‘专业’;
comment on column t_kc.bjId is ‘班级’;
comment on column t_kc.njId is ‘年级’;
comment on column t_kc.bxxx is ‘必修选修’;
comment on column t_kc.xf is ‘学分’;
comment on column t_kc.rs is ‘人数上线’;
comment on column t_kc.fileUrl is ‘资料’;
–课程表加注释
comment on table t_kc is ‘课程’;
SQLCopy
课程选课表创建语句如下：
create table t_kclist(
id integer,
kcId int,
studentId int,
teacherId int,
insertDate datetime,
pf int,
df int,
back varchar(100)
);
–课程选课字段加注释
comment on column t_kclist.id is ‘主键’;
comment on column t_kclist.kcId is ‘课程’;
comment on column t_kclist.studentId is ‘学生’;
comment on column t_kclist.teacherId is ‘老师’;
comment on column t_kclist.insertDate is ‘选课日期’;
comment on column t_kclist.pf is ‘评分’;
comment on column t_kclist.df is ‘得分’;
comment on column t_kclist.back is ‘评语’;
–课程选课表加注释
comment on table t_kclist is ‘课程选课’;
SQLCopy
年级表创建语句如下：
create table t_nj(
id integer,
njName varchar(100)
);
–年级字段加注释
comment on column t_nj.id is ‘主键’;
comment on column t_nj.njName is ‘年级’;
–年级表加注释
comment on table t_nj is ‘年级’;
SQLCopy
学生表创建语句如下：
create table t_student(
id integer,
username varchar(100),
password varchar(100),
zyId int,
bjId int,
njId int,
studentName varchar(100),
headPic varchar(100),
phone varchar(100),
age varchar(100),
sex 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.zyId is ‘专业’;
comment on column t_student.bjId is ‘班级’;
comment on column t_student.njId is ‘年级’;
comment on column t_student.studentName is ‘姓名’;
comment on column t_student.headPic is ‘籍贯’;
comment on column t_student.phone is ‘电话’;
comment on column t_student.age is ‘年龄’;
comment on column t_student.sex is ‘性别’;
–学生表加注释
comment on table t_student is ‘学生’;
SQLCopy
老师表创建语句如下：
create table t_teacher(
id integer,
username varchar(100),
password varchar(100),
teacherName varchar(100),
headPic varchar(100),
phone varchar(100),
age varchar(100),
sex 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.headPic is ‘籍贯’;
comment on column t_teacher.phone is ‘电话’;
comment on column t_teacher.age is ‘年龄’;
comment on column t_teacher.sex is ‘性别’;
–老师表加注释
comment on table t_teacher is ‘老师’;
SQLCopy
选课时间表创建语句如下：
create table t_xksj(
id integer,
showDate datetime
);
–选课时间字段加注释
comment on column t_xksj.id is ‘主键’;
comment on column t_xksj.showDate is ‘选课时间’;
–选课时间表加注释
comment on table t_xksj is ‘选课时间’;
SQLCopy
专业表创建语句如下：
create table t_zy(
id integer,
zyName varchar(100)
);
–专业字段加注释
comment on column t_zy.id is ‘主键’;
comment on column t_zy.zyName is ‘专业’;
–专业表加注释
comment on table t_zy is ‘专业’;
SQLCopy
oracle特有，对应序列如下：
create sequence s_t_bj;
create sequence s_t_kc;
create sequence s_t_kclist;
create sequence s_t_nj;
create sequence s_t_student;
create sequence s_t_teacher;
create sequence s_t_xksj;
create sequence s_t_zy;
SQLCopy

多功能课程管理系统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’);
SQLCopy
班级表创建语句如下：
–班级表注释
create table t_bj(
id int identity(1,1) primary key not null,–主键
bjName varchar(100)–班级
);
SQLCopy
课程表创建语句如下：
–课程表注释
create table t_kc(
id int identity(1,1) primary key not null,–主键
teacherId int,–老师
kcName varchar(100),–课程名称
kcNum varchar(100),–课程号
zyId int,–专业
bjId int,–班级
njId int,–年级
bxxx varchar(100),–必修选修
xf int,–学分
rs int,–人数上线
fileUrl varchar(100)–资料
);
SQLCopy
课程选课表创建语句如下：
–课程选课表注释
create table t_kclist(
id int identity(1,1) primary key not null,–主键
kcId int,–课程
studentId int,–学生
teacherId int,–老师
insertDate datetime,–选课日期
pf int,–评分
df int,–得分
back varchar(100)–评语
);
SQLCopy
年级表创建语句如下：
–年级表注释
create table t_nj(
id int identity(1,1) primary key not null,–主键
njName varchar(100)–年级
);
SQLCopy
学生表创建语句如下：
–学生表注释
create table t_student(
id int identity(1,1) primary key not null,–主键
username varchar(100),–学号
password varchar(100),–密码
zyId int,–专业
bjId int,–班级
njId int,–年级
studentName varchar(100),–姓名
headPic varchar(100),–籍贯
phone varchar(100),–电话
age varchar(100),–年龄
sex varchar(100)–性别
);
SQLCopy
老师表创建语句如下：
–老师表注释
create table t_teacher(
id int identity(1,1) primary key not null,–主键
username varchar(100),–工号
password varchar(100),–密码
teacherName varchar(100),–姓名
headPic varchar(100),–籍贯
phone varchar(100),–电话
age varchar(100),–年龄
sex varchar(100)–性别
);
SQLCopy
选课时间表创建语句如下：
–选课时间表注释
create table t_xksj(
id int identity(1,1) primary key not null,–主键
showDate datetime–选课时间
);
SQLCopy
专业表创建语句如下：
–专业表注释
create table t_zy(
id int identity(1,1) primary key not null,–主键
zyName varchar(100)–专业
);
SQLCopy

多功能课程管理系统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;}
}
JavaCopy
课程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 Integer teacherId;
//课程名称
private String kcName;
//课程号
private String kcNum;
//专业
private Integer zyId;
//班级
private Integer bjId;
//年级
private Integer njId;
//必修选修
private String bxxx;
//学分
private Integer xf;
//人数上线
private Integer rs;
//资料
private String fileUrl;
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
public String getKcNum() {return kcNum;}
public void setKcNum(String kcNum) {this.kcNum = kcNum;}
public Integer getZyId() {return zyId;}
public void setZyId(Integer zyId) {this.zyId = zyId;}
public Integer getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
public Integer getNjId() {return njId;}
public void setNjId(Integer njId) {this.njId = njId;}
public String getBxxx() {return bxxx;}
public void setBxxx(String bxxx) {this.bxxx = bxxx;}
public Integer getXf() {return xf;}
public void setXf(Integer xf) {this.xf = xf;}
public Integer getRs() {return rs;}
public void setRs(Integer rs) {this.rs = rs;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
}
JavaCopy
课程选课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_kclist”)
public class Kclist {
//主键
@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 Integer teacherId;
//选课日期
private Date insertDate;
//评分
private Integer pf;
//得分
private Integer df;
//评语
private String back;
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 Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public Integer getPf() {return pf;}
public void setPf(Integer pf) {this.pf = pf;}
public Integer getDf() {return df;}
public void setDf(Integer df) {this.df = df;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
}
JavaCopy
年级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_nj”)
public class Nj {
//主键
@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 njName;
public String getNjName() {return njName;}
public void setNjName(String njName) {this.njName = njName;}
}
JavaCopy
学生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 zyId;
//班级
private Integer bjId;
//年级
private Integer njId;
//姓名
private String studentName;
//籍贯
private String headPic;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
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 getZyId() {return zyId;}
public void setZyId(Integer zyId) {this.zyId = zyId;}
public Integer getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
public Integer getNjId() {return njId;}
public void setNjId(Integer njId) {this.njId = njId;}
public String getStudentName() {return studentName;}
public void setStudentName(String studentName) {this.studentName = studentName;}
public String getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
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;}
}
JavaCopy
老师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 headPic;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
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 getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
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;}
}
JavaCopy
选课时间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_xksj”)
public class Xksj {
//主键
@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 Date showDate;
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}
JavaCopy
专业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_zy”)
public class Zy {
//主键
@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 zyName;
public String getZyName() {return zyName;}
public void setZyName(String zyName) {this.zyName = zyName;}
}
JavaCopy

多功能课程管理系统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;}
}
JavaCopy
课程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 Integer teacherId;
//课程名称
private String kcName;
//课程号
private String kcNum;
//专业
private Integer zyId;
//班级
private Integer bjId;
//年级
private Integer njId;
//必修选修
private String bxxx;
//学分
private Integer xf;
//人数上线
private Integer rs;
//资料
private String fileUrl;
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
public String getKcNum() {return kcNum;}
public void setKcNum(String kcNum) {this.kcNum = kcNum;}
public Integer getZyId() {return zyId;}
public void setZyId(Integer zyId) {this.zyId = zyId;}
public Integer getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
public Integer getNjId() {return njId;}
public void setNjId(Integer njId) {this.njId = njId;}
public String getBxxx() {return bxxx;}
public void setBxxx(String bxxx) {this.bxxx = bxxx;}
public Integer getXf() {return xf;}
public void setXf(Integer xf) {this.xf = xf;}
public Integer getRs() {return rs;}
public void setRs(Integer rs) {this.rs = rs;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
}
JavaCopy
课程选课javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//课程选课
public class Kclist 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 Integer teacherId;
//选课日期
private Date insertDate;
//评分
private Integer pf;
//得分
private Integer df;
//评语
private String back;
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 Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public Integer getPf() {return pf;}
public void setPf(Integer pf) {this.pf = pf;}
public Integer getDf() {return df;}
public void setDf(Integer df) {this.df = df;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
}
JavaCopy
年级javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//年级
public class Nj extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//年级
private String njName;
public String getNjName() {return njName;}
public void setNjName(String njName) {this.njName = njName;}
}
JavaCopy
学生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 zyId;
//班级
private Integer bjId;
//年级
private Integer njId;
//姓名
private String studentName;
//籍贯
private String headPic;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
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 getZyId() {return zyId;}
public void setZyId(Integer zyId) {this.zyId = zyId;}
public Integer getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
public Integer getNjId() {return njId;}
public void setNjId(Integer njId) {this.njId = njId;}
public String getStudentName() {return studentName;}
public void setStudentName(String studentName) {this.studentName = studentName;}
public String getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
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;}
}
JavaCopy
老师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 headPic;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
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 getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
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;}
}
JavaCopy
选课时间javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//选课时间
public class Xksj extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//选课时间
private Date showDate;
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}
JavaCopy
专业javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//专业
public class Zy extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//专业
private String zyName;
public String getZyName() {return zyName;}
public void setZyName(String zyName) {this.zyName = zyName;}
}
JavaCopy