功能介绍
管理员:首页、个人中心、教员管理、学员管理、家教招聘管理、家教应聘管理、教员评价管理、系统管理等功能。
用户:首页、家教招聘、家教应聘、教员评价、我的等
数据库脚本
/*
SQLyog Ultimate v9.30
MySQL - 5.7.26 : Database - ssm6ex3y
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`ssm6ex3y` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `ssm6ex3y`;
/*Table structure for table `config` */
DROP TABLE IF EXISTS `config`;
CREATE TABLE `config` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`name` varchar(100) NOT NULL COMMENT '配置参数名称',
`value` varchar(100) DEFAULT NULL COMMENT '配置参数值',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='配置文件';
/*Data for the table `config` */
insert into `config`(`id`,`name`,`value`) values (1,'picture1','http://localhost:8080/ssm6ex3y/upload/picture1.jpg'),(2,'picture2','http://localhost:8080/ssm6ex3y/upload/picture2.jpg'),(3,'picture3','http://localhost:8080/ssm6ex3y/upload/picture3.jpg'),(6,'homepage',NULL);
/*Table structure for table `jiajiaoyingpin` */
DROP TABLE IF EXISTS `jiajiaoyingpin`;
CREATE TABLE `jiajiaoyingpin` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`kechengmingcheng` varchar(200) DEFAULT NULL COMMENT '课程名称',
`kechengtupian` varchar(200) DEFAULT NULL COMMENT '课程图片',
`jiajiaoyaoqiu` varchar(200) DEFAULT NULL COMMENT '家教要求',
`fudaoxuqiu` varchar(200) DEFAULT NULL COMMENT '辅导需求',
`fudaojiage` int(11) DEFAULT NULL COMMENT '辅导价格',
`fudaoshijian` varchar(200) DEFAULT NULL COMMENT '辅导时间',
`xuqiuxiangqing` longtext COMMENT '需求详情',
`fabushijian` varchar(200) DEFAULT NULL COMMENT '发布时间',
`yonghuming` varchar(200) DEFAULT NULL COMMENT '用户名',
`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
`shouji` varchar(200) DEFAULT NULL COMMENT '手机',
`shenqingneirong` varchar(200) NOT NULL COMMENT '申请内容',
`shenqingshijian` datetime DEFAULT NULL COMMENT '申请时间',
`jiaoyuangonghao` varchar(200) DEFAULT NULL COMMENT '教员工号',
`jiaoyuanxingming` varchar(200) DEFAULT NULL COMMENT '教员姓名',
`jiaoyuanzhicheng` varchar(200) DEFAULT NULL COMMENT '教员职称',
`lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
`sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
`userid` bigint(20) DEFAULT NULL COMMENT '用户id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1650093269193 DEFAULT CHARSET=utf8 COMMENT='家教应聘';
/*Data for the table `jiajiaoyingpin` */
insert into `jiajiaoyingpin`(`id`,`addtime`,`kechengmingcheng`,`kechengtupian`,`jiajiaoyaoqiu`,`fudaoxuqiu`,`fudaojiage`,`fudaoshijian`,`xuqiuxiangqing`,`fabushijian`,`yonghuming`,`xingming`,`shouji`,`shenqingneirong`,`shenqingshijian`,`jiaoyuangonghao`,`jiaoyuanxingming`,`jiaoyuanzhicheng`,`lianxidianhua`,`sfsh`,`shhf`,`userid`) values (42,'2021-04-14 10:10:57','课程名称2','http://localhost:8080/ssm6ex3y/upload/jiajiaoyingpin_kechengtupian2.jpg','家教要求2','辅导需求2',2,'辅导时间2','需求详情2','发布时间2','用户名2','姓名2','13823888882','申请内容2','2021-04-14 10:10:57','教员工号2','教员姓名2','教员职称2','联系电话2','是','',2),(43,'2021-04-14 10:10:57','课程名称3','http://localhost:8080/ssm6ex3y/upload/jiajiaoyingpin_kechengtupian3.jpg','家教要求3','辅导需求3',3,'辅导时间3','需求详情3','发布时间3','用户名3','姓名3','13823888883','申请内容3','2021-04-14 10:10:57','教员工号3','教员姓名3','教员职称3','联系电话3','是','',3),(44,'2021-04-14 10:10:57','课程名称4','http://localhost:8080/ssm6ex3y/upload/jiajiaoyingpin_kechengtupian4.jpg','家教要求4','辅导需求4',4,'辅导时间4','需求详情4','发布时间4','用户名4','姓名4','13823888884','申请内容4','2021-04-14 10:10:57','教员工号4','教员姓名4','教员职称4','联系电话4','是','',4),(45,'2021-04-14 10:10:57','课程名称5','http://localhost:8080/ssm6ex3y/upload/jiajiaoyingpin_kechengtupian5.jpg','家教要求5','辅导需求5',5,'辅导时间5','需求详情5','发布时间5','用户名5','姓名5','13823888885','申请内容5','2021-04-14 10:10:57','教员工号5','教员姓名5','教员职称5','联系电话5','是','',5),(<