开发语言：Java
框架：ssm
JDK版本：JDK1.8
服务器：tomcat7
数据库：mysql 5.7（一定要5.7版本）
数据库工具：Navicat11
开发软件：eclipse/myeclipse/idea
Maven包：Maven3.3.9
浏览器：谷歌浏览器
数据库脚本：
DROP TABLE IF EXISTS `dingdanxinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dingdanxinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`dingdanbianhao` varchar(200) DEFAULT NULL COMMENT ‘订单编号’,
`chufadi` varchar(200) DEFAULT NULL COMMENT ‘出发地’,
`mudedi` varchar(200) DEFAULT NULL COMMENT ‘目的地’,
`xiadanshijian` datetime DEFAULT NULL COMMENT ‘下单时间’,
`dingdanzhuangtai` varchar(200) DEFAULT NULL COMMENT ‘订单状态’,
`beizhu` varchar(200) DEFAULT NULL COMMENT ‘备注’,
`xuehao` varchar(200) DEFAULT NULL COMMENT ‘学号’,
`xingming` varchar(200) DEFAULT NULL COMMENT ‘姓名’,
`lianxidianhua` varchar(200) DEFAULT NULL COMMENT ‘联系电话’,
PRIMARY KEY (`id`),
UNIQUE KEY `dingdanbianhao` (`dingdanbianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=1650292773423 DEFAULT CHARSET=utf8 COMMENT=’订单信息’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `dingdanxinxi`
—
LOCK TABLES `dingdanxinxi` WRITE;
/*!40000 ALTER TABLE `dingdanxinxi` DISABLE KEYS */;
INSERT INTO `dingdanxinxi` VALUES (31,’2022-04-18 13:36:37′,’1111111111′,’出发地1′,’目的地1′,’2022-04-18 21:36:37′,’已接单’,’备注1′,’学号1′,’姓名1′,’13823888881′),(32,’2022-04-18 13:36:37′,’2222222222′,’出发地2′,’目的地2′,’2022-04-18 21:36:37′,’已接单’,’备注2′,’学号2′,’姓名2′,’13823888882′),(33,’2022-04-18 13:36:37′,’3333333333′,’出发地3′,’目的地3′,’2022-04-18 21:36:37′,’已接单’,’备注3′,’学号3′,’姓名3′,’13823888883′),(34,’2022-04-18 13:36:37′,’4444444444′,’出发地4′,’目的地4′,’2022-04-18 21:36:37′,’已接单’,’备注4′,’学号4′,’姓名4′,’13823888884′),(35,’2022-04-18 13:36:37′,’5555555555′,’出发地5′,’目的地5′,’2022-04-18 21:36:37′,’已接单’,’备注5′,’学号5′,’姓名5′,’13823888885′),(36,’2022-04-18 13:36:37′,’6666666666′,’出发地6′,’目的地6′,’2022-04-18 21:36:37′,’已接单’,’备注6′,’学号6′,’姓名6′,’13823888886′),(1650292773422,’2022-04-18 14:39:33′,’1650292700199′,’XXXX’,’XXX’,’2022-04-18 22:38:20′,’已接单’,’XXX’,’111′,’张三’,’18154541454′);
/*!40000 ALTER TABLE `dingdanxinxi` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `jiedanxinxi`
—
DROP TABLE IF EXISTS `jiedanxinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jiedanxinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`dingdanbianhao` varchar(200) DEFAULT NULL COMMENT ‘订单编号’,
`chufadi` varchar(200) DEFAULT NULL COMMENT ‘出发地’,
`mudedi` varchar(200) DEFAULT NULL COMMENT ‘目的地’,
`jiage` float DEFAULT NULL COMMENT ‘价格’,
`jiedanshijian` datetime DEFAULT NULL COMMENT ‘接单时间’,
`jiedanzhuangtai` varchar(200) DEFAULT NULL COMMENT ‘接单状态’,
`jiedanbeizhu` varchar(200) DEFAULT NULL COMMENT ‘接单备注’,
`xuehao` varchar(200) DEFAULT NULL COMMENT ‘学号’,
`xingming` varchar(200) DEFAULT NULL COMMENT ‘姓名’,
`sijizhanghao` varchar(200) DEFAULT NULL COMMENT ‘司机账号’,
`sijixingming` varchar(200) DEFAULT NULL COMMENT ‘司机姓名’,
`lianxidianhua` varchar(200) DEFAULT NULL COMMENT ‘联系电话’,
`sfsh` varchar(200) DEFAULT ‘否’ COMMENT ‘是否审核’,
`shhf` longtext COMMENT ‘审核回复’,
`ispay` varchar(200) DEFAULT ‘未支付’ COMMENT ‘是否支付’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1650292827109 DEFAULT CHARSET=utf8 COMMENT=’接单信息’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `jiedanxinxi`
—
LOCK TABLES `jiedanxinxi` WRITE;
/*!40000 ALTER TABLE `jiedanxinxi` DISABLE KEYS */;
INSERT INTO `jiedanxinxi` VALUES (41,’2022-04-18 13:36:37′,’订单编号1′,’出发地1′,’目的地1′,1,’2022-04-18 21:36:37′,’待付款’,’接单备注1′,’学号1′,’姓名1′,’司机账号1′,’司机姓名1′,’13823888881′,’是’,”,’未支付’),(42,’2022-04-18 13:36:37′,’订单编号2′,’出发地2′,’目的地2′,2,’2022-04-18 21:36:37′,’待付款’,’接单备注2′,’学号2′,’姓名2′,’司机账号2′,’司机姓名2′,’13823888882′,’是’,”,’未支付’),(43,’2022-04-18 13:36:37′,’订单编号3′,’出发地3′,’目的地3′,3,’2022-04-18 21:36:37′,’待付款’,’接单备注3′,’学号3′,’姓名3′,’司机账号3′,’司机姓名3′,’13823888883′,’是’,”,’未支付’),(44,’2022-04-18 13:36:37′,’订单编号4′,’出发地4′,’目的地4′,4,’2022-04-18 21:36:37′,’待付款’,’接单备注4′,’学号4′,’姓名4′,’司机账号4′,’司机姓名4′,’13823888884′,’是’,”,’未支付’),(45,’2022-04-18 13:36:37′,’订单编号5′,’出发地5′,’目的地5′,5,’2022-04-18 21:36:37′,’待付款’,’接单备注5′,’学号5′,’姓名5′,’司机账号5′,’司机姓名5′,’13823888885′,’是’,”,’未支付’),(46,’2022-04-18 13:36:37′,’订单编号6′,’出发地6′,’目的地6′,6,’2022-04-18 21:36:37′,’待付款’,’接单备注6′,’学号6′,’姓名6′,’司机账号6′,’司机姓名6′,’13823888886′,’是’,”,’未支付’),(1650292827108,’2022-04-18 14:40:26′,’1650292700199′,’XXXX’,’XXX’,80,’2022-04-18 22:39:10′,’已完成’,’xxxx’,’111′,’张三’,’222′,’李四’,’18154541454′,’是’,’xx’,’已支付’);
/*!40000 ALTER TABLE `jiedanxinxi` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `liuyanxinxi`
—
DROP TABLE IF EXISTS `liuyanxinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `liuyanxinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`biaoti` varchar(200) DEFAULT NULL COMMENT ‘标题’,
`liuyanneirong` longtext COMMENT ‘留言内容’,
`liuyanshijian` datetime 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=1650292878646 DEFAULT CHARSET=utf8 COMMENT=’留言信息’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `liuyanxinxi`
—
LOCK TABLES `liuyanxinxi` WRITE;
/*!40000 ALTER TABLE `liuyanxinxi` DISABLE KEYS */;
INSERT INTO `liuyanxinxi` VALUES (51,’2022-04-18 13:36:37′,’标题1′,’留言内容1′,’2022-04-18 21:36:37′,’是’,”,1),(52,’2022-04-18 13:36:37′,’标题2′,’留言内容2′,’2022-04-18 21:36:37′,’是’,”,2),(53,’2022-04-18 13:36:37′,’标题3′,’留言内容3′,’2022-04-18 21:36:37′,’是’,”,3),(54,’2022-04-18 13:36:37′,’标题4′,’留言内容4′,’2022-04-18 21:36:37′,’是’,”,4),(55,’2022-04-18 13:36:37′,’标题5′,’留言内容5′,’2022-04-18 21:36:37′,’是’,”,5),(56,’2022-04-18 13:36:37′,’标题6′,’留言内容6′,’2022-04-18 21:36:37′,’是’,”,6),(1650292781241,’2022-04-18 14:39:40′,’XXXX’,’XXXX’,’2022-04-18 22:38:31′,’是’,’回复留言信息’,1650292651525),(1650292878645,’2022-04-18 14:41:17′,’XXXX’,’XXXX’,’2022-04-18 22:40:08′,’是’,’回复留言’,1650292680057);
/*!40000 ALTER TABLE `liuyanxinxi` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `siji`
—
DROP TABLE IF EXISTS `siji`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `siji` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`sijizhanghao` varchar(200) NOT NULL COMMENT ‘司机账号’,
`mima` varchar(200) NOT NULL COMMENT ‘密码’,
`sijixingming` varchar(200) NOT NULL COMMENT ‘司机姓名’,
`lianxidianhua` varchar(200) DEFAULT NULL COMMENT ‘联系电话’,
`shenfenzheng` varchar(200) DEFAULT NULL COMMENT ‘身份证’,
`jinjilianxiren` varchar(200) DEFAULT NULL COMMENT ‘紧急联系人’,
`jinjidianhua` varchar(200) DEFAULT NULL COMMENT ‘紧急电话’,
`chexing` varchar(200) DEFAULT NULL COMMENT ‘车型’,
`jiashizheng` varchar(200) DEFAULT NULL COMMENT ‘驾驶证’,
`sfsh` varchar(200) DEFAULT ‘否’ COMMENT ‘是否审核’,
`shhf` longtext COMMENT ‘审核回复’,
PRIMARY KEY (`id`),
UNIQUE KEY `sijizhanghao` (`sijizhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=1650292680058 DEFAULT CHARSET=utf8 COMMENT=’司机’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `siji`
—
LOCK TABLES `siji` WRITE;
/*!40000 ALTER TABLE `siji` DISABLE KEYS */;
INSERT INTO `siji` VALUES (21,’2022-04-18 13:36:37′,’司机账号1′,’e10adc3949ba59abbe56e057f20f883e’,’司机姓名1′,’13823888881′,’440300199101010001′,’紧急联系人1′,’13823888881′,’车型1′,’upload/siji_jiashizheng1.jpg’,’是’,”),(22,’2022-04-18 13:36:37′,’司机账号2′,’e10adc3949ba59abbe56e057f20f883e’,’司机姓名2′,’13823888882′,’440300199202020002′,’紧急联系人2′,’13823888882′,’车型2′,’upload/siji_jiashizheng2.jpg’,’是’,”),(23,’2022-04-18 13:36:37′,’司机账号3′,’e10adc3949ba59abbe56e057f20f883e’,’司机姓名3′,’13823888883′,’440300199303030003′,’紧急联系人3′,’13823888883′,’车型3′,’upload/siji_jiashizheng3.jpg’,’是’,”),(24,’2022-04-18 13:36:37′,’司机账号4′,’e10adc3949ba59abbe56e057f20f883e’,’司机姓名4′,’13823888884′,’440300199404040004′,’紧急联系人4′,’13823888884′,’车型4′,’upload/siji_jiashizheng4.jpg’,’是’,”),(25,’2022-04-18 13:36:37′,’司机账号5′,’e10adc3949ba59abbe56e057f20f883e’,’司机姓名5′,’13823888885′,’440300199505050005′,’紧急联系人5′,’13823888885′,’车型5′,’upload/siji_jiashizheng5.jpg’,’是’,”),(26,’2022-04-18 13:36:37′,’司机账号6′,’e10adc3949ba59abbe56e057f20f883e’,’司机姓名6′,’13823888886′,’440300199606060006′,’紧急联系人6′,’13823888886′,’车型6′,’upload/siji_jiashizheng6.jpg’,’是’,”),(1650292680057,’2022-04-18 14:38:00′,’222′,’bcbe3365e6ac95ea2c0343a2395834dd’,’李四’,’18154541454′,’441458545414541454′,’李武’,’18154541454′,’宝马’,’upload/1650292745660.png’,’是’,’111′);
/*!40000 ALTER TABLE `siji` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `token`
—
DROP TABLE IF EXISTS `token`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `token` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`userid` bigint(20) NOT NULL COMMENT ‘用户id’,
`username` varchar(100) NOT NULL COMMENT ‘用户名’,
`tablename` varchar(100) DEFAULT NULL COMMENT ‘表名’,
`role` varchar(100) DEFAULT NULL COMMENT ‘角色’,
`token` varchar(200) NOT NULL COMMENT ‘密码’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘新增时间’,
`expiratedtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘过期时间’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT=’token表’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `token`
—
LOCK TABLES `token` WRITE;
/*!40000 ALTER TABLE `token` DISABLE KEYS */;
INSERT INTO `token` VALUES (1,1,’abo’,’users’,’管理员’,’pmfrt53eev62le25x62r4gpx2vvif5um’,’2022-04-18 14:38:27′,’2022-04-18 15:41:26′),(2,1650292680057,’222′,’siji’,’司机’,’x3b3closdd9g859hmiqrntwtf37zx0fe’,’2022-04-18 14:38:45′,’2022-04-18 15:42:09′),(3,1650292651525,’111′,’xuesheng’,’学生’,’dllz1p0gjqi45qazq90gch85ibk95tf0′,’2022-04-18 14:39:14′,’2022-04-18 15:42:03′);
/*!40000 ALTER TABLE `token` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `users`
—
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`username` varchar(100) NOT NULL COMMENT ‘用户名’,
`password` varchar(100) NOT NULL COMMENT ‘密码’,
`role` varchar(100) DEFAULT ‘管理员’ COMMENT ‘角色’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘新增时间’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT=’用户表’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `users`
—
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,’abo’,’abo’,’管理员’,’2022-04-18 13:36:37′);
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `xuesheng`
—
DROP TABLE IF EXISTS `xuesheng`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xuesheng` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`xuehao` varchar(200) NOT NULL COMMENT ‘学号’,
`mima` varchar(200) NOT NULL COMMENT ‘密码’,
`xingming` varchar(200) NOT NULL COMMENT ‘姓名’,
`xueyuan` varchar(200) DEFAULT NULL COMMENT ‘学院’,
`lianxidianhua` varchar(200) DEFAULT NULL COMMENT ‘联系电话’,
`jinjilianxiren` varchar(200) DEFAULT NULL COMMENT ‘紧急联系人’,
`jinjidianhua` varchar(200) DEFAULT NULL COMMENT ‘紧急电话’,
`shenfenzheng` varchar(200) DEFAULT NULL COMMENT ‘身份证’,
`xueshengzheng` varchar(200) DEFAULT NULL COMMENT ‘学生证’,
PRIMARY KEY (`id`),
UNIQUE KEY `xuehao` (`xuehao`)
) ENGINE=InnoDB AUTO_INCREMENT=1650292651526 DEFAULT CHARSET=utf8 COMMENT=’学生’;
/*!40101 SET character_set_client = @saved_cs_client */;