班级网站
班级网站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_bjjj(
id int primary key auto_increment comment ‘主键’,
content varchar(100) comment ‘班级简介’
) comment ‘班级简介’;
SQLCopy
班级相册表创建语句如下:
create table t_bjxc(
id int primary key auto_increment comment ‘主键’,
studentId int comment ‘学生’,
types varchar(100) comment ‘类别’,
title varchar(100) comment ‘标题’,
pic varchar(100) comment ‘图片’
) comment ‘班级相册’;
SQLCopy
班级新闻表创建语句如下:
create table t_bjxw(
id int primary key auto_increment comment ‘主键’,
title varchar(100) comment ‘标题’,
pic varchar(100) comment ‘图片’,
content varchar(100) comment ‘内容’
) comment ‘班级新闻’;
SQLCopy
班级资源表创建语句如下:
create table t_bjzy(
id int primary key auto_increment comment ‘主键’,
types varchar(100) comment ‘类别’,
title varchar(100) comment ‘标题’,
url varchar(100) comment ‘资源’,
content varchar(100) comment ‘内容’,
remark 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_lyb(
id int primary key auto_increment comment ‘主键’,
studentId int comment ‘学生’,
title varchar(100) comment ‘标题’,
content varchar(100) comment ‘内容’,
insertDate datetime 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 ‘姓名’,
pic varchar(100) comment ‘头像’,
xh varchar(100) comment ‘学号’,
xx varchar(100) comment ‘学校’,
bj varchar(100) comment ‘班级’,
rzzw varchar(100) comment ‘任职职位’,
yx varchar(100) comment ‘院系’,
phone varchar(100) comment ‘电话’,
age varchar(100) comment ‘年龄’,
sex varchar(100) comment ‘性别’
) comment ‘学生’;
SQLCopy
投票表创建语句如下:
create table t_tp(
id int primary key auto_increment comment ‘主键’,
studentId int comment ‘学生’,
title varchar(100) comment ‘投票主题’,
pic varchar(100) comment ‘图片’,
content varchar(100) comment ‘内容’,
status varchar(100) comment ‘状态’,
insertDate datetime comment ‘日期’
) comment ‘投票’;
SQLCopy
投票记录表创建语句如下:
create table t_tplist(
id int primary key auto_increment comment ‘主键’,
studentId int comment ‘学生’,
insertDate datetime comment ‘日期’,
tpId int comment ‘投票’
) comment ‘投票记录’;
SQLCopy
通讯录表创建语句如下:
create table t_txl(
id int primary key auto_increment comment ‘主键’,
xm varchar(100) comment ‘姓名’,
zz varchar(100) comment ‘家庭住址’,
dh varchar(100) comment ‘电话’
) comment ‘通讯录’;
SQLCopy
你问我答表创建语句如下:
create table t_wt(
id int primary key auto_increment comment ‘主键’,
studentId int comment ‘学生’,
title varchar(100) comment ‘标题’,
pic varchar(100) comment ‘图片’,
content varchar(100) comment ‘内容’,
hd varchar(100) comment ‘回答答案’,
status varchar(100) comment ‘状态’,
insertDate datetime 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_bjjj(
id integer,
content varchar(100)
);
–班级简介字段加注释
comment on column t_bjjj.id is ‘主键’;
comment on column t_bjjj.content is ‘班级简介’;
–班级简介表加注释
comment on table t_bjjj is ‘班级简介’;
SQLCopy
班级相册表创建语句如下:
create table t_bjxc(
id integer,
studentId int,
types varchar(100),
title varchar(100),
pic varchar(100)
);
–班级相册字段加注释
comment on column t_bjxc.id is ‘主键’;
comment on column t_bjxc.studentId is ‘学生’;
comment on column t_bjxc.types is ‘类别’;
comment on column t_bjxc.title is ‘标题’;
comment on column t_bjxc.pic is ‘图片’;
–班级相册表加注释
comment on table t_bjxc is ‘班级相册’;
SQLCopy
班级新闻表创建语句如下:
create table t_bjxw(
id integer,
title varchar(100),
pic varchar(100),
content varchar(100)
);
–班级新闻字段加注释
comment on column t_bjxw.id is ‘主键’;
comment on column t_bjxw.title is ‘标题’;
comment on column t_bjxw.pic is ‘图片’;
comment on column t_bjxw.content is ‘内容’;
–班级新闻表加注释
comment on table t_bjxw is ‘班级新闻’;
SQLCopy
班级资源表创建语句如下:
create table t_bjzy(
id integer,
types varchar(100),
title varchar(100),
url varchar(100),
content varchar(100),
remark varchar(100)
);
–班级资源字段加注释
comment on column t_bjzy.id is ‘主键’;
comment on column t_bjzy.types is ‘类别’;
comment on column t_bjzy.title is ‘标题’;
comment on column t_bjzy.url is ‘资源’;
comment on column t_bjzy.content is ‘内容’;
comment on column t_bjzy.remark is ‘备注’;
–班级资源表加注释
comment on table t_bjzy 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_lyb(
id integer,
studentId int,
title varchar(100),
content varchar(100),
insertDate datetime
);
–留言板字段加注释
comment on column t_lyb.id is ‘主键’;
comment on column t_lyb.studentId is ‘学生’;
comment on column t_lyb.title is ‘标题’;
comment on column t_lyb.content is ‘内容’;
comment on column t_lyb.insertDate is ‘留言日期’;
–留言板表加注释
comment on table t_lyb is ‘留言板’;
SQLCopy
学生表创建语句如下:
create table t_student(
id integer,
username varchar(100),
password varchar(100),
studentName varchar(100),
pic varchar(100),
xh varchar(100),
xx varchar(100),
bj varchar(100),
rzzw varchar(100),
yx varchar(100),
phone varchar(100),
age varchar(100),
sex 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_student.pic is ‘头像’;
comment on column t_student.xh is ‘学号’;
comment on column t_student.xx is ‘学校’;
comment on column t_student.bj is ‘班级’;
comment on column t_student.rzzw is ‘任职职位’;
comment on column t_student.yx is ‘院系’;
comment on column t_student.phone is ‘电话’;
comment on column t_student.age is ‘年龄’;
comment on column t_student.sex is ‘性别’;
–学生表加注释
comment on table t_student is ‘学生’;
SQLCopy
投票表创建语句如下:
create table t_tp(
id integ