一、在配置类中编写Mysql配置信息

二、实现Mysql配置类 

python">import pymysql
from config.config import MYSQL_HOST, MYSQL_USER, MYSQL_PASSWD, MYSQL_PROT, MYSQL_DB, MYSQL_CHARSETclass MysqlDB():def __init__(self, MYSQL_HOST, MYSQL_USER, MYSQL_PASSWD, MYSQL_PROT, MYSQL_DB, MYSQL_CHARSET):self.mysql = pymysql.connect(host=MYSQL_HOST,  # 连接名称，默认127.0.0.1user=MYSQL_USER,  # 用户名passwd=MYSQL_PASSWD,  # 密码port=MYSQL_PROT,  # 端口，默认为3306db=MYSQL_DB,  # 数据库名称charset=MYSQL_CHARSET,  # 字符编码)def get(self):self.mysql.ping(reconnect=True)cursor = self.mysql.cursor()# 执行一个简单的SELECT语句cursor.execute("select * from test")# 获取结果results = cursor.fetchall()cursor.close()return  resultsdef get_index_by_id(self,id):self.mysql.ping(reconnect=True)cursor = self.mysql.cursor()# 执行一个简单的SELECT语句cursor.execute(f"select * from test where id  = {id}")# 获取结果results = cursor.fetchall()cursor.close()return resultsmysql_db = MysqlDB(MYSQL_HOST, MYSQL_USER, MYSQL_PASSWD, MYSQL_PROT, MYSQL_DB, MYSQL_CHARSET)

三、在目标文件中引用并使用

python">from config.MysqlConfig import mysql_db"""
测试专用
"""
@bi.route('/ssss', methods=['GET'])
def get_test():result = mysql_db.get();print(result)