基于python的校園用車管理系統(tǒng)設(shè)計(jì)與實(shí)現(xiàn)-計(jì)算機(jī)畢業(yè)設(shè)計(jì)源碼+LW文檔
開發(fā)語言：Python
框架：django
Python版本：python3.7.7
數(shù)據(jù)庫：mysql 5.7（一定要5.7版本）
數(shù)據(jù)庫工具：Navicat11
開發(fā)軟件：PyCharm?
瀏覽器：谷歌瀏覽器
數(shù)據(jù)庫：
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 '配置參數(shù)名稱',
? `value` varchar(100) DEFAULT NULL COMMENT '配置參數(shù)值',
? 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 '創(chuàng)建時(shí)間',
? `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 '上車時(shí)間',
? 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 '創(chuàng)建時(shí)間',
? `jiaoshigonghao` varchar(200) DEFAULT NULL COMMENT '教師工號',
? `jiaoshixingming` varchar(200) DEFAULT NULL COMMENT '教師姓名',
? `jiaoshixingbie` varchar(200) DEFAULT NULL COMMENT '教師性別',
? `jiaoshishouji` varchar(200) DEFAULT NULL COMMENT '教師手機(jī)',
? `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 '創(chuàng)建時(shí)間',
? `sijigonghao` varchar(200) DEFAULT NULL COMMENT '司機(jī)工號',
? `sijixingming` varchar(200) DEFAULT NULL COMMENT '司機(jī)姓名',
? `xingbie` varchar(200) DEFAULT NULL COMMENT '性別',
? `nianling` int(11) DEFAULT NULL COMMENT '年齡',
? `jialing` int(11) DEFAULT NULL COMMENT '駕齡',
? `sijishouji` varchar(200) DEFAULT NULL COMMENT '司機(jī)手機(jī)',
? PRIMARY KEY (`id`),
? UNIQUE KEY `sijigonghao` (`sijigonghao`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COMMENT='司機(jī)信息';
/*!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','司機(jī)工號1','司機(jī)姓名1','男',1,1,'司機(jī)手機(jī)1'),(42,'2022-02-08 08:31:32','司機(jī)工號2','司機(jī)姓名2','男',2,2,'司機(jī)手機(jī)2'),(43,'2022-02-08 08:31:32','司機(jī)工號3','司機(jī)姓名3','男',3,3,'司機(jī)手機(jī)3'),(44,'2022-02-08 08:31:32','司機(jī)工號4','司機(jī)姓名4','男',4,4,'司機(jī)手機(jī)4'),(45,'2022-02-08 08:31:32','司機(jī)工號5','司機(jī)姓名5','男',5,5,'司機(jī)手機(jī)5'),(46,'2022-02-08 08:31:32','司機(jī)工號6','司機(jī)姓名6','男',6,6,'司機(jī)手機(jī)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 '新增時(shí)間',
? 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 '創(chuàng)建時(shí)間',
? `xiaochebianhao` varchar(200) DEFAULT NULL COMMENT '校車編號',
? `xiaochemingcheng` varchar(200) DEFAULT NULL COMMENT '校車名稱',
? `chepaihao` varchar(200) DEFAULT NULL COMMENT '車牌號',
? `sijigonghao` varchar(200) DEFAULT NULL COMMENT '司機(jī)工號',
? `sijixingming` varchar(200) DEFAULT NULL COMMENT '司機(jī)姓名',
? `likaishijian` datetime DEFAULT NULL COMMENT '離開時(shí)間',
? `jinrushijian` datetime DEFAULT NULL COMMENT '進(jìn)入時(shí)間',
? `chengzuorenshu` int(11) DEFAULT NULL COMMENT '乘坐人數(shù)',
? `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','司機(jī)工號1','司機(jī)姓名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','司機(jī)工號2','司機(jī)姓名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','司機(jī)工號3','司機(jī)姓名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','司機(jī)工號4','司機(jī)姓名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','司機(jī)工號5','司機(jī)姓名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','司機(jī)工號6','司機(jī)姓名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 '創(chuàng)建時(shí)間',
? `xiaochebianhao` varchar(200) DEFAULT NULL COMMENT '校車編號',
? `xiaochemingcheng` varchar(200) DEFAULT NULL COMMENT '校車名稱',
? `chepaihao` varchar(200) DEFAULT NULL COMMENT '車牌號',
? `zairenshu` int(11) DEFAULT NULL COMMENT '載人數(shù)',
? `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 '創(chuàng)建時(shí)間',
? `xuehao` varchar(200) DEFAULT NULL COMMENT '學(xué)號',
? `xueshengxingming` varchar(200) DEFAULT NULL COMMENT '學(xué)生姓名',
? `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 '上車時(shí)間',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COMMENT='學(xué)生乘坐';
/*!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','學(xué)號1','學(xué)生姓名1','年級1','班級1','校車編號1','校車名稱1','車牌號1','2022-02-08 16:31:33'),(62,'2022-02-08 08:31:33','學(xué)號2','學(xué)生姓名2','年級2','班級2','校車編號2','校車名稱2','車牌號2','2022-02-08 16:31:33'),(63,'2022-02-08 08:31:33','學(xué)號3','學(xué)生姓名3','年級3','班級3','校車編號3','校車名稱3','車牌號3','2022-02-08 16:31:33'),(64,'2022-02-08 08:31:33','學(xué)號4','學(xué)生姓名4','年級4','班級4','校車編號4','校車名稱4','車牌號4','2022-02-08 16:31:33'),(65,'2022-02-08 08:31:33','學(xué)號5','學(xué)生姓名5','年級5','班級5','校車編號5','校車名稱5','車牌號5','2022-02-08 16:31:33'),(66,'2022-02-08 08:31:33','學(xué)號6','學(xué)生姓名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 '創(chuàng)建時(shí)間',
? `xuehao` varchar(200) NOT NULL COMMENT '學(xué)號',
? `xueshengxingming` varchar(200) NOT NULL COMMENT '學(xué)生姓名',
? `xingbie` varchar(200) DEFAULT NULL COMMENT '性別',
? `nianji` varchar(200) DEFAULT NULL COMMENT '年級',
? `banji` varchar(200) DEFAULT NULL COMMENT '班級',
? `xueshengshouji` varchar(200) DEFAULT NULL COMMENT '學(xué)生手機(jī)',
? PRIMARY KEY (`id`),
? UNIQUE KEY `xuehao` (`xuehao`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='學(xué)生信息';
/*!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','學(xué)號1','學(xué)生姓名1','男','年級1','班級1','13823888881'),(12,'2022-02-08 08:31:32','學(xué)號2','學(xué)生姓名2','男','年級2','班級2','13823888882'),(13,'2022-02-08 08:31:32','學(xué)號3','學(xué)生姓名3','男','年級3','班級3','13823888883'),(14,'2022-02-08 08:31:32','學(xué)號4','學(xué)生姓名4','男','年級4','班級4','13823888884'),(15,'2022-02-08 08:31:32','學(xué)號5','學(xué)生姓名5','男','年級5','班級5','13823888885'),(16,'2022-02-08 08:31:32','學(xué)號6','學(xué)生姓名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 */;
