基于数字化校园的大学生学科竞赛管理系统的设计与实现

基于数字化校园的大学生学科竞赛管理系统的设计与实现登录注册界面

基于数字化校园的大学生学科竞赛管理系统的设计与实现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_gg(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '标题',
	content varchar(100) comment '内容',
	showDate varchar(100) comment '显示日期'
) comment '公告';

交流表创建语句如下:


create table t_jl(
	id int primary key auto_increment comment '主键',
	jsId int comment '赛事',
	content varchar(100) comment '内容',
	insertDate datetime comment '日期',
	jlName varchar(100) comment '姓名'
) comment '交流';

竞赛表创建语句如下:


create table t_js(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '标题',
	pic varchar(100) comment '图片',
	jsfile varchar(100) comment '文件',
	content varchar(100) comment '内容',
	jsdate varchar(100) comment '发起日期',
	zdtcId int comment '指导老师',
	status varchar(100) comment '状态',
	xmzj varchar(100) comment ''
) comment '竞赛';

竞赛报名表创建语句如下:


create table t_jslist(
	id int primary key auto_increment comment '主键',
	jsId int comment '赛事',
	studentId int comment '学生',
	insertDate datetime comment '报名日期',
	status varchar(100) comment '状态',
	zp varchar(100) comment '作品',
	jg varchar(100) comment '结果'
) comment '竞赛报名';

教务处管理员表创建语句如下:


create table t_jwctc(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	jwctcName varchar(100) comment '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话',
	qx varchar(100) comment '权限'
) comment '教务处管理员';

申报表创建语句如下:


create table t_sb(
	id int primary key auto_increment comment '主键',
	sbtype varchar(100) comment '申报类型',
	title varchar(100) comment '标题',
	pic varchar(100) comment '图片',
	sbfile varchar(100) comment '文件',
	content varchar(100) comment '内容',
	insertDate datetime comment '发起日期',
	zdtcId int comment '指导老师',
	status varchar(100) comment '状态',
	py varchar(100) comment '说明',
	v1 varchar(100) comment '',
	v2 varchar(100) comment '',
	v3 varchar(100) comment '',
	v4 varchar(100) comment '',
	v5 varchar(100) comment '',
	v6 varchar(100) comment '',
	v7 varchar(100) comment '',
	v8 varchar(100) comment '',
	v9 varchar(100) comment '',
	xyName varchar(100) comment '',
	jwcName 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 '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	bj varchar(100) comment '班级',
	phone varchar(100) comment '电话',
	qx varchar(100) comment '权限'
) comment '学生';

新闻表创建语句如下:


create table t_xw(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '标题',
	pic varchar(100) comment '图片',
	content varchar(100) comment '内容',
	showDate varchar(100) comment '显示日期'
) comment '新闻';

学院管理员表创建语句如下:


create table t_xytc(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	xytcName varchar(100) comment '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话',
	qx varchar(100) comment '权限'
) comment '学院管理员';

指导老师表创建语句如下:


create table t_zdtc(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	zdtcName varchar(100) comment '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话',
	qx 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_gg(
	id integer,
	title varchar(100),
	content varchar(100),
	showDate varchar(100)
);
--公告字段加注释
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_jl(
	id integer,
	jsId int,
	content varchar(100),
	insertDate datetime,
	jlName varchar(100)
);
--交流字段加注释
comment on column t_jl.id is '主键';
comment on column t_jl.jsId is '赛事';
comment on column t_jl.content is '内容';
comment on column t_jl.insertDate is '日期';
comment on column t_jl.jlName is '姓名';
--交流表加注释
comment on table t_jl is '交流';

竞赛表创建语句如下:


create table t_js(
	id integer,
	title varchar(100),
	pic varchar(100),
	jsfile varchar(100),
	content varchar(100),
	jsdate varchar(100),
	zdtcId int,
	status varchar(100),
	xmzj varchar(100)
);
--竞赛字段加注释
comment on column t_js.id is '主键';
comment on column t_js.title is '标题';
comment on column t_js.pic is '图片';
comment on column t_js.jsfile is '文件';
comment on column t_js.content is '内容';
comment on column t_js.jsdate is '发起日期';
comment on column t_js.zdtcId is '指导老师';
comment on column t_js.status is '状态';
comment on column t_js.xmzj is '';
--竞赛表加注释
comment on table t_js is '竞赛';

竞赛报名表创建语句如下:


create table t_jslist(
	id integer,
	jsId int,
	studentId int,
	insertDate datetime,
	status varchar(100),
	zp varchar(100),
	jg varchar(100)
);
--竞赛报名字段加注释
comment on column t_jslist.id is '主键';
comment on column t_jslist.jsId is '赛事';
comment on column t_jslist.studentId is '学生';
comment on column t_jslist.insertDate is '报名日期';
comment on column t_jslist.status is '状态';
comment on column t_jslist.zp is '作品';
comment on column t_jslist.jg is '结果';
--竞赛报名表加注释
comment on table t_jslist is '竞赛报名';

教务处管理员表创建语句如下:


create table t_jwctc(
	id integer,
	username varchar(100),
	password varchar(100),
	jwctcName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100),
	qx varchar(100)
);
--教务处管理员字段加注释
comment on column t_jwctc.id is '主键';
comment on column t_jwctc.username is '账号';
comment on column t_jwctc.password is '密码';
comment on column t_jwctc.jwctcName is '姓名';
comment on column t_jwctc.age is '年龄';
comment on column t_jwctc.sex is '性别';
comment on column t_jwctc.phone is '电话';
comment on column t_jwctc.qx is '权限';
--教务处管理员表加注释
comment on table t_jwctc is '教务处管理员';

申报表创建语句如下:


create table t_sb(
	id integer,
	sbtype varchar(100),
	title varchar(100),
	pic varchar(100),
	sbfile varchar(100),
	content varchar(100),
	insertDate datetime,
	zdtcId int,
	status varchar(100),
	py varchar(100),
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	v4 varchar(100),
	v5 varchar(100),
	v6 varchar(100),
	v7 varchar(100),
	v8 varchar(100),
	v9 varchar(100),
	xyName varchar(100),
	jwcName varchar(100)
);
--申报字段加注释
comment on column t_sb.id is '主键';
comment on column t_sb.sbtype is '申报类型';
comment on column t_sb.title is '标题';
comment on column t_sb.pic is '图片';
comment on column t_sb.sbfile is '文件';
comment on column t_sb.content is '内容';
comment on column t_sb.insertDate is '发起日期';
comment on column t_sb.zdtcId is '指导老师';
comment on column t_sb.status is '状态';
comment on column t_sb.py is '说明';
comment on column t_sb.v1 is '';
comment on column t_sb.v2 is '';
comment on column t_sb.v3 is '';
comment on column t_sb.v4 is '';
comment on column t_sb.v5 is '';
comment on column t_sb.v6 is '';
comment on column t_sb.v7 is '';
comment on column t_sb.v8 is '';
comment on column t_sb.v9 is '';
comment on column t_sb.xyName is '';
comment on column t_sb.jwcName is '';
--申报表加注释
comment on table t_sb is '申报';

学生表创建语句如下:


create table t_student(
	id integer,
	username varchar(100),
	password varchar(100),
	studentName varchar(100),
	age varchar(100),
	sex varchar(100),
	bj varchar(100),
	phone varchar(100),
	qx 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.age is '年龄';
comment on column t_student.sex is '性别';
comment on column t_student.bj is '班级';
comment on column t_student.phone is '电话';
comment on column t_student.qx is '权限';
--学生表加注释
comment on table t_student is '学生';

新闻表创建语句如下:


create table t_xw(
	id integer,
	title varchar(100),
	pic varchar(100),
	content varchar(100),
	showDate varchar(100)
);
--新闻字段加注释
comment on column t_xw.id is '主键';
comment on column t_xw.title is '标题';
comment on column t_xw.pic is '图片';
comment on column t_xw.content is '内容';
comment on column t_xw.showDate is '显示日期';
--新闻表加注释
comment on table t_xw is '新闻';

学院管理员表创建语句如下:


create table t_xytc(
	id integer,
	username varchar(100),
	password varchar(100),
	xytcName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100),
	qx varchar(100)
);
--学院管理员字段加注释
comment on column t_xytc.id is '主键';
comment on column t_xytc.username is '账号';
comment on column t_xytc.password is '密码';
comment on column t_xytc.xytcName is '姓名';
comment on column t_xytc.age is '年龄';
comment on column t_xytc.sex is '性别';
comment on column t_xytc.phone is '电话';
comment on column t_xytc.qx is '权限';
--学院管理员表加注释
comment on table t_xytc is '学院管理员';

指导老师表创建语句如下:


create table t_zdtc(
	id integer,
	username varchar(100),
	password varchar(100),
	zdtcName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100),
	qx varchar(100)
);
--指导老师字段加注释
comment on column t_zdtc.id is '主键';
comment on column t_zdtc.username is '账号';
comment on column t_zdtc.password is '密码';
comment on column t_zdtc.zdtcName is '姓名';
comment on column t_zdtc.age is '年龄';
comment on column t_zdtc.sex is '性别';
comment on column t_zdtc.phone is '电话';
comment on column t_zdtc.qx is '权限';
--指导老师表加注释
comment on table t_zdtc is '指导老师';

oracle特有,对应序列如下:


create sequence s_t_gg;
create sequence s_t_jl;
create sequence s_t_js;
create sequence s_t_jslist;
create sequence s_t_jwctc;
create sequence s_t_sb;
create sequence s_t_student;
create sequence s_t_xw;
create sequence s_t_xytc;
create sequence s_t_zdtc;

基于数字化校园的大学生学科竞赛管理系统的设计与实现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_gg(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--标题
	content varchar(100),--内容
	showDate varchar(100)--显示日期
);

交流表创建语句如下:


--交流表注释
create table t_jl(
	id int identity(1,1) primary key not null,--主键
	jsId int,--赛事
	content varchar(100),--内容
	insertDate datetime,--日期
	jlName varchar(100)--姓名
);

竞赛表创建语句如下:


--竞赛表注释
create table t_js(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--标题
	pic varchar(100),--图片
	jsfile varchar(100),--文件
	content varchar(100),--内容
	jsdate varchar(100),--发起日期
	zdtcId int,--指导老师
	status varchar(100),--状态
	xmzj varchar(100)--
);

竞赛报名表创建语句如下:


--竞赛报名表注释
create table t_jslist(
	id int identity(1,1) primary key not null,--主键
	jsId int,--赛事
	studentId int,--学生
	insertDate datetime,--报名日期
	status varchar(100),--状态
	zp varchar(100),--作品
	jg varchar(100)--结果
);

教务处管理员表创建语句如下:


--教务处管理员表注释
create table t_jwctc(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	jwctcName varchar(100),--姓名
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100),--电话
	qx varchar(100)--权限
);

申报表创建语句如下:


--申报表注释
create table t_sb(
	id int identity(1,1) primary key not null,--主键
	sbtype varchar(100),--申报类型
	title varchar(100),--标题
	pic varchar(100),--图片
	sbfile varchar(100),--文件
	content varchar(100),--内容
	insertDate datetime,--发起日期
	zdtcId int,--指导老师
	status varchar(100),--状态
	py varchar(100),--说明
	v1 varchar(100),--
	v2 varchar(100),--
	v3 varchar(100),--
	v4 varchar(100),--
	v5 varchar(100),--
	v6 varchar(100),--
	v7 varchar(100),--
	v8 varchar(100),--
	v9 varchar(100),--
	xyName varchar(100),--
	jwcName varchar(100)--
);

学生表创建语句如下:


--学生表注释
create table t_student(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--学号
	password varchar(100),--密码
	studentName varchar(100),--姓名
	age varchar(100),--年龄
	sex varchar(100),--性别
	bj varchar(100),--班级
	phone varchar(100),--电话
	qx varchar(100)--权限
);

新闻表创建语句如下:


--新闻表注释
create table t_xw(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--标题
	pic varchar(100),--图片
	content varchar(100),--内容
	showDate varchar(100)--显示日期
);

学院管理员表创建语句如下:


--学院管理员表注释
create table t_xytc(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	xytcName varchar(100),--姓名
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100),--电话
	qx varchar(100)--权限
);

指导老师表创建语句如下:


--指导老师表注释
create table t_zdtc(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	zdtcName varchar(100),--姓名
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100),--电话
	qx 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_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 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_jl")
public class Jl {
//主键
@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 jsId;
//内容
private String content;
//日期
private Date insertDate;
//姓名
private String jlName;
public Integer getJsId() {return jsId;}
public void setJsId(Integer jsId) {this.jsId = jsId;}
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 getJlName() {return jlName;}
public void setJlName(String jlName) {this.jlName = jlName;}
}

竞赛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_js")
public class Js {
//主键
@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 pic;
//文件
private String jsfile;
//内容
private String content;
//发起日期
private String jsdate;
//指导老师
private Integer zdtcId;
//状态
private String status;
//
private String xmzj;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getJsfile() {return jsfile;}
public void setJsfile(String jsfile) {this.jsfile = jsfile;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getJsdate() {return jsdate;}
public void setJsdate(String jsdate) {this.jsdate = jsdate;}
public Integer getZdtcId() {return zdtcId;}
public void setZdtcId(Integer zdtcId) {this.zdtcId = zdtcId;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getXmzj() {return xmzj;}
public void setXmzj(String xmzj) {this.xmzj = xmzj;}
}

竞赛报名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_jslist")
public class Jslist {
//主键
@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 jsId;
//学生
private Integer studentId;
//报名日期
private Date insertDate;
//状态
private String status;
//作品
private String zp;
//结果
private String jg;
public Integer getJsId() {return jsId;}
public void setJsId(Integer jsId) {this.jsId = jsId;}
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
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;}
public String getZp() {return zp;}
public void setZp(String zp) {this.zp = zp;}
public String getJg() {return jg;}
public void setJg(String jg) {this.jg = jg;}
}

教务处管理员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_jwctc")
public class Jwctc {
//主键
@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 jwctcName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//权限
private String qx;
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 getJwctcName() {return jwctcName;}
public void setJwctcName(String jwctcName) {this.jwctcName = jwctcName;}
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;}
public String getQx() {return qx;}
public void setQx(String qx) {this.qx = qx;}
}

申报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_sb")
public class Sb {
//主键
@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 sbtype;
//标题
private String title;
//图片
private String pic;
//文件
private String sbfile;
//内容
private String content;
//发起日期
private Date insertDate;
//指导老师
private Integer zdtcId;
//状态
private String status;
//说明
private String py;
//
private String v1;
//
private String v2;
//
private String v3;
//
private String v4;
//
private String v5;
//
private String v6;
//
private String v7;
//
private String v8;
//
private String v9;
//
private String xyName;
//
private String jwcName;
public String getSbtype() {return sbtype;}
public void setSbtype(String sbtype) {this.sbtype = sbtype;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getSbfile() {return sbfile;}
public void setSbfile(String sbfile) {this.sbfile = sbfile;}
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 Integer getZdtcId() {return zdtcId;}
public void setZdtcId(Integer zdtcId) {this.zdtcId = zdtcId;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getPy() {return py;}
public void setPy(String py) {this.py = py;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
public String getV8() {return v8;}
public void setV8(String v8) {this.v8 = v8;}
public String getV9() {return v9;}
public void setV9(String v9) {this.v9 = v9;}
public String getXyName() {return xyName;}
public void setXyName(String xyName) {this.xyName = xyName;}
public String getJwcName() {return jwcName;}
public void setJwcName(String jwcName) {this.jwcName = jwcName;}
}

学生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 age;
//性别
private String sex;
//班级
private String bj;
//电话
private String phone;
//权限
private String qx;
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 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 getBj() {return bj;}
public void setBj(String bj) {this.bj = bj;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getQx() {return qx;}
public void setQx(String qx) {this.qx = qx;}
}

新闻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_xw")
public class Xw {
//主键
@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 pic;
//内容
private String content;
//显示日期
private String showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
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_xytc")
public class Xytc {
//主键
@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 xytcName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//权限
private String qx;
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 getXytcName() {return xytcName;}
public void setXytcName(String xytcName) {this.xytcName = xytcName;}
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;}
public String getQx() {return qx;}
public void setQx(String qx) {this.qx = qx;}
}

指导老师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_zdtc")
public class Zdtc {
//主键
@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 zdtcName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//权限
private String qx;
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 getZdtcName() {return zdtcName;}
public void setZdtcName(String zdtcName) {this.zdtcName = zdtcName;}
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;}
public String getQx() {return qx;}
public void setQx(String qx) {this.qx = qx;}
}

基于数字化校园的大学生学科竞赛管理系统的设计与实现spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

公告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;
//显示日期
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 Jl  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//赛事
private Integer jsId;
//内容
private String content;
//日期
private Date insertDate;
//姓名
private String jlName;
public Integer getJsId() {return jsId;}
public void setJsId(Integer jsId) {this.jsId = jsId;}
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 getJlName() {return jlName;}
public void setJlName(String jlName) {this.jlName = jlName;}
}

竞赛javaBean创建语句如下:


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

//竞赛
public class Js  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//图片
private String pic;
//文件
private String jsfile;
//内容
private String content;
//发起日期
private String jsdate;
//指导老师
private Integer zdtcId;
//状态
private String status;
//
private String xmzj;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getJsfile() {return jsfile;}
public void setJsfile(String jsfile) {this.jsfile = jsfile;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getJsdate() {return jsdate;}
public void setJsdate(String jsdate) {this.jsdate = jsdate;}
public Integer getZdtcId() {return zdtcId;}
public void setZdtcId(Integer zdtcId) {this.zdtcId = zdtcId;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getXmzj() {return xmzj;}
public void setXmzj(String xmzj) {this.xmzj = xmzj;}
}

竞赛报名javaBean创建语句如下:


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

//竞赛报名
public class Jslist  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//赛事
private Integer jsId;
//学生
private Integer studentId;
//报名日期
private Date insertDate;
//状态
private String status;
//作品
private String zp;
//结果
private String jg;
public Integer getJsId() {return jsId;}
public void setJsId(Integer jsId) {this.jsId = jsId;}
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
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;}
public String getZp() {return zp;}
public void setZp(String zp) {this.zp = zp;}
public String getJg() {return jg;}
public void setJg(String jg) {this.jg = jg;}
}

教务处管理员javaBean创建语句如下:


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

//教务处管理员
public class Jwctc  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 jwctcName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//权限
private String qx;
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 getJwctcName() {return jwctcName;}
public void setJwctcName(String jwctcName) {this.jwctcName = jwctcName;}
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;}
public String getQx() {return qx;}
public void setQx(String qx) {this.qx = qx;}
}

申报javaBean创建语句如下:


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

//申报
public class Sb  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//申报类型
private String sbtype;
//标题
private String title;
//图片
private String pic;
//文件
private String sbfile;
//内容
private String content;
//发起日期
private Date insertDate;
//指导老师
private Integer zdtcId;
//状态
private String status;
//说明
private String py;
//
private String v1;
//
private String v2;
//
private String v3;
//
private String v4;
//
private String v5;
//
private String v6;
//
private String v7;
//
private String v8;
//
private String v9;
//
private String xyName;
//
private String jwcName;
public String getSbtype() {return sbtype;}
public void setSbtype(String sbtype) {this.sbtype = sbtype;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getSbfile() {return sbfile;}
public void setSbfile(String sbfile) {this.sbfile = sbfile;}
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 Integer getZdtcId() {return zdtcId;}
public void setZdtcId(Integer zdtcId) {this.zdtcId = zdtcId;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getPy() {return py;}
public void setPy(String py) {this.py = py;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
public String getV8() {return v8;}
public void setV8(String v8) {this.v8 = v8;}
public String getV9() {return v9;}
public void setV9(String v9) {this.v9 = v9;}
public String getXyName() {return xyName;}
public void setXyName(String xyName) {this.xyName = xyName;}
public String getJwcName() {return jwcName;}
public void setJwcName(String jwcName) {this.jwcName = jwcName;}
}

学生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 age;
//性别
private String sex;
//班级
private String bj;
//电话
private String phone;
//权限
private String qx;
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 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 getBj() {return bj;}
public void setBj(String bj) {this.bj = bj;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getQx() {return qx;}
public void setQx(String qx) {this.qx = qx;}
}

新闻javaBean创建语句如下:


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

//新闻
public class Xw  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//图片
private String pic;
//内容
private String content;
//显示日期
private String showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
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 Xytc  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 xytcName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//权限
private String qx;
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 getXytcName() {return xytcName;}
public void setXytcName(String xytcName) {this.xytcName = xytcName;}
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;}
public String getQx() {return qx;}
public void setQx(String qx) {this.qx = qx;}
}

指导老师javaBean创建语句如下:


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

//指导老师
public class Zdtc  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 zdtcName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//权限
private String qx;
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 getZdtcName() {return zdtcName;}
public void setZdtcName(String zdtcName) {this.zdtcName = zdtcName;}
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;}
public String getQx() {return qx;}
public void setQx(String qx) {this.qx = qx;}
}

源代码下载点这里

评论