- 基于MVC的学科竞赛采集系统mysql数据库创建语句
- 基于MVC的学科竞赛采集系统oracle数据库创建语句
- 基于MVC的学科竞赛采集系统sqlserver数据库创建语句
- 基于MVC的学科竞赛采集系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 基于MVC的学科竞赛采集系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
基于MVC的学科竞赛采集系统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_bd(
id int primary key auto_increment comment '主键',
studentId int comment '学生',
teacherId int comment '老师'
) comment '学生绑定';
公告表创建语句如下：
create table t_gg(
id int primary key auto_increment comment '主键',
v1 varchar(100) comment '标题',
pic varchar(100) comment '图片',
showDate datetime comment '日期',
v3 varchar(100) comment '内容'
) comment '公告';
竞赛表创建语句如下：
create table t_jingsai(
id int primary key auto_increment comment '主键',
title varchar(100) comment '竞赛名称',
content varchar(100) comment '竞赛详细说明',
endDate datetime comment '截止日期',
status varchar(100) comment '状态'
) comment '竞赛';
参赛列表表创建语句如下：
create table t_jingsailist(
id int primary key auto_increment comment '主键',
jingsaiId int comment '竞赛',
studentId int comment '学生',
pic varchar(100) comment '图片',
fileUrl varchar(100) comment '附件',
insertDate datetime comment '发起日期',
back varchar(100) comment '评语',
zj varchar(100) comment '状态',
status varchar(100) comment ''
) comment '参赛列表';
留言表创建语句如下：
create table t_liuyan(
id int primary key auto_increment comment '主键',
studentId int comment '学生',
content varchar(100) comment '留言内容',
back varchar(100) comment '回复',
insertDate datetime comment '日期',
status varchar(100) comment '状态'
) comment '留言';
评委表创建语句如下：
create table t_pw(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
pwName varchar(100) comment '姓名',
phone varchar(100) comment '电话',
sex 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 '姓名',
pic varchar(100) comment '头像',
phone varchar(100) comment '电话',
xh varchar(100) comment '学号',
sex 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 '姓名',
pic varchar(100) comment '头像',
phone varchar(100) comment '电话',
gh varchar(100) comment '工号',
sex varchar(100) comment '性别'
) comment '老师';
基于MVC的学科竞赛采集系统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_bd(
id integer,
studentId int,
teacherId int
);
--学生绑定字段加注释
comment on column t_bd.id is '主键';
comment on column t_bd.studentId is '学生';
comment on column t_bd.teacherId is '老师';
--学生绑定表加注释
comment on table t_bd is '学生绑定';
公告表创建语句如下：
create table t_gg(
id integer,
v1 varchar(100),
pic varchar(100),
showDate datetime,
v3 varchar(100)
);
--公告字段加注释
comment on column t_gg.id is '主键';
comment on column t_gg.v1 is '标题';
comment on column t_gg.pic is '图片';
comment on column t_gg.showDate is '日期';
comment on column t_gg.v3 is '内容';
--公告表加注释
comment on table t_gg is '公告';
竞赛表创建语句如下：
create table t_jingsai(
id integer,
title varchar(100),
content varchar(100),
endDate datetime,
status varchar(100)
);
--竞赛字段加注释
comment on column t_jingsai.id is '主键';
comment on column t_jingsai.title is '竞赛名称';
comment on column t_jingsai.content is '竞赛详细说明';
comment on column t_jingsai.endDate is '截止日期';
comment on column t_jingsai.status is '状态';
--竞赛表加注释
comment on table t_jingsai is '竞赛';
参赛列表表创建语句如下：
create table t_jingsailist(
id integer,
jingsaiId int,
studentId int,
pic varchar(100),
fileUrl varchar(100),
insertDate datetime,
back varchar(100),
zj varchar(100),
status varchar(100)
);
--参赛列表字段加注释
comment on column t_jingsailist.id is '主键';
comment on column t_jingsailist.jingsaiId is '竞赛';
comment on column t_jingsailist.studentId is '学生';
comment on column t_jingsailist.pic is '图片';
comment on column t_jingsailist.fileUrl is '附件';
comment on column t_jingsailist.insertDate is '发起日期';
comment on column t_jingsailist.back is '评语';
comment on column t_jingsailist.zj is '状态';
comment on column t_jingsailist.status is '';
--参赛列表表加注释
comment on table t_jingsailist is '参赛列表';
留言表创建语句如下：
create table t_liuyan(
id integer,
studentId int,
content varchar(100),
back varchar(100),
insertDate datetime,
status varchar(100)
);
--留言字段加注释
comment on column t_liuyan.id is '主键';
comment on column t_liuyan.studentId is '学生';
comment on column t_liuyan.content is '留言内容';
comment on column t_liuyan.back is '回复';
comment on column t_liuyan.insertDate is '日期';
comment on column t_liuyan.status is '状态';
--留言表加注释
comment on table t_liuyan is '留言';
评委表创建语句如下：
create table t_pw(
id integer,
username varchar(100),
password varchar(100),
pwName varchar(100),
phone varchar(100),
sex varchar(100)
);
--评委字段加注释
comment on column t_pw.id is '主键';
comment on column t_pw.username is '账号';
comment on column t_pw.password is '密码';
comment on column t_pw.pwName is '姓名';
comment on column t_pw.phone is '电话';
comment on column t_pw.sex is '性别';
--评委表加注释
comment on table t_pw is '评委';
学生表创建语句如下：
create table t_student(
id integer,
username varchar(100),
password varchar(100),
studentName varchar(100),
pic varchar(100),
phone varchar(100),
xh 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.studentName is '姓名';
comment on column t_student.pic is '头像';
comment on column t_student.phone is '电话';
comment on column t_student.xh is '学号';
comment on column t_student.sex is '性别';
--学生表加注释
comment on table t_student is '学生';
老师表创建语句如下：
create table t_teacher(
id integer,
username varchar(100),
password varchar(100),
teacherName varchar(100),
pic varchar(100),
phone varchar(100),
gh 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.pic is '头像';
comment on column t_teacher.phone is '电话';
comment on column t_teacher.gh is '工号';
comment on column t_teacher.sex is '性别';
--老师表加注释
comment on table t_teacher is '老师';
oracle特有，对应序列如下：
create sequence s_t_bd;
create sequence s_t_gg;
create sequence s_t_jingsai;
create sequence s_t_jingsailist;
create sequence s_t_liuyan;
create sequence s_t_pw;
create sequence s_t_student;
create sequence s_t_teacher;
基于MVC的学科竞赛采集系统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_bd(
id int identity(1,1) primary key not null,--主键
studentId int,--学生
teacherId int--老师
);
公告表创建语句如下：
--公告表注释
create table t_gg(
id int identity(1,1) primary key not null,--主键
v1 varchar(100),--标题
pic varchar(100),--图片
showDate datetime,--日期
v3 varchar(100)--内容
);
竞赛表创建语句如下：
--竞赛表注释
create table t_jingsai(
id int identity(1,1) primary key not null,--主键
title varchar(100),--竞赛名称
content varchar(100),--竞赛详细说明
endDate datetime,--截止日期
status varchar(100)--状态
);
参赛列表表创建语句如下：
--参赛列表表注释
create table t_jingsailist(
id int identity(1,1) primary key not null,--主键
jingsaiId int,--竞赛
studentId int,--学生
pic varchar(100),--图片
fileUrl varchar(100),--附件
insertDate datetime,--发起日期
back varchar(100),--评语
zj varchar(100),--状态
status varchar(100)--
);
留言表创建语句如下：
--留言表注释
create table t_liuyan(
id int identity(1,1) primary key not null,--主键
studentId int,--学生
content varchar(100),--留言内容
back varchar(100),--回复
insertDate datetime,--日期
status varchar(100)--状态
);
评委表创建语句如下：
--评委表注释
create table t_pw(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
pwName varchar(100),--姓名
phone varchar(100),--电话
sex varchar(100)--性别
);
学生表创建语句如下：
--学生表注释
create table t_student(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
studentName varchar(100),--姓名
pic varchar(100),--头像
phone varchar(100),--电话
xh varchar(100),--学号
sex varchar(100)--性别
);
老师表创建语句如下：
--老师表注释
create table t_teacher(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
teacherName varchar(100),--姓名
pic varchar(100),--头像
phone varchar(100),--电话
gh varchar(100),--工号
sex varchar(100)--性别
);
登录后主页.jpg?x-oss-process=style/00001)
基于MVC的学科竞赛采集系统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_bd")
public class Bd {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//老师
private Integer teacherId;
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;}
}公告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 v1;
//图片
private String pic;
//日期
private Date showDate;
//内容
private String v3;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
}竞赛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_jingsai")
public class Jingsai {
//主键
@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 endDate;
//状态
private String status;
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 getEndDate() {return endDate;}
public void setEndDate(Date endDate) {this.endDate = endDate;}
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_jingsailist")
public class Jingsailist {
//主键
@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 jingsaiId;
//学生
private Integer studentId;
//图片
private String pic;
//附件
private String fileUrl;
//发起日期
private Date insertDate;
//评语
private String back;
//状态
private String zj;
//
private String status;
public Integer getJingsaiId() {return jingsaiId;}
public void setJingsaiId(Integer jingsaiId) {this.jingsaiId = jingsaiId;}
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
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 getZj() {return zj;}
public void setZj(String zj) {this.zj = zj;}
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_liuyan")
public class Liuyan {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//留言内容
private String content;
//回复
private String back;
//日期
private Date insertDate;
//状态
private String status;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
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_pw")
public class Pw {
//主键
@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 pwName;
//电话
private String phone;
//性别
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 getPwName() {return pwName;}
public void setPwName(String pwName) {this.pwName = pwName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
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_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 pic;
//电话
private String phone;
//学号
private String xh;
//性别
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 getStudentName() {return studentName;}
public void setStudentName(String studentName) {this.studentName = studentName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
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;}
}老师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 pic;
//电话
private String phone;
//工号
private String gh;
//性别
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 getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
}基于MVC的学科竞赛采集系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
学生绑定javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//学生绑定
public class Bd extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//老师
private Integer teacherId;
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;}
}公告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 v1;
//图片
private String pic;
//日期
private Date showDate;
//内容
private String v3;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
}竞赛javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//竞赛
public class Jingsai 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 Date endDate;
//状态
private String status;
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 getEndDate() {return endDate;}
public void setEndDate(Date endDate) {this.endDate = endDate;}
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 Jingsailist extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//竞赛
private Integer jingsaiId;
//学生
private Integer studentId;
//图片
private String pic;
//附件
private String fileUrl;
//发起日期
private Date insertDate;
//评语
private String back;
//状态
private String zj;
//
private String status;
public Integer getJingsaiId() {return jingsaiId;}
public void setJingsaiId(Integer jingsaiId) {this.jingsaiId = jingsaiId;}
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
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 getZj() {return zj;}
public void setZj(String zj) {this.zj = zj;}
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 Liuyan extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//留言内容
private String content;
//回复
private String back;
//日期
private Date insertDate;
//状态
private String status;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
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 Pw 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 pwName;
//电话
private String phone;
//性别
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 getPwName() {return pwName;}
public void setPwName(String pwName) {this.pwName = pwName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
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 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 pic;
//电话
private String phone;
//学号
private String xh;
//性别
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 getStudentName() {return studentName;}
public void setStudentName(String studentName) {this.studentName = studentName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
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;}
}老师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 pic;
//电话
private String phone;
//工号
private String gh;
//性别
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 getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
}