python 连接查询mysql数据库并解决查询结果输出后中文ascii格式的问题

首先引入pyMysql Package然后上代码：#!/usr/bin/python# -*- coding: UTF-8 -*-import pymysqlimport jsondef mysqlOpts():#连接mysql数据库db = pymysql.connect(host='localhost', port=3306, user='root', passwd='allen', db='

zxt_net

461人浏览 · 2020-12-18 22:54:28

zxt_net · 2020-12-18 22:54:28 发布

首先引入pyMysql Package

然后上代码：

#!/usr/bin/python
# -*- coding: UTF-8 -*-
import pymysql
import json

def mysqlOpts():
    #连接mysql数据库
    db = pymysql.connect(host='localhost', port=3306, user='root', passwd='allen', db='testDB', charset='utf8')
    cursor=db.cursor()
    data=cursor.execute('select * from t_student')
    dataInfo=cursor.fetchmany(data)
    for info in dataInfo:
        #这是关键
        print json.dumps(info,encoding='UTF-8', ensure_ascii=False)

if __name__ == '__main__':
    mysqlOpts()