基于web的师生交流平台的设计与实现
基于web的师生交流平台的设计与实现mysql数据库创建语句
基于web的师生交流平台的设计与实现oracle数据库创建语句
基于web的师生交流平台的设计与实现sqlserver数据库创建语句
基于web的师生交流平台的设计与实现spring+springMVC+hibernate框架对象(javaBean,pojo)设计
基于web的师生交流平台的设计与实现spring+springMVC+mybatis框架对象(javaBean,pojo)设计
高质量编程视频:shangyepingtai.xin
基于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’);
SQLCopy
表创建语句如下:
create table t_customer(
id int primary key auto_increment comment ‘主键’,
username varchar(100) comment ‘’,
password varchar(100) comment ‘’,
customerName varchar(100) comment ‘’,
age varchar(100) comment ‘’,
sex varchar(100) comment ‘’,
phone varchar(100) comment ‘’,
status varchar(100) comment ‘’
) comment ‘’;
SQLCopy
表创建语句如下:
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 ‘’;
SQLCopy
表创建语句如下:
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 ‘’;
SQLCopy
表创建语句如下:
create table t_examlist(
id int primary key auto_increment comment ‘主键’,
examId int comment ‘’,
examtmId int comment ‘’
) comment ‘’;
SQLCopy
表创建语句如下:
create table t_examtm(
id int primary key auto_increment comment ‘主键’,
types int comment ‘’,
v1 varchar(100) comment ‘’,
v2 varchar(100) comment ‘’,
v3 varchar(100) comment ‘’,
v4 varchar(100) comment ‘’,
v5 varchar(100) comment ‘’,
v6 varchar(100) comment ‘’,
v7 varchar(100) comment ‘’,
v8 varchar(100) comment ‘’,
v9 varchar(100) comment ‘’,
v10 varchar(100) comment ‘’
) comment ‘’;
SQLCopy
表创建语句如下:
create table t_gg(
id int primary key auto_increment comment ‘主键’,
title varchar(100) comment ‘’,
pic varchar(100) comment ‘’,
content varchar(100) comment ‘’,
showDate datetime comment ‘’
) comment ‘’;
SQLCopy
热门话题表创建语句如下:
create table t_jiaoliu(
id int primary key auto_increment comment ‘主键’,
title varchar(100) comment ‘热门话题’,
pic varchar(100) comment ‘图片’,
content varchar(100) comment ‘内容’,
cNum int comment ‘访问数’,
pNum int comment ‘评论数’,
fqz varchar(100) comment ‘发起者’
) comment ‘热门话题’;
SQLCopy
热门话题交流表创建语句如下:
create table t_jiaoliulist(
id int primary key auto_increment comment ‘主键’,
jiaoliuId int comment ‘话题’,
customerId int comment ‘用户’,
content varchar(100) comment ‘内容’,
insertDate datetime comment ‘日期’,
customerName varchar(100) comment ‘’
) comment ‘热门话题交流’;
SQLCopy
表创建语句如下:
create table t_jj(
id int primary key auto_increment comment ‘主键’,
content varchar(100) comment ‘’
) comment ‘’;
SQLCopy
表创建语句如下:
create table t_kc(
id int primary key auto_increment comment ‘主键’,
teacherId int comment ‘’,
kcName varchar(100) comment ‘’,
address varchar(100) comment ‘附件或视频’,
showDate datetime comment ‘’,
types varchar(100) comment ‘视频@课件’
) comment ‘’;
SQLCopy
课程交流表创建语句如下:
create table t_kcjiaoliu(
id int primary key auto_increment comment ‘主键’,
kcId int comment ‘课程’,
insertDate datetime comment ‘日期’,
content varchar(100) comment ‘内容’,
customerName varchar(100) comment ‘姓名’
) comment ‘课程交流’;
SQLCopy
表创建语句如下:
create table t_qd(
id int primary key auto_increment comment ‘主键’,
customerId int comment ‘’,
insertDate datetime comment ‘’
) comment ‘’;
SQLCopy
表创建语句如下:
create table t_teacher(
id int primary key auto_increment comment ‘主键’,
username varchar(100) comment ‘’,
password varchar(100) comment ‘’,
teacherName varchar(100) comment ‘’,
age varchar(100) comment ‘’,
sex varchar(100) comment ‘’,
phone varchar(100) comment ‘’
) comment ‘’;
SQLCopy
基于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 ‘超级管理员’;
SQLCopy
表创建语句如下:
create table t_customer(
id integer,
username varchar(100),
password varchar(100),
customerName varchar(100),
age varchar(100),
sex varchar(100),
phone varchar(100),
status varchar(100)
);
–字段加注释
comment on column t_customer.id is ‘主键’;
comment on column t_customer.username is ‘’;
comment on column t_customer.password is ‘’;
comment on column t_customer.customerName is ‘’;
comment on column t_customer.age is ‘’;
comment on column t_customer.sex is ‘’;
comment on column t_customer.phone is ‘’;
comment on column t_customer.status is ‘’;
–表加注释
comment on table t_customer is ‘’;
SQLCopy
表创建语句如下:
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 ‘’;
SQLCopy
表创建语句如下:
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 ‘’;
SQLCopy
表创建语句如下:
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 ‘’;
SQLCopy
表创建语句如下:
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 ‘’;
comment on column t_examtm.v3 is ‘’;
comment on column t_examtm.v4 is ‘’;
comment on column t_examtm.v5 is ‘’;
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 ‘’;
SQLCopy
表创建语句如下:
create table t_gg(
id integer,
title varchar(100),
pic varchar(100),
content varchar(100),
showDate datetime
);
–字段加注释
comment on column t_gg.id is ‘主键’;
comment on column t_gg.title is ‘’;
comment on column t_gg.pic is ‘’;
comment on column t_gg.content is ‘’;
comment on column t_gg.showDate is ‘’;
–表加注释
comment on table t_gg is ‘’;
SQLCopy
热门话题表创建语句如下:
create table t_jiaoliu(
id integer,
title varchar(100),
pic varchar(100),
content varchar(100),
cNum int,
pNum int,
fqz varchar(100)
);
–热门话题字段加注释
comment on column t_jiaoliu.id is ‘主键’;
comment on column t_jiaoliu.title is ‘热门话题’;
comment on column t_jiaoliu.pic is ‘图片’;
comment on column t_jiaoliu.content is ‘内容’;
comment on column t_jiaoliu.cNum is ‘访问数’;
comment on column t_jiaoliu.pNum is ‘评论数’;
comment on column t_jiaoliu.fqz is ‘发起者’;
–热门话题表加注释
comment on table t_jiaoliu is ‘热门话题’;
SQLCopy
热门话题交流表创建语句如下:
create table t_jiaoliulist(
id integer,
jiaoliuId int,
customerId int,
content varchar(100),
insertDate datetime,
customerName varchar(100)
);
–热门话题交流字段加注释
comment on column t_jiaoliulist.id is ‘主键’;
comment on column t_jiaoliulist.jiaoliuId is ‘话题’;
comment on column t_jiaoliulist.customerId is ‘用户’;
comment on column t_jiaoliulist.content is ‘内容’;
comment on column t_jiaoliulist.insertDate is ‘日期’;