开发语言: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′,’[email protected]’,’备注1′),(32,’2022-02-08 08:31:32′,’教师工号2′,’教师姓名2′,’男’,’13823888882′,’[email protected]’,’备注2′),(33,’2022-02-08 08:31:32′,’教师工号3′,’教师姓名3′,’男’,’13823888883′,’[email protected]’,’备注3′),(34,’2022-02-08 08:31:32′,’教师工号4′,’教师姓名4′,’男’,’13823888884′,’[email protected]’,’备注4′),(35,’2022-02-08 08:31:32′,’教师工号5′,’教师姓名5′,’男’,’13823888885′,’[email protected]’,’备注5′),(36,’2022-02-08 08:31:32′,’教师工号6′,’教师姓名6′,’男’,’13823888886′,’[email protected]’,’备注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 */;