- 选课系统mysql数据库创建语句
- 选课系统oracle数据库创建语句
- 选课系统sqlserver数据库创建语句
- 选课系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 选课系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
选课系统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 '班级',
bzr varchar(100) comment '班主任'
) comment '班级';
公告表创建语句如下：
create table t_gg(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
content text comment '内容',
showDate datetime comment '公告日期'
) comment '公告';
课程表创建语句如下：
create table t_kc(
id int primary key auto_increment comment '主键',
kcName varchar(100) comment '课程',
beginDate datetime comment '报名开始日期',
endDate datetime comment '报名结束',
status varchar(100) comment '',
teacherId int comment '老师',
skdd varchar(100) comment '上课地点',
sksj text comment '上课时间',
skyq text comment '上课要求',
rsxz int comment '人数限制'
) comment '课程';
选课表创建语句如下：
create table t_kclist(
id int primary key auto_increment comment '主键',
kcId int comment '课程',
studentId int comment '学生',
cj int comment '成绩',
pj text comment '评价',
xf int comment '学分'
) comment '选课';
留言表创建语句如下：
create table t_ly(
id int primary key auto_increment comment '主键',
studentId int comment '学生',
content text comment '内容',
insertDate datetime comment '留言日期',
back text comment '回复',
status varchar(100) comment '状态'
) comment '留言';
评价表创建语句如下：
create table t_pj(
id int primary key auto_increment comment '主键',
teacherId int comment '老师',
content text comment '评价',
studentId int comment '学生',
insertDate datetime 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 '姓名',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '',
zyId int comment '专业',
bjId int comment '班级',
xh 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 ''
) comment '老师';
专业表创建语句如下：
create table t_zy(
id int primary key auto_increment comment '主键',
zyName 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),
bzr varchar(100)
);
--班级字段加注释
comment on column t_bj.id is '主键';
comment on column t_bj.bjName is '班级';
comment on column t_bj.bzr is '班主任';
--班级表加注释
comment on table t_bj is '班级';
公告表创建语句如下：
create table t_gg(
id integer,
title varchar(100),
content text,
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.showDate is '公告日期';
--公告表加注释
comment on table t_gg is '公告';
课程表创建语句如下：
create table t_kc(
id integer,
kcName varchar(100),
beginDate datetime,
endDate datetime,
status varchar(100),
teacherId int,
skdd varchar(100),
sksj text,
skyq text,
rsxz int
);
--课程字段加注释
comment on column t_kc.id is '主键';
comment on column t_kc.kcName is '课程';
comment on column t_kc.beginDate is '报名开始日期';
comment on column t_kc.endDate is '报名结束';
comment on column t_kc.status is '';
comment on column t_kc.teacherId is '老师';
comment on column t_kc.skdd is '上课地点';
comment on column t_kc.sksj is '上课时间';
comment on column t_kc.skyq is '上课要求';
comment on column t_kc.rsxz is '人数限制';
--课程表加注释
comment on table t_kc is '课程';
选课表创建语句如下：
create table t_kclist(
id integer,
kcId int,
studentId int,
cj int,
pj text,
xf int
);
--选课字段加注释
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.cj is '成绩';
comment on column t_kclist.pj is '评价';
comment on column t_kclist.xf is '学分';
--选课表加注释
comment on table t_kclist is '选课';
留言表创建语句如下：
create table t_ly(
id integer,
studentId int,
content text,
insertDate datetime,
back text,
status varchar(100)
);
--留言字段加注释
comment on column t_ly.id is '主键';
comment on column t_ly.studentId is '学生';
comment on column t_ly.content is '内容';
comment on column t_ly.insertDate is '留言日期';
comment on column t_ly.back is '回复';
comment on column t_ly.status is '状态';
--留言表加注释
comment on table t_ly is '留言';
评价表创建语句如下：
create table t_pj(
id integer,
teacherId int,
content text,
studentId int,
insertDate datetime
);
--评价字段加注释
comment on column t_pj.id is '主键';
comment on column t_pj.teacherId is '老师';
comment on column t_pj.content is '评价';
comment on column t_pj.studentId is '学生';
comment on column t_pj.insertDate is '评价日期';
--评价表加注释
comment on table t_pj is '评价';
学生表创建语句如下：
create table t_student(
id integer,
username varchar(100),
password varchar(100),
studentName varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100),
zyId int,
bjId int,
xh 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.phone is '电话';
comment on column t_student.age is '年龄';
comment on column t_student.sex is '';
comment on column t_student.zyId is '专业';
comment on column t_student.bjId is '班级';
comment on column t_student.xh 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)
);
--老师字段加注释
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 table t_teacher is '老师';
专业表创建语句如下：
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 '专业';
oracle特有，对应序列如下：
create sequence s_t_bj;
create sequence s_t_gg;
create sequence s_t_kc;
create sequence s_t_kclist;
create sequence s_t_ly;
create sequence s_t_pj;
create sequence s_t_student;
create sequence s_t_teacher;
create sequence s_t_zy;
选课系统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),--班级
bzr varchar(100)--班主任
);
公告表创建语句如下：
--公告表注释
create table t_gg(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
content text,--内容
showDate datetime--公告日期
);
课程表创建语句如下：
--课程表注释
create table t_kc(
id int identity(1,1) primary key not null,--主键
kcName varchar(100),--课程
beginDate datetime,--报名开始日期
endDate datetime,--报名结束
status varchar(100),--
teacherId int,--老师
skdd varchar(100),--上课地点
sksj text,--上课时间
skyq text,--上课要求
rsxz int--人数限制
);
选课表创建语句如下：
--选课表注释
create table t_kclist(
id int identity(1,1) primary key not null,--主键
kcId int,--课程
studentId int,--学生
cj int,--成绩
pj text,--评价
xf int--学分
);
留言表创建语句如下：
--留言表注释
create table t_ly(
id int identity(1,1) primary key not null,--主键
studentId int,--学生
content text,--内容
insertDate datetime,--留言日期
back text,--回复
status varchar(100)--状态
);
评价表创建语句如下：
--评价表注释
create table t_pj(
id int identity(1,1) primary key not null,--主键
teacherId int,--老师
content text,--评价
studentId int,--学生
insertDate datetime--评价日期
);
学生表创建语句如下：
--学生表注释
create table t_student(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
studentName varchar(100),--姓名
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100),--
zyId int,--专业
bjId int,--班级
xh 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)--
);
专业表创建语句如下：
--专业表注释
create table t_zy(
id int identity(1,1) primary key not null,--主键
zyName varchar(100)--专业
);
登录后主页.jpg?x-oss-process=style/00001)
选课系统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;
//班主任
private String bzr;
public String getBjName() {return bjName;}
public void setBjName(String bjName) {this.bjName = bjName;}
public String getBzr() {return bzr;}
public void setBzr(String bzr) {this.bzr = bzr;}
}公告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 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 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_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 Date beginDate;
//报名结束
private Date endDate;
//
private String status;
//老师
private Long teacherId;
//上课地点
private String skdd;
//上课时间
private String sksj;
//上课要求
private String skyq;
//人数限制
private Integer rsxz;
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
public Date getBeginDate() {return beginDate;}
public void setBeginDate(Date beginDate) {this.beginDate = beginDate;}
public Date getEndDate() {return endDate;}
public void setEndDate(Date endDate) {this.endDate = endDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Long getTeacherId() {return teacherId;}
public void setTeacherId(Long teacherId) {this.teacherId = teacherId;}
public String getSkdd() {return skdd;}
public void setSkdd(String skdd) {this.skdd = skdd;}
public String getSksj() {return sksj;}
public void setSksj(String sksj) {this.sksj = sksj;}
public String getSkyq() {return skyq;}
public void setSkyq(String skyq) {this.skyq = skyq;}
public Integer getRsxz() {return rsxz;}
public void setRsxz(Integer rsxz) {this.rsxz = rsxz;}
}选课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 Long kcId;
//学生
private Long studentId;
//成绩
private Integer cj;
//评价
private String pj;
//学分
private Integer xf;
public Long getKcId() {return kcId;}
public void setKcId(Long kcId) {this.kcId = kcId;}
public Long getStudentId() {return studentId;}
public void setStudentId(Long studentId) {this.studentId = studentId;}
public Integer getCj() {return cj;}
public void setCj(Integer cj) {this.cj = cj;}
public String getPj() {return pj;}
public void setPj(String pj) {this.pj = pj;}
public Integer getXf() {return xf;}
public void setXf(Integer xf) {this.xf = xf;}
}留言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_ly")
public class Ly {
//主键
@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 Long studentId;
//内容
private String content;
//留言日期
private Date insertDate;
//回复
private String back;
//状态
private String status;
public Long getStudentId() {return studentId;}
public void setStudentId(Long studentId) {this.studentId = studentId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
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_pj")
public class Pj {
//主键
@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 Long teacherId;
//评价
private String content;
//学生
private Long studentId;
//评价日期
private Date insertDate;
public Long getTeacherId() {return teacherId;}
public void setTeacherId(Long teacherId) {this.teacherId = teacherId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Long getStudentId() {return studentId;}
public void setStudentId(Long studentId) {this.studentId = studentId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}学生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 phone;
//年龄
private String age;
//
private String sex;
//专业
private Long zyId;
//班级
private Long bjId;
//学号
private String xh;
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 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 Long getZyId() {return zyId;}
public void setZyId(Long zyId) {this.zyId = zyId;}
public Long getBjId() {return bjId;}
public void setBjId(Long bjId) {this.bjId = bjId;}
public String getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
}老师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;
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;}
}专业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;}
}选课系统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;
//班主任
private String bzr;
public String getBjName() {return bjName;}
public void setBjName(String bjName) {this.bjName = bjName;}
public String getBzr() {return bzr;}
public void setBzr(String bzr) {this.bzr = bzr;}
}公告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;
//公告日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
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 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 Kc extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//课程
private String kcName;
//报名开始日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date beginDate;
//报名结束
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date endDate;
//
private String status;
//老师
private Long teacherId;
//上课地点
private String skdd;
//上课时间
private String sksj;
//上课要求
private String skyq;
//人数限制
private Integer rsxz;
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
public Date getBeginDate() {return beginDate;}
public void setBeginDate(Date beginDate) {this.beginDate = beginDate;}
public Date getEndDate() {return endDate;}
public void setEndDate(Date endDate) {this.endDate = endDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Long getTeacherId() {return teacherId;}
public void setTeacherId(Long teacherId) {this.teacherId = teacherId;}
public String getSkdd() {return skdd;}
public void setSkdd(String skdd) {this.skdd = skdd;}
public String getSksj() {return sksj;}
public void setSksj(String sksj) {this.sksj = sksj;}
public String getSkyq() {return skyq;}
public void setSkyq(String skyq) {this.skyq = skyq;}
public Integer getRsxz() {return rsxz;}
public void setRsxz(Integer rsxz) {this.rsxz = rsxz;}
}选课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 Long kcId;
//学生
private Long studentId;
//成绩
private Integer cj;
//评价
private String pj;
//学分
private Integer xf;
public Long getKcId() {return kcId;}
public void setKcId(Long kcId) {this.kcId = kcId;}
public Long getStudentId() {return studentId;}
public void setStudentId(Long studentId) {this.studentId = studentId;}
public Integer getCj() {return cj;}
public void setCj(Integer cj) {this.cj = cj;}
public String getPj() {return pj;}
public void setPj(String pj) {this.pj = pj;}
public Integer getXf() {return xf;}
public void setXf(Integer xf) {this.xf = xf;}
}留言javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//留言
public class Ly extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Long studentId;
//内容
private String content;
//留言日期
private Date insertDate;
//回复
private String back;
//状态
private String status;
public Long getStudentId() {return studentId;}
public void setStudentId(Long studentId) {this.studentId = studentId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
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 Pj extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//老师
private Long teacherId;
//评价
private String content;
//学生
private Long studentId;
//评价日期
private Date insertDate;
public Long getTeacherId() {return teacherId;}
public void setTeacherId(Long teacherId) {this.teacherId = teacherId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Long getStudentId() {return studentId;}
public void setStudentId(Long studentId) {this.studentId = studentId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}学生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 phone;
//年龄
private String age;
//
private String sex;
//专业
private Long zyId;
//班级
private Long bjId;
//学号
private String xh;
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 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 Long getZyId() {return zyId;}
public void setZyId(Long zyId) {this.zyId = zyId;}
public Long getBjId() {return bjId;}
public void setBjId(Long bjId) {this.bjId = bjId;}
public String getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
}老师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;
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;}
}专业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;}
}