网上选课系统
网上选课系统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_kc(
id int primary key auto_increment comment ‘主键’,
kcName varchar(100) comment ‘课程名称’,
pic varchar(100) comment ‘图片’,
content varchar(100) comment ‘内容’
) comment ‘课程’;
SQLCopy
课程选择表创建语句如下:
create table t_kcxz(
id int primary key auto_increment comment ‘主键’,
studentId int comment ‘学生’,
kcId int comment ‘课程’,
code int comment ‘分数’,
xq varchar(100) comment ‘学期’
) comment ‘课程选择’;
SQLCopy
学生表创建语句如下:
create table t_student(
id int primary key auto_increment comment ‘主键’,
username varchar(100) comment ‘账号’,
password varchar(100) comment ‘密码’,
studentName varchar(100) comment ‘姓名’,
xh varchar(100) comment ‘学号’,
age varchar(100) comment ‘年龄’,
sex varchar(100) comment ‘性别’,
phone varchar(100) comment ‘电话’,
pic varchar(100) 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 ‘电话’,
pic varchar(100) comment ‘头像’
) comment ‘老师’;
SQLCopy
建议表创建语句如下:
create table t_yj(
id int primary key auto_increment comment ‘主键’,
studentId 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_kc(
id integer,
kcName varchar(100),
pic varchar(100),
content 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 table t_kc is ‘课程’;
SQLCopy
课程选择表创建语句如下:
create table t_kcxz(
id integer,
studentId int,
kcId int,
code int,
xq varchar(100)
);
–课程选择字段加注释
comment on column t_kcxz.id is ‘主键’;
comment on column t_kcxz.studentId is ‘学生’;
comment on column t_kcxz.kcId is ‘课程’;
comment on column t_kcxz.code is ‘分数’;
comment on column t_kcxz.xq is ‘学期’;
–课程选择表加注释
comment on table t_kcxz is ‘课程选择’;
SQLCopy
学生表创建语句如下:
create table t_student(
id integer,
username varchar(100),
password varchar(100),
studentName varchar(100),
xh varchar(100),
age varchar(100),
sex varchar(100),
phone varchar(100),
pic varchar(100)
);
–学生字段加注释
comment on column t_student.id is ‘主键’;
comment on column t_student.username is ‘账号’;
comment on column t_student.password is ‘密码’;
comment on column t_student.studentName is ‘姓名’;
comment on column t_studen