基于python的校园用车管理系统设计与实现-计算机毕业设计源码+LW文档

2022-10-04 22:56 作者:计算机毕业设计大神888 0人读过 | 我要投稿

开发语言：Python

框架：django

Python版本：python3.7.7

数据库：mysql 5.7（一定要5.7版本）

数据库工具：Navicat11

开发软件：PyCharm

浏览器：谷歌浏览器

数据库：

DROP TABLE IF EXISTS `config`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

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=4 DEFAULT CHARSET=utf8 COMMENT='配置文件';

/*!40101 SET character_set_client = @saved_cs_client */;

-- Dumping data for table `config`

LOCK TABLES `config` WRITE;

/*!40000 ALTER TABLE `config` DISABLE KEYS */;

INSERT INTO `config` VALUES (1,'picture1','upload/picture1.jpg'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg');

/*!40000 ALTER TABLE `config` ENABLE KEYS */;

UNLOCK TABLES;

-- Table structure for table `jiaoshichengzuo`

DROP TABLE IF EXISTS `jiaoshichengzuo`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `jiaoshichengzuo` (

`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

`jiaoshigonghao` varchar(200) DEFAULT NULL COMMENT '教师工号',

`jiaoshixingming` varchar(200) DEFAULT NULL COMMENT '教师姓名',

`xiaochebianhao` varchar(200) DEFAULT NULL COMMENT '校车编号',

`xiaochemingcheng` varchar(200) DEFAULT NULL COMMENT '校车名称',

`chepaihao` varchar(200) DEFAULT NULL COMMENT '车牌号',

`shangcheshijian` datetime DEFAULT NULL COMMENT '上车时间',

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8 COMMENT='教师乘坐';

/*!40101 SET character_set_client = @saved_cs_client */;

-- Dumping data for table `jiaoshichengzuo`

LOCK TABLES `jiaoshichengzuo` WRITE;

/*!40000 ALTER TABLE `jiaoshichengzuo` DISABLE KEYS */;

INSERT INTO `jiaoshichengzuo` VALUES (71,'2022-02-08 08:31:33','教师工号1','教师姓名1','校车编号1','校车名称1','车牌号1','2022-02-08 16:31:33'),(72,'2022-02-08 08:31:33','教师工号2','教师姓名2','校车编号2','校车名称2','车牌号2','2022-02-08 16:31:33'),(73,'2022-02-08 08:31:33','教师工号3','教师姓名3','校车编号3','校车名称3','车牌号3','2022-02-08 16:31:33'),(74,'2022-02-08 08:31:33','教师工号4','教师姓名4','校车编号4','校车名称4','车牌号4','2022-02-08 16:31:33'),(75,'2022-02-08 08:31:33','教师工号5','教师姓名5','校车编号5','校车名称5','车牌号5','2022-02-08 16:31:33'),(76,'2022-02-08 08:31:33','教师工号6','教师姓名6','校车编号6','校车名称6','车牌号6','2022-02-08 16:31:33');

/*!40000 ALTER TABLE `jiaoshichengzuo` ENABLE KEYS */;

UNLOCK TABLES;

-- Table structure for table `jiaoshixinxi`

DROP TABLE IF EXISTS `jiaoshixinxi`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `jiaoshixinxi` (

`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

`jiaoshigonghao` varchar(200) DEFAULT NULL COMMENT '教师工号',

`jiaoshixingming` varchar(200) DEFAULT NULL COMMENT '教师姓名',

`jiaoshixingbie` varchar(200) DEFAULT NULL COMMENT '教师性别',

`jiaoshishouji` varchar(200) DEFAULT NULL COMMENT '教师手机',

`jiaoshiyouxiang` varchar(200) DEFAULT NULL COMMENT '教师邮箱',

`beizhu` varchar(200) DEFAULT NULL COMMENT '备注',

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COMMENT='教师信息';

/*!40101 SET character_set_client = @saved_cs_client */;

-- Dumping data for table `jiaoshixinxi`

LOCK TABLES `jiaoshixinxi` WRITE;

/*!40000 ALTER TABLE `jiaoshixinxi` DISABLE KEYS */;

INSERT INTO `jiaoshixinxi` VALUES (31,'2022-02-08 08:31:32','教师工号1','教师姓名1','男','13823888881','773890001@qq.com','备注1'),(32,'2022-02-08 08:31:32','教师工号2','教师姓名2','男','13823888882','773890002@qq.com','备注2'),(33,'2022-02-08 08:31:32','教师工号3','教师姓名3','男','13823888883','773890003@qq.com','备注3'),(34,'2022-02-08 08:31:32','教师工号4','教师姓名4','男','13823888884','773890004@qq.com','备注4'),(35,'2022-02-08 08:31:32','教师工号5','教师姓名5','男','13823888885','773890005@qq.com','备注5'),(36,'2022-02-08 08:31:32','教师工号6','教师姓名6','男','13823888886','773890006@qq.com','备注6');

/*!40000 ALTER TABLE `jiaoshixinxi` ENABLE KEYS */;

UNLOCK TABLES;

-- Table structure for table `sijixinxi`

DROP TABLE IF EXISTS `sijixinxi`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `sijixinxi` (

`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

`sijigonghao` varchar(200) DEFAULT NULL COMMENT '司机工号',

`sijixingming` varchar(200) DEFAULT NULL COMMENT '司机姓名',

`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',

`nianling` int(11) DEFAULT NULL COMMENT '年龄',

`jialing` int(11) DEFAULT NULL COMMENT '驾龄',

`sijishouji` varchar(200) DEFAULT NULL COMMENT '司机手机',

PRIMARY KEY (`id`),

UNIQUE KEY `sijigonghao` (`sijigonghao`)

) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COMMENT='司机信息';

/*!40101 SET character_set_client = @saved_cs_client */;

-- Dumping data for table `sijixinxi`

LOCK TABLES `sijixinxi` WRITE;

/*!40000 ALTER TABLE `sijixinxi` DISABLE KEYS */;

INSERT INTO `sijixinxi` VALUES (41,'2022-02-08 08:31:32','司机工号1','司机姓名1','男',1,1,'司机手机1'),(42,'2022-02-08 08:31:32','司机工号2','司机姓名2','男',2,2,'司机手机2'),(43,'2022-02-08 08:31:32','司机工号3','司机姓名3','男',3,3,'司机手机3'),(44,'2022-02-08 08:31:32','司机工号4','司机姓名4','男',4,4,'司机手机4'),(45,'2022-02-08 08:31:32','司机工号5','司机姓名5','男',5,5,'司机手机5'),(46,'2022-02-08 08:31:32','司机工号6','司机姓名6','男',6,6,'司机手机6');

/*!40000 ALTER TABLE `sijixinxi` 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-02-08 08:31:33');

/*!40000 ALTER TABLE `users` ENABLE KEYS */;

UNLOCK TABLES;

-- Table structure for table `xiaochejilu`

DROP TABLE IF EXISTS `xiaochejilu`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `xiaochejilu` (

`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

`xiaochebianhao` varchar(200) DEFAULT NULL COMMENT '校车编号',

`xiaochemingcheng` varchar(200) DEFAULT NULL COMMENT '校车名称',

`chepaihao` varchar(200) DEFAULT NULL COMMENT '车牌号',

`sijigonghao` varchar(200) DEFAULT NULL COMMENT '司机工号',

`sijixingming` varchar(200) DEFAULT NULL COMMENT '司机姓名',

`likaishijian` datetime DEFAULT NULL COMMENT '离开时间',

`jinrushijian` datetime DEFAULT NULL COMMENT '进入时间',

`chengzuorenshu` int(11) DEFAULT NULL COMMENT '乘坐人数',

`beizhu` longtext COMMENT '备注',

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COMMENT='校车记录';

/*!40101 SET character_set_client = @saved_cs_client */;

-- Dumping data for table `xiaochejilu`

LOCK TABLES `xiaochejilu` WRITE;

/*!40000 ALTER TABLE `xiaochejilu` DISABLE KEYS */;

INSERT INTO `xiaochejilu` VALUES (51,'2022-02-08 08:31:33','校车编号1','校车名称1','车牌号1','司机工号1','司机姓名1','2022-02-08 16:31:33','2022-02-08 16:31:33',1,'备注1'),(52,'2022-02-08 08:31:33','校车编号2','校车名称2','车牌号2','司机工号2','司机姓名2','2022-02-08 16:31:33','2022-02-08 16:31:33',2,'备注2'),(53,'2022-02-08 08:31:33','校车编号3','校车名称3','车牌号3','司机工号3','司机姓名3','2022-02-08 16:31:33','2022-02-08 16:31:33',3,'备注3'),(54,'2022-02-08 08:31:33','校车编号4','校车名称4','车牌号4','司机工号4','司机姓名4','2022-02-08 16:31:33','2022-02-08 16:31:33',4,'备注4'),(55,'2022-02-08 08:31:33','校车编号5','校车名称5','车牌号5','司机工号5','司机姓名5','2022-02-08 16:31:33','2022-02-08 16:31:33',5,'备注5'),(56,'2022-02-08 08:31:33','校车编号6','校车名称6','车牌号6','司机工号6','司机姓名6','2022-02-08 16:31:33','2022-02-08 16:31:33',6,'备注6');

/*!40000 ALTER TABLE `xiaochejilu` ENABLE KEYS */;

UNLOCK TABLES;

-- Table structure for table `xiaochexinxi`

DROP TABLE IF EXISTS `xiaochexinxi`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `xiaochexinxi` (

`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

`xiaochebianhao` varchar(200) DEFAULT NULL COMMENT '校车编号',

`xiaochemingcheng` varchar(200) DEFAULT NULL COMMENT '校车名称',

`chepaihao` varchar(200) DEFAULT NULL COMMENT '车牌号',

`zairenshu` int(11) DEFAULT NULL COMMENT '载人数',

`xiaochetupian` varchar(200) DEFAULT NULL COMMENT '校车图片',

`xiaocheluxian` longtext COMMENT '校车路线',

PRIMARY KEY (`id`),

UNIQUE KEY `xiaochebianhao` (`xiaochebianhao`)

) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 COMMENT='校车信息';

/*!40101 SET character_set_client = @saved_cs_client */;

-- Dumping data for table `xiaochexinxi`

LOCK TABLES `xiaochexinxi` WRITE;

/*!40000 ALTER TABLE `xiaochexinxi` DISABLE KEYS */;

INSERT INTO `xiaochexinxi` VALUES (21,'2022-02-08 08:31:32','1111111111','校车名称1','车牌号1',1,'upload/xiaochexinxi_xiaochetupian1.jpg','校车路线1'),(22,'2022-02-08 08:31:32','2222222222','校车名称2','车牌号2',2,'upload/xiaochexinxi_xiaochetupian2.jpg','校车路线2'),(23,'2022-02-08 08:31:32','3333333333','校车名称3','车牌号3',3,'upload/xiaochexinxi_xiaochetupian3.jpg','校车路线3'),(24,'2022-02-08 08:31:32','4444444444','校车名称4','车牌号4',4,'upload/xiaochexinxi_xiaochetupian4.jpg','校车路线4'),(25,'2022-02-08 08:31:32','5555555555','校车名称5','车牌号5',5,'upload/xiaochexinxi_xiaochetupian5.jpg','校车路线5'),(26,'2022-02-08 08:31:32','6666666666','校车名称6','车牌号6',6,'upload/xiaochexinxi_xiaochetupian6.jpg','校车路线6');

/*!40000 ALTER TABLE `xiaochexinxi` ENABLE KEYS */;

UNLOCK TABLES;

-- Table structure for table `xueshengchengzuo`

DROP TABLE IF EXISTS `xueshengchengzuo`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `xueshengchengzuo` (

`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

`xuehao` varchar(200) DEFAULT NULL COMMENT '学号',

`xueshengxingming` varchar(200) DEFAULT NULL COMMENT '学生姓名',

`nianji` varchar(200) DEFAULT NULL COMMENT '年级',

`banji` varchar(200) DEFAULT NULL COMMENT '班级',

`xiaochebianhao` varchar(200) DEFAULT NULL COMMENT '校车编号',

`xiaochemingcheng` varchar(200) DEFAULT NULL COMMENT '校车名称',

`chepaihao` varchar(200) DEFAULT NULL COMMENT '车牌号',

`shangcheshijian` datetime DEFAULT NULL COMMENT '上车时间',

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COMMENT='学生乘坐';

/*!40101 SET character_set_client = @saved_cs_client */;

-- Dumping data for table `xueshengchengzuo`

LOCK TABLES `xueshengchengzuo` WRITE;

/*!40000 ALTER TABLE `xueshengchengzuo` DISABLE KEYS */;

INSERT INTO `xueshengchengzuo` VALUES (61,'2022-02-08 08:31:33','学号1','学生姓名1','年级1','班级1','校车编号1','校车名称1','车牌号1','2022-02-08 16:31:33'),(62,'2022-02-08 08:31:33','学号2','学生姓名2','年级2','班级2','校车编号2','校车名称2','车牌号2','2022-02-08 16:31:33'),(63,'2022-02-08 08:31:33','学号3','学生姓名3','年级3','班级3','校车编号3','校车名称3','车牌号3','2022-02-08 16:31:33'),(64,'2022-02-08 08:31:33','学号4','学生姓名4','年级4','班级4','校车编号4','校车名称4','车牌号4','2022-02-08 16:31:33'),(65,'2022-02-08 08:31:33','学号5','学生姓名5','年级5','班级5','校车编号5','校车名称5','车牌号5','2022-02-08 16:31:33'),(66,'2022-02-08 08:31:33','学号6','学生姓名6','年级6','班级6','校车编号6','校车名称6','车牌号6','2022-02-08 16:31:33');

/*!40000 ALTER TABLE `xueshengchengzuo` ENABLE KEYS */;

UNLOCK TABLES;

-- Table structure for table `xueshengxinxi`

DROP TABLE IF EXISTS `xueshengxinxi`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `xueshengxinxi` (

`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

`xuehao` varchar(200) NOT NULL COMMENT '学号',

`xueshengxingming` varchar(200) NOT NULL COMMENT '学生姓名',

`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',

`nianji` varchar(200) DEFAULT NULL COMMENT '年级',

`banji` varchar(200) DEFAULT NULL COMMENT '班级',

`xueshengshouji` varchar(200) DEFAULT NULL COMMENT '学生手机',

PRIMARY KEY (`id`),

UNIQUE KEY `xuehao` (`xuehao`)

) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='学生信息';

/*!40101 SET character_set_client = @saved_cs_client */;

-- Dumping data for table `xueshengxinxi`

LOCK TABLES `xueshengxinxi` WRITE;

/*!40000 ALTER TABLE `xueshengxinxi` DISABLE KEYS */;

INSERT INTO `xueshengxinxi` VALUES (11,'2022-02-08 08:31:32','学号1','学生姓名1','男','年级1','班级1','13823888881'),(12,'2022-02-08 08:31:32','学号2','学生姓名2','男','年级2','班级2','13823888882'),(13,'2022-02-08 08:31:32','学号3','学生姓名3','男','年级3','班级3','13823888883'),(14,'2022-02-08 08:31:32','学号4','学生姓名4','男','年级4','班级4','13823888884'),(15,'2022-02-08 08:31:32','学号5','学生姓名5','男','年级5','班级5','13823888885'),(16,'2022-02-08 08:31:32','学号6','学生姓名6','男','年级6','班级6','13823888886');

/*!40000 ALTER TABLE `xueshengxinxi` ENABLE KEYS */;

UNLOCK TABLES;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;