python 数组转成json

来源:互联网 发布:无线传输数据 编辑:程序博客网 时间:2024/06/05 16:57
# !/usr/bin/env python# -*- coding: utf-8 -*-import cx_Oraclefrom pprint import pprintimport csvimport timeimport reimport binasciiimport jsonconn = cx_Oracle.connect('system/oracle@192.168.137.2/serv')cursor = conn.cursor()xsql='select * from tlcb_mon_device'r = cursor.execute(xsql)#print rarr=[]for x in r:    #print x[1]   #print x[1].decode('gbk').encode('utf-8')    #print len(x[1])    y=x[1].decode('gbk').encode('utf-8')    #print len(y)    #print  type(x)    arr.append(x[0])    #arr.append(y)b=json.dumps(arr)#print arr#print type(arr)print b#print type(b)

原创粉丝点击