基于WEB的编程自学网站

基于WEB的编程自学网站登录注册界面

基于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_bk(
	id int primary key auto_increment comment '主键',
	bkName varchar(100) comment '版块名称'
) comment '论坛版块';

用户表创建语句如下:


create table t_customer(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	name 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 '入库日期',
	headPic varchar(100) comment '头像',
	level varchar(100) comment '层级',
	isft varchar(100) comment '发帖权限',
	ispl varchar(100) comment '评论权限',
	mb1 varchar(100) comment '密保1',
	mb2 varchar(100) comment '密保2',
	mb3 varchar(100) comment '密保3',
	sj1 varchar(100) comment '',
	sj2 varchar(100) comment '',
	sj3 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 '状态',
	ny 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 '',
	df varchar(100) comment '',
	v1 int comment '',
	v2 int comment '',
	v3 int comment '',
	isdl 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_kc(
	id int primary key auto_increment comment '主键',
	kcName varchar(100) comment '课程名称',
	pic varchar(100) comment '图片',
	content varchar(100) comment '内容说明',
	kczjs varchar(100) comment '课程章节数'
) comment '课程';

留言表创建语句如下:


create table t_liuyan(
	id int primary key auto_increment comment '主键',
	customerId int comment '发起人',
	toId int comment '回复人',
	content varchar(100) comment '发起内容',
	insertDate datetime comment '发起日期',
	back varchar(100) comment '回复内容',
	backDate datetime comment '回复时间',
	status varchar(100) comment '状态'
) comment '留言';

论坛说明表创建语句如下:


create table t_ltsm(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '论坛说明'
) comment '论坛说明';

敏感词表创建语句如下:


create table t_mgc(
	id int primary key auto_increment comment '主键',
	mgc 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_wdhy(
	id int primary key auto_increment comment '主键',
	customerId int comment '我',
	hhId int comment '好友',
	insertDate datetime 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 '发布日期',
	nologin varchar(100) comment '游客是否可见',
	bkId int comment ''
) comment '我的消息';

校园新闻表创建语句如下:


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

用户选择课程表创建语句如下:


create table t_xzkc(
	id int primary key auto_increment comment '主键',
	kcId int comment '课程',
	customerId int comment '用户',
	df int comment '得分',
	zjId int comment '最新章节',
	pj varchar(100) comment '评价',
	jy varchar(100) comment '建议'
) comment '用户选择课程';

章节表创建语句如下:


create table t_zj(
	id int primary key auto_increment comment '主键',
	kcId int comment '课程',
	zjbh varchar(100) comment '章节编号',
	px int comment '排序',
	content varchar(100) comment '内容',
	tm1 varchar(100) comment '选择题一',
	da1 varchar(100) comment '答案',
	tm2 varchar(100) comment '选择题二',
	da2 varchar(100) comment '答案',
	tm3 varchar(100) comment '选择题三',
	da3 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_bk(
	id integer,
	bkName varchar(100)
);
--论坛版块字段加注释
comment on column t_bk.id is '主键';
comment on column t_bk.bkName is '版块名称';
--论坛版块表加注释
comment on table t_bk is '论坛版块';

用户表创建语句如下:


create table t_customer(
	id integer,
	username varchar(100),
	password varchar(100),
	name varchar(100),
	phone varchar(100),
	sex varchar(100),
	age varchar(100),
	address varchar(100),
	idcard varchar(100),
	insertDate datetime,
	headPic varchar(100),
	level varchar(100),
	isft varchar(100),
	ispl varchar(100),
	mb1 varchar(100),
	mb2 varchar(100),
	mb3 varchar(100),
	sj1 varchar(100),
	sj2 varchar(100),
	sj3 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.name 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.headPic is '头像';
comment on column t_customer.level is '层级';
comment on column t_customer.isft is '发帖权限';
comment on column t_customer.ispl is '评论权限';
comment on column t_customer.mb1 is '密保1';
comment on column t_customer.mb2 is '密保2';
comment on column t_customer.mb3 is '密保3';
comment on column t_customer.sj1 is '';
comment on column t_customer.sj2 is '';
comment on column t_customer.sj3 is '';
--用户表加注释
comment on table t_customer is '用户';

试卷表创建语句如下:


create table t_exam(
	id integer,
	examName varchar(100),
	showDate varchar(100),
	status varchar(100),
	ny 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 column t_exam.ny 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),
	df varchar(100),
	v1 int,
	v2 int,
	v3 int,
	isdl 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 column t_examanswer.df is '';
comment on column t_examanswer.v1 is '';
comment on column t_examanswer.v2 is '';
comment on column t_examanswer.v3 is '';
comment on column t_examanswer.isdl 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_kc(
	id integer,
	kcName varchar(100),
	pic varchar(100),
	content varchar(100),
	kczjs varchar(100)
);
--课程字段加注释
comment on column t_kc.id is '主键';
comment on column t_kc.kcName is '课程名称';
comment on column t_kc.pic is '图片';
comment on column t_kc.content is '内容说明';
comment on column t_kc.kczjs is '课程章节数';
--课程表加注释
comment on table t_kc is '课程';

留言表创建语句如下:


create table t_liuyan(
	id integer,
	customerId int,
	toId int,
	content varchar(100),
	insertDate datetime,
	back varchar(100),
	backDate datetime,
	status varchar(100)
);
--留言字段加注释
comment on column t_liuyan.id is '主键';
comment on column t_liuyan.customerId is '发起人';
comment on column t_liuyan.toId is '回复人';
comment on column t_liuyan.content is '发起内容';
comment on column t_liuyan.insertDate is '发起日期';
comment on column t_liuyan.back is '回复内容';
comment on column t_liuyan.backDate is '回复时间';
comment on column t_liuyan.status is '状态';
--留言表加注释
comment on table t_liuyan is '留言';

论坛说明表创建语句如下:


create table t_ltsm(
	id integer,
	title varchar(100)
);
--论坛说明字段加注释
comment on column t_ltsm.id is '主键';
comment on column t_ltsm.title is '论坛说明';
--论坛说明表加注释
comment on table t_ltsm is '论坛说明';

敏感词表创建语句如下:


create table t_mgc(
	id integer,
	mgc varchar(100)
);
--敏感词字段加注释
comment on column t_mgc.id is '主键';
comment on column t_mgc.mgc is '敏感词';
--敏感词表加注释
comment on table t_mgc 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_wdhy(
	id integer,
	customerId int,
	hhId int,
	insertDate datetime
);
--我的好友字段加注释
comment on column t_wdhy.id is '主键';
comment on column t_wdhy.customerId is '我';
comment on column t_wdhy.hhId is '好友';
comment on column t_wdhy.insertDate is '关注日期';
--我的好友表加注释
comment on table t_wdhy is '我的好友';

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


create table t_wdxx(
	id integer,
	customerId int,
	title varchar(100),
	pic varchar(100),
	content varchar(100),
	zan int,
	insertDate datetime,
	nologin varchar(100),
	bkId 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.nologin is '游客是否可见';
comment on column t_wdxx.bkId is '';
--我的消息表加注释
comment on table t_wdxx is '我的消息';

校园新闻表创建语句如下:


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

用户选择课程表创建语句如下:


create table t_xzkc(
	id integer,
	kcId int,
	customerId int,
	df int,
	zjId int,
	pj varchar(100),
	jy varchar(100)
);
--用户选择课程字段加注释
comment on column t_xzkc.id is '主键';
comment on column t_xzkc.kcId is '课程';
comment on column t_xzkc.customerId is '用户';
comment on column t_xzkc.df is '得分';
comment on column t_xzkc.zjId is '最新章节';
comment on column t_xzkc.pj is '评价';
comment on column t_xzkc.jy is '建议';
--用户选择课程表加注释
comment on table t_xzkc is '用户选择课程';

章节表创建语句如下:


create table t_zj(
	id integer,
	kcId int,
	zjbh varchar(100),
	px int,
	content varchar(100),
	tm1 varchar(100),
	da1 varchar(100),
	tm2 varchar(100),
	da2 varchar(100),
	tm3 varchar(100),
	da3 varchar(100)
);
--章节字段加注释
comment on column t_zj.id is '主键';
comment on column t_zj.kcId is '课程';
comment on column t_zj.zjbh is '章节编号';
comment on column t_zj.px is '排序';
comment on column t_zj.content is '内容';
comment on column t_zj.tm1 is '选择题一';
comment on column t_zj.da1 is '答案';
comment on column t_zj.tm2 is '选择题二';
comment on column t_zj.da2 is '答案';
comment on column t_zj.tm3 is '选择题三';
comment on column t_zj.da3 is '答案';
--章节表加注释
comment on table t_zj is '章节';

oracle特有,对应序列如下:


create sequence s_t_bk;
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_kc;
create sequence s_t_liuyan;
create sequence s_t_ltsm;
create sequence s_t_mgc;
create sequence s_t_pinglun;
create sequence s_t_wdhy;
create sequence s_t_wdxx;
create sequence s_t_xw;
create sequence s_t_xzkc;
create sequence s_t_zj;

基于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_bk(
	id int identity(1,1) primary key not null,--主键
	bkName varchar(100)--版块名称
);

用户表创建语句如下:


--用户表注释
create table t_customer(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	name varchar(100),--姓名
	phone varchar(100),--手机
	sex varchar(100),--性别
	age varchar(100),--年龄
	address varchar(100),--地点
	idcard varchar(100),--工作方向
	insertDate datetime,--入库日期
	headPic varchar(100),--头像
	level varchar(100),--层级
	isft varchar(100),--发帖权限
	ispl varchar(100),--评论权限
	mb1 varchar(100),--密保1
	mb2 varchar(100),--密保2
	mb3 varchar(100),--密保3
	sj1 varchar(100),--
	sj2 varchar(100),--
	sj3 varchar(100)--
);

试卷表创建语句如下:


--试卷表注释
create table t_exam(
	id int identity(1,1) primary key not null,--主键
	examName varchar(100),--名称
	showDate varchar(100),--日期
	status varchar(100),--状态
	ny 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),--
	df varchar(100),--
	v1 int,--
	v2 int,--
	v3 int,--
	isdl 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_kc(
	id int identity(1,1) primary key not null,--主键
	kcName varchar(100),--课程名称
	pic varchar(100),--图片
	content varchar(100),--内容说明
	kczjs varchar(100)--课程章节数
);

留言表创建语句如下:


--留言表注释
create table t_liuyan(
	id int identity(1,1) primary key not null,--主键
	customerId int,--发起人
	toId int,--回复人
	content varchar(100),--发起内容
	insertDate datetime,--发起日期
	back varchar(100),--回复内容
	backDate datetime,--回复时间
	status varchar(100)--状态
);

论坛说明表创建语句如下:


--论坛说明表注释
create table t_ltsm(
	id int identity(1,1) primary key not null,--主键
	title varchar(100)--论坛说明
);

敏感词表创建语句如下:


--敏感词表注释
create table t_mgc(
	id int identity(1,1) primary key not null,--主键
	mgc 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_wdhy(
	id int identity(1,1) primary key not null,--主键
	customerId int,--我
	hhId int,--好友
	insertDate datetime--关注日期
);

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


--我的消息表注释
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,--发布日期
	nologin varchar(100),--游客是否可见
	bkId int--
);

校园新闻表创建语句如下:


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

用户选择课程表创建语句如下:


--用户选择课程表注释
create table t_xzkc(
	id int identity(1,1) primary key not null,--主键
	kcId int,--课程
	customerId int,--用户
	df int,--得分
	zjId int,--最新章节
	pj varchar(100),--评价
	jy varchar(100)--建议
);

章节表创建语句如下:


--章节表注释
create table t_zj(
	id int identity(1,1) primary key not null,--主键
	kcId int,--课程
	zjbh varchar(100),--章节编号
	px int,--排序
	content varchar(100),--内容
	tm1 varchar(100),--选择题一
	da1 varchar(100),--答案
	tm2 varchar(100),--选择题二
	da2 varchar(100),--答案
	tm3 varchar(100),--选择题三
	da3 varchar(100)--答案
);

基于WEB的编程自学网站登录后主页

基于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_bk")
public class Bk {
//主键
@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 bkName;
public String getBkName() {return bkName;}
public void setBkName(String bkName) {this.bkName = bkName;}
}

用户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 name;
//手机
private String phone;
//性别
private String sex;
//年龄
private String age;
//地点
private String address;
//工作方向
private String idcard;
//入库日期
private Date insertDate;
//头像
private String headPic;
//层级
private String level;
//发帖权限
private String isft;
//评论权限
private String ispl;
//密保1
private String mb1;
//密保2
private String mb2;
//密保3
private String mb3;
//
private String sj1;
//
private String sj2;
//
private String sj3;
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 getName() {return name;}
public void setName(String name) {this.name = name;}
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 getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
public String getLevel() {return level;}
public void setLevel(String level) {this.level = level;}
public String getIsft() {return isft;}
public void setIsft(String isft) {this.isft = isft;}
public String getIspl() {return ispl;}
public void setIspl(String ispl) {this.ispl = ispl;}
public String getMb1() {return mb1;}
public void setMb1(String mb1) {this.mb1 = mb1;}
public String getMb2() {return mb2;}
public void setMb2(String mb2) {this.mb2 = mb2;}
public String getMb3() {return mb3;}
public void setMb3(String mb3) {this.mb3 = mb3;}
public String getSj1() {return sj1;}
public void setSj1(String sj1) {this.sj1 = sj1;}
public String getSj2() {return sj2;}
public void setSj2(String sj2) {this.sj2 = sj2;}
public String getSj3() {return sj3;}
public void setSj3(String sj3) {this.sj3 = sj3;}
}

试卷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;
//
private String ny;
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;}
public String getNy() {return ny;}
public void setNy(String ny) {this.ny = ny;}
}

答案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;
//
private String df;
//
private Integer v1;
//
private Integer v2;
//
private Integer v3;
//
private String isdl;
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;}
public String getDf() {return df;}
public void setDf(String df) {this.df = df;}
public Integer getV1() {return v1;}
public void setV1(Integer v1) {this.v1 = v1;}
public Integer getV2() {return v2;}
public void setV2(Integer v2) {this.v2 = v2;}
public Integer getV3() {return v3;}
public void setV3(Integer v3) {this.v3 = v3;}
public String getIsdl() {return isdl;}
public void setIsdl(String isdl) {this.isdl = isdl;}
}

试卷题目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_kc")
public class Kc {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//课程名称
private String kcName;
//图片
private String pic;
//内容说明
private String content;
//课程章节数
private String kczjs;
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
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 getKczjs() {return kczjs;}
public void setKczjs(String kczjs) {this.kczjs = kczjs;}
}

留言javaBean创建语句如下:


package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity

//留言
@Table(name = "t_liuyan")
public class Liuyan {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//发起人
private Integer customerId;
//回复人
private Integer toId;
//发起内容
private String content;
//发起日期
private Date insertDate;
//回复内容
private String back;
//回复时间
private Date backDate;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getToId() {return toId;}
public void setToId(Integer toId) {this.toId = toId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
public Date getBackDate() {return backDate;}
public void setBackDate(Date backDate) {this.backDate = backDate;}
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_ltsm")
public class Ltsm {
//主键
@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;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
}

敏感词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_mgc")
public class Mgc {
//主键
@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 mgc;
public String getMgc() {return mgc;}
public void setMgc(String mgc) {this.mgc = mgc;}
}

评论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_wdhy")
public class Wdhy {
//主键
@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 hhId;
//关注日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getHhId() {return hhId;}
public void setHhId(Integer hhId) {this.hhId = hhId;}
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_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 String nologin;
//
private Integer bkId;
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 String getNologin() {return nologin;}
public void setNologin(String nologin) {this.nologin = nologin;}
public Integer getBkId() {return bkId;}
public void setBkId(Integer bkId) {this.bkId = bkId;}
}

校园新闻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 content;
//图片
private String pic;
//日期
private Date showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}

用户选择课程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_xzkc")
public class Xzkc {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//课程
private Integer kcId;
//用户
private Integer customerId;
//得分
private Integer df;
//最新章节
private Integer zjId;
//评价
private String pj;
//建议
private String jy;
public Integer getKcId() {return kcId;}
public void setKcId(Integer kcId) {this.kcId = kcId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getDf() {return df;}
public void setDf(Integer df) {this.df = df;}
public Integer getZjId() {return zjId;}
public void setZjId(Integer zjId) {this.zjId = zjId;}
public String getPj() {return pj;}
public void setPj(String pj) {this.pj = pj;}
public String getJy() {return jy;}
public void setJy(String jy) {this.jy = jy;}
}

章节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_zj")
public class Zj {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//课程
private Integer kcId;
//章节编号
private String zjbh;
//排序
private Integer px;
//内容
private String content;
//选择题一
private String tm1;
//答案
private String da1;
//选择题二
private String tm2;
//答案
private String da2;
//选择题三
private String tm3;
//答案
private String da3;
public Integer getKcId() {return kcId;}
public void setKcId(Integer kcId) {this.kcId = kcId;}
public String getZjbh() {return zjbh;}
public void setZjbh(String zjbh) {this.zjbh = zjbh;}
public Integer getPx() {return px;}
public void setPx(Integer px) {this.px = px;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getTm1() {return tm1;}
public void setTm1(String tm1) {this.tm1 = tm1;}
public String getDa1() {return da1;}
public void setDa1(String da1) {this.da1 = da1;}
public String getTm2() {return tm2;}
public void setTm2(String tm2) {this.tm2 = tm2;}
public String getDa2() {return da2;}
public void setDa2(String da2) {this.da2 = da2;}
public String getTm3() {return tm3;}
public void setTm3(String tm3) {this.tm3 = tm3;}
public String getDa3() {return da3;}
public void setDa3(String da3) {this.da3 = da3;}
}

基于WEB的编程自学网站spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

论坛版块javaBean创建语句如下:


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

//论坛版块
public class Bk  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//版块名称
private String bkName;
public String getBkName() {return bkName;}
public void setBkName(String bkName) {this.bkName = bkName;}
}

用户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 name;
//手机
private String phone;
//性别
private String sex;
//年龄
private String age;
//地点
private String address;
//工作方向
private String idcard;
//入库日期
private Date insertDate;
//头像
private String headPic;
//层级
private String level;
//发帖权限
private String isft;
//评论权限
private String ispl;
//密保1
private String mb1;
//密保2
private String mb2;
//密保3
private String mb3;
//
private String sj1;
//
private String sj2;
//
private String sj3;
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 getName() {return name;}
public void setName(String name) {this.name = name;}
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 getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
public String getLevel() {return level;}
public void setLevel(String level) {this.level = level;}
public String getIsft() {return isft;}
public void setIsft(String isft) {this.isft = isft;}
public String getIspl() {return ispl;}
public void setIspl(String ispl) {this.ispl = ispl;}
public String getMb1() {return mb1;}
public void setMb1(String mb1) {this.mb1 = mb1;}
public String getMb2() {return mb2;}
public void setMb2(String mb2) {this.mb2 = mb2;}
public String getMb3() {return mb3;}
public void setMb3(String mb3) {this.mb3 = mb3;}
public String getSj1() {return sj1;}
public void setSj1(String sj1) {this.sj1 = sj1;}
public String getSj2() {return sj2;}
public void setSj2(String sj2) {this.sj2 = sj2;}
public String getSj3() {return sj3;}
public void setSj3(String sj3) {this.sj3 = sj3;}
}

试卷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;
//
private String ny;
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;}
public String getNy() {return ny;}
public void setNy(String ny) {this.ny = ny;}
}

答案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;
//
private String df;
//
private Integer v1;
//
private Integer v2;
//
private Integer v3;
//
private String isdl;
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;}
public String getDf() {return df;}
public void setDf(String df) {this.df = df;}
public Integer getV1() {return v1;}
public void setV1(Integer v1) {this.v1 = v1;}
public Integer getV2() {return v2;}
public void setV2(Integer v2) {this.v2 = v2;}
public Integer getV3() {return v3;}
public void setV3(Integer v3) {this.v3 = v3;}
public String getIsdl() {return isdl;}
public void setIsdl(String isdl) {this.isdl = isdl;}
}

试卷题目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 Kc  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//课程名称
private String kcName;
//图片
private String pic;
//内容说明
private String content;
//课程章节数
private String kczjs;
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
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 getKczjs() {return kczjs;}
public void setKczjs(String kczjs) {this.kczjs = kczjs;}
}

留言javaBean创建语句如下:


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

//留言
public class Liuyan  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//发起人
private Integer customerId;
//回复人
private Integer toId;
//发起内容
private String content;
//发起日期
private Date insertDate;
//回复内容
private String back;
//回复时间
private Date backDate;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getToId() {return toId;}
public void setToId(Integer toId) {this.toId = toId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
public Date getBackDate() {return backDate;}
public void setBackDate(Date backDate) {this.backDate = backDate;}
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 Ltsm  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//论坛说明
private String title;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
}

敏感词javaBean创建语句如下:


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

//敏感词
public class Mgc  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//敏感词
private String mgc;
public String getMgc() {return mgc;}
public void setMgc(String mgc) {this.mgc = mgc;}
}

评论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 Wdhy  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//我
private Integer customerId;
//好友
private Integer hhId;
//关注日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getHhId() {return hhId;}
public void setHhId(Integer hhId) {this.hhId = hhId;}
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 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 String nologin;
//
private Integer bkId;
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 String getNologin() {return nologin;}
public void setNologin(String nologin) {this.nologin = nologin;}
public Integer getBkId() {return bkId;}
public void setBkId(Integer bkId) {this.bkId = bkId;}
}

校园新闻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 content;
//图片
private String pic;
//日期
private Date showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}

用户选择课程javaBean创建语句如下:


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

//用户选择课程
public class Xzkc  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//课程
private Integer kcId;
//用户
private Integer customerId;
//得分
private Integer df;
//最新章节
private Integer zjId;
//评价
private String pj;
//建议
private String jy;
public Integer getKcId() {return kcId;}
public void setKcId(Integer kcId) {this.kcId = kcId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getDf() {return df;}
public void setDf(Integer df) {this.df = df;}
public Integer getZjId() {return zjId;}
public void setZjId(Integer zjId) {this.zjId = zjId;}
public String getPj() {return pj;}
public void setPj(String pj) {this.pj = pj;}
public String getJy() {return jy;}
public void setJy(String jy) {this.jy = jy;}
}

章节javaBean创建语句如下:


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

//章节
public class Zj  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//课程
private Integer kcId;
//章节编号
private String zjbh;
//排序
private Integer px;
//内容
private String content;
//选择题一
private String tm1;
//答案
private String da1;
//选择题二
private String tm2;
//答案
private String da2;
//选择题三
private String tm3;
//答案
private String da3;
public Integer getKcId() {return kcId;}
public void setKcId(Integer kcId) {this.kcId = kcId;}
public String getZjbh() {return zjbh;}
public void setZjbh(String zjbh) {this.zjbh = zjbh;}
public Integer getPx() {return px;}
public void setPx(Integer px) {this.px = px;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getTm1() {return tm1;}
public void setTm1(String tm1) {this.tm1 = tm1;}
public String getDa1() {return da1;}
public void setDa1(String da1) {this.da1 = da1;}
public String getTm2() {return tm2;}
public void setTm2(String tm2) {this.tm2 = tm2;}
public String getDa2() {return da2;}
public void setDa2(String da2) {this.da2 = da2;}
public String getTm3() {return tm3;}
public void setTm3(String tm3) {this.tm3 = tm3;}
public String getDa3() {return da3;}
public void setDa3(String da3) {this.da3 = da3;}
}

源代码下载点这里

评论