@app.route('/asnlist') #入库单
def anslist():
db = pymysql.connect("127.0.0.1","root","root","hjs",charset='utf8',cursorclass = pymysql.cursors.DictCursor )
cursor = db.cursor()
sql = "select * from asn"
cursor.execute(sql)
data = cursor.fetchall() #获取全部查询到的数据
# fields = cursor.description #获取全部字段名
cursor.close()
db.close()
return json.dumps(data)
# # 创建字段列表
# column_list = []
# for i in fields:
# column_list.append(i[0])
# jsondata=[]
# for row in data:
# result = {}
# x = 0
# for i in column_list:
# result[i] = row[x]
# x=x+1
# jsondata.append(result)
# return json.dumps(jsondata)
搞了一大通原来pymysql自带字典输出的