python3 读取mysql后放出接口。但是每次前端调用就会报错,怎么解决这个问题?

#coding=utf-8

from flask import Flask, request, jsonify, Blueprint
import json
import result.data as resultData
from MysqlHelper import MysqlHelper


import pymysql  #导入 pymysql

# 打开数据库连接
db = pymysql.connect(host="127.0.0.1", user="root", password="un", db="audit_test", port=3306)

# 使用cursor()方法获取操作游标
cursor = db.cursor()

api_database = Blueprint('database', __name__) # 蓝图

# 普通搜索标题
@api_database.route('/api/database/common', methods=['POST', 'GET'])
def select_database_json():
    sql = "select id,name,password from user"
    cursor.execute(sql)  # 执行sql语句
    # for r in cursor.fetchall():
    #     print(r)
    # cursor.close()
    # db.close()
    #
    # if results == ():
    #     print("用户名错误")
    # elif results != ():
    #     print("登陆成功")
    # else:
    #     print("密码错误")
    #     # print(results)
    db.commit()
    cursor.close()
    db.close()
    helper = MysqlHelper()
    result_text = resultData.result_title_01
    # print(result_text)
    response = jsonify(result_text)
    response.headers['Access-Control-Allow-Origin'] = '*'
    response.headers['Access-Control-Allow-Methods'] = 'POST'
    response.headers['Access-Control-Allow-Headers'] = 'x-requested-with,content-type'
    return response

图片描述

阅读 1.2k
撰写回答
你尚未登录,登录后可以
  • 和开发者交流问题的细节
  • 关注并接收问题和回答的更新提醒
  • 参与内容的编辑和改进,让解决方法与时俱进