mysql数据库生成json_Python3实现 将MySQL数据库中的记录生成JSON数据

思路:首先连接MYSQL数据库，将查询到的数据存放到字典中,然年将每个组装好的字典放到List中

调用json.dumps(jsonData, ensure_ascii=False)方法,生成JSON数据并返回。

MySQLData2Json.py

在手机上的效果：

import json, MySQLdb

import io

import sys

import urllib.request

sys.stdout = io.TextIOWrapper(sys.stdout.buffer,encoding='utf8')

'''

Create on 2019-08-12

@author:Philtellcy

@function:Read Data from mysql database transform json format

'''

def Table2Json():

try:

# 连接数据库

conn = MySQLdb.connect(host='localhost', user='root',

passwd='root', db='suibian',charset='utf8')

cur = conn.cursor()

sql = "select * from newstitle"

cur.execute(sql)

result = cur.fetchall()

cur.close()

jsonData = []

# 循环读取元组数据

print("读到了数据")

for row in result:

data = {}

data['NewsID'] = str(row[0])

data['Title'] = str(row[1])

data['DescCn'] = str(row[2])

data['DescJp'] = str(row[3])

data['Title_ip'] = str(row[4])

data['Title_cn'] = row[5]

print(str(row[5]),row[5],data['Title_cn'])

data['Category'] = str(row[6])

data['TopicId'] = str(row[7])

data['Sound'] = str(row[8])

data['Url'] = str(row[9])

data['Pic'] = str(row[10])

data['PicDesc'] = str(row[11])

data['CreatTime'] = str(row[12])

data['PublishTime'] = str(row[13])

data['ReadCount'] = str(row[14])

data['HotFlag'] = str(row[15])

data['Flag'] = str(row[16])

data['WordCount'] = str(row[17])

data['HardWeight'] = str(row[18])

data['TFlag'] = str(row[19])

data['uid'] = str(row[20])

data['auid'] = str(row[21])

data['groupid'] = str(row[22])

data['Likes'] = str(row[23])

data['DisLikes'] = str(row[24])

data['newsfrom'] = str(row[25])

data['VFlag'] = str(row[26])

jsonData.append(data)

jsondatar = json.dumps(jsonData, ensure_ascii=False)

return jsondatar[1:len(jsondatar) - 1]

print("连接成功")

except Exception as e:

print('MySQL connect fail ',e)

if __name__ == '__main__':

jsonData = Table2Json()

print("转换成json的数据",jsonData)

# 将数据存放到本地

f = open('D:\getuidata.txt', 'w+',encoding='utf-8')

f.write(jsonData)

f.close()