在线考试系统
在线考试系统mysql数据库创建语句
在线考试系统oracle数据库创建语句
在线考试系统sqlserver数据库创建语句
在线考试系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
在线考试系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
高质量编程视频:shangyepingtai.xin
在线考试系统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_contact(
id int primary key auto_increment comment ‘主键’,
customerId int comment ‘用户’,
phone varchar(100) comment ‘联系方式’,
content varchar(100) comment ‘内容’,
insertDate datetime comment ‘日期’
) comment ‘建议’;
SQLCopy
客户表创建语句如下:
create table t_customer(
id int primary key auto_increment comment ‘主键’,
username varchar(100) comment ‘账号’,
password varchar(100) comment ‘密码’,
name varchar(100) comment ‘姓名’,
sex varchar(100) comment ‘性别’,
address varchar(100) comment ‘地址’,
mobile 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 ‘’,
sj int comment ‘’,
skls varchar(100) comment ‘授课老师’,
skdx varchar(100) comment ‘授课对象’,
sksj varchar(100) comment ‘授课时间’,
skbj varchar(100) comment ‘授课班级’,
skxq varchar(100) comment ‘授课学期’,
ppp 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 ‘’,
skbj varchar(100) comment ‘’,
skxq varchar(100) comment ‘’,
types int comment ‘’,
examId int comment ‘’,
v1all int comment ‘’,
v2all int comment ‘’,
v3all int comment ‘’,
v4all int comment ‘’
) comment ‘答案’;
SQLCopy
表创建语句如下:
create table t_examas(
id int primary key auto_increment comment ‘主键’,
examName varchar(100) comment ‘课程名称’,
showDate varchar(100) comment ‘日期’,
status varchar(100) comment ‘状态’,
ny varchar(100) comment ‘’,
sj int comment ‘’,
skls varchar(100) comment ‘授课老师’,
skdx varchar(100) comment ‘授课对象’,
sksj varchar(100) comment ‘授课时间’,
skbj varchar(100) comment ‘授课班级’,
skxq varchar(100) comment ‘授课学期’,
v1 int comment ‘’,
v2 int comment ‘’,
v3 int comment ‘’,
v4 int 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 ‘选项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 ‘考试题目’;
SQLCopy
课本知识点表创建语句如下:
create table t_kbzsd(
id int primary key auto_increment comment ‘主键’,
title varchar(100) comment ‘标题’,
content varchar(100) comment ‘内容’
) comment ‘课本知识点’;
SQLCopy
考试大纲表创建语句如下:
create table t_ksdg(
id int primary key auto_increment comment ‘主键’,
title varchar(100) comment ‘标题’,
content varchar(100) comment ‘内容’
) comment ‘考试大纲’;
SQLCopy
收藏表创建语句如下:
create table t_sc(
id int primary key auto_increment comment ‘主键’,
customerId int comment ‘学生’,
examtmId int 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 ‘姓名’,
phone varchar(100) comment ‘电话’,
age varchar(100) comment ‘年龄’
) comment ‘老师’;
SQLCopy
知识点表创建语句如下:
create table t_zsd(
id int primary key auto_increment comment ‘主键’,
examId int comment ‘课程’,
title varchar(100) comment ‘知识点说明’,
content varchar(100) comment ‘知识点内容’
) comment ‘知识点’;
SQLCopy
在线考试系统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_contact(
id integer,
customerId int,
phone varchar(100),
content varchar(100),
insertDate datetime
);
–建议字段加注释
comment on column t_contact.id is ‘主键’;
comment on column t_contact.customerId is ‘用户’;
comment on column t_contact.phone is ‘联系方式’;
comment on column t_contact.content is ‘内容’;
comment on column t_contact.insertDate is ‘日期’;
–建议表加注释
comment on table t_contact is ‘建议’;
SQLCopy
客户表创建语句如下:
create table t_customer(
id integer,
username varchar(100),
password varchar(100),
name varchar(100),
sex varchar(100),
address varchar(100),
mobile 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.sex is ‘性别’;
comment on column t_customer.address is ‘地址’;
comment on column t_customer.mobile 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),
sj int,
skls varchar(100),
skdx varchar(100),
sksj varchar(100),
skbj varchar(100),
skxq varchar(100),
ppp 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 column t_exam.sj is ‘’;
comment on column t_exam.skls is ‘授课老师’;
comment on column t_exam.skdx is ‘授课对象’;
comment on column t_exam.sksj is ‘授课时间’;
comment on column t_exam.skbj is ‘授课班级’;
comment on column t_exam.skxq is ‘授课学期’;
comment on column t_exam.ppp 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),
skbj varchar(100),
skxq varchar(100),
types int,
examId int,
v1all int,
v2all int,
v3all int,
v4all int
);
–答案字段加注释
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 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 ‘答案’;
SQLCopy
表创建语句如下:
create table t_examas(
id integer,
examName varchar(100),
showDate varchar(100),
status varchar(100),
ny varchar(100),
sj int,
skls varchar(100),
skdx varchar(100),
sksj varchar(100),
skbj varchar(100),
skxq varchar(100),
v1 int,
v2 int,
v3 int,
v4 int
);
–字段加注释
comment on column t_examas.id is ‘主键’;
comment on column t_examas.examName is ‘课程名称’;
comment on column t_examas.showDate is ‘日期’;
comment on column t_examas.status is ‘状态’;
comment on column t_examas.ny is ‘’;
comment on column t_examas.sj is ‘’;
comment on column t_examas.skls is ‘授课老师’;
comment on column t_examas.skdx is ‘授课对象’;
comment on column t_examas.sksj is ‘授课时间’;
comment on column t_examas.skbj is ‘授课班级’;
comment on column t_examas.skxq is ‘授课学期’;
comment on column t_examas.v1 is ‘’;
comment on column t_examas.v2 is ‘’;
comment on column t_examas.v3 is ‘’;
comment on column t_examas.v4 is ‘’;
–表加注释
comment on table t_examas 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),