基于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(11) comment '用户',phone varchar(100) comment '联系方式',content text 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 '姓名',sex varchar(100) comment '性别',address varchar(100) comment '地址',phone varchar(100) comment '手机',account int(11) comment '账户',jf int(11) comment '积分',headPic varchar(50) comment '头像'
) comment '客户';create table t_examanswer(id int primary key auto_increment comment '主键',customerId int(11) comment '用户',examName varchar(100) comment '试卷名称',insertDate datetime comment '日期',tm text comment '题目',da varchar(1000) comment '客户答案',answer varchar(1000) comment '正确答案',batchId varchar(1000) comment '',df varchar(1000) comment '',v1 int(11) comment '',v2 int(11) comment '',v3 int(11) comment '',isdl varchar(50) comment '',skbj varchar(50) comment '',skxq varchar(50) comment '',types int(11) comment '',examId int(11) comment '',v1all int(11) comment '',v2all int(11) comment '',v3all int(11) comment '',v4all int(11) comment ''
) comment '答案';create table t_examtm(id int primary key auto_increment comment '主键',types int(11) comment '类型',v1 varchar(100) comment '题目标题',v2 varchar(1000) comment '选项A',v3 varchar(1000) comment '选项B',v4 varchar(1000) comment '选项C',v5 varchar(1000) comment '选项D',v6 varchar(1000) comment '答案',v7 varchar(1000) comment '题目',v8 varchar(1000) comment '答案',v9 varchar(1000) comment '题目',v10 varchar(1000) comment '答案'
) comment '考试题目';create table t_lbt(id int primary key auto_increment comment '主键',pic varchar(100) comment '图片',url varchar(1000) comment ''
) comment '轮播图';create table t_pinglun(id int primary key auto_increment comment '主键',wdxxId int(11) comment '评论信息',customerId int(11) comment '评论人',content text comment '评论内容',insertDate datetime comment '评论日期'
) comment '评论';create table t_product(id int primary key auto_increment comment '主键',productName varchar(100) comment '名称',productPic1 varchar(100) comment '图片1',productPic2 varchar(100) comment '',productPic3 varchar(100) comment '',productPic4 varchar(100) comment '',price int(11) comment '',oldPrice int(11) comment '',content text comment '内容',nums int(11) comment '',tjxj varchar(50) comment '',status varchar(50) comment '状态',typesId int(11) comment '分类',jf int(11) comment '',userId int(11) comment '',bqId int(11) comment '标签',djl int(11) comment '点击量'
) comment '内容模块';create table t_productclick(id int primary key auto_increment comment '主键',productId int(11) comment '产品',customerId int(11) comment '用户',insertDate datetime comment '日期'
) comment '产品点击';create table t_types(id int primary key auto_increment comment '主键',typesName varchar(1000) comment '分类'
) comment '分类';create table t_wdxx(id int primary key auto_increment comment '主键',customerId int(11) comment '我',title varchar(100) comment '标题',pic varchar(100) comment '图片',content text comment '内容',zan int(11) comment '赞',insertDate datetime comment '发布日期',nologin varchar(50) comment '游客是否可见',bkId int(11) comment ''
) comment '我的消息';create table t_xiaoxi(id int primary key auto_increment comment '主键',customerId int(11) comment '用户',title varchar(100) comment '标题',content text comment '内容',insertDate datetime comment '日期'
) comment '消息';create table t_zx(id int primary key auto_increment comment '主键',title varchar(100) comment '标题',content longtext comment '内容',pic varchar(100) comment '图片'
) comment '资讯';#############oracle数据库创建语句###################
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(11) comment '用户',phone varchar(100) comment '联系方式',content text 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 '姓名',sex varchar(100) comment '性别',address varchar(100) comment '地址',phone varchar(100) comment '手机',account int(11) comment '账户',jf int(11) comment '积分',headPic varchar(50) comment '头像'
) comment '客户';create table t_examanswer(id int primary key auto_increment comment '主键',customerId int(11) comment '用户',examName varchar(100) comment '试卷名称',insertDate datetime comment '日期',tm text comment '题目',da varchar(1000) comment '客户答案',answer varchar(1000) comment '正确答案',batchId varchar(1000) comment '',df varchar(1000) comment '',v1 int(11) comment '',v2 int(11) comment '',v3 int(11) comment '',isdl varchar(50) comment '',skbj varchar(50) comment '',skxq varchar(50) comment '',types int(11) comment '',examId int(11) comment '',v1all int(11) comment '',v2all int(11) comment '',v3all int(11) comment '',v4all int(11) comment ''
) comment '答案';create table t_examtm(id int primary key auto_increment comment '主键',types int(11) comment '类型',v1 varchar(100) comment '题目标题',v2 varchar(1000) comment '选项A',v3 varchar(1000) comment '选项B',v4 varchar(1000) comment '选项C',v5 varchar(1000) comment '选项D',v6 varchar(1000) comment '答案',v7 varchar(1000) comment '题目',v8 varchar(1000) comment '答案',v9 varchar(1000) comment '题目',v10 varchar(1000) comment '答案'
) comment '考试题目';create table t_lbt(id int primary key auto_increment comment '主键',pic varchar(100) comment '图片',url varchar(1000) comment ''
) comment '轮播图';create table t_pinglun(id int primary key auto_increment comment '主键',wdxxId int(11) comment '评论信息',customerId int(11) comment '评论人',content text comment '评论内容',insertDate datetime comment '评论日期'
) comment '评论';create table t_product(id int primary key auto_increment comment '主键',productName varchar(100) comment '名称',productPic1 varchar(100) comment '图片1',productPic2 varchar(100) comment '',productPic3 varchar(100) comment '',productPic4 varchar(100) comment '',price int(11) comment '',oldPrice int(11) comment '',content text comment '内容',nums int(11) comment '',tjxj varchar(50) comment '',status varchar(50) comment '状态',typesId int(11) comment '分类',jf int(11) comment '',userId int(11) comment '',bqId int(11) comment '标签',djl int(11) comment '点击量'
) comment '内容模块';create table t_productclick(id int primary key auto_increment comment '主键',productId int(11) comment '产品',customerId int(11) comment '用户',insertDate datetime comment '日期'
) comment '产品点击';create table t_types(id int primary key auto_increment comment '主键',typesName varchar(1000) comment '分类'
) comment '分类';create table t_wdxx(id int primary key auto_increment comment '主键',customerId int(11) comment '我',title varchar(100) comment '标题',pic varchar(100) comment '图片',content text comment '内容',zan int(11) comment '赞',insertDate datetime comment '发布日期',nologin varchar(50) comment '游客是否可见',bkId int(11) comment ''
) comment '我的消息';create table t_xiaoxi(id int primary key auto_increment comment '主键',customerId int(11) comment '用户',title varchar(100) comment '标题',content text comment '内容',insertDate datetime comment '日期'
) comment '消息';create table t_zx(id int primary key auto_increment comment '主键',title varchar(100) comment '标题',content longtext comment '内容',pic varchar(100) comment '图片'
) comment '资讯';create table t_contact(id integer,customerId int(11),phone varchar(100),content text,insertDate datetime
);
--建议字段加注释
comment on column t_contact.id is '主键';
comment on column t_contact.id is '主键唯一ID';
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),sex varchar(100),address varchar(100),phone varchar(100),account int(11),jf int(11),headPic varchar(50)
);
--客户字段加注释
comment on column t_customer.id is '主键';
comment on column t_customer.id is '主键唯一ID';
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.sex is '性别';
comment on column t_customer.address is '地址';
comment on column t_customer.phone is '手机';
comment on column t_customer.account is '账户';
comment on column t_customer.jf is '积分';
comment on column t_customer.headPic is '头像';
--客户表加注释
comment on table t_customer is '客户';create table t_examanswer(id integer,customerId int(11),examName varchar(100),insertDate datetime,tm text,da varchar(1000),answer varchar(1000),batchId varchar(1000),df varchar(1000),v1 int(11),v2 int(11),v3 int(11),isdl varchar(50),skbj varchar(50),skxq varchar(50),types int(11),examId int(11),v1all int(11),v2all int(11),v3all int(11),v4all int(11)
);
--答案字段加注释
comment on column t_examanswer.id is '主键';
comment on column t_examanswer.id is '主键唯一ID';
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 column t_examanswer.skbj is '';
comment on column t_examanswer.skxq is '';
comment on column t_examanswer.types is '';
comment on column t_examanswer.examId is '';
comment on column t_examanswer.v1all is '';
comment on column t_examanswer.v2all is '';
comment on column t_examanswer.v3all is '';
comment on column t_examanswer.v4all is '';
--答案表加注释
comment on table t_examanswer is '答案';create table t_examtm(id integer,types int(11),v1 varchar(100),v2 varchar(1000),v3 varchar(1000),v4 varchar(1000),v5 varchar(1000),v6 varchar(1000),v7 varchar(1000),v8 varchar(1000),v9 varchar(1000),v10 varchar(1000)
);
--考试题目字段加注释
comment on column t_examtm.id is '主键';
comment on column t_examtm.id is '主键唯一ID';
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_lbt(id integer,pic varchar(100),url varchar(1000)
);
--轮播图字段加注释
comment on column t_lbt.id is '主键';
comment on column t_lbt.id is '主键唯一ID';
comment on column t_lbt.pic is '图片';
comment on column t_lbt.url is '';
--轮播图表加注释
comment on table t_lbt is '轮播图';create table t_pinglun(id integer,wdxxId int(11),customerId int(11),content text,insertDate datetime
);
--评论字段加注释
comment on column t_pinglun.id is '主键';
comment on column t_pinglun.id is '主键唯一ID';
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_product(id integer,productName varchar(100),productPic1 varchar(100),productPic2 varchar(100),productPic3 varchar(100),productPic4 varchar(100),price int(11),oldPrice int(11),content text,nums int(11),tjxj varchar(50),status varchar(50),typesId int(11),jf int(11),userId int(11),bqId int(11),djl int(11)
);
--内容模块字段加注释
comment on column t_product.id is '主键';
comment on column t_product.id is '主键唯一ID';
comment on column t_product.productName is '名称';
comment on column t_product.productPic1 is '图片1';
comment on column t_product.productPic2 is '';
comment on column t_product.productPic3 is '';
comment on column t_product.productPic4 is '';
comment on column t_product.price is '';
comment on column t_product.oldPrice is '';
comment on column t_product.content is '内容';
comment on column t_product.nums is '';
comment on column t_product.tjxj is '';
comment on column t_product.status is '状态';
comment on column t_product.typesId is '分类';
comment on column t_product.jf is '';
comment on column t_product.userId is '';
comment on column t_product.bqId is '标签';
comment on column t_product.djl is '点击量';
--内容模块表加注释
comment on table t_product is '内容模块';create table t_productclick(id integer,productId int(11),customerId int(11),insertDate datetime
);
--产品点击字段加注释
comment on column t_productclick.id is '主键';
comment on column t_productclick.id is '主键唯一ID';
comment on column t_productclick.productId is '产品';
comment on column t_productclick.customerId is '用户';
comment on column t_productclick.insertDate is '日期';
--产品点击表加注释
comment on table t_productclick is '产品点击';create table t_types(id integer,typesName varchar(1000)
);
--分类字段加注释
comment on column t_types.id is '主键';
comment on column t_types.id is '主键唯一ID';
comment on column t_types.typesName is '分类';
--分类表加注释
comment on table t_types is '分类';create table t_wdxx(id integer,customerId int(11),title varchar(100),pic varchar(100),content text,zan int(11),insertDate datetime,nologin varchar(50),bkId int(11)
);
--我的消息字段加注释
comment on column t_wdxx.id is '主键';
comment on column t_wdxx.id is '主键唯一ID';
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_xiaoxi(id integer,customerId int(11),title varchar(100),content text,insertDate datetime
);
--消息字段加注释
comment on column t_xiaoxi.id is '主键';
comment on column t_xiaoxi.id is '主键唯一ID';
comment on column t_xiaoxi.customerId is '用户';
comment on column t_xiaoxi.title is '标题';
comment on column t_xiaoxi.content is '内容';
comment on column t_xiaoxi.insertDate is '日期';
--消息表加注释
comment on table t_xiaoxi is '消息';create table t_zx(id integer,title varchar(100),content longtext,pic varchar(100)
);
--资讯字段加注释
comment on column t_zx.id is '主键';
comment on column t_zx.id is '主键唯一ID';
comment on column t_zx.title is '标题';
comment on column t_zx.content is '内容';
comment on column t_zx.pic is '图片';
--资讯表加注释
comment on table t_zx is '资讯';#############sqlserver数据库创建语句###################
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(11) comment '用户',phone varchar(100) comment '联系方式',content text 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 '姓名',sex varchar(100) comment '性别',address varchar(100) comment '地址',phone varchar(100) comment '手机',account int(11) comment '账户',jf int(11) comment '积分',headPic varchar(50) comment '头像'
) comment '客户';create table t_examanswer(id int primary key auto_increment comment '主键',customerId int(11) comment '用户',examName varchar(100) comment '试卷名称',insertDate datetime comment '日期',tm text comment '题目',da varchar(1000) comment '客户答案',answer varchar(1000) comment '正确答案',batchId varchar(1000) comment '',df varchar(1000) comment '',v1 int(11) comment '',v2 int(11) comment '',v3 int(11) comment '',isdl varchar(50) comment '',skbj varchar(50) comment '',skxq varchar(50) comment '',types int(11) comment '',examId int(11) comment '',v1all int(11) comment '',v2all int(11) comment '',v3all int(11) comment '',v4all int(11) comment ''
) comment '答案';create table t_examtm(id int primary key auto_increment comment '主键',types int(11) comment '类型',v1 varchar(100) comment '题目标题',v2 varchar(1000) comment '选项A',v3 varchar(1000) comment '选项B',v4 varchar(1000) comment '选项C',v5 varchar(1000) comment '选项D',v6 varchar(1000) comment '答案',v7 varchar(1000) comment '题目',v8 varchar(1000) comment '答案',v9 varchar(1000) comment '题目',v10 varchar(1000) comment '答案'
) comment '考试题目';create table t_lbt(id int primary key auto_increment comment '主键',pic varchar(100) comment '图片',url varchar(1000) comment ''
) comment '轮播图';create table t_pinglun(id int primary key auto_increment comment '主键',wdxxId int(11) comment '评论信息',customerId int(11) comment '评论人',content text comment '评论内容',insertDate datetime comment '评论日期'
) comment '评论';create table t_product(id int primary key auto_increment comment '主键',productName varchar(100) comment '名称',productPic1 varchar(100) comment '图片1',productPic2 varchar(100) comment '',productPic3 varchar(100) comment '',productPic4 varchar(100) comment '',price int(11) comment '',oldPrice int(11) comment '',content text comment '内容',nums int(11) comment '',tjxj varchar(50) comment '',status varchar(50) comment '状态',typesId int(11) comment '分类',jf int(11) comment '',userId int(11) comment '',bqId int(11) comment '标签',djl int(11) comment '点击量'
) comment '内容模块';create table t_productclick(id int primary key auto_increment comment '主键',productId int(11) comment '产品',customerId int(11) comment '用户',insertDate datetime comment '日期'
) comment '产品点击';create table t_types(id int primary key auto_increment comment '主键',typesName varchar(1000) comment '分类'
) comment '分类';create table t_wdxx(id int primary key auto_increment comment '主键',customerId int(11) comment '我',title varchar(100) comment '标题',pic varchar(100) comment '图片',content text comment '内容',zan int(11) comment '赞',insertDate datetime comment '发布日期',nologin varchar(50) comment '游客是否可见',bkId int(11) comment ''
) comment '我的消息';create table t_xiaoxi(id int primary key auto_increment comment '主键',customerId int(11) comment '用户',title varchar(100) comment '标题',content text comment '内容',insertDate datetime comment '日期'
) comment '消息';create table t_zx(id int primary key auto_increment comment '主键',title varchar(100) comment '标题',content longtext comment '内容',pic varchar(100) comment '图片'
) comment '资讯';create table t_contact(id integer,customerId int(11),phone varchar(100),content text,insertDate datetime
);
--建议字段加注释
comment on column t_contact.id is '主键';
comment on column t_contact.id is '主键唯一ID';
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),sex varchar(100),address varchar(100),phone varchar(100),account int(11),jf int(11),headPic varchar(50)
);
--客户字段加注释
comment on column t_customer.id is '主键';
comment on column t_customer.id is '主键唯一ID';
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.sex is '性别';
comment on column t_customer.address is '地址';
comment on column t_customer.phone is '手机';
comment on column t_customer.account is '账户';
comment on column t_customer.jf is '积分';
comment on column t_customer.headPic is '头像';
--客户表加注释
comment on table t_customer is '客户';create table t_examanswer(id integer,customerId int(11),examName varchar(100),insertDate datetime,tm text,da varchar(1000),answer varchar(1000),batchId varchar(1000),df varchar(1000),v1 int(11),v2 int(11),v3 int(11),isdl varchar(50),skbj varchar(50),skxq varchar(50),types int(11),examId int(11),v1all int(11),v2all int(11),v3all int(11),v4all int(11)
);
--答案字段加注释
comment on column t_examanswer.id is '主键';
comment on column t_examanswer.id is '主键唯一ID';
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 column t_examanswer.skbj is '';
comment on column t_examanswer.skxq is '';
comment on column t_examanswer.types is '';
comment on column t_examanswer.examId is '';
comment on column t_examanswer.v1all is '';
comment on column t_examanswer.v2all is '';
comment on column t_examanswer.v3all is '';
comment on column t_examanswer.v4all is '';
--答案表加注释
comment on table t_examanswer is '答案';create table t_examtm(id integer,types int(11),v1 varchar(100),v2 varchar(1000),v3 varchar(1000),v4 varchar(1000),v5 varchar(1000),v6 varchar(1000),v7 varchar(1000),v8 varchar(1000),v9 varchar(1000),v10 varchar(1000)
);
--考试题目字段加注释
comment on column t_examtm.id is '主键';
comment on column t_examtm.id is '主键唯一ID';
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_lbt(id integer,pic varchar(100),url varchar(1000)
);
--轮播图字段加注释
comment on column t_lbt.id is '主键';
comment on column t_lbt.id is '主键唯一ID';
comment on column t_lbt.pic is '图片';
comment on column t_lbt.url is '';
--轮播图表加注释
comment on table t_lbt is '轮播图';create table t_pinglun(id integer,wdxxId int(11),customerId int(11),content text,insertDate datetime
);
--评论字段加注释
comment on column t_pinglun.id is '主键';
comment on column t_pinglun.id is '主键唯一ID';
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_product(id integer,productName varchar(100),productPic1 varchar(100),productPic2 varchar(100),productPic3 varchar(100),productPic4 varchar(100),price int(11),oldPrice int(11),content text,nums int(11),tjxj varchar(50),status varchar(50),typesId int(11),jf int(11),userId int(11),bqId int(11),djl int(11)
);
--内容模块字段加注释
comment on column t_product.id is '主键';
comment on column t_product.id is '主键唯一ID';
comment on column t_product.productName is '名称';
comment on column t_product.productPic1 is '图片1';
comment on column t_product.productPic2 is '';
comment on column t_product.productPic3 is '';
comment on column t_product.productPic4 is '';
comment on column t_product.price is '';
comment on column t_product.oldPrice is '';
comment on column t_product.content is '内容';
comment on column t_product.nums is '';
comment on column t_product.tjxj is '';
comment on column t_product.status is '状态';
comment on column t_product.typesId is '分类';
comment on column t_product.jf is '';
comment on column t_product.userId is '';
comment on column t_product.bqId is '标签';
comment on column t_product.djl is '点击量';
--内容模块表加注释
comment on table t_product is '内容模块';create table t_productclick(id integer,productId int(11),customerId int(11),insertDate datetime
);
--产品点击字段加注释
comment on column t_productclick.id is '主键';
comment on column t_productclick.id is '主键唯一ID';
comment on column t_productclick.productId is '产品';
comment on column t_productclick.customerId is '用户';
comment on column t_productclick.insertDate is '日期';
--产品点击表加注释
comment on table t_productclick is '产品点击';create table t_types(id integer,typesName varchar(1000)
);
--分类字段加注释
comment on column t_types.id is '主键';
comment on column t_types.id is '主键唯一ID';
comment on column t_types.typesName is '分类';
--分类表加注释
comment on table t_types is '分类';create table t_wdxx(id integer,customerId int(11),title varchar(100),pic varchar(100),content text,zan int(11),insertDate datetime,nologin varchar(50),bkId int(11)
);
--我的消息字段加注释
comment on column t_wdxx.id is '主键';
comment on column t_wdxx.id is '主键唯一ID';
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_xiaoxi(id integer,customerId int(11),title varchar(100),content text,insertDate datetime
);
--消息字段加注释
comment on column t_xiaoxi.id is '主键';
comment on column t_xiaoxi.id is '主键唯一ID';
comment on column t_xiaoxi.customerId is '用户';
comment on column t_xiaoxi.title is '标题';
comment on column t_xiaoxi.content is '内容';
comment on column t_xiaoxi.insertDate is '日期';
--消息表加注释
comment on table t_xiaoxi is '消息';create table t_zx(id integer,title varchar(100),content longtext,pic varchar(100)
);
--资讯字段加注释
comment on column t_zx.id is '主键';
comment on column t_zx.id is '主键唯一ID';
comment on column t_zx.title is '标题';
comment on column t_zx.content is '内容';
comment on column t_zx.pic is '图片';
--资讯表加注释
comment on table t_zx is '资讯';--建议表注释
create table t_contact(id int identity(1,1) primary key not null,--主键customerId int(11),--用户phone varchar(100),--联系方式content text,--内容insertDate datetime--日期
);--客户表注释
create table t_customer(id int identity(1,1) primary key not null,--主键username varchar(100),--账号password varchar(100),--密码customerName varchar(100),--姓名sex varchar(100),--性别address varchar(100),--地址phone varchar(100),--手机account int(11),--账户jf int(11),--积分headPic varchar(50)--头像
);--答案表注释
create table t_examanswer(id int identity(1,1) primary key not null,--主键customerId int(11),--用户examName varchar(100),--试卷名称insertDate datetime,--日期tm text,--题目da varchar(1000),--客户答案answer varchar(1000),--正确答案batchId varchar(1000),--df varchar(1000),--v1 int(11),--v2 int(11),--v3 int(11),--isdl varchar(50),--skbj varchar(50),--skxq varchar(50),--types int(11),--examId int(11),--v1all int(11),--v2all int(11),--v3all int(11),--v4all int(11)--
);--考试题目表注释
create table t_examtm(id int identity(1,1) primary key not null,--主键types int(11),--类型v1 varchar(100),--题目标题v2 varchar(1000),--选项Av3 varchar(1000),--选项Bv4 varchar(1000),--选项Cv5 varchar(1000),--选项Dv6 varchar(1000),--答案v7 varchar(1000),--题目v8 varchar(1000),--答案v9 varchar(1000),--题目v10 varchar(1000)--答案
);--轮播图表注释
create table t_lbt(id int identity(1,1) primary key not null,--主键pic varchar(100),--图片url varchar(1000)--
);--评论表注释
create table t_pinglun(id int identity(1,1) primary key not null,--主键wdxxId int(11),--评论信息customerId int(11),--评论人content text,--评论内容insertDate datetime--评论日期
);--内容模块表注释
create table t_product(id int identity(1,1) primary key not null,--主键productName varchar(100),--名称productPic1 varchar(100),--图片1productPic2 varchar(100),--productPic3 varchar(100),--productPic4 varchar(100),--price int(11),--oldPrice int(11),--content text,--内容nums int(11),--tjxj varchar(50),--status varchar(50),--状态typesId int(11),--分类jf int(11),--userId int(11),--bqId int(11),--标签djl int(11)--点击量
);--产品点击表注释
create table t_productclick(id int identity(1,1) primary key not null,--主键productId int(11),--产品customerId int(11),--用户insertDate datetime--日期
);--分类表注释
create table t_types(id int identity(1,1) primary key not null,--主键typesName varchar(1000)--分类
);--我的消息表注释
create table t_wdxx(id int identity(1,1) primary key not null,--主键customerId int(11),--我title varchar(100),--标题pic varchar(100),--图片content text,--内容zan int(11),--赞insertDate datetime,--发布日期nologin varchar(50),--游客是否可见bkId int(11)--
);--消息表注释
create table t_xiaoxi(id int identity(1,1) primary key not null,--主键customerId int(11),--用户title varchar(100),--标题content text,--内容insertDate datetime--日期
);--资讯表注释
create table t_zx(id int identity(1,1) primary key not null,--主键title varchar(100),--标题content longtext,--内容pic varchar(100)--图片
);

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;}
//主键唯一ID
private int id;
//用户
private int customerId;
//联系方式
private String phone;
//内容
private String content;
//日期
private Date insertDate;
public int getId() {return id;}
public void setId(int id) {this.id = id;}
public int getCustomerId() {return customerId;}
public void setCustomerId(int 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;}
}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;}
//主键唯一ID
private int id;
//账号
private String username;
//密码
private String password;
//姓名
private String customerName;
//性别
private String sex;
//地址
private String address;
//手机
private String phone;
//账户
private int account;
//积分
private int jf;
//头像
private String headPic;
public int getId() {return id;}
public void setId(int id) {this.id = id;}
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 getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public int getAccount() {return account;}
public void setAccount(int account) {this.account = account;}
public int getJf() {return jf;}
public void setJf(int jf) {this.jf = jf;}
public String getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
}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;}
//主键唯一ID
private int id;
//用户
private int customerId;
//试卷名称
private String examName;
//日期
private Date insertDate;
//题目
private String tm;
//客户答案
private String da;
//正确答案
private String answer;
//
private String batchId;
//
private String df;
//
private int v1;
//
private int v2;
//
private int v3;
//
private String isdl;
//
private String skbj;
//
private String skxq;
//
private int types;
//
private int examId;
//
private int v1all;
//
private int v2all;
//
private int v3all;
//
private int v4all;
public int getId() {return id;}
public void setId(int id) {this.id = id;}
public int getCustomerId() {return customerId;}
public void setCustomerId(int 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 int getV1() {return v1;}
public void setV1(int v1) {this.v1 = v1;}
public int getV2() {return v2;}
public void setV2(int v2) {this.v2 = v2;}
public int getV3() {return v3;}
public void setV3(int v3) {this.v3 = v3;}
public String getIsdl() {return isdl;}
public void setIsdl(String isdl) {this.isdl = isdl;}
public String getSkbj() {return skbj;}
public void setSkbj(String skbj) {this.skbj = skbj;}
public String getSkxq() {return skxq;}
public void setSkxq(String skxq) {this.skxq = skxq;}
public int getTypes() {return types;}
public void setTypes(int types) {this.types = types;}
public int getExamId() {return examId;}
public void setExamId(int examId) {this.examId = examId;}
public int getV1all() {return v1all;}
public void setV1all(int v1all) {this.v1all = v1all;}
public int getV2all() {return v2all;}
public void setV2all(int v2all) {this.v2all = v2all;}
public int getV3all() {return v3all;}
public void setV3all(int v3all) {this.v3all = v3all;}
public int getV4all() {return v4all;}
public void setV4all(int v4all) {this.v4all = v4all;}
}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;}
//主键唯一ID
private int id;
//类型
private int 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 int getId() {return id;}
public void setId(int id) {this.id = id;}
public int getTypes() {return types;}
public void setTypes(int 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;}
}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;}
//主键唯一ID
private int id;
//图片
private String pic;
//
private String url;
public int getId() {return id;}
public void setId(int id) {this.id = id;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getUrl() {return url;}
public void setUrl(String url) {this.url = url;}
}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;}
//主键唯一ID
private int id;
//评论信息
private int wdxxId;
//评论人
private int customerId;
//评论内容
private String content;
//评论日期
private Date insertDate;
public int getId() {return id;}
public void setId(int id) {this.id = id;}
public int getWdxxId() {return wdxxId;}
public void setWdxxId(int wdxxId) {this.wdxxId = wdxxId;}
public int getCustomerId() {return customerId;}
public void setCustomerId(int 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;}
}package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;//内容模块
public class Product  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//主键唯一ID
private int id;
//名称
private String productName;
//图片1
private String productPic1;
//
private String productPic2;
//
private String productPic3;
//
private String productPic4;
//
private int price;
//
private int oldPrice;
//内容
private String content;
//
private int nums;
//
private String tjxj;
//状态
private String status;
//分类
private int typesId;
//
private int jf;
//
private int userId;
//标签
private int bqId;
//点击量
private int djl;
public int getId() {return id;}
public void setId(int id) {this.id = id;}
public String getProductName() {return productName;}
public void setProductName(String productName) {this.productName = productName;}
public String getProductPic1() {return productPic1;}
public void setProductPic1(String productPic1) {this.productPic1 = productPic1;}
public String getProductPic2() {return productPic2;}
public void setProductPic2(String productPic2) {this.productPic2 = productPic2;}
public String getProductPic3() {return productPic3;}
public void setProductPic3(String productPic3) {this.productPic3 = productPic3;}
public String getProductPic4() {return productPic4;}
public void setProductPic4(String productPic4) {this.productPic4 = productPic4;}
public int getPrice() {return price;}
public void setPrice(int price) {this.price = price;}
public int getOldPrice() {return oldPrice;}
public void setOldPrice(int oldPrice) {this.oldPrice = oldPrice;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public int getNums() {return nums;}
public void setNums(int nums) {this.nums = nums;}
public String getTjxj() {return tjxj;}
public void setTjxj(String tjxj) {this.tjxj = tjxj;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public int getTypesId() {return typesId;}
public void setTypesId(int typesId) {this.typesId = typesId;}
public int getJf() {return jf;}
public void setJf(int jf) {this.jf = jf;}
public int getUserId() {return userId;}
public void setUserId(int userId) {this.userId = userId;}
public int getBqId() {return bqId;}
public void setBqId(int bqId) {this.bqId = bqId;}
public int getDjl() {return djl;}
public void setDjl(int djl) {this.djl = djl;}
}package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;//产品点击
public class Productclick  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//主键唯一ID
private int id;
//产品
private int productId;
//用户
private int customerId;
//日期
private Date insertDate;
public int getId() {return id;}
public void setId(int id) {this.id = id;}
public int getProductId() {return productId;}
public void setProductId(int productId) {this.productId = productId;}
public int getCustomerId() {return customerId;}
public void setCustomerId(int customerId) {this.customerId = customerId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;//分类
public class Types  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//主键唯一ID
private int id;
//分类
private String typesName;
public int getId() {return id;}
public void setId(int id) {this.id = id;}
public String getTypesName() {return typesName;}
public void setTypesName(String typesName) {this.typesName = typesName;}
}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;}
//主键唯一ID
private int id;
//我
private int customerId;
//标题
private String title;
//图片
private String pic;
//内容
private String content;
//赞
private int zan;
//发布日期
private Date insertDate;
//游客是否可见
private String nologin;
//
private int bkId;
public int getId() {return id;}
public void setId(int id) {this.id = id;}
public int getCustomerId() {return customerId;}
public void setCustomerId(int 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 int getZan() {return zan;}
public void setZan(int 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 int getBkId() {return bkId;}
public void setBkId(int bkId) {this.bkId = bkId;}
}package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;//消息
public class Xiaoxi  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//主键唯一ID
private int id;
//用户
private int customerId;
//标题
private String title;
//内容
private String content;
//日期
private Date insertDate;
public int getId() {return id;}
public void setId(int id) {this.id = id;}
public int getCustomerId() {return customerId;}
public void setCustomerId(int customerId) {this.customerId = customerId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;//资讯
public class Zx  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//主键唯一ID
private int id;
//标题
private String title;
//内容
private String content;
//图片
private String pic;
public int getId() {return id;}
public void setId(int id) {this.id = id;}
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;}
}