python读取mysql中表内数据转换成json_【python】从MySQL中读取内容，存为json对象的列表...

现在有数据存在MySQL中，需要把其中的数据存为json对象再进行解析，写了一个简单的python脚本以供参考，其中用了python的MySQLdb库

# !/usr/bin/python

# -*- coding:utf-8 -*-

import json,MySQLdb

def tableToJson(table):

try:

conn = MySQLdb.Connect(host='localhost',user='root',passwd='nsfocus',db='securitycontroller',port=3306) #define connection object

cur = conn.cursor()

except:

print 'MySQL connect fail...'

sql = 'select * from %s' %table

cur.execute(sql)

data = cur.fetchall()

cur.close()

jsonData = []

for row in data:

#each row just like 'e4e580edfa0ed99ab9159f962df4da16 000081eb0e69212fdcc4005106529732 00:11:22:03:04:02 00:90:0b:2f:15:46 10.201.111.1 114.114.114.114 7170 53 0 0 [(00:00:00:1e:08:09:64:36,46)] 2014-12-04T13:19:45.981+08:00 2014-12-04