#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
