python从数据取出数据转为json型

其实也没什么难的，之前卡住了，写个博客以后备用

 

class A():

    def __init__(self):
         = (db='', host='localhost', port=3306, user='', passwd='',
                                  charset='utf8')
         = ()
    def B(self,phone_user):
        sql = 'select * from `%s`' % (phone_user)
        (sql)
        rows = ()
        objects_list = []
        for row in rows:
            d = ()
            d['cardnum'] = row[0]
            d['bankname'] = row[1]
            d['phonenumber'] = row[2]
            d['rest'] = row[3]
            d['id_main'] = row[4]
            objects_list.append(d)
         
        j = (objects_list)
        return j