java毕业设计_基于web的家教管理系统

基于web的家教管理系统mysql数据库创建语句
基于web的家教管理系统oracle数据库创建语句
基于web的家教管理系统sqlserver数据库创建语句
基于web的家教管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
基于web的家教管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
基于web的家教管理系统登录注册界面
基于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_adminlb(
id int primary key auto_increment comment ‘主键’,
typename varchar(100) comment ‘类别’
) comment ‘管理员类别’;
SQLCopy
学员表创建语句如下：

create table t_customer(
id int primary key auto_increment comment ‘主键’,
username varchar(100) comment ‘用户名’,
password varchar(100) comment ‘密码’,
question varchar(100) comment ‘提示问题’,
answer varchar(100) comment ‘答案’,
adminlbId int comment ‘类别ID’,
realname varchar(100) comment ‘真实姓名’,
sexuality varchar(100) comment ‘性别’,
date_of_birth varchar(100) comment ‘出生年月’,
areas varchar(100) comment ‘地区’,
tellphone varchar(100) comment ‘电话号码’,
QQemail varchar(100) comment ‘QQ邮箱’,
course varchar(100) comment ‘求教课程’,
method varchar(100) comment ‘需要的家教方式’,
sex_need varchar(100) comment ‘性别要求’,
pay varchar(100) comment ‘工资待遇’,
typename varchar(100) comment ‘类别名称’,
head_portrait varchar(100) comment ‘头像’,
elses varchar(100) comment ‘其他’
) comment ‘学员’;
SQLCopy
教员表创建语句如下：

create table t_jiaoyuan(
id int primary key auto_increment comment ‘主键’,
username varchar(100) comment ‘用户名’,
password varchar(100) comment ‘密码’,
question varchar(100) comment ‘提示问题’,
answer varchar(100) comment ‘答案’,
Instruction varchar(100) comment ‘学历’,
major varchar(100) comment ‘专业’,
adminlbId int comment ‘类别ID’,
Workplace varchar(100) comment ‘工作地方’,
realname varchar(100) comment ‘真实姓名’,
sexuality varchar(100) comment ‘性别’,
date_of_birth varchar(100) comment ‘出生年月’,
areas varchar(100) comment ‘地区’,
tellphone varchar(100) comment ‘电话号码’,
QQemail varchar(100) comment ‘QQ邮箱’,
course varchar(100) comment ‘可教科目’,
method varchar(100) comment ‘提供的家教方式’,
sex_need varchar(100) comment ‘性别要求’,
treatment varchar(100) comment ‘期望工资’,
typename varchar(100) comment ‘类别名称’,
head_portrait varchar(100) comment ‘头像’
) comment ‘教员’;
SQLCopy
轮播图表创建语句如下：

create table t_lbt(
id int primary key auto_increment comment ‘主键’,
pic varchar(100) comment ‘图片’
) comment ‘轮播图’;
SQLCopy
留言表创建语句如下：

create table t_liuyan(
id int primary key auto_increment comment ‘主键’,
customerId int comment ‘用户’,
title varchar(100) comment ‘标题’,
content varchar(100) comment ‘内容’,
insertDate datetime comment ‘日期’,
back varchar(100) comment ‘回复’,
status varchar(100) comment ‘状态’,
jiaoyuanId int comment ‘教员’
) comment ‘留言’;
SQLCopy
评论表创建语句如下：

create table t_pinglun(
id int primary key auto_increment comment ‘主键’,
wdxxId int comment ‘评论信息’,
customerId int comment ‘评论人’,
content varchar(100) comment ‘评论内容’,
insertDate datetime comment ‘评论日期’
) comment ‘评论’;
SQLCopy
表创建语句如下：

create table t_pinglun_product(
id int primary key auto_increment comment ‘主键’,
productId int comment ‘评论信息’,
customerId int comment ‘评论人’,
content varchar(100) comment ‘评论内容’,
insertDate datetime comment ‘评论日期’
) comment ‘’;
SQLCopy
产品表创建语句如下：

create table t_product(
id int primary key auto_increment comment ‘主键’,
productName varchar(100) comment ‘产品名称’,
productPic1 varchar(100) comment ‘图片1’,
productPic2 varchar(100) comment ‘图片2’,
productPic3 varchar(100) comment ‘图片3’,
productPic4 varchar(100) comment ‘图片4’,
price int comment ‘价格’,
oldPrice int comment ‘原价’,
content varchar(100) comment ‘内容’,
nums int comment ‘数量’,
tjxj varchar(100) comment ‘推荐星级’,
status varchar(100) comment ‘状态’,
typesId int comment ‘分类’,
jf int comment ‘积分’,
userId int comment ‘商家’,
bqId int comment ‘标签’,
djl int comment ‘点击量’
) comment ‘产品’;
SQLCopy
投诉表创建语句如下：

create table t_tousu(
id int primary key auto_increment comment ‘主键’,
contact varchar(100) comment ‘联系人’,
tellphone varchar(100) comment ‘电话号码’,
city varchar(100) comment ‘城市’,
content varchar(100) comment ‘内容’,
qqemail varchar(100) comment ‘qq邮箱’
) comment ‘投诉’;
SQLCopy
分类表创建语句如下：

create table t_types(
id int primary key auto_increment comment ‘主键’,
typesName varchar(100) comment ‘分类’
) comment ‘分类’;
SQLCopy
我的消息表创建语句如下：

create table t_wdxx(
id int primary key auto_increment comment ‘主键’,
customerId int comment ‘我’,
title varchar(100) comment ‘标题’,
pic varchar(100) comment ‘图片’,
content varchar(100) comment ‘内容’,
zan int comment ‘赞’,
insertDate datetime comment ‘发布日期’,
nologin varchar(100) comment ‘游客是否可见’,
bkId int comment ‘’
) comment ‘我的消息’;
SQLCopy
新闻表创建语句如下：

create table t_xinwen(
id int primary key auto_increment comment ‘主键’,
title varchar(100) comment ‘新闻标题’,
content varchar(100) comment ‘新闻内容’,
showDate datetime comment ‘添加时间’,
author varchar(100) comment ‘作者’,
xinwenlbId int comment ‘新闻类别’
) comment ‘新闻’;
SQLCopy
新闻类别表创建语句如下：

create table t_xinwenlb(
id int primary key auto_increment comment ‘主键’,
typename 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_adminlb(
id integer,
typename varchar(100)
);
–管理员类别字段加注释
comment on column t_adminlb.id is ‘主键’;
comment on column t_adminlb.typename is ‘类别’;
–管理员类别表加注释
comment on table t_adminlb is ‘管理员类别’;
SQLCopy
学员表创建语句如下：

create table t_customer(
id integer,
username varchar(100),
password varchar(100),
question varchar(100),
answer varchar(100),
adminlbId int,
realname varchar(100),
sexuality varchar(100),
date_of_birth varchar(100),
areas varchar(100),
tellphone varchar(100),
QQemail varchar(100),
course varchar(100),
method varchar(100),
sex_need varchar(100),
pay varchar(100),
typename varchar(100),
head_portrait varchar(100),
elses 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.question is ‘提示问题’;
comment on column t_customer.answer is ‘答案’;
comment on column t_customer.adminlbId is ‘类别ID’;
comment on column t_customer.realname is ‘真实姓名’;
comment on column t_customer.sexuality is ‘性别’;
comment on column t_customer.date_of_birth is ‘出生年月’;
comment on column t_customer.areas is ‘地区’;
comment on column t_customer.tellphone is ‘电话号码’;
comment on column t_customer.QQemail is ‘QQ邮箱’;
comment on column t_customer.course is ‘求教课程’;
comment on column t_customer.method is ‘需要的家教方式’;
comment on column t_customer.sex_need is ‘性别要求’;
comment on column t_customer.pay is ‘工资待遇’;
comment on column t_customer.typename is ‘类别名称’;
comment on column t_customer.head_portrait is ‘头像’;
comment on column t_customer.elses is ‘其他’;
–学员表加注释
comment on table t_customer is ‘学员’;
SQLCopy
教员表创建语句如下：

create table t_jiaoyuan(
id integer,
username varchar(100),
password varchar(100),
question varchar(100),
answer varchar(100),
Instruction varchar(100),
major varchar(100),
adminlbId int,
Workplace varchar(100),
realname varchar(100),
sexuality varchar(100),
date_of_birth varchar(100),
areas varchar(100),
tellphone varchar(100),
QQemail varchar(100),
course varchar(100),
method varchar(100),
sex_need varchar(100),
treatment varchar(100),
typename varchar(100),
head_portrait varchar(100)
);
–教员字段加注释
comment on column t_jiaoyuan.id is ‘主键’;
comment on column t_jiaoyuan.username is ‘用户名’;
comment on column t_jiaoyuan.password is ‘密码’;
comment on column t_jiaoyuan.question is ‘提示问题’;
comment on column t_jiaoyuan.answer is ‘答案’;
comment on column t_jiaoyuan.Instruction is ‘学历’;
comment on column t_jiaoyuan.major is ‘专业’;
comment on column t_jiaoyuan.adminlbId is ‘类别ID’;
comment on column t_jiaoyuan.Workplace is ‘工作地方’;
comment on column t_jiaoyuan.realname is ‘真实姓名’;
comment on column t_jiaoyuan.sexuality is ‘性别’;
comment on column t_jiaoyuan.date_of_birth is ‘出生年月’;
comment on column t_jiaoyuan.areas is ‘地区’;
comment on column t_jiaoyuan.tellphone is ‘电话号码’;
comment on column t_jiaoyuan.QQemail is ‘QQ邮箱’;
comment on column t_jiaoyuan.course is ‘可教科目’;
comment on column t_jiaoyuan.method is ‘提供的家教方式’;
comment on column t_jiaoyuan.sex_need is ‘性别要求’;
comment on column t_jiaoyuan.treatment is ‘期望工资’;
comment on column t_jiaoyuan.typename is ‘类别名称’;
comment on column t_jiaoyuan.head_portrait is ‘头像’;
–教员表加注释
comment on table t_jiaoyuan is ‘教员’;
SQLCopy
轮播图表创建语句如下：

create table t_lbt(
id integer,
pic varchar(100)
);
–轮播图字段加注释
comment on column t_lbt.id is ‘主键’;
comment on column t_lbt.pic is ‘图片’;
–轮播图表加注释
comment on table t_lbt is ‘轮播图’;
SQLCopy
留言表创建语句如下：

create table t_liuyan(
id integer,
customerId int,
title varchar(100),
content varchar(100),
insertDate datetime,
back varchar(100),
status varchar(100),
jiaoyuanId int
);
–留言字段加注释
comment on column t_liuyan.id is ‘主键’;
comment on column t_liuyan.customerId is ‘用户’;
comment on column t_liuyan.title is ‘标题’;
comment on column t_liuyan.content is ‘内容’;
comment on column t_liuyan.insertDate is ‘日期’;
comment on column t_liuyan.back is ‘回复’;
comment on column t_liuyan.status is ‘状态’;
comment on column t_liuyan.jiaoyuanId is ‘教员’;
–留言表加注释
comment on table t_liuyan is ‘留言’;
SQLCopy
评论表创建语句如下：

create table t_pinglun(
id integer,
wdxxId int,
customerId int,
content varchar(100),
insertDate datetime
);
–评论字段加注释
comment on column t_pinglun.id is ‘主键’;
comment on column t_pinglun.wdxxId is ‘评论信息’;
comment on column t_pinglun.customerId is ‘评论人’;
comment on column t_pinglun.content is ‘评论内容’;
comment on column t_pinglun.insertDate is ‘评论日期’;
–评论表加注释
comment on table t_pinglun is ‘评论’;
SQLCopy
表创建语句如下：

create table t_pinglun_product(
id integer,
productId int,
customerId int,
content varchar(100),
insertDate datetime
);
–字段加注释
comment on column t_pinglun_product.id is ‘主键’;
comment on column t_pinglun_product.productId is ‘评论信息’;
comment on column t_pinglun_product.customerId is ‘评论人’;
comment on column t_pinglun_product.content is ‘评论内容’;
comment on column t_pinglun_product.insertDate is ‘评论日期’;
–表加注释
comment on table t_pinglun_product is ‘’;
SQLCopy
产品表创建语句如下：

create table t_product(
id integer,
productName varchar(100),
productPic1 varchar(100),
productPic2 varchar(100),
productPic3 varchar(100),
productPic4 varchar(100),
price int,
oldPrice int,
content varchar(100),
nums int,
tjxj varchar(100),
status varchar(100),
typesId int,
jf int,
userId int,
bqId int,
djl int
);
–产品字段加注释
comment on column t_product.id is ‘主键’;
comment on column t_product.productName is ‘产品名称’;
comment on column t_product.productPic1 is ‘图片1’;
comment on column t_product.productPic2 is ‘图片2’;
comment on column t_product.productPic3 is ‘图片3’;
comment on column t_product.productPic4 is ‘图片4’;
comment on column t_product.price is ‘价格’;
comment on column t_product.oldPrice