校园学车预约平台
发布时间
阅读量：
阅读量
#############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_car(
id int primary key auto_increment comment '主键',
carName varchar(100) comment '车辆编号',
pic varchar(100) comment '牌照',
pp varchar(100) comment '品牌',
content text comment '备注'
) comment '车辆';
create table t_cd(
id int primary key auto_increment comment '主键',
cdName varchar(100) comment '场地编号',
pic varchar(100) comment '拍照',
pp varchar(100) comment '详细地址',
content text 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 '姓名',
headPic varchar(100) comment '头像',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别'
) comment '学员';
create table t_gg(
id int primary key auto_increment comment '主键',
ggName varchar(100) comment '标题',
content text comment '内容',
insertDate datetime comment '日期'
) comment '公告';
create table t_pj(
id int primary key auto_increment comment '主键',
customerId int(11) comment '学员',
teacherId int(11) comment '教练',
content text comment '评价',
pf int(11) comment '评分',
insertDate datetime comment '发起日期'
) comment '教练评价';
create table t_shipin(
id int primary key auto_increment comment '主键',
shipinName varchar(100) comment '视频名称',
fileUrl varchar(100) comment '视频',
content text comment '视频内容简介'
) comment '培训视频';
create table t_sqxm(
id int primary key auto_increment comment '主键',
customerId int(11) comment '学员',
title varchar(100) comment '申请项目',
content text comment '申请备注',
insertDate datetime comment '申请日期',
back text comment '回复',
status varchar(100) comment '状态'
) comment '申请项目';
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 '年龄',
sex varchar(100) comment '性别',
headPic varchar(100) comment '头像'
) comment '教练';
create table t_wt(
id int primary key auto_increment comment '主键',
customerId int(11) comment '学员',
wtName varchar(100) comment '问题说明',
content text comment '详细内容',
insertDate datetime comment '发起日期',
back text comment '回复',
status varchar(100) comment '状态'
) comment '问题';
create table t_yy(
id int primary key auto_increment comment '主键',
customerId int(11) comment '学员',
content text comment '预约说明',
showDate datetime comment '预约日期',
teacherId int(11) comment '选择教练',
yyxm varchar(100) comment '项目',
back text comment '回复',
status varchar(100) comment '状态'
) comment '预约学车';
create table t_ziyuan(
id int primary key auto_increment comment '主键',
ziyuanName varchar(100) comment '资源名称',
pic varchar(100) comment '图片',
fileUrl varchar(100) comment '附件',
content text comment '资源说明'
) comment '课程资源';
create table t_zj(
id int primary key auto_increment comment '主键',
customerId int(11) comment '学员',
xf int(11) comment '学费金额',
mm varchar(100) comment '学费名目',
showDate datetime comment '上交日期',
content text 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_car(
id int primary key auto_increment comment '主键',
carName varchar(100) comment '车辆编号',
pic varchar(100) comment '牌照',
pp varchar(100) comment '品牌',
content text comment '备注'
) comment '车辆';
create table t_cd(
id int primary key auto_increment comment '主键',
cdName varchar(100) comment '场地编号',
pic varchar(100) comment '拍照',
pp varchar(100) comment '详细地址',
content text 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 '姓名',
headPic varchar(100) comment '头像',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别'
) comment '学员';
create table t_gg(
id int primary key auto_increment comment '主键',
ggName varchar(100) comment '标题',
content text comment '内容',
insertDate datetime comment '日期'
) comment '公告';
create table t_pj(
id int primary key auto_increment comment '主键',
customerId int(11) comment '学员',
teacherId int(11) comment '教练',
content text comment '评价',
pf int(11) comment '评分',
insertDate datetime comment '发起日期'
) comment '教练评价';
create table t_shipin(
id int primary key auto_increment comment '主键',
shipinName varchar(100) comment '视频名称',
fileUrl varchar(100) comment '视频',
content text comment '视频内容简介'
) comment '培训视频';
create table t_sqxm(
id int primary key auto_increment comment '主键',
customerId int(11) comment '学员',
title varchar(100) comment '申请项目',
content text comment '申请备注',
insertDate datetime comment '申请日期',
back text comment '回复',
status varchar(100) comment '状态'
) comment '申请项目';
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 '年龄',
sex varchar(100) comment '性别',
headPic varchar(100) comment '头像'
) comment '教练';
create table t_wt(
id int primary key auto_increment comment '主键',
customerId int(11) comment '学员',
wtName varchar(100) comment '问题说明',
content text comment '详细内容',
insertDate datetime comment '发起日期',
back text comment '回复',
status varchar(100) comment '状态'
) comment '问题';
create table t_yy(
id int primary key auto_increment comment '主键',
customerId int(11) comment '学员',
content text comment '预约说明',
showDate datetime comment '预约日期',
teacherId int(11) comment '选择教练',
yyxm varchar(100) comment '项目',
back text comment '回复',
status varchar(100) comment '状态'
) comment '预约学车';
create table t_ziyuan(
id int primary key auto_increment comment '主键',
ziyuanName varchar(100) comment '资源名称',
pic varchar(100) comment '图片',
fileUrl varchar(100) comment '附件',
content text comment '资源说明'
) comment '课程资源';
create table t_zj(
id int primary key auto_increment comment '主键',
customerId int(11) comment '学员',
xf int(11) comment '学费金额',
mm varchar(100) comment '学费名目',
showDate datetime comment '上交日期',
content text comment '备注'
) comment '学费资金';
create table t_car(
id integer,
carName varchar(100),
pic varchar(100),
pp varchar(100),
content text
);
--车辆字段加注释
comment on column t_car.id is '主键';
comment on column t_car.id is '主键唯一ID';
comment on column t_car.carName is '车辆编号';
comment on column t_car.pic is '牌照';
comment on column t_car.pp is '品牌';
comment on column t_car.content is '备注';
--车辆表加注释
comment on table t_car is '车辆';
create table t_cd(
id integer,
cdName varchar(100),
pic varchar(100),
pp varchar(100),
content text
);
--场地字段加注释
comment on column t_cd.id is '主键';
comment on column t_cd.id is '主键唯一ID';
comment on column t_cd.cdName is '场地编号';
comment on column t_cd.pic is '拍照';
comment on column t_cd.pp is '详细地址';
comment on column t_cd.content is '备注';
--场地表加注释
comment on table t_cd is '场地';
create table t_customer(
id integer,
username varchar(100),
password varchar(100),
customerName varchar(100),
headPic varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100)
);
--学员字段加注释
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.headPic is '头像';
comment on column t_customer.phone is '电话';
comment on column t_customer.age is '年龄';
comment on column t_customer.sex is '性别';
--学员表加注释
comment on table t_customer is '学员';
create table t_gg(
id integer,
ggName varchar(100),
content text,
insertDate datetime
);
--公告字段加注释
comment on column t_gg.id is '主键';
comment on column t_gg.id is '主键唯一ID';
comment on column t_gg.ggName is '标题';
comment on column t_gg.content is '内容';
comment on column t_gg.insertDate is '日期';
--公告表加注释
comment on table t_gg is '公告';
create table t_pj(
id integer,
customerId int(11),
teacherId int(11),
content text,
pf int(11),
insertDate datetime
);
--教练评价字段加注释
comment on column t_pj.id is '主键';
comment on column t_pj.id is '主键唯一ID';
comment on column t_pj.customerId is '学员';
comment on column t_pj.teacherId is '教练';
comment on column t_pj.content is '评价';
comment on column t_pj.pf is '评分';
comment on column t_pj.insertDate is '发起日期';
--教练评价表加注释
comment on table t_pj is '教练评价';
create table t_shipin(
id integer,
shipinName varchar(100),
fileUrl varchar(100),
content text
);
--培训视频字段加注释
comment on column t_shipin.id is '主键';
comment on column t_shipin.id is '主键唯一ID';
comment on column t_shipin.shipinName is '视频名称';
comment on column t_shipin.fileUrl is '视频';
comment on column t_shipin.content is '视频内容简介';
--培训视频表加注释
comment on table t_shipin is '培训视频';
create table t_sqxm(
id integer,
customerId int(11),
title varchar(100),
content text,
insertDate datetime,
back text,
status varchar(100)
);
--申请项目字段加注释
comment on column t_sqxm.id is '主键';
comment on column t_sqxm.id is '主键唯一ID';
comment on column t_sqxm.customerId is '学员';
comment on column t_sqxm.title is '申请项目';
comment on column t_sqxm.content is '申请备注';
comment on column t_sqxm.insertDate is '申请日期';
comment on column t_sqxm.back is '回复';
comment on column t_sqxm.status is '状态';
--申请项目表加注释
comment on table t_sqxm is '申请项目';
create table t_teacher(
id integer,
username varchar(100),
password varchar(100),
teacherName varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100),
headPic varchar(100)
);
--教练字段加注释
comment on column t_teacher.id is '主键';
comment on column t_teacher.id is '主键唯一ID';
comment on column t_teacher.username is '账号';
comment on column t_teacher.password is '密码';
comment on column t_teacher.teacherName is '姓名';
comment on column t_teacher.phone is '电话';
comment on column t_teacher.age is '年龄';
comment on column t_teacher.sex is '性别';
comment on column t_teacher.headPic is '头像';
--教练表加注释
comment on table t_teacher is '教练';
create table t_wt(
id integer,
customerId int(11),
wtName varchar(100),
content text,
insertDate datetime,
back text,
status varchar(100)
);
--问题字段加注释
comment on column t_wt.id is '主键';
comment on column t_wt.id is '主键唯一ID';
comment on column t_wt.customerId is '学员';
comment on column t_wt.wtName is '问题说明';
comment on column t_wt.content is '详细内容';
comment on column t_wt.insertDate is '发起日期';
comment on column t_wt.back is '回复';
comment on column t_wt.status is '状态';
--问题表加注释
comment on table t_wt is '问题';
create table t_yy(
id integer,
customerId int(11),
content text,
showDate datetime,
teacherId int(11),
yyxm varchar(100),
back text,
status varchar(100)
);
--预约学车字段加注释
comment on column t_yy.id is '主键';
comment on column t_yy.id is '主键唯一ID';
comment on column t_yy.customerId is '学员';
comment on column t_yy.content is '预约说明';
comment on column t_yy.showDate is '预约日期';
comment on column t_yy.teacherId is '选择教练';
comment on column t_yy.yyxm is '项目';
comment on column t_yy.back is '回复';
comment on column t_yy.status is '状态';
--预约学车表加注释
comment on table t_yy is '预约学车';
create table t_ziyuan(
id integer,
ziyuanName varchar(100),
pic varchar(100),
fileUrl varchar(100),
content text
);
--课程资源字段加注释
comment on column t_ziyuan.id is '主键';
comment on column t_ziyuan.id is '主键唯一ID';
comment on column t_ziyuan.ziyuanName is '资源名称';
comment on column t_ziyuan.pic is '图片';
comment on column t_ziyuan.fileUrl is '附件';
comment on column t_ziyuan.content is '资源说明';
--课程资源表加注释
comment on table t_ziyuan is '课程资源';
create table t_zj(
id integer,
customerId int(11),
xf int(11),
mm varchar(100),
showDate datetime,
content text
);
--学费资金字段加注释
comment on column t_zj.id is '主键';
comment on column t_zj.id is '主键唯一ID';
comment on column t_zj.customerId is '学员';
comment on column t_zj.xf is '学费金额';
comment on column t_zj.mm is '学费名目';
comment on column t_zj.showDate is '上交日期';
comment on column t_zj.content is '备注';
--学费资金表加注释
comment on table t_zj 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_car(
id int primary key auto_increment comment '主键',
carName varchar(100) comment '车辆编号',
pic varchar(100) comment '牌照',
pp varchar(100) comment '品牌',
content text comment '备注'
) comment '车辆';
create table t_cd(
id int primary key auto_increment comment '主键',
cdName varchar(100) comment '场地编号',
pic varchar(100) comment '拍照',
pp varchar(100) comment '详细地址',
content text 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 '姓名',
headPic varchar(100) comment '头像',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别'
) comment '学员';
create table t_gg(
id int primary key auto_increment comment '主键',
ggName varchar(100) comment '标题',
content text comment '内容',
insertDate datetime comment '日期'
) comment '公告';
create table t_pj(
id int primary key auto_increment comment '主键',
customerId int(11) comment '学员',
teacherId int(11) comment '教练',
content text comment '评价',
pf int(11) comment '评分',
insertDate datetime comment '发起日期'
) comment '教练评价';
create table t_shipin(
id int primary key auto_increment comment '主键',
shipinName varchar(100) comment '视频名称',
fileUrl varchar(100) comment '视频',
content text comment '视频内容简介'
) comment '培训视频';
create table t_sqxm(
id int primary key auto_increment comment '主键',
customerId int(11) comment '学员',
title varchar(100) comment '申请项目',
content text comment '申请备注',
insertDate datetime comment '申请日期',
back text comment '回复',
status varchar(100) comment '状态'
) comment '申请项目';
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 '年龄',
sex varchar(100) comment '性别',
headPic varchar(100) comment '头像'
) comment '教练';
create table t_wt(
id int primary key auto_increment comment '主键',
customerId int(11) comment '学员',
wtName varchar(100) comment '问题说明',
content text comment '详细内容',
insertDate datetime comment '发起日期',
back text comment '回复',
status varchar(100) comment '状态'
) comment '问题';
create table t_yy(
id int primary key auto_increment comment '主键',
customerId int(11) comment '学员',
content text comment '预约说明',
showDate datetime comment '预约日期',
teacherId int(11) comment '选择教练',
yyxm varchar(100) comment '项目',
back text comment '回复',
status varchar(100) comment '状态'
) comment '预约学车';
create table t_ziyuan(
id int primary key auto_increment comment '主键',
ziyuanName varchar(100) comment '资源名称',
pic varchar(100) comment '图片',
fileUrl varchar(100) comment '附件',
content text comment '资源说明'
) comment '课程资源';
create table t_zj(
id int primary key auto_increment comment '主键',
customerId int(11) comment '学员',
xf int(11) comment '学费金额',
mm varchar(100) comment '学费名目',
showDate datetime comment '上交日期',
content text comment '备注'
) comment '学费资金';
create table t_car(
id integer,
carName varchar(100),
pic varchar(100),
pp varchar(100),
content text
);
--车辆字段加注释
comment on column t_car.id is '主键';
comment on column t_car.id is '主键唯一ID';
comment on column t_car.carName is '车辆编号';
comment on column t_car.pic is '牌照';
comment on column t_car.pp is '品牌';
comment on column t_car.content is '备注';
--车辆表加注释
comment on table t_car is '车辆';
create table t_cd(
id integer,
cdName varchar(100),
pic varchar(100),
pp varchar(100),
content text
);
--场地字段加注释
comment on column t_cd.id is '主键';
comment on column t_cd.id is '主键唯一ID';
comment on column t_cd.cdName is '场地编号';
comment on column t_cd.pic is '拍照';
comment on column t_cd.pp is '详细地址';
comment on column t_cd.content is '备注';
--场地表加注释
comment on table t_cd is '场地';
create table t_customer(
id integer,
username varchar(100),
password varchar(100),
customerName varchar(100),
headPic varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100)
);
--学员字段加注释
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.headPic is '头像';
comment on column t_customer.phone is '电话';
comment on column t_customer.age is '年龄';
comment on column t_customer.sex is '性别';
--学员表加注释
comment on table t_customer is '学员';
create table t_gg(
id integer,
ggName varchar(100),
content text,
insertDate datetime
);
--公告字段加注释
comment on column t_gg.id is '主键';
comment on column t_gg.id is '主键唯一ID';
comment on column t_gg.ggName is '标题';
comment on column t_gg.content is '内容';
comment on column t_gg.insertDate is '日期';
--公告表加注释
comment on table t_gg is '公告';
create table t_pj(
id integer,
customerId int(11),
teacherId int(11),
content text,
pf int(11),
insertDate datetime
);
--教练评价字段加注释
comment on column t_pj.id is '主键';
comment on column t_pj.id is '主键唯一ID';
comment on column t_pj.customerId is '学员';
comment on column t_pj.teacherId is '教练';
comment on column t_pj.content is '评价';
comment on column t_pj.pf is '评分';
comment on column t_pj.insertDate is '发起日期';
--教练评价表加注释
comment on table t_pj is '教练评价';
create table t_shipin(
id integer,
shipinName varchar(100),
fileUrl varchar(100),
content text
);
--培训视频字段加注释
comment on column t_shipin.id is '主键';
comment on column t_shipin.id is '主键唯一ID';
comment on column t_shipin.shipinName is '视频名称';
comment on column t_shipin.fileUrl is '视频';
comment on column t_shipin.content is '视频内容简介';
--培训视频表加注释
comment on table t_shipin is '培训视频';
create table t_sqxm(
id integer,
customerId int(11),
title varchar(100),
content text,
insertDate datetime,
back text,
status varchar(100)
);
--申请项目字段加注释
comment on column t_sqxm.id is '主键';
comment on column t_sqxm.id is '主键唯一ID';
comment on column t_sqxm.customerId is '学员';
comment on column t_sqxm.title is '申请项目';
comment on column t_sqxm.content is '申请备注';
comment on column t_sqxm.insertDate is '申请日期';
comment on column t_sqxm.back is '回复';
comment on column t_sqxm.status is '状态';
--申请项目表加注释
comment on table t_sqxm is '申请项目';
create table t_teacher(
id integer,
username varchar(100),
password varchar(100),
teacherName varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100),
headPic varchar(100)
);
--教练字段加注释
comment on column t_teacher.id is '主键';
comment on column t_teacher.id is '主键唯一ID';
comment on column t_teacher.username is '账号';
comment on column t_teacher.password is '密码';
comment on column t_teacher.teacherName is '姓名';
comment on column t_teacher.phone is '电话';
comment on column t_teacher.age is '年龄';
comment on column t_teacher.sex is '性别';
comment on column t_teacher.headPic is '头像';
--教练表加注释
comment on table t_teacher is '教练';
create table t_wt(
id integer,
customerId int(11),
wtName varchar(100),
content text,
insertDate datetime,
back text,
status varchar(100)
);
--问题字段加注释
comment on column t_wt.id is '主键';
comment on column t_wt.id is '主键唯一ID';
comment on column t_wt.customerId is '学员';
comment on column t_wt.wtName is '问题说明';
comment on column t_wt.content is '详细内容';
comment on column t_wt.insertDate is '发起日期';
comment on column t_wt.back is '回复';
comment on column t_wt.status is '状态';
--问题表加注释
comment on table t_wt is '问题';
create table t_yy(
id integer,
customerId int(11),
content text,
showDate datetime,
teacherId int(11),
yyxm varchar(100),
back text,
status varchar(100)
);
--预约学车字段加注释
comment on column t_yy.id is '主键';
comment on column t_yy.id is '主键唯一ID';
comment on column t_yy.customerId is '学员';
comment on column t_yy.content is '预约说明';
comment on column t_yy.showDate is '预约日期';
comment on column t_yy.teacherId is '选择教练';
comment on column t_yy.yyxm is '项目';
comment on column t_yy.back is '回复';
comment on column t_yy.status is '状态';
--预约学车表加注释
comment on table t_yy is '预约学车';
create table t_ziyuan(
id integer,
ziyuanName varchar(100),
pic varchar(100),
fileUrl varchar(100),
content text
);
--课程资源字段加注释
comment on column t_ziyuan.id is '主键';
comment on column t_ziyuan.id is '主键唯一ID';
comment on column t_ziyuan.ziyuanName is '资源名称';
comment on column t_ziyuan.pic is '图片';
comment on column t_ziyuan.fileUrl is '附件';
comment on column t_ziyuan.content is '资源说明';
--课程资源表加注释
comment on table t_ziyuan is '课程资源';
create table t_zj(
id integer,
customerId int(11),
xf int(11),
mm varchar(100),
showDate datetime,
content text
);
--学费资金字段加注释
comment on column t_zj.id is '主键';
comment on column t_zj.id is '主键唯一ID';
comment on column t_zj.customerId is '学员';
comment on column t_zj.xf is '学费金额';
comment on column t_zj.mm is '学费名目';
comment on column t_zj.showDate is '上交日期';
comment on column t_zj.content is '备注';
--学费资金表加注释
comment on table t_zj is '学费资金';
--车辆表注释
create table t_car(
id int identity(1,1) primary key not null,--主键
carName varchar(100),--车辆编号
pic varchar(100),--牌照
pp varchar(100),--品牌
content text--备注
);
--场地表注释
create table t_cd(
id int identity(1,1) primary key not null,--主键
cdName varchar(100),--场地编号
pic varchar(100),--拍照
pp varchar(100),--详细地址
content text--备注
);
--学员表注释
create table t_customer(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
customerName varchar(100),--姓名
headPic varchar(100),--头像
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100)--性别
);
--公告表注释
create table t_gg(
id int identity(1,1) primary key not null,--主键
ggName varchar(100),--标题
content text,--内容
insertDate datetime--日期
);
--教练评价表注释
create table t_pj(
id int identity(1,1) primary key not null,--主键
customerId int(11),--学员
teacherId int(11),--教练
content text,--评价
pf int(11),--评分
insertDate datetime--发起日期
);
--培训视频表注释
create table t_shipin(
id int identity(1,1) primary key not null,--主键
shipinName varchar(100),--视频名称
fileUrl varchar(100),--视频
content text--视频内容简介
);
--申请项目表注释
create table t_sqxm(
id int identity(1,1) primary key not null,--主键
customerId int(11),--学员
title varchar(100),--申请项目
content text,--申请备注
insertDate datetime,--申请日期
back text,--回复
status varchar(100)--状态
);
--教练表注释
create table t_teacher(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
teacherName varchar(100),--姓名
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100),--性别
headPic varchar(100)--头像
);
--问题表注释
create table t_wt(
id int identity(1,1) primary key not null,--主键
customerId int(11),--学员
wtName varchar(100),--问题说明
content text,--详细内容
insertDate datetime,--发起日期
back text,--回复
status varchar(100)--状态
);
--预约学车表注释
create table t_yy(
id int identity(1,1) primary key not null,--主键
customerId int(11),--学员
content text,--预约说明
showDate datetime,--预约日期
teacherId int(11),--选择教练
yyxm varchar(100),--项目
back text,--回复
status varchar(100)--状态
);
--课程资源表注释
create table t_ziyuan(
id int identity(1,1) primary key not null,--主键
ziyuanName varchar(100),--资源名称
pic varchar(100),--图片
fileUrl varchar(100),--附件
content text--资源说明
);
--学费资金表注释
create table t_zj(
id int identity(1,1) primary key not null,--主键
customerId int(11),--学员
xf int(11),--学费金额
mm varchar(100),--学费名目
showDate datetime,--上交日期
content text--备注
);
AI助手 package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//车辆
public class Car extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//主键唯一ID
private int id;
//车辆编号
private String carName;
//牌照
private String pic;
//品牌
private String pp;
//备注
private String content;
public int getId() {return id;}
public void setId(int id) {this.id = id;}
public String getCarName() {return carName;}
public void setCarName(String carName) {this.carName = carName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getPp() {return pp;}
public void setPp(String pp) {this.pp = pp;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//场地
public class Cd extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//主键唯一ID
private int id;
//场地编号
private String cdName;
//拍照
private String pic;
//详细地址
private String pp;
//备注
private String content;
public int getId() {return id;}
public void setId(int id) {this.id = id;}
public String getCdName() {return cdName;}
public void setCdName(String cdName) {this.cdName = cdName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getPp() {return pp;}
public void setPp(String pp) {this.pp = pp;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}
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 headPic;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
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 getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
}
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//公告
public class Gg extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//主键唯一ID
private int id;
//标题
private String ggName;
//内容
private String content;
//日期
private Date insertDate;
public int getId() {return id;}
public void setId(int id) {this.id = id;}
public String getGgName() {return ggName;}
public void setGgName(String ggName) {this.ggName = ggName;}
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 Pj 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 int teacherId;
//评价
private String content;
//评分
private int pf;
//发起日期
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 int getTeacherId() {return teacherId;}
public void setTeacherId(int teacherId) {this.teacherId = teacherId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public int getPf() {return pf;}
public void setPf(int pf) {this.pf = pf;}
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 Shipin extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//主键唯一ID
private int id;
//视频名称
private String shipinName;
//视频
private String fileUrl;
//视频内容简介
private String content;
public int getId() {return id;}
public void setId(int id) {this.id = id;}
public String getShipinName() {return shipinName;}
public void setShipinName(String shipinName) {this.shipinName = shipinName;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//申请项目
public class Sqxm 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;
//回复
private String back;
//状态
private String status;
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;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//教练
public class Teacher 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 teacherName;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//头像
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 getTeacherName() {return teacherName;}
public void setTeacherName(String teacherName) {this.teacherName = teacherName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
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 Wt 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 wtName;
//详细内容
private String content;
//发起日期
private Date insertDate;
//回复
private String back;
//状态
private String status;
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 getWtName() {return wtName;}
public void setWtName(String wtName) {this.wtName = wtName;}
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;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//预约学车
public class Yy 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 content;
//预约日期
private Date showDate;
//选择教练
private int teacherId;
//项目
private String yyxm;
//回复
private String back;
//状态
private String status;
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 getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public int getTeacherId() {return teacherId;}
public void setTeacherId(int teacherId) {this.teacherId = teacherId;}
public String getYyxm() {return yyxm;}
public void setYyxm(String yyxm) {this.yyxm = yyxm;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//课程资源
public class Ziyuan extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//主键唯一ID
private int id;
//资源名称
private String ziyuanName;
//图片
private String pic;
//附件
private String fileUrl;
//资源说明
private String content;
public int getId() {return id;}
public void setId(int id) {this.id = id;}
public String getZiyuanName() {return ziyuanName;}
public void setZiyuanName(String ziyuanName) {this.ziyuanName = ziyuanName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//学费资金
public class Zj 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 int xf;
//学费名目
private String mm;
//上交日期
private Date showDate;
//备注
private String content;
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 int getXf() {return xf;}
public void setXf(int xf) {this.xf = xf;}
public String getMm() {return mm;}
public void setMm(String mm) {this.mm = mm;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}
AI助手全部评论 (0)
还没有任何评论哟~