python学生管理系统实训报告，基于python校园用车管理系统设计实现-计算机毕业设计源码

威哥 2023-01-16 12:04:55 147

python学生管理系统实训报告，基于python校园用车管理系统设计实现-计算机毕业设计源码DROP TABLE IF EXISTS `config`;数据库：数据库工具：Navicat11开发软件：PyCharm浏览器：谷歌浏览器

开发语言：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 */;

python学生管理系统实训报告，基于python校园用车管理系统设计实现-计算机毕业设计源码(1)