/*
Navicat MySQL Data Transfer
Source Server : 127.0.0.1
Source Server Version : 50018
Source Host : 127.0.0.1:3306
Source Database : jiajiao
Target Server Type : MYSQL
Target Server Version : 50018
File Encoding : 65001
Date: 2019-11-21 14:44:23
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for t_admin
-- ----------------------------
DROP TABLE IF EXISTS `t_admin`;
CREATE TABLE `t_admin` (
`aId` int(11) NOT NULL auto_increment,
`username` varchar(50) default NULL,
`password` varchar(50) default NULL,
PRIMARY KEY (`aId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for t_area
-- ----------------------------
DROP TABLE IF EXISTS `t_area`;
CREATE TABLE `t_area` (
`aId` int(11) NOT NULL auto_increment,
`province` varchar(50) default NULL,
`city` varchar(50) default NULL,
`district` varchar(50) default NULL,
`town` varchar(50) default NULL,
PRIMARY KEY (`aId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for t_course
-- ----------------------------
DROP TABLE IF EXISTS `t_course`;
CREATE TABLE `t_course` (
`courseId` int(11) NOT NULL auto_increment COMMENT '编号',
`courseName` varchar(50) default NULL COMMENT '科目名称',
`kemuxiaolei` int(11) default NULL COMMENT '所属年级(课程小类)',
`kemudalei` int(11) default NULL COMMENT '课程大类',
`isMobile` int(11) default '1' COMMENT '是否显示在手机端首页',
PRIMARY KEY (`courseId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for t_dictinfo
-- ----------------------------
DROP TABLE IF EXISTS `t_dictinfo`;
CREATE TABLE `t_dictinfo` (
`dictId` int(11) NOT NULL auto_increment,
`code` varchar(100) default NULL COMMENT '类别编号',
`content` varchar(100) default NULL COMMENT '内容',
`linkDict` int(11) default '1' COMMENT '科目小类跟科目大类关联',
PRIMARY KEY (`dictId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for t_district
-- ----------------------------
DROP TABLE IF EXISTS `t_district`;
CREATE TABLE `t_district` (
`districtId` int(11) NOT NULL auto_increment,
`district` varchar(50) default '',
PRIMARY KEY (`districtId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for t_evaluation
-- ----------------------------
DROP TABLE IF EXISTS `t_evaluation`;
CREATE TABLE `t_evaluation` (
`eId` int(11) NOT NULL auto_increment,
`teacherId` int(11) default NULL COMMENT '教员编号',
`memberId` int(11) default NULL COMMENT '学员编号',
`toId` int(11) default NULL COMMENT '接单编号',
`oId` int(11) default NULL COMMENT '订单编号',
`score` int(11) default '5' COMMENT '满意度',
`evaluationContent` varchar(200) default NULL COMMENT '评价内容',
`evaluationTime` varchar(50) default NULL COMMENT '评价时间',
PRIMARY KEY (`eId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for t_fastorderteacher
-- ----------------------------
DROP TABLE IF EXISTS `t_fastorderteacher`;
CREATE TABLE `t_fastorderteacher` (
`fotId` int(11) NOT NULL auto_increment,
`name` varchar(50) default NULL,
`phone` varchar(50) default NULL,
`teachingCourse` int(11) default NULL,
`teachingCourseName` varchar(50) default NULL,
`wxNumber` varchar(100) default NULL,
`orderPrice` varchar(50) default NULL,
`teacherId` int(11) default NULL,
`remark` text,
`state` int(11) default '1' COMMENT '1发布中2学员联系中3教员联系中4试授课中5已完成6请家教失败7退款中',
`publicTime` varchar(50) default NULL,
`ip` varchar(50) default NULL COMMENT '客户端ip地址（防止恶意预约）',
PRIMARY KEY (`fotId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for t_gradeprice
-- ----------------------------
DROP TABLE IF EXISTS `t_gradeprice`;
CREATE TABLE `t_gradeprice` (
`pId` int(11) NOT NULL auto_increment,
`gradeId` int(11) default NULL,
`tminPrice` int(11) default NULL,
`tmaxPrice` int(11) default NULL,
`sminPrice` int(11) default NULL,
`smaxPrice` int(11) default NULL,
`gradeType` int(11) default NULL,
PRIMARY KEY (`pId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for t_institution
-- ----------------------------
DROP TABLE IF EXISTS `t_institution`;
CREATE TABLE `t_institution` (
`iId` int(11) NOT NULL auto_increment,
`iName` varchar(255) default '' COMMENT '机构名称',
`kemudalei` varchar(255) default '' COMMENT '科目大类',
`course` varchar(255) default '' COMMENT '教学课程',
`contactName` varchar(255) default '' COMMENT '机构联系人',
`contactPhone` varchar(255) default '' COMMENT '机构联系人电话',
`teachingType` varchar(100) default '' COMMENT '授课方式',
`teachingPrice` varchar(100) default '' COMMENT '价格',
`isListen` int(11) default '1' COMMENT '是否免费试听',
`qq` varchar(255) default '',
`logo` varchar(255) default '' COMMENT '家教机构logo',
`areaId` int(11) default '1' COMMENT '地区',
`address` varchar(255) default NULL COMMENT '描述',
`lng` varchar(255) default '' COMMENT '经度',
`lat` varchar(255) default '' COMMENT '纬度',
`photo` varchar(255) default '' COMMENT '照片',
`pubTime` varchar(255) default '' COMMENT '发布时间',
`sort` int(11) default '0' COMMENT '排序',
`introduce` text COMMENT '介绍',
`viewNum` int(11) default '1' COMMENT '浏览量',
`display` int(11) default '1' COMMENT '是否显示',
PRIMARY KEY (`iId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for t_link
-- ----------------------------
DROP TABLE IF EXISTS `t_link`;
CREATE TABLE `t_link` (
`lId` int(11) NOT NULL auto_increment,
`webName` varchar(200) NOT NULL COMMENT '网站名称',
`webUrl` varchar(200) NOT NULL COMMENT '网站地址',
`webDescribe` varchar(200) default '' COMMENT '描述',
`contactName` varchar(50) default '' COMMENT '联系人',
`webPhone` varchar(50) NOT NULL COMMENT '联系电话',
`display` int(11) default '0' COMMENT '是否显示',
`sort` int(11) default '0' COMMENT '排序权重',
`pubTime` varchar(255) default '' COMMENT '申请时间',
PRIMARY KEY (`lId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for t_member
-- ----------------------------
DROP TABLE IF EXISTS `t_member`;
CREATE TABLE `t_member` (
`memberId` int(11) NOT NULL auto_increment,
`name` varchar(50) default '' COMMENT '姓名',
`phone` varchar(50) default NULL COMMENT '手机号',
`password` varchar(100) default NULL COMMENT '密码',
`gender` int(11) default '0' COMMENT '性别',
`wxNumber` varchar(100) default '' COMMENT '微信号',
`districtId` int(11) default '0' COMMENT '区域编号，为0代表空，不然springmvc会报错',
`address` varchar(200) default '' COMMENT '大概住址',
`registTime` varchar(50) default NULL COMMENT '注册时间',
`isUse` int(11) default '1' COMMENT '账号是否可用',
PRIMARY KEY (`memberId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for t_memberorderteacher
-- ----------------------------
DROP TABLE IF EXISTS `t_memberorderteacher`;
CREATE TABLE `t_memberorderteacher` (
`mosId` int(11) NOT NULL auto_increment,
`memberId` int(11) default NULL,
`teacherId` int(11) default NULL,
`teachingCourse` int(11) default NULL,
`teachingCourseName` varchar(50) default NULL,
`name` varchar(50) default NULL,
`gender` int(11) default NULL,
`areaId` int(11) default NULL,
`address` varchar(200) default NULL,
`lat` varchar(50) default NULL,
`lng` varchar(50) default NULL,
`publicTime` varchar(50) default NULL,
`price` varchar(255) default NULL,
`remark` text,
`state` int(11) def
基于Java的学生家教系统源码
版权申诉
15 浏览量
2023-05-12
23:13:19
上传
评论
收藏 25.84MB ZIP 举报
基于Java的学生家教系统源码 （1120个子文件） 
api 238B api 230B api(1) 238B TeacherDaoImpl.class 22KB AdminController.class 20KB TeacherController.class 20KB MemberController.class 17KB OrderDaoImpl.class 16KB ArrayHelper.class 15KB TeacherServiceImpl.class 14KB PaperController.class 12KB InstitutionController.class 10KB PaperDaoImpl.class 10KB PageUtil.class 9KB Teacher.class 9KB InstitutionServiceImpl.class 9KB Orders.class 8KB MemberOrderTeacherDaoImpl.class 8KB MobileController.class 7KB WelcomeController.class 7KB NewsDaoImpl.class 7KB NewsController.class 7KB NoticeController.class 6KB NoticeDaoImpl.class 6KB OrdersServiceImpl.class 6KB InstitutionDaoImpl.class 6KB MemberDaoImpl.class 6KB TakeOrdersDaoImpl.class 5KB CommonUtil.class 5KB Institution.class 5KB FastOrderTeacherDaoImpl.class 5KB RegisterController.class 5KB OrderController.class 4KB TakeOrdersServiceImpl.class 4KB LoginController.class 4KB MemberOrderTeacher.class 4KB TakeOrders.class 4KB CodeController.class 4KB LinkDaoImpl.class 4KB PaperServiceImpl.class 4KB MemberServiceImpl.class 4KB MemberOrderTeacherServiceImpl.class 4KB FastOrderTeacher.class 4KB LinkController.class 3KB Member.class 3KB CourseDaoImpl.class 3KB Paper.class 3KB NewsServiceImpl.class 3KB TeacherService.class 3KB NoticeServiceImpl.class 3KB GradePrice.class 3KB Link.class 3KB Notice.class 2KB News.class 2KB FastOrderTeacherServiceImpl.class 2KB MemberOrderTeacherController.class 2KB Course.class 2KB Evaluation.class 2KB TeacherDao.class 2KB OrdersService.class 2KB AdminDaoImpl.class 2KB LinkServiceImpl.class 2KB MD5Utils.class 2KB GradePriceDaoImpl.class 2KB OrdersDao.class 2KB DictInfoImpl.class 1KB DictInfo.class 1KB DistrictDaoImpl.class 1KB Area.class 1KB Admin.class 1KB PaperService.class 1KB CourseServiceImpl.class 1KB StringUtil.class 1KB PaperDao.class 1KB MemberOrderTeacherService.class 1KB DictInfoServiceImpl.class 1KB District.class 1KB NewsService.class 1KB AdminServiceImpl.class 1KB NoticeService.class 1015B DataDto.class 1015B MemberService.class 942B TakeOrdersService.class 913B MemberOrderTeacherDao.class 892B NoticeDao.class 891B InstitutionService.class 879B DistrictServiceImpl.class 851B GradePriceServiceImpl.class 838B NewsDao.class 817B FastOrderTeacherService.class 755B MemberDao.class 750B FastOrderTeacherDao.class 639B TakeOrdersDao.class 622B Main.class 612B InstitutionDao.class 610B CourseDao.class 454B AreaDaoImpl.class 448B LinkService.class 423B CourseService.class 410B LinkDao.class 359B共 1120 条
- 1
- 2
- 3
- 4
- 5
- 6
- 12
资源评论
