收藏关注不迷路!!
🌟文末获取源码+数据库🌟
感兴趣的可以先收藏起来,还有大家在毕设选题(免费咨询指导选题),项目以及论文编写等相关问题都可以给我留言咨询,希望帮助更多的人
前言
随着计算机技术发展,计算机系统的应用已延伸到社会的各个领域,大量基于大数据的广泛应用给生活带来了十分的便利。博客系统凭借其开放性、持久性和深度内容,为个体提供了独特的自我展示和交流空间。此外,博客系统互操作性和自定义功能,为用户提供了高度的自主性和个性化体验,这在数字时代对维护信息多样性和促进民主参与具有重要意义。
系统阐述的是博客系统的设计与实现,对于Python、B/S结构、MySQL进行了较为深入的学习与应用。主要针对系统的设计,描述,实现和分析与测试方面来表明开发的过程。开发中使用了Flask框架和MySQL数据库技术搭建系统的整体架构。利用这些技术结合实际需求开发了具有用户管理,标签管理,分类管理,文章管理,公告资讯管理,举报信息管理,消息通知管理,系统管理,我的信息等功能的系统,最后对系统进行相应的测试,测试系统有无存在问题以及测试用户权限来优化系统,最后系统达到预期目标。
关键字:博客;Python;Flask;MySQL数据库
详细视频演示
文章底部名片,联系我看更详细的演示视频
一、项目介绍
开发语言:Python
python框架:flask
软件版本:python3.7/python3.8
数据库:mysql 5.7或更高版本
数据库工具:Navicat11
开发软件:PyCharm/vs code
前端框架:vue.js
————————————————
二、功能介绍
该章节的功能模块设计,只是大概描述了系统的所有功能模块,将功能按权限来讲解。系统总体功能如图4-1所示。
图4-1 系统总体结构图
三、核心代码
部分代码:
def users_login(request):
if request.method in ["POST", "GET"]:
msg = {'code': normal_code, "msg": mes.normal_code}
req_dict = request.session.get("req_dict")
if req_dict.get('role')!=None:
del req_dict['role']
datas = users.getbyparams(users, users, req_dict)
if not datas:
msg['code'] = password_error_code
msg['msg'] = mes.password_error_code
return JsonResponse(msg)
req_dict['id'] = datas[0].get('id')
return Auth.authenticate(Auth, users, req_dict)
def users_register(request):
if request.method in ["POST", "GET"]:
msg = {'code': normal_code, "msg": mes.normal_code}
req_dict = request.session.get("req_dict")
error = users.createbyreq(users, users, req_dict)
if error != None:
msg['code'] = crud_error_code
msg['msg'] = error
return JsonResponse(msg)
def users_session(request):
'''
'''
if request.method in ["POST", "GET"]:
msg = {"code": normal_code,"msg":mes.normal_code, "data": {}}
req_dict = {"id": request.session.get('params').get("id")}
msg['data'] = users.getbyparams(users, users, req_dict)[0]
return JsonResponse(msg)
def users_logout(request):
if request.method in ["POST", "GET"]:
msg = {
"msg": "退出成功",
"code": 0
}
return JsonResponse(msg)
def users_page(request):
'''
'''
if request.method in ["POST", "GET"]:
msg = {"code": normal_code, "msg": mes.normal_code,
"data": {"currPage": 1, "totalPage": 1, "total": 1, "pageSize": 10, "list": []}}
req_dict = request.session.get("req_dict")
tablename = request.session.get("tablename")
try:
__hasMessage__ = users.__hasMessage__
except:
__hasMessage__ = None
if __hasMessage__ and __hasMessage__ != "否":
if tablename != "users":
req_dict["userid"] = request.session.get("params").get("id")
if tablename == "users":
msg['data']['list'], msg['data']['currPage'], msg['data']['totalPage'], msg['data']['total'], \
msg['data']['pageSize'] = users.page(users, users, req_dict)
else:
msg['data']['list'], msg['data']['currPage'], msg['data']['totalPage'], msg['data']['total'], \
msg['data']['pageSize'] = [],1,0,0,10
return JsonResponse(msg)
数据库参考
-- MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64)
--
-- Host: localhost Database: python12j5u0rf
-- ------------------------------------------------------
-- Server version 5.7.31
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Current Database: `python12j5u0rf`
--
/*!40000 DROP DATABASE IF EXISTS `python12j5u0rf`*/;
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `python12j5u0rf` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
USE `python12j5u0rf`;
--
-- Table structure for table `biaoqian`
--
DROP TABLE IF EXISTS `biaoqian`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `biaoqian` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`biaoqian` varchar(200) NOT NULL COMMENT '标签',
PRIMARY KEY (`id`),
UNIQUE KEY `biaoqian` (`biaoqian`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COMMENT='标签';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `biaoqian`
--
LOCK TABLES `biaoqian` WRITE;
/*!40000 ALTER TABLE `biaoqian` DISABLE KEYS */;
INSERT INTO `biaoqian` VALUES (21,'2024-03-11 12:12:43','标签1'),(22,'2024-03-11 12:12:43','标签2'),(23,'2024-03-11 12:12:43','标签3'),(24,'2024-03-11 12:12:43','标签4'),(25,'2024-03-11 12:12:43','标签5'),(26,'2024-03-11 12:12:43','标签6'),(27,'2024-03-11 12:12:43','标签7'),(28,'2024-03-11 12:12:43','标签8');
/*!40000 ALTER TABLE `biaoqian` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `chat`
--
DROP TABLE IF EXISTS `chat`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chat` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`adminid` bigint(20) DEFAULT NULL COMMENT '管理员id',
`ask` longtext COMMENT '提问',
`reply` longtext COMMENT '回复',
`isreply` int(11) DEFAULT NULL COMMENT '是否回复',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1710163318088 DEFAULT CHARSET=utf8 COMMENT='平台沟通';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `chat`
--
LOCK TABLES `chat` WRITE;
/*!40000 ALTER TABLE `chat` DISABLE KEYS */;
INSERT INTO `chat` VALUES (81,'2024-03-11 12:12:43',1,1,'提问1','回复1',1),(82,'2024-03-11 12:12:43',2,2,'提问2','回复2',2),(83,'2024-03-11 12:12:43',3,3,'提问3','回复3',3),(84,'2024-03-11 12:12:43',4,4,'提问4','回复4',4),(85,'2024-03-11 12:12:43',5,5,'提问5','回复5',5),(86,'2024-03-11 12:12:43',6,6,'提问6','回复6',6),(87,'2024-03-11 12:12:43',7,7,'提问7','回复7',7),(88,'2024-03-11 12:12:43',8,8,'提问8','回复8',8),(1710163318087,'2024-03-11 13:21:58',1710163310156,NULL,'11',NULL,1);
/*!40000 ALTER TABLE `chat` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `config`
--
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 '配置参数值',
`url` varchar(500) DEFAULT NULL COMMENT 'url',
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',NULL),(2,'picture2','upload/picture2.jpg',NULL),(3,'picture3','upload/picture3.jpg',NULL);
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `discussgonggaozixun`
--
DROP TABLE IF EXISTS `discussgonggaozixun`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discussgonggaozixun` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`refid` bigint(20) NOT NULL COMMENT '关联表id',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`avatarurl` longtext COMMENT '头像',
`nickname` varchar(200) DEFAULT NULL COMMENT '用户名',
`content` longtext NOT NULL COMMENT '评论内容',
`reply` longtext COMMENT '回复内容',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1710163170182 DEFAULT CHARSET=utf8 COMMENT='公告资讯评论表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `discussgonggaozixun`
--
LOCK TABLES `discussgonggaozixun` WRITE;
/*!40000 ALTER TABLE `discussgonggaozixun` DISABLE KEYS */;
INSERT INTO `discussgonggaozixun` VALUES (1710163170181,'2024-03-11 13:19:30',58,11,'upload/yonghu_touxiang1.jpg','用户名1','<p>666</p>',NULL);
/*!40000 ALTER TABLE `discussgonggaozixun` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `discusswenzhang`
--
DROP TABLE IF EXISTS `discusswenzhang`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discusswenzhang` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`refid` bigint(20) NOT NULL COMMENT '关联表id',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`avatarurl` longtext COMMENT '头像',
`nickname` varchar(200) DEFAULT NULL COMMENT '用户名',
`content` longtext NOT NULL COMMENT '评论内容',
`reply` longtext COMMENT '回复内容',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文章评论表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `discusswenzhang`
--
LOCK TABLES `discusswenzhang` WRITE;
/*!40000 ALTER TABLE `discusswenzhang` DISABLE KEYS */;
/*!40000 ALTER TABLE `discusswenzhang` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `fenlei`
--
DROP TABLE IF EXISTS `fenlei`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fenlei` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`fenlei` varchar(200) NOT NULL COMMENT '分类',
`image` longtext COMMENT '图片',
PRIMARY KEY (`id`),
UNIQUE KEY `fenlei` (`fenlei`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 COMMENT='分类';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `fenlei`
--
LOCK TABLES `fenlei` WRITE;
/*!40000 ALTER TABLE `fenlei` DISABLE KEYS */;
INSERT INTO `fenlei` VALUES (31,'2024-03-11 12:12:43','分类1','upload/fenlei_image1.jpg,upload/fenlei_image2.jpg,upload/fenlei_image3.jpg'),(32,'2024-03-11 12:12:43','分类2','upload/fenlei_image2.jpg,upload/fenlei_image3.jpg,upload/fenlei_image4.jpg'),(33,'2024-03-11 12:12:43','分类3','upload/fenlei_image3.jpg,upload/fenlei_image4.jpg,upload/fenlei_image5.jpg'),(34,'2024-03-11 12:12:43','分类4','upload/fenlei_image4.jpg,upload/fenlei_image5.jpg,upload/fenlei_image6.jpg'),(35,'2024-03-11 12:12:43','分类5','upload/fenlei_image5.jpg,upload/fenlei_image6.jpg,upload/fenlei_image7.jpg'),(36,'2024-03-11 12:12:43','分类6','upload/fenlei_image6.jpg,upload/fenlei_image7.jpg,upload/fenlei_image8.jpg'),(37,'2024-03-11 12:12:43','分类7','upload/fenlei_image7.jpg,upload/fenlei_image8.jpg,upload/fenlei_image9.jpg'),(38,'2024-03-11 12:12:43','分类8','upload/fenlei_image8.jpg,upload/fenlei_image9.jpg,upload/fenlei_image10.jpg');
/*!40000 ALTER TABLE `fenlei` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `gonggaozixun`
--
DROP TABLE IF EXISTS `gonggaozixun`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gonggaozixun` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`biaoti` varchar(200) NOT NULL COMMENT '标题',
`tupian` longtext COMMENT '图片',
`jianjie` longtext COMMENT '简介',
`neirong` longtext NOT NULL COMMENT '内容',
`fabushijian` datetime DEFAULT NULL COMMENT '发布时间',
`thumbsupnum` int(11) DEFAULT '0' COMMENT '赞',
`crazilynum` int(11) DEFAULT '0' COMMENT '踩',
`clicktime` datetime DEFAULT NULL COMMENT '最近点击时间',
`clicknum` int(11) DEFAULT '0' COMMENT '点击次数',
`discussnum` int(11) DEFAULT '0' COMMENT '评论数',
`storeupnum` int(11) DEFAULT '0' COMMENT '收藏数',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8 COMMENT='公告资讯';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `gonggaozixun`
--
LOCK TABLES `gonggaozixun` WRITE;
/*!40000 ALTER TABLE `gonggaozixun` DISABLE KEYS */;
INSERT INTO `gonggaozixun` VALUES (51,'2024-03-11 12:12:43','标题1','upload/gonggaozixun_tupian1.jpg,upload/gonggaozixun_tupian2.jpg,upload/gonggaozixun_tupian3.jpg','简介1','内容1','2024-03-11 20:12:43',1,1,'2024-03-11 20:12:43',1,0,1),(52,'2024-03-11 12:12:43','标题2','upload/gonggaozixun_tupian2.jpg,upload/gonggaozixun_tupian3.jpg,upload/gonggaozixun_tupian4.jpg','简介2','内容2','2024-03-11 20:12:43',2,2,'2024-03-11 20:12:43',2,0,2),(53,'2024-03-11 12:12:43','标题3','upload/gonggaozixun_tupian3.jpg,upload/gonggaozixun_tupian4.jpg,upload/gonggaozixun_tupian5.jpg','简介3','内容3','2024-03-11 20:12:43',3,3,'2024-03-11 20:12:43',3,0,3),(54,'2024-03-11 12:12:43','标题4','upload/gonggaozixun_tupian4.jpg,upload/gonggaozixun_tupian5.jpg,upload/gonggaozixun_tupian6.jpg','简介4','内容4','2024-03-11 20:12:43',4,4,'2024-03-11 20:12:43',4,0,4),(55,'2024-03-11 12:12:43','标题5','upload/gonggaozixun_tupian5.jpg,upload/gonggaozixun_tupian6.jpg,upload/gonggaozixun_tupian7.jpg','简介5','内容5','2024-03-11 20:12:43',5,5,'2024-03-11 20:12:43',5,0,5),(56,'2024-03-11 12:12:43','标题6','upload/gonggaozixun_tupian6.jpg,upload/gonggaozixun_tupian7.jpg,upload/gonggaozixun_tupian8.jpg','简介6','内容6','2024-03-11 20:12:43',6,6,'2024-03-11 20:12:43',6,0,6),(57,'2024-03-11 12:12:43','标题7','upload/gonggaozixun_tupian7.jpg,upload/gonggaozixun_tupian8.jpg,upload/gonggaozixun_tupian9.jpg','简介7','内容7','2024-03-11 20:12:43',7,7,'2024-03-11 20:12:43',7,0,7),(58,'2024-03-11 12:12:43','标题8','upload/gonggaozixun_tupian8.jpg,upload/gonggaozixun_tupian9.jpg,upload/gonggaozixun_tupian10.jpg','简介8','内容8','2024-03-11 20:12:43',8,8,'2024-03-11 20:12:43',9,1,8);
/*!40000 ALTER TABLE `gonggaozixun` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `jubaoxinxi`
--
DROP TABLE IF EXISTS `jubaoxinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jubaoxinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`yonghuming` varchar(200) DEFAULT NULL COMMENT '用户名',
`nicheng` varchar(200) DEFAULT NULL COMMENT '昵称',
`tupian` longtext COMMENT '图片',
`jubaoneirong` longtext COMMENT '举报内容',
`jubaoshijian` datetime DEFAULT NULL COMMENT '举报时间',
`sfsh` varchar(200) DEFAULT '待审核' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8 COMMENT='举报信息';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `jubaoxinxi`
--
LOCK TABLES `jubaoxinxi` WRITE;
/*!40000 ALTER TABLE `jubaoxinxi` DISABLE KEYS */;
INSERT INTO `jubaoxinxi` VALUES (61,'2024-03-11 12:12:43','用户名1','昵称1','upload/jubaoxinxi_tupian1.jpg,upload/jubaoxinxi_tupian2.jpg,upload/jubaoxinxi_tupian3.jpg','举报内容1','2024-03-11 20:12:43','是',''),(62,'2024-03-11 12:12:43','用户名2','昵称2','upload/jubaoxinxi_tupian2.jpg,upload/jubaoxinxi_tupian3.jpg,upload/jubaoxinxi_tupian4.jpg','举报内容2','2024-03-11 20:12:43','是',''),(63,'2024-03-11 12:12:43','用户名3','昵称3','upload/jubaoxinxi_tupian3.jpg,upload/jubaoxinxi_tupian4.jpg,upload/jubaoxinxi_tupian5.jpg','举报内容3','2024-03-11 20:12:43','是',''),(64,'2024-03-11 12:12:43','用户名4','昵称4','upload/jubaoxinxi_tupian4.jpg,upload/jubaoxinxi_tupian5.jpg,upload/jubaoxinxi_tupian6.jpg','举报内容4','2024-03-11 20:12:43','是',''),(65,'2024-03-11 12:12:43','用户名5','昵称5','upload/jubaoxinxi_tupian5.jpg,upload/jubaoxinxi_tupian6.jpg,upload/jubaoxinxi_tupian7.jpg','举报内容5','2024-03-11 20:12:43','是',''),(66,'2024-03-11 12:12:43','用户名6','昵称6','upload/jubaoxinxi_tupian6.jpg,upload/jubaoxinxi_tupian7.jpg,upload/jubaoxinxi_tupian8.jpg','举报内容6','2024-03-11 20:12:43','是',''),(67,'2024-03-11 12:12:43','用户名7','昵称7','upload/jubaoxinxi_tupian7.jpg,upload/jubaoxinxi_tupian8.jpg,upload/jubaoxinxi_tupian9.jpg','举报内容7','2024-03-11 20:12:43','是',''),(68,'2024-03-11 12:12:43','用户名8','昵称8','upload/jubaoxinxi_tupian8.jpg,upload/jubaoxinxi_tupian9.jpg,upload/jubaoxinxi_tupian10.jpg','举报内容8','2024-03-11 20:12:43','是','');
/*!40000 ALTER TABLE `jubaoxinxi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `menu`
--
DROP TABLE IF EXISTS `menu`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `menu` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`menujson` longtext 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 `menu`
--
LOCK TABLES `menu` WRITE;
/*!40000 ALTER TABLE `menu` DISABLE KEYS */;
INSERT INTO `menu` VALUES (1,'2024-03-11 12:12:43','[{\"backMenu\":[{\"child\":[{\"allButtons\":[\"新增\",\"查看\",\"修改\",\"删除\",\"用户统计\",\"首页总数\",\"首页统计\"],\"appFrontIcon\":\"cuIcon-keyboard\",\"buttons\":[\"新增\",\"查看\",\"修改\",\"删除\",\"首页总数\",\"首页统计\"],\"menu\":\"用户\",\"menuJump\":\"列表\",\"tableName\":\"yonghu\"}],\"menu\":\"用户管理\"},{\"child\":[{\"allButtons\":[\"新增\",\"查看\",\"修改\",\"删除\"],\"appFrontIcon\":\"cuIcon-album\",\"buttons\":[\"新增\",\"查看\",\"修改\",\"删除\"],\"menu\":\"标签\",\"menuJump\":\"列表\",\"tableName\":\"biaoqian\"}],\"menu\":\"标签管理\"},{\"child\":[{\"allButtons\":[\"新增\",\"查看\",\"修改\",\"删除\"],\"appFrontIcon\":\"cuIcon-vipcard\",\"buttons\":[\"新增\",\"查看\",\"修改\",\"删除\"],\"menu\":\"分类\",\"menuJump\":\"列表\",\"tableName\":\"fenlei\"}],\"menu\":\"分类管理\"},{\"child\":[{\"allButtons\":[\"新增\",\"查看\",\"修改\",\"删除\",\"审核\",\"文章统计\",\"用户发布量\",\"查看评论\",\"首页总数\",\"首页统计\"],\"appFrontIcon\":\"cuIcon-pic\",\"buttons\":[\"查看\",\"修改\",\"删除\",\"审核\",\"查看评论\",\"首页统计\",\"首页总数\"],\"menu\":\"文章\",\"menuJump\":\"列表\",\"tableName\":\"wenzhang\"}],\"menu\":\"文章管理\"},{\"child\":[{\"allButtons\":[\"新增\",\"查看\",\"修改\",\"删除\",\"查看评论\"],\"appFrontIcon\":\"cuIcon-rank\",\"buttons\":[\"新增\",\"查看\",\"修改\",\"删除\",\"查看评论\"],\"menu\":\"公告资讯\",\"menuJump\":\"列表\",\"tableName\":\"gonggaozixun\"}],\"menu\":\"公告资讯管理\"},{\"child\":[{\"allButtons\":[\"新增\",\"查看\",\"修改\",\"删除\",\"审核\"],\"appFrontIcon\":\"cuIcon-camera\",\"buttons\":[\"查看\",\"修改\",\"删除\",\"审核\"],\"menu\":\"举报信息\",\"menuJump\":\"列表\",\"tableName\":\"jubaoxinxi\"}],\"menu\":\"举报信息管理\"},{\"child\":[{\"allButtons\":[\"新增\",\"查看\",\"修改\",\"删除\"],\"appFrontIcon\":\"cuIcon-discover\",\"buttons\":[\"新增\",\"查看\",\"修改\",\"删除\"],\"menu\":\"消息通知\",\"menuJump\":\"列表\",\"tableName\":\"xiaoxitongzhi\"}],\"menu\":\"消息通知管理\"},{\"child\":[{\"allButtons\":[\"新增\",\"查看\",\"修改\",\"删除\"],\"appFrontIcon\":\"cuIcon-service\",\"buttons\":[\"查看\",\"修改\",\"删除\"],\"menu\":\"平台沟通\",\"tableName\":\"chat\"},{\"allButtons\":[\"查看\",\"编辑名称\",\"编辑父级\",\"编辑权限\",\"删除\"],\"appFrontIcon\":\"cuIcon-brand\",\"buttons\":[\"查看\",\"编辑权限\",\"删除\"],\"menu\":\"菜单列表\",\"tableName\":\"menu\"},{\"allButtons\":[\"查看\",\"删除\"],\"appFrontIcon\":\"cuIcon-copy\",\"buttons\":[\"查看\",\"删除\"],\"menu\":\"系统日志\",\"tableName\":\"syslog\"},{\"allButtons\":[\"新增\",\"查看\",\"修改\",\"删除\"],\"appFrontIcon\":\"cuIcon-similar\",\"buttons\":[\"查看\",\"修改\"],\"menu\":\"轮播图管理\",\"tableName\":\"config\"}],\"menu\":\"系统管理\"}],\"frontMenu\":[{\"child\":[{\"allButtons\":[\"新增\",\"查看\",\"修改\",\"删除\",\"审核\",\"文章统计\",\"用户发布量\",\"查看评论\",\"首页总数\",\"首页统计\"],\"appFrontIcon\":\"cuIcon-medal\",\"buttons\":[\"查看\",\"查看评论\"],\"menu\":\"文章列表\",\"menuJump\":\"列表\",\"tableName\":\"wenzhang\"}],\"menu\":\"文章模块\"},{\"child\":[{\"allButtons\":[\"新增\",\"查看\",\"修改\",\"删除\",\"查看评论\"],\"appFrontIcon\":\"cuIcon-discover\",\"buttons\":[\"查看\",\"查看评论\"],\"menu\":\"公告资讯列表\",\"menuJump\":\"列表\",\"tableName\":\"gonggaozixun\"}],\"menu\":\"公告资讯模块\"}],\"hasBackLogin\":\"是\",\"hasBackRegister\":\"否\",\"hasFrontLogin\":\"否\",\"hasFrontRegister\":\"否\",\"roleName\":\"管理员\",\"tableName\":\"users\"},{\"backMenu\":[{\"child\":[{\"allButtons\":[\"新增\",\"查看\",\"修改\",\"删除\",\"审核\",\"文章统计\",\"用户发布量\",\"查看评论\",\"首页总数\",\"首页统计\"],\"appFrontIcon\":\"cuIcon-pic\",\"buttons\":[\"新增\",\"查看\",\"修改\",\"删除\"],\"menu\":\"文章\",\"menuJump\":\"列表\",\"tableName\":\"wenzhang\"}],\"menu\":\"文章管理\"},{\"child\":[{\"allButtons\":[\"新增\",\"查看\",\"修改\",\"删除\",\"审核\"],\"appFrontIcon\":\"cuIcon-camera\",\"buttons\":[\"新增\",\"查看\",\"修改\",\"删除\"],\"menu\":\"举报信息\",\"menuJump\":\"列表\",\"tableName\":\"jubaoxinxi\"}],\"menu\":\"举报信息管理\"},{\"child\":[{\"allButtons\":[\"新增\",\"查看\",\"修改\",\"删除\"],\"appFrontIcon\":\"cuIcon-discover\",\"buttons\":[\"查看\"],\"menu\":\"消息通知\",\"menuJump\":\"列表\",\"tableName\":\"xiaoxitongzhi\"}],\"menu\":\"消息通知管理\"}],\"frontMenu\":[{\"child\":[{\"allButtons\":[\"新增\",\"查看\",\"修改\",\"删除\",\"审核\",\"文章统计\",\"用户发布量\",\"查看评论\",\"首页总数\",\"首页统计\"],\"appFrontIcon\":\"cuIcon-medal\",\"buttons\":[\"查看\",\"查看评论\"],\"menu\":\"文章列表\",\"menuJump\":\"列表\",\"tableName\":\"wenzhang\"}],\"menu\":\"文章模块\"},{\"child\":[{\"allButtons\":[\"新增\",\"查看\",\"修改\",\"删除\",\"查看评论\"],\"appFrontIcon\":\"cuIcon-discover\",\"buttons\":[\"查看\",\"查看评论\"],\"menu\":\"公告资讯列表\",\"menuJump\":\"列表\",\"tableName\":\"gonggaozixun\"}],\"menu\":\"公告资讯模块\"}],\"hasBackLogin\":\"否\",\"hasBackRegister\":\"否\",\"hasFrontLogin\":\"是\",\"hasFrontRegister\":\"是\",\"roleName\":\"用户\",\"tableName\":\"yonghu\"}]');
/*!40000 ALTER TABLE `menu` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `storeup`
--
DROP TABLE IF EXISTS `storeup`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `storeup` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`refid` bigint(20) DEFAULT NULL COMMENT '商品id',
`tablename` varchar(200) DEFAULT NULL COMMENT '表名',
`name` varchar(200) NOT NULL COMMENT '名称',
`picture` longtext COMMENT '图片',
`type` varchar(200) DEFAULT '1' COMMENT '类型',
`inteltype` varchar(200) DEFAULT NULL COMMENT '推荐类型',
`remark` varchar(200) DEFAULT NULL COMMENT '备注',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='收藏表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `storeup`
--
LOCK TABLES `storeup` WRITE;
/*!40000 ALTER TABLE `storeup` DISABLE KEYS */;
/*!40000 ALTER TABLE `storeup` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `syslog`
--
DROP TABLE IF EXISTS `syslog`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `syslog` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`username` varchar(200) NOT NULL COMMENT '用户名',
`operation` varchar(200) NOT NULL COMMENT '用户操作',
`method` varchar(200) DEFAULT NULL COMMENT '请求方法',
`params` longtext COMMENT '请求参数',
`time` bigint(20) DEFAULT NULL COMMENT '请求时长(毫秒)',
`ip` varchar(200) DEFAULT NULL COMMENT 'IP地址',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1710163590270 DEFAULT CHARSET=utf8 COMMENT='系统日志';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `syslog`
--
LOCK TABLES `syslog` WRITE;
/*!40000 ALTER TABLE `syslog` DISABLE KEYS */;
/*!40000 ALTER TABLE `syslog` 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 '密码',
`image` varchar(200) DEFAULT 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,'admin','admin','upload/image1.jpg','管理员','2024-03-11 12:12:43');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `wenzhang`
--
DROP TABLE IF EXISTS `wenzhang`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wenzhang` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`biaoti` varchar(200) NOT NULL COMMENT '标题',
`fenlei` varchar(200) NOT NULL COMMENT '分类',
`biaoqian` varchar(200) DEFAULT NULL COMMENT '标签',
`tupian` longtext COMMENT '图片',
`shipin` longtext COMMENT '视频',
`yonghuming` varchar(200) DEFAULT NULL COMMENT '用户名',
`nicheng` varchar(200) DEFAULT NULL COMMENT '昵称',
`neirong` longtext COMMENT '内容',
`fabushijian` datetime DEFAULT NULL COMMENT '发布时间',
`sfsh` varchar(200) DEFAULT '待审核' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
`thumbsupnum` int(11) DEFAULT '0' COMMENT '赞',
`crazilynum` int(11) DEFAULT '0' COMMENT '踩',
`clicktime` datetime DEFAULT NULL COMMENT '最近点击时间',
`clicknum` int(11) DEFAULT '0' COMMENT '点击次数',
`discussnum` int(11) DEFAULT '0' COMMENT '评论数',
`storeupnum` int(11) DEFAULT '0' COMMENT '收藏数',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8 COMMENT='文章';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `wenzhang`
--
LOCK TABLES `wenzhang` WRITE;
/*!40000 ALTER TABLE `wenzhang` DISABLE KEYS */;
INSERT INTO `wenzhang` VALUES (41,'2024-03-11 12:12:43','标题1','分类1','标签1','upload/wenzhang_tupian1.jpg,upload/wenzhang_tupian2.jpg,upload/wenzhang_tupian3.jpg','','用户名1','昵称1','内容1','2024-03-11 20:12:43','是','',1,1,'2024-03-11 20:12:43',1,0,1),(42,'2024-03-11 12:12:43','标题2','分类2','标签2','upload/wenzhang_tupian2.jpg,upload/wenzhang_tupian3.jpg,upload/wenzhang_tupian4.jpg','','用户名2','昵称2','内容2','2024-03-11 20:12:43','是','',2,2,'2024-03-11 20:12:43',2,0,2),(43,'2024-03-11 12:12:43','标题3','分类3','标签3','upload/wenzhang_tupian3.jpg,upload/wenzhang_tupian4.jpg,upload/wenzhang_tupian5.jpg','','用户名3','昵称3','内容3','2024-03-11 20:12:43','是','',3,3,'2024-03-11 20:12:43',3,0,3),(44,'2024-03-11 12:12:43','标题4','分类4','标签4','upload/wenzhang_tupian4.jpg,upload/wenzhang_tupian5.jpg,upload/wenzhang_tupian6.jpg','','用户名4','昵称4','内容4','2024-03-11 20:12:43','是','',4,4,'2024-03-11 20:12:43',4,0,4),(45,'2024-03-11 12:12:43','标题5','分类5','标签5','upload/wenzhang_tupian5.jpg,upload/wenzhang_tupian6.jpg,upload/wenzhang_tupian7.jpg','','用户名5','昵称5','内容5','2024-03-11 20:12:43','是','',5,5,'2024-03-11 20:12:43',5,0,5),(46,'2024-03-11 12:12:43','标题6','分类6','标签6','upload/wenzhang_tupian6.jpg,upload/wenzhang_tupian7.jpg,upload/wenzhang_tupian8.jpg','','用户名6','昵称6','内容6','2024-03-11 20:12:43','是','',6,6,'2024-03-11 20:12:43',6,0,6),(47,'2024-03-11 12:12:43','标题7','分类7','标签7','upload/wenzhang_tupian7.jpg,upload/wenzhang_tupian8.jpg,upload/wenzhang_tupian9.jpg','','用户名7','昵称7','内容7','2024-03-11 20:12:43','是','',7,7,'2024-03-11 20:12:43',7,0,7),(48,'2024-03-11 12:12:43','标题8','分类8','标签8','upload/wenzhang_tupian8.jpg,upload/wenzhang_tupian9.jpg,upload/wenzhang_tupian10.jpg','','用户名8','昵称8','内容8','2024-03-11 20:12:43','是','',8,8,'2024-03-11 20:12:43',8,0,8);
/*!40000 ALTER TABLE `wenzhang` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `xiaoxitongzhi`
--
DROP TABLE IF EXISTS `xiaoxitongzhi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xiaoxitongzhi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`yonghuming` varchar(200) NOT NULL COMMENT '用户名',
`nicheng` varchar(200) DEFAULT NULL COMMENT '昵称',
`tongzhineirong` longtext NOT NULL COMMENT '通知内容',
`tongzhishijian` datetime DEFAULT NULL COMMENT '通知时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1710163421505 DEFAULT CHARSET=utf8 COMMENT='消息通知';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `xiaoxitongzhi`
--
LOCK TABLES `xiaoxitongzhi` WRITE;
/*!40000 ALTER TABLE `xiaoxitongzhi` DISABLE KEYS */;
INSERT INTO `xiaoxitongzhi` VALUES (71,'2024-03-11 12:12:43','用户名1','昵称1','通知内容1','2024-03-11 20:12:43'),(72,'2024-03-11 12:12:43','用户名2','昵称2','通知内容2','2024-03-11 20:12:43'),(73,'2024-03-11 12:12:43','用户名3','昵称3','通知内容3','2024-03-11 20:12:43'),(74,'2024-03-11 12:12:43','用户名4','昵称4','通知内容4','2024-03-11 20:12:43'),(75,'2024-03-11 12:12:43','用户名5','昵称5','通知内容5','2024-03-11 20:12:43'),(76,'2024-03-11 12:12:43','用户名6','昵称6','通知内容6','2024-03-11 20:12:43'),(77,'2024-03-11 12:12:43','用户名7','昵称7','通知内容7','2024-03-11 20:12:43'),(78,'2024-03-11 12:12:43','用户名8','昵称8','通知内容8','2024-03-11 20:12:43');
/*!40000 ALTER TABLE `xiaoxitongzhi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `yonghu`
--
DROP TABLE IF EXISTS `yonghu`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `yonghu` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`yonghuming` varchar(200) NOT NULL COMMENT '用户名',
`mima` varchar(200) NOT NULL COMMENT '密码',
`nicheng` varchar(200) NOT NULL COMMENT '昵称',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`nianling` int(11) DEFAULT NULL COMMENT '年龄',
`touxiang` longtext COMMENT '头像',
`status` int(11) DEFAULT '0' COMMENT '状态',
`passwordwrongnum` int(11) DEFAULT '0' COMMENT '密码错误次数',
PRIMARY KEY (`id`),
UNIQUE KEY `yonghuming` (`yonghuming`)
) ENGINE=InnoDB AUTO_INCREMENT=1710163310157 DEFAULT CHARSET=utf8 COMMENT='用户';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `yonghu`
--
LOCK TABLES `yonghu` WRITE;
/*!40000 ALTER TABLE `yonghu` DISABLE KEYS */;
INSERT INTO `yonghu` VALUES (11,'2024-03-11 12:12:43','用户名1','e10adc3949ba59abbe56e057f20f883e','昵称1','男',1,'upload/yonghu_touxiang1.jpg',0,0),(12,'2024-03-11 12:12:43','用户名2','e10adc3949ba59abbe56e057f20f883e','昵称2','男',2,'upload/yonghu_touxiang2.jpg',0,0),(13,'2024-03-11 12:12:43','用户名3','e10adc3949ba59abbe56e057f20f883e','昵称3','男',3,'upload/yonghu_touxiang3.jpg',0,0),(14,'2024-03-11 12:12:43','用户名4','e10adc3949ba59abbe56e057f20f883e','昵称4','男',4,'upload/yonghu_touxiang4.jpg',0,0),(15,'2024-03-11 12:12:43','用户名5','e10adc3949ba59abbe56e057f20f883e','昵称5','男',5,'upload/yonghu_touxiang5.jpg',0,0),(16,'2024-03-11 12:12:43','用户名6','e10adc3949ba59abbe56e057f20f883e','昵称6','男',6,'upload/yonghu_touxiang6.jpg',0,0),(17,'2024-03-11 12:12:43','用户名7','e10adc3949ba59abbe56e057f20f883e','昵称7','男',7,'upload/yonghu_touxiang7.jpg',0,0),(18,'2024-03-11 12:12:43','用户名8','e10adc3949ba59abbe56e057f20f883e','昵称8','男',8,'upload/yonghu_touxiang8.jpg',0,0);
/*!40000 ALTER TABLE `yonghu` 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 */;
-- Dump completed on 2024-03-15 23:17:41
四、效果图
五、文章目录
目 录
1 绪 论 1
1.1 选题背景与意义 1
1.2 国内外研究现状 1
1.3 研究内容 2
2 关键技术介绍 3
2.1 PYTHON语言简介 3
2.2 MySQL数据库 3
2.3 FLASK框架 4
2.4 Vue框架 5
2.5 B/S架构 5
3 系统分析 7
3.1功能需求分析 7
3.2系统可行性分析 7
3.2.1技术可行性 7
3.2.2 经济可行性 8
3.2.3社会可行性 8
3.3 系统功能分析 8
3.4系统流程分析 9
3.4.1 登录流程图 10
3.4.2 添加新用户流程图 10
第四章 系统设计 12
4.1系统设计原理 12
4.2功能模块设计 12
4.3 数据库设计 12
4.3.1数据库设计原则 12
4.3.2数据库E-R图设计 13
4.3.3数据库表结构设计 13
5 系统的实现 22
5.1系统功能实现 22
5.2管理员功能实现 24
6系统测试 32
6.1系统测试的目的 32
6.2软件测试过程 32
6.3系统测试用例 33
结 论 34
致 谢 35
参考文献 36
六 、源码获取
下方名片联系我即可!!
大家点赞、收藏、关注、评论啦 、查看👇🏻获取联系方式👇🏻