毕业设计-基于SSM-驾校预约管理系统的设计与实现-设计与实现（源码 + 演示视频）.zip

/* Navicat MySQL Data Transfer Source Server : localhost_3306 Source Server Version : 50087 Source Host : localhost:3306 Source Database : ssmsxtxsqgwpthsg9269w3ca Target Server Type : MYSQL Target Server Version : 50087 File Encoding : 65001 Date: 2021-03-15 14:35:07 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `allusers` -- ---------------------------- DROP TABLE IF EXISTS `allusers`; CREATE TABLE `allusers` ( `id` int(11) NOT NULL auto_increment, `username` varchar(50) default NULL, `pwd` varchar(50) default NULL, `cx` varchar(50) default '普通管理员', `addtime` timestamp NOT NULL default CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of allusers -- ---------------------------- INSERT INTO `allusers` VALUES ('2', 'hsg', 'hsg', '超级管理员', '2021-03-08 10:17:05'); INSERT INTO `allusers` VALUES ('3', 'hsg123', '123', '普通管理员', '2021-03-08 10:42:40'); -- ---------------------------- -- Table structure for `dx` -- ---------------------------- DROP TABLE IF EXISTS `dx`; CREATE TABLE `dx` ( `ID` int(11) NOT NULL auto_increment, `leibie` varchar(50) default NULL, `content` longtext, PRIMARY KEY (`ID`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of dx -- ---------------------------- INSERT INTO `dx` VALUES ('1', '系统公告', '<p>\r\n 欢迎大家登陆我站，我站主要是为广大朋友精心制作的一个系统，希望大家能够在我站获得一个好心情，谢谢！\r\n</p>\r\n<p>\r\n 自强不息，海纳百川，努力学习！fff\r\n</p>'); INSERT INTO `dx` VALUES ('2', '系统简介', '系统简介hhrthrrrrr22ggg'); INSERT INTO `dx` VALUES ('3', '关于我们', '&nbsp; &nbsp; 本公司坚持走:以质量求生存,以科技求发展,重合同守信用的道路,生产经营得到迅速发展。我们将以优质的产品和最完善的售后服务来真诚与各界朋友开展广泛的合作,共同创造一个美好的未来!<br />\r\n<br />\r\n公司行为准则:忠信仁义，以人为本。 <br />\r\n忠：即忠诚， 包括三重含义：企业忠于国家、忠于民族；企业忠于客户；员工忠于企业。 <br />\r\n信：即诚信，做企业要立足根本道德、信义，要诚实、讲信用。 <br />\r\n仁：即仁爱，上司对下属要仁爱、体贴，同事之间要关怀、友爱。 <br />\r\n<p>\r\n 义：即大义，公司在与合作伙伴、客户的交往过程中，不做损人利己的事，维护自己利益的前提是不损害他人利益；对民族、社会要共襄义举，要识大义，明是非。\r\n</p>\r\n<p>\r\n 具体内容需自行修改设置\r\n</p>'); INSERT INTO `dx` VALUES ('4', '联系方式', '联系人：xxxxxxxx<br /> 电话：0000-0000000<br /> 手机：010000000000<br /> 传真：0000-0000000<br /> 邮件：xxxxxxxx@163.com<br /> 地址：您公司的地址<br /> 网址：http://www.xxxx.com<br />'); -- ---------------------------- -- Table structure for `jiaolian` -- ---------------------------- DROP TABLE IF EXISTS `jiaolian`; CREATE TABLE `jiaolian` ( `id` int(11) NOT NULL auto_increment, `jiaolianbianhao` varchar(50) default NULL, `mima` varchar(50) default NULL, `jiaolianxingming` varchar(50) default NULL, `xingbie` varchar(50) default NULL, `shenfenzheng` varchar(50) default NULL, `lianxidianhua` varchar(50) default NULL, `youxiang` varchar(50) default NULL, `jialing` varchar(50) default NULL, `addtime` timestamp NOT NULL default CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of jiaolian -- ---------------------------- INSERT INTO `jiaolian` VALUES ('2', '014', '001', '易建联', '女', '330327198501020300', '4231999', '2352352@qq.com', '6', '2021-03-08 10:17:05'); INSERT INTO `jiaolian` VALUES ('3', '013', '001', '孙俪', '女', '330327199504059511', '8945622', ' fegge@163.com', '13', '2021-03-08 10:17:05'); INSERT INTO `jiaolian` VALUES ('4', '012', '001', '连小云', '男', '330327185403060589', '6460848', 'regrodd@qq.com', '12', '2021-03-08 10:17:05'); INSERT INTO `jiaolian` VALUES ('5', '030', '001', '王与馨', '女', '330327199010142546', '6497512', 'grorti@qq.com', '14', '2021-03-08 10:17:05'); INSERT INTO `jiaolian` VALUES ('6', '005', '001', '梅西', '女', '33032719900723568X', '4265325', '43643933@qq.com', '16', '2021-03-08 10:17:05'); INSERT INTO `jiaolian` VALUES ('7', '009', '001', '郑亚斌', '女', '330327198406150488', '8895632', 'trodd@yahoo.com', '19', '2021-03-08 10:17:05'); INSERT INTO `jiaolian` VALUES ('8', '017', '001', '詹姆斯', '女', '330327198811020456', '8954878', '56547474@qq.com', '18', '2021-03-08 10:17:05'); INSERT INTO `jiaolian` VALUES ('9', '001', '001', '穆铁柱', '女', '330327199005060003', '6460233', 'grhtrhk@163.com', '27', '2021-03-08 10:17:05'); INSERT INTO `jiaolian` VALUES ('10', '456', '456', '发多少', '男', '112233223322334433', '13433223344', '324324@qq.com', '2', '2021-03-08 10:45:26'); -- ---------------------------- -- Table structure for `kaoshianpai` -- ---------------------------- DROP TABLE IF EXISTS `kaoshianpai`; CREATE TABLE `kaoshianpai` ( `id` int(11) NOT NULL auto_increment, `xiangmu` varchar(50) default NULL, `kaoshishijian` datetime default NULL, `kaoshididian` varchar(50) default NULL, `beizhu` varchar(500) default NULL, `addtime` timestamp NOT NULL default CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of kaoshianpai -- ---------------------------- INSERT INTO `kaoshianpai` VALUES ('2', '科目三', '2021-02-26 10:36:00', '东城路99号', '没问题', '2021-03-08 10:17:05'); INSERT INTO `kaoshianpai` VALUES ('3', '科目一', '2021-03-27 20:43:00', '河滨东路139号', 'abc', '2021-03-08 10:17:05'); INSERT INTO `kaoshianpai` VALUES ('4', '科目二', '2021-04-03 05:52:00', '方城丽圆11幢201室', '无', '2021-03-08 10:17:05'); INSERT INTO `kaoshianpai` VALUES ('5', '科目二', '2021-04-03 05:52:00', '开明路22号', 'abc', '2021-03-08 10:17:05'); INSERT INTO `kaoshianpai` VALUES ('6', '科目一', '2021-03-15 05:46:00', '人民路57号', 'ok', '2021-03-08 10:17:05'); INSERT INTO `kaoshianpai` VALUES ('7', '科目三', '2021-03-27 20:43:00', '泰兴路22号', '无', '2021-03-08 10:17:05'); INSERT INTO `kaoshianpai` VALUES ('8', '科目三', '2021-02-16 16:29:00', '鑫和锦园2栋', '无', '2021-03-08 10:17:05'); INSERT INTO `kaoshianpai` VALUES ('9', '科目三', '2021-02-26 10:36:00', '解放路73号', '没问题', '2021-03-08 10:17:05'); INSERT INTO `kaoshianpai` VALUES ('10', '科目二', '2021-03-11 10:45:37', 'dfs gfds gdf十多个单方事故dfs', '广东佛山给对方是个单方事故的飞洒', '2021-03-08 10:45:47'); -- ---------------------------- -- Table structure for `kaoshiyuyue` -- ---------------------------- DROP TABLE IF EXISTS `kaoshiyuyue`; CREATE TABLE `kaoshiyuyue` ( `id` int(11) NOT NULL auto_increment, `xiangmu` varchar(50) default NULL, `kaoshishijian` varchar(50) default NULL, `kaoshididian` varchar(50) default NULL, `xuehao` varchar(50) default NULL, `xueshengxingming` varchar(50) default NULL, `jiakaojindu` varchar(50) default NULL, `lianxidianhua` varchar(50) default NULL, `jiaolianbianhao` varchar(50) default NULL, `jiaolianxingming` varchar(50) default NULL, `issh` varchar(10) default '待审核', `shhf` varchar(200) default NULL, `addtime` timestamp NOT NULL default CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Re