基于WEB的网上选课系统的设计与实现 _部分源代码分享

• 基于WEB的网上选课系统的设计与实现mysql数据库创建语句
• 基于WEB的网上选课系统的设计与实现oracle数据库创建语句
• 基于WEB的网上选课系统的设计与实现sqlserver数据库创建语句
• 基于WEB的网上选课系统的设计与实现spring+springMVC+hibernate框架对象(javaBean,pojo)设计
• 基于WEB的网上选课系统的设计与实现spring+springMVC+mybatis框架对象(javaBean,pojo)设计

基于WEB的网上选课系统的设计与实现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_contact(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	phone varchar(100) comment '联系方式',
	content varchar(100) comment '内容',
	insertDate datetime comment '日期'
) comment '建议';

用户表创建语句如下：

create table t_customer(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	customerName varchar(100) comment '姓名',
	phone varchar(100) comment '手机',
	sex varchar(100) comment '性别',
	age varchar(100) comment '年龄',
	address varchar(100) comment '家庭住址',
	idcard varchar(100) comment '身份证',
	insertDate datetime comment '入库日期',
	types varchar(100) comment '类别'
) comment '用户';

试卷表创建语句如下：

create table t_exam(
	id int primary key auto_increment comment '主键',
	examName varchar(100) comment '名称',
	showDate varchar(100) comment '日期',
	status varchar(100) comment '状态'
) comment '试卷';

答案表创建语句如下：

create table t_examanswer(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	examName varchar(100) comment '试卷名称',
	insertDate datetime comment '日期',
	tm varchar(100) comment '题目',
	da varchar(100) comment '客户答案',
	answer varchar(100) comment '正确答案',
	batchId varchar(100) comment ''
) comment '答案';

试卷题目表创建语句如下：

create table t_examlist(
	id int primary key auto_increment comment '主键',
	examId int comment '试卷',
	examtmId int comment '题目'
) comment '试卷题目';

考试题目表创建语句如下：

create table t_examtm(
	id int primary key auto_increment comment '主键',
	types int comment '类型',
	v1 varchar(100) comment '题目标题',
	v2 varchar(100) comment '选项A',
	v3 varchar(100) comment '选项B',
	v4 varchar(100) comment '选项C',
	v5 varchar(100) comment '选项D',
	v6 varchar(100) comment '答案',
	v7 varchar(100) comment '题目',
	v8 varchar(100) comment '答案',
	v9 varchar(100) comment '题目',
	v10 varchar(100) comment '答案'
) comment '考试题目';

课表表创建语句如下：

create table t_kb(
	id int primary key auto_increment comment '主键',
	va1 int comment '星期一第一节',
	va2 int comment '星期一第二节',
	va3 int comment '星期一第三节',
	va4 int comment '星期一第四节',
	vb1 int comment '星期二第一节',
	vb2 int comment '星期二第二节',
	vb3 int comment '星期二第三节',
	vb4 int comment '星期二第四节',
	vc1 int comment '星期三第一节',
	vc2 int comment '星期三第二节',
	vc3 int comment '星期三第三节',
	vc4 int comment '星期三第四节',
	vd1 int comment '星期四第一节',
	vd2 int comment '星期四第二节',
	vd3 int comment '星期四第三节',
	vd4 int comment '星期四第四节',
	ve1 int comment '星期五第一节',
	ve2 int comment '星期五第二节',
	ve3 int comment '星期五第三节',
	ve4 int comment '星期五第四节'
) comment '课表';

轮播图表创建语句如下：

create table t_lbt(
	id int primary key auto_increment comment '主键',
	lbtName varchar(100) comment '标题',
	lbtPic varchar(100) comment '图片',
	url varchar(100) comment '链接'
) comment '轮播图';

选课历史表创建语句如下：

create table t_ls(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	wdxxId int comment '课程',
	insertDate datetime comment '日期'
) comment '选课历史';

年级表创建语句如下：

create table t_nj(
	id int primary key auto_increment comment '主键',
	njName varchar(100) comment '年级名称'
) comment '年级';

评论表创建语句如下：

create table t_pinglun(
	id int primary key auto_increment comment '主键',
	wdxxId int comment '评论信息',
	customerId int comment '评论人',
	content varchar(100) comment '评论内容',
	insertDate datetime comment '评论日期'
) comment '评论';

视频表创建语句如下：

create table t_radios(
	id int primary key auto_increment comment '主键',
	radiosName varchar(100) comment '标题',
	radiosUrl varchar(100) comment '视频',
	radiosContent varchar(100) comment '内容',
	radiosDate varchar(100) comment '日期'
) comment '视频';

我的消息表创建语句如下：

create table t_wdxx(
	id int primary key auto_increment comment '主键',
	customerId int comment '我',
	title varchar(100) comment '标题',
	pic varchar(100) comment '图片',
	content varchar(100) comment '内容',
	zan int comment '赞',
	insertDate datetime comment '发布日期',
	njId int comment '年级',
	yxId int comment '院系',
	zyId int comment '专业',
	num int comment '报名总数'
) comment '我的消息';

选课表创建语句如下：

create table t_xk(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	wdxxId int comment '课程',
	insertDate datetime comment '日期'
) comment '选课';

新闻表创建语句如下：

create table t_xw(
	id int primary key auto_increment comment '主键',
	xwName varchar(100) comment '标题',
	xwPic varchar(100) comment '图片',
	xwContent varchar(100) comment '内容',
	xwDate varchar(100) comment '日期'
) comment '新闻';

院系表创建语句如下：

create table t_yx(
	id int primary key auto_increment comment '主键',
	yxName varchar(100) comment '院系名称'
) comment '院系';

专业表创建语句如下：

create table t_zy(
	id int primary key auto_increment comment '主键',
	zyName varchar(100) comment '专业名称'
) comment '专业';

基于WEB的网上选课系统的设计与实现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_contact(
	id integer,
	customerId int,
	phone varchar(100),
	content varchar(100),
	insertDate datetime
);
--建议字段加注释
comment on column t_contact.id is '主键';
comment on column t_contact.customerId is '用户';
comment on column t_contact.phone is '联系方式';
comment on column t_contact.content is '内容';
comment on column t_contact.insertDate is '日期';
--建议表加注释
comment on table t_contact is '建议';

用户表创建语句如下：

create table t_customer(
	id integer,
	username varchar(100),
	password varchar(100),
	customerName varchar(100),
	phone varchar(100),
	sex varchar(100),
	age varchar(100),
	address varchar(100),
	idcard varchar(100),
	insertDate datetime,
	types varchar(100)
);
--用户字段加注释
comment on column t_customer.id is '主键';
comment on column t_customer.username is '账号';
comment on column t_customer.password is '密码';
comment on column t_customer.customerName is '姓名';
comment on column t_customer.phone is '手机';
comment on column t_customer.sex is '性别';
comment on column t_customer.age is '年龄';
comment on column t_customer.address is '家庭住址';
comment on column t_customer.idcard is '身份证';
comment on column t_customer.insertDate is '入库日期';
comment on column t_customer.types is '类别';
--用户表加注释
comment on table t_customer is '用户';

试卷表创建语句如下：

create table t_exam(
	id integer,
	examName varchar(100),
	showDate varchar(100),
	status varchar(100)
);
--试卷字段加注释
comment on column t_exam.id is '主键';
comment on column t_exam.examName is '名称';
comment on column t_exam.showDate is '日期';
comment on column t_exam.status is '状态';
--试卷表加注释
comment on table t_exam is '试卷';

答案表创建语句如下：

create table t_examanswer(
	id integer,
	customerId int,
	examName varchar(100),
	insertDate datetime,
	tm varchar(100),
	da varchar(100),
	answer varchar(100),
	batchId varchar(100)
);
--答案字段加注释
comment on column t_examanswer.id is '主键';
comment on column t_examanswer.customerId is '用户';
comment on column t_examanswer.examName is '试卷名称';
comment on column t_examanswer.insertDate is '日期';
comment on column t_examanswer.tm is '题目';
comment on column t_examanswer.da is '客户答案';
comment on column t_examanswer.answer is '正确答案';
comment on column t_examanswer.batchId is '';
--答案表加注释
comment on table t_examanswer is '答案';

试卷题目表创建语句如下：

create table t_examlist(
	id integer,
	examId int,
	examtmId int
);
--试卷题目字段加注释
comment on column t_examlist.id is '主键';
comment on column t_examlist.examId is '试卷';
comment on column t_examlist.examtmId is '题目';
--试卷题目表加注释
comment on table t_examlist is '试卷题目';

考试题目表创建语句如下：

create table t_examtm(
	id integer,
	types int,
	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),
	v10 varchar(100)
);
--考试题目字段加注释
comment on column t_examtm.id is '主键';
comment on column t_examtm.types is '类型';
comment on column t_examtm.v1 is '题目标题';
comment on column t_examtm.v2 is '选项A';
comment on column t_examtm.v3 is '选项B';
comment on column t_examtm.v4 is '选项C';
comment on column t_examtm.v5 is '选项D';
comment on column t_examtm.v6 is '答案';
comment on column t_examtm.v7 is '题目';
comment on column t_examtm.v8 is '答案';
comment on column t_examtm.v9 is '题目';
comment on column t_examtm.v10 is '答案';
--考试题目表加注释
comment on table t_examtm is '考试题目';

课表表创建语句如下：

create table t_kb(
	id integer,
	va1 int,
	va2 int,
	va3 int,
	va4 int,
	vb1 int,
	vb2 int,
	vb3 int,
	vb4 int,
	vc1 int,
	vc2 int,
	vc3 int,
	vc4 int,
	vd1 int,
	vd2 int,
	vd3 int,
	vd4 int,
	ve1 int,
	ve2 int,
	ve3 int,
	ve4 int
);
--课表字段加注释
comment on column t_kb.id is '主键';
comment on column t_kb.va1 is '星期一第一节';
comment on column t_kb.va2 is '星期一第二节';
comment on column t_kb.va3 is '星期一第三节';
comment on column t_kb.va4 is '星期一第四节';
comment on column t_kb.vb1 is '星期二第一节';
comment on column t_kb.vb2 is '星期二第二节';
comment on column t_kb.vb3 is '星期二第三节';
comment on column t_kb.vb4 is '星期二第四节';
comment on column t_kb.vc1 is '星期三第一节';
comment on column t_kb.vc2 is '星期三第二节';
comment on column t_kb.vc3 is '星期三第三节';
comment on column t_kb.vc4 is '星期三第四节';
comment on column t_kb.vd1 is '星期四第一节';
comment on column t_kb.vd2 is '星期四第二节';
comment on column t_kb.vd3 is '星期四第三节';
comment on column t_kb.vd4 is '星期四第四节';
comment on column t_kb.ve1 is '星期五第一节';
comment on column t_kb.ve2 is '星期五第二节';
comment on column t_kb.ve3 is '星期五第三节';
comment on column t_kb.ve4 is '星期五第四节';
--课表表加注释
comment on table t_kb is '课表';

轮播图表创建语句如下：

create table t_lbt(
	id integer,
	lbtName varchar(100),
	lbtPic varchar(100),
	url varchar(100)
);
--轮播图字段加注释
comment on column t_lbt.id is '主键';
comment on column t_lbt.lbtName is '标题';
comment on column t_lbt.lbtPic is '图片';
comment on column t_lbt.url is '链接';
--轮播图表加注释
comment on table t_lbt is '轮播图';

选课历史表创建语句如下：

create table t_ls(
	id integer,
	customerId int,
	wdxxId int,
	insertDate datetime
);
--选课历史字段加注释
comment on column t_ls.id is '主键';
comment on column t_ls.customerId is '用户';
comment on column t_ls.wdxxId is '课程';
comment on column t_ls.insertDate is '日期';
--选课历史表加注释
comment on table t_ls is '选课历史';

年级表创建语句如下：

create table t_nj(
	id integer,
	njName varchar(100)
);
--年级字段加注释
comment on column t_nj.id is '主键';
comment on column t_nj.njName is '年级名称';
--年级表加注释
comment on table t_nj is '年级';

评论表创建语句如下：

create table t_pinglun(
	id integer,
	wdxxId int,
	customerId int,
	content varchar(100),
	insertDate datetime
);
--评论字段加注释
comment on column t_pinglun.id is '主键';
comment on column t_pinglun.wdxxId is '评论信息';
comment on column t_pinglun.customerId is '评论人';
comment on column t_pinglun.content is '评论内容';
comment on column t_pinglun.insertDate is '评论日期';
--评论表加注释
comment on table t_pinglun is '评论';

视频表创建语句如下：

create table t_radios(
	id integer,
	radiosName varchar(100),
	radiosUrl varchar(100),
	radiosContent varchar(100),
	radiosDate varchar(100)
);
--视频字段加注释
comment on column t_radios.id is '主键';
comment on column t_radios.radiosName is '标题';
comment on column t_radios.radiosUrl is '视频';
comment on column t_radios.radiosContent is '内容';
comment on column t_radios.radiosDate is '日期';
--视频表加注释
comment on table t_radios is '视频';

我的消息表创建语句如下：

create table t_wdxx(
	id integer,
	customerId int,
	title varchar(100),
	pic varchar(100),
	content varchar(100),
	zan int,
	insertDate datetime,
	njId int,
	yxId int,
	zyId int,
	num int
);
--我的消息字段加注释
comment on column t_wdxx.id is '主键';
comment on column t_wdxx.customerId is '我';
comment on column t_wdxx.title is '标题';
comment on column t_wdxx.pic is '图片';
comment on column t_wdxx.content is '内容';
comment on column t_wdxx.zan is '赞';
comment on column t_wdxx.insertDate is '发布日期';
comment on column t_wdxx.njId is '年级';
comment on column t_wdxx.yxId is '院系';
comment on column t_wdxx.zyId is '专业';
comment on column t_wdxx.num is '报名总数';
--我的消息表加注释
comment on table t_wdxx is '我的消息';

选课表创建语句如下：

create table t_xk(
	id integer,
	customerId int,
	wdxxId int,
	insertDate datetime
);
--选课字段加注释
comment on column t_xk.id is '主键';
comment on column t_xk.customerId is '用户';
comment on column t_xk.wdxxId is '课程';
comment on column t_xk.insertDate is '日期';
--选课表加注释
comment on table t_xk is '选课';

新闻表创建语句如下：

create table t_xw(
	id integer,
	xwName varchar(100),
	xwPic varchar(100),
	xwContent varchar(100),
	xwDate varchar(100)
);
--新闻字段加注释
comment on column t_xw.id is '主键';
comment on column t_xw.xwName is '标题';
comment on column t_xw.xwPic is '图片';
comment on column t_xw.xwContent is '内容';
comment on column t_xw.xwDate is '日期';
--新闻表加注释
comment on table t_xw is '新闻';

院系表创建语句如下：

create table t_yx(
	id integer,
	yxName varchar(100)
);
--院系字段加注释
comment on column t_yx.id is '主键';
comment on column t_yx.yxName is '院系名称';
--院系表加注释
comment on table t_yx 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_contact;
create sequence s_t_customer;
create sequence s_t_exam;
create sequence s_t_examanswer;
create sequence s_t_examlist;
create sequence s_t_examtm;
create sequence s_t_kb;
create sequence s_t_lbt;
create sequence s_t_ls;
create sequence s_t_nj;
create sequence s_t_pinglun;
create sequence s_t_radios;
create sequence s_t_wdxx;
create sequence s_t_xk;
create sequence s_t_xw;
create sequence s_t_yx;
create sequence s_t_zy;

基于WEB的网上选课系统的设计与实现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_contact(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	phone varchar(100),--联系方式
	content varchar(100),--内容
	insertDate datetime--日期
);

用户表创建语句如下：

--用户表注释
create table t_customer(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	customerName varchar(100),--姓名
	phone varchar(100),--手机
	sex varchar(100),--性别
	age varchar(100),--年龄
	address varchar(100),--家庭住址
	idcard varchar(100),--身份证
	insertDate datetime,--入库日期
	types varchar(100)--类别
);

试卷表创建语句如下：

--试卷表注释
create table t_exam(
	id int identity(1,1) primary key not null,--主键
	examName varchar(100),--名称
	showDate varchar(100),--日期
	status varchar(100)--状态
);

答案表创建语句如下：

--答案表注释
create table t_examanswer(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	examName varchar(100),--试卷名称
	insertDate datetime,--日期
	tm varchar(100),--题目
	da varchar(100),--客户答案
	answer varchar(100),--正确答案
	batchId varchar(100)--
);

试卷题目表创建语句如下：

--试卷题目表注释
create table t_examlist(
	id int identity(1,1) primary key not null,--主键
	examId int,--试卷
	examtmId int--题目
);

考试题目表创建语句如下：

--考试题目表注释
create table t_examtm(
	id int identity(1,1) primary key not null,--主键
	types int,--类型
	v1 varchar(100),--题目标题
	v2 varchar(100),--选项A
	v3 varchar(100),--选项B
	v4 varchar(100),--选项C
	v5 varchar(100),--选项D
	v6 varchar(100),--答案
	v7 varchar(100),--题目
	v8 varchar(100),--答案
	v9 varchar(100),--题目
	v10 varchar(100)--答案
);

课表表创建语句如下：

--课表表注释
create table t_kb(
	id int identity(1,1) primary key not null,--主键
	va1 int,--星期一第一节
	va2 int,--星期一第二节
	va3 int,--星期一第三节
	va4 int,--星期一第四节
	vb1 int,--星期二第一节
	vb2 int,--星期二第二节
	vb3 int,--星期二第三节
	vb4 int,--星期二第四节
	vc1 int,--星期三第一节
	vc2 int,--星期三第二节
	vc3 int,--星期三第三节
	vc4 int,--星期三第四节
	vd1 int,--星期四第一节
	vd2 int,--星期四第二节
	vd3 int,--星期四第三节
	vd4 int,--星期四第四节
	ve1 int,--星期五第一节
	ve2 int,--星期五第二节
	ve3 int,--星期五第三节
	ve4 int--星期五第四节
);

轮播图表创建语句如下：

--轮播图表注释
create table t_lbt(
	id int identity(1,1) primary key not null,--主键
	lbtName varchar(100),--标题
	lbtPic varchar(100),--图片
	url varchar(100)--链接
);

选课历史表创建语句如下：

--选课历史表注释
create table t_ls(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	wdxxId int,--课程
	insertDate datetime--日期
);

年级表创建语句如下：

--年级表注释
create table t_nj(
	id int identity(1,1) primary key not null,--主键
	njName varchar(100)--年级名称
);

评论表创建语句如下：

--评论表注释
create table t_pinglun(
	id int identity(1,1) primary key not null,--主键
	wdxxId int,--评论信息
	customerId int,--评论人
	content varchar(100),--评论内容
	insertDate datetime--评论日期
);

视频表创建语句如下：

--视频表注释
create table t_radios(
	id int identity(1,1) primary key not null,--主键
	radiosName varchar(100),--标题
	radiosUrl varchar(100),--视频
	radiosContent varchar(100),--内容
	radiosDate varchar(100)--日期
);

我的消息表创建语句如下：

--我的消息表注释
create table t_wdxx(
	id int identity(1,1) primary key not null,--主键
	customerId int,--我
	title varchar(100),--标题
	pic varchar(100),--图片
	content varchar(100),--内容
	zan int,--赞
	insertDate datetime,--发布日期
	njId int,--年级
	yxId int,--院系
	zyId int,--专业
	num int--报名总数
);

选课表创建语句如下：

--选课表注释
create table t_xk(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	wdxxId int,--课程
	insertDate datetime--日期
);

新闻表创建语句如下：

--新闻表注释
create table t_xw(
	id int identity(1,1) primary key not null,--主键
	xwName varchar(100),--标题
	xwPic varchar(100),--图片
	xwContent varchar(100),--内容
	xwDate varchar(100)--日期
);

院系表创建语句如下：

--院系表注释
create table t_yx(
	id int identity(1,1) primary key not null,--主键
	yxName varchar(100)--院系名称
);

专业表创建语句如下：

--专业表注释
create table t_zy(
	id int identity(1,1) primary key not null,--主键
	zyName varchar(100)--专业名称
);

基于WEB的网上选课系统的设计与实现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_contact")
public class Contact {
//主键
@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 customerId;
//联系方式
private String phone;
//内容
private String content;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
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;}
}

用户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_customer")
public class Customer {
//主键
@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 customerName;
//手机
private String phone;
//性别
private String sex;
//年龄
private String age;
//家庭住址
private String address;
//身份证
private String idcard;
//入库日期
private Date insertDate;
//类别
private String types;
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 getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
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;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
}

试卷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_exam")
public class Exam {
//主键
@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 examName;
//日期
private String showDate;
//状态
private String status;
public String getExamName() {return examName;}
public void setExamName(String examName) {this.examName = examName;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
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_examanswer")
public class Examanswer {
//主键
@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 customerId;
//试卷名称
private String examName;
//日期
private Date insertDate;
//题目
private String tm;
//客户答案
private String da;
//正确答案
private String answer;
//
private String batchId;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getExamName() {return examName;}
public void setExamName(String examName) {this.examName = examName;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getTm() {return tm;}
public void setTm(String tm) {this.tm = tm;}
public String getDa() {return da;}
public void setDa(String da) {this.da = da;}
public String getAnswer() {return answer;}
public void setAnswer(String answer) {this.answer = answer;}
public String getBatchId() {return batchId;}
public void setBatchId(String batchId) {this.batchId = batchId;}
}

试卷题目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_examlist")
public class Examlist {
//主键
@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 examId;
//题目
private Integer examtmId;
public Integer getExamId() {return examId;}
public void setExamId(Integer examId) {this.examId = examId;}
public Integer getExamtmId() {return examtmId;}
public void setExamtmId(Integer examtmId) {this.examtmId = examtmId;}
}

考试题目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_examtm")
public class Examtm {
//主键
@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 types;
//题目标题
private String v1;
//选项A
private String v2;
//选项B
private String v3;
//选项C
private String v4;
//选项D
private String v5;
//答案
private String v6;
//题目
private String v7;
//答案
private String v8;
//题目
private String v9;
//答案
private String v10;
public Integer getTypes() {return types;}
public void setTypes(Integer types) {this.types = types;}
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 getV10() {return v10;}
public void setV10(String v10) {this.v10 = v10;}
}

课表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_kb")
public class Kb {
//主键
@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 va1;
//星期一第二节
private Integer va2;
//星期一第三节
private Integer va3;
//星期一第四节
private Integer va4;
//星期二第一节
private Integer vb1;
//星期二第二节
private Integer vb2;
//星期二第三节
private Integer vb3;
//星期二第四节
private Integer vb4;
//星期三第一节
private Integer vc1;
//星期三第二节
private Integer vc2;
//星期三第三节
private Integer vc3;
//星期三第四节
private Integer vc4;
//星期四第一节
private Integer vd1;
//星期四第二节
private Integer vd2;
//星期四第三节
private Integer vd3;
//星期四第四节
private Integer vd4;
//星期五第一节
private Integer ve1;
//星期五第二节
private Integer ve2;
//星期五第三节
private Integer ve3;
//星期五第四节
private Integer ve4;
public Integer getVa1() {return va1;}
public void setVa1(Integer va1) {this.va1 = va1;}
public Integer getVa2() {return va2;}
public void setVa2(Integer va2) {this.va2 = va2;}
public Integer getVa3() {return va3;}
public void setVa3(Integer va3) {this.va3 = va3;}
public Integer getVa4() {return va4;}
public void setVa4(Integer va4) {this.va4 = va4;}
public Integer getVb1() {return vb1;}
public void setVb1(Integer vb1) {this.vb1 = vb1;}
public Integer getVb2() {return vb2;}
public void setVb2(Integer vb2) {this.vb2 = vb2;}
public Integer getVb3() {return vb3;}
public void setVb3(Integer vb3) {this.vb3 = vb3;}
public Integer getVb4() {return vb4;}
public void setVb4(Integer vb4) {this.vb4 = vb4;}
public Integer getVc1() {return vc1;}
public void setVc1(Integer vc1) {this.vc1 = vc1;}
public Integer getVc2() {return vc2;}
public void setVc2(Integer vc2) {this.vc2 = vc2;}
public Integer getVc3() {return vc3;}
public void setVc3(Integer vc3) {this.vc3 = vc3;}
public Integer getVc4() {return vc4;}
public void setVc4(Integer vc4) {this.vc4 = vc4;}
public Integer getVd1() {return vd1;}
public void setVd1(Integer vd1) {this.vd1 = vd1;}
public Integer getVd2() {return vd2;}
public void setVd2(Integer vd2) {this.vd2 = vd2;}
public Integer getVd3() {return vd3;}
public void setVd3(Integer vd3) {this.vd3 = vd3;}
public Integer getVd4() {return vd4;}
public void setVd4(Integer vd4) {this.vd4 = vd4;}
public Integer getVe1() {return ve1;}
public void setVe1(Integer ve1) {this.ve1 = ve1;}
public Integer getVe2() {return ve2;}
public void setVe2(Integer ve2) {this.ve2 = ve2;}
public Integer getVe3() {return ve3;}
public void setVe3(Integer ve3) {this.ve3 = ve3;}
public Integer getVe4() {return ve4;}
public void setVe4(Integer ve4) {this.ve4 = ve4;}
}

轮播图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_lbt")
public class Lbt {
//主键
@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 lbtName;
//图片
private String lbtPic;
//链接
private String url;
public String getLbtName() {return lbtName;}
public void setLbtName(String lbtName) {this.lbtName = lbtName;}
public String getLbtPic() {return lbtPic;}
public void setLbtPic(String lbtPic) {this.lbtPic = lbtPic;}
public String getUrl() {return url;}
public void setUrl(String url) {this.url = url;}
}

选课历史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_ls")
public class Ls {
//主键
@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 customerId;
//课程
private Integer wdxxId;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getWdxxId() {return wdxxId;}
public void setWdxxId(Integer wdxxId) {this.wdxxId = wdxxId;}
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_nj")
public class Nj {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//年级名称
private String njName;
public String getNjName() {return njName;}
public void setNjName(String njName) {this.njName = njName;}
}

评论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_pinglun")
public class Pinglun {
//主键
@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 wdxxId;
//评论人
private Integer customerId;
//评论内容
private String content;
//评论日期
private Date insertDate;
public Integer getWdxxId() {return wdxxId;}
public void setWdxxId(Integer wdxxId) {this.wdxxId = wdxxId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
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;}
}

视频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_radios")
public class Radios {
//主键
@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 radiosName;
//视频
private String radiosUrl;
//内容
private String radiosContent;
//日期
private String radiosDate;
public String getRadiosName() {return radiosName;}
public void setRadiosName(String radiosName) {this.radiosName = radiosName;}
public String getRadiosUrl() {return radiosUrl;}
public void setRadiosUrl(String radiosUrl) {this.radiosUrl = radiosUrl;}
public String getRadiosContent() {return radiosContent;}
public void setRadiosContent(String radiosContent) {this.radiosContent = radiosContent;}
public String getRadiosDate() {return radiosDate;}
public void setRadiosDate(String radiosDate) {this.radiosDate = radiosDate;}
}

我的消息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_wdxx")
public class Wdxx {
//主键
@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 customerId;
//标题
private String title;
//图片
private String pic;
//内容
private String content;
//赞
private Integer zan;
//发布日期
private Date insertDate;
//年级
private Integer njId;
//院系
private Integer yxId;
//专业
private Integer zyId;
//报名总数
private Integer num;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
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 Integer getZan() {return zan;}
public void setZan(Integer zan) {this.zan = zan;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public Integer getNjId() {return njId;}
public void setNjId(Integer njId) {this.njId = njId;}
public Integer getYxId() {return yxId;}
public void setYxId(Integer yxId) {this.yxId = yxId;}
public Integer getZyId() {return zyId;}
public void setZyId(Integer zyId) {this.zyId = zyId;}
public Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
}

选课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_xk")
public class Xk {
//主键
@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 customerId;
//课程
private Integer wdxxId;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getWdxxId() {return wdxxId;}
public void setWdxxId(Integer wdxxId) {this.wdxxId = wdxxId;}
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_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 xwName;
//图片
private String xwPic;
//内容
private String xwContent;
//日期
private String xwDate;
public String getXwName() {return xwName;}
public void setXwName(String xwName) {this.xwName = xwName;}
public String getXwPic() {return xwPic;}
public void setXwPic(String xwPic) {this.xwPic = xwPic;}
public String getXwContent() {return xwContent;}
public void setXwContent(String xwContent) {this.xwContent = xwContent;}
public String getXwDate() {return xwDate;}
public void setXwDate(String xwDate) {this.xwDate = xwDate;}
}

院系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_yx")
public class Yx {
//主键
@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 yxName;
public String getYxName() {return yxName;}
public void setYxName(String yxName) {this.yxName = yxName;}
}

专业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;}
}

基于WEB的网上选课系统的设计与实现spring+springMVC+mybatis框架对象(javaBean,pojo)设计：

建议javaBean创建语句如下：

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

//建议
public class Contact  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//联系方式
private String phone;
//内容
private String content;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
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;}
}

用户javaBean创建语句如下：

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

//用户
public class Customer  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 customerName;
//手机
private String phone;
//性别
private String sex;
//年龄
private String age;
//家庭住址
private String address;
//身份证
private String idcard;
//入库日期
private Date insertDate;
//类别
private String types;
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 getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
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;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
}

试卷javaBean创建语句如下：

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

//试卷
public class Exam  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//名称
private String examName;
//日期
private String showDate;
//状态
private String status;
public String getExamName() {return examName;}
public void setExamName(String examName) {this.examName = examName;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
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 Examanswer  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//试卷名称
private String examName;
//日期
private Date insertDate;
//题目
private String tm;
//客户答案
private String da;
//正确答案
private String answer;
//
private String batchId;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getExamName() {return examName;}
public void setExamName(String examName) {this.examName = examName;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getTm() {return tm;}
public void setTm(String tm) {this.tm = tm;}
public String getDa() {return da;}
public void setDa(String da) {this.da = da;}
public String getAnswer() {return answer;}
public void setAnswer(String answer) {this.answer = answer;}
public String getBatchId() {return batchId;}
public void setBatchId(String batchId) {this.batchId = batchId;}
}

试卷题目javaBean创建语句如下：

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

//试卷题目
public class Examlist  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//试卷
private Integer examId;
//题目
private Integer examtmId;
public Integer getExamId() {return examId;}
public void setExamId(Integer examId) {this.examId = examId;}
public Integer getExamtmId() {return examtmId;}
public void setExamtmId(Integer examtmId) {this.examtmId = examtmId;}
}

考试题目javaBean创建语句如下：

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

//考试题目
public class Examtm  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//类型
private Integer types;
//题目标题
private String v1;
//选项A
private String v2;
//选项B
private String v3;
//选项C
private String v4;
//选项D
private String v5;
//答案
private String v6;
//题目
private String v7;
//答案
private String v8;
//题目
private String v9;
//答案
private String v10;
public Integer getTypes() {return types;}
public void setTypes(Integer types) {this.types = types;}
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 getV10() {return v10;}
public void setV10(String v10) {this.v10 = v10;}
}

课表javaBean创建语句如下：

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

//课表
public class Kb  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//星期一第一节
private Integer va1;
//星期一第二节
private Integer va2;
//星期一第三节
private Integer va3;
//星期一第四节
private Integer va4;
//星期二第一节
private Integer vb1;
//星期二第二节
private Integer vb2;
//星期二第三节
private Integer vb3;
//星期二第四节
private Integer vb4;
//星期三第一节
private Integer vc1;
//星期三第二节
private Integer vc2;
//星期三第三节
private Integer vc3;
//星期三第四节
private Integer vc4;
//星期四第一节
private Integer vd1;
//星期四第二节
private Integer vd2;
//星期四第三节
private Integer vd3;
//星期四第四节
private Integer vd4;
//星期五第一节
private Integer ve1;
//星期五第二节
private Integer ve2;
//星期五第三节
private Integer ve3;
//星期五第四节
private Integer ve4;
public Integer getVa1() {return va1;}
public void setVa1(Integer va1) {this.va1 = va1;}
public Integer getVa2() {return va2;}
public void setVa2(Integer va2) {this.va2 = va2;}
public Integer getVa3() {return va3;}
public void setVa3(Integer va3) {this.va3 = va3;}
public Integer getVa4() {return va4;}
public void setVa4(Integer va4) {this.va4 = va4;}
public Integer getVb1() {return vb1;}
public void setVb1(Integer vb1) {this.vb1 = vb1;}
public Integer getVb2() {return vb2;}
public void setVb2(Integer vb2) {this.vb2 = vb2;}
public Integer getVb3() {return vb3;}
public void setVb3(Integer vb3) {this.vb3 = vb3;}
public Integer getVb4() {return vb4;}
public void setVb4(Integer vb4) {this.vb4 = vb4;}
public Integer getVc1() {return vc1;}
public void setVc1(Integer vc1) {this.vc1 = vc1;}
public Integer getVc2() {return vc2;}
public void setVc2(Integer vc2) {this.vc2 = vc2;}
public Integer getVc3() {return vc3;}
public void setVc3(Integer vc3) {this.vc3 = vc3;}
public Integer getVc4() {return vc4;}
public void setVc4(Integer vc4) {this.vc4 = vc4;}
public Integer getVd1() {return vd1;}
public void setVd1(Integer vd1) {this.vd1 = vd1;}
public Integer getVd2() {return vd2;}
public void setVd2(Integer vd2) {this.vd2 = vd2;}
public Integer getVd3() {return vd3;}
public void setVd3(Integer vd3) {this.vd3 = vd3;}
public Integer getVd4() {return vd4;}
public void setVd4(Integer vd4) {this.vd4 = vd4;}
public Integer getVe1() {return ve1;}
public void setVe1(Integer ve1) {this.ve1 = ve1;}
public Integer getVe2() {return ve2;}
public void setVe2(Integer ve2) {this.ve2 = ve2;}
public Integer getVe3() {return ve3;}
public void setVe3(Integer ve3) {this.ve3 = ve3;}
public Integer getVe4() {return ve4;}
public void setVe4(Integer ve4) {this.ve4 = ve4;}
}

轮播图javaBean创建语句如下：

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

//轮播图
public class Lbt  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String lbtName;
//图片
private String lbtPic;
//链接
private String url;
public String getLbtName() {return lbtName;}
public void setLbtName(String lbtName) {this.lbtName = lbtName;}
public String getLbtPic() {return lbtPic;}
public void setLbtPic(String lbtPic) {this.lbtPic = lbtPic;}
public String getUrl() {return url;}
public void setUrl(String url) {this.url = url;}
}

选课历史javaBean创建语句如下：

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

//选课历史
public class Ls  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//课程
private Integer wdxxId;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getWdxxId() {return wdxxId;}
public void setWdxxId(Integer wdxxId) {this.wdxxId = wdxxId;}
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 Nj  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//年级名称
private String njName;
public String getNjName() {return njName;}
public void setNjName(String njName) {this.njName = njName;}
}

评论javaBean创建语句如下：

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

//评论
public class Pinglun  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//评论信息
private Integer wdxxId;
//评论人
private Integer customerId;
//评论内容
private String content;
//评论日期
private Date insertDate;
public Integer getWdxxId() {return wdxxId;}
public void setWdxxId(Integer wdxxId) {this.wdxxId = wdxxId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
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;}
}

视频javaBean创建语句如下：

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

//视频
public class Radios  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String radiosName;
//视频
private String radiosUrl;
//内容
private String radiosContent;
//日期
private String radiosDate;
public String getRadiosName() {return radiosName;}
public void setRadiosName(String radiosName) {this.radiosName = radiosName;}
public String getRadiosUrl() {return radiosUrl;}
public void setRadiosUrl(String radiosUrl) {this.radiosUrl = radiosUrl;}
public String getRadiosContent() {return radiosContent;}
public void setRadiosContent(String radiosContent) {this.radiosContent = radiosContent;}
public String getRadiosDate() {return radiosDate;}
public void setRadiosDate(String radiosDate) {this.radiosDate = radiosDate;}
}

我的消息javaBean创建语句如下：

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

//我的消息
public class Wdxx  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//我
private Integer customerId;
//标题
private String title;
//图片
private String pic;
//内容
private String content;
//赞
private Integer zan;
//发布日期
private Date insertDate;
//年级
private Integer njId;
//院系
private Integer yxId;
//专业
private Integer zyId;
//报名总数
private Integer num;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
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 Integer getZan() {return zan;}
public void setZan(Integer zan) {this.zan = zan;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public Integer getNjId() {return njId;}
public void setNjId(Integer njId) {this.njId = njId;}
public Integer getYxId() {return yxId;}
public void setYxId(Integer yxId) {this.yxId = yxId;}
public Integer getZyId() {return zyId;}
public void setZyId(Integer zyId) {this.zyId = zyId;}
public Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
}

选课javaBean创建语句如下：

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

//选课
public class Xk  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//课程
private Integer wdxxId;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getWdxxId() {return wdxxId;}
public void setWdxxId(Integer wdxxId) {this.wdxxId = wdxxId;}
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 Xw  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String xwName;
//图片
private String xwPic;
//内容
private String xwContent;
//日期
private String xwDate;
public String getXwName() {return xwName;}
public void setXwName(String xwName) {this.xwName = xwName;}
public String getXwPic() {return xwPic;}
public void setXwPic(String xwPic) {this.xwPic = xwPic;}
public String getXwContent() {return xwContent;}
public void setXwContent(String xwContent) {this.xwContent = xwContent;}
public String getXwDate() {return xwDate;}
public void setXwDate(String xwDate) {this.xwDate = xwDate;}
}

院系javaBean创建语句如下：

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

//院系
public class Yx  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//院系名称
private String yxName;
public String getYxName() {return yxName;}
public void setYxName(String yxName) {this.yxName = yxName;}
}

专业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;}
}