python SQLserver 查询得到 字典格式数据

直接上代码吧

?

1 2 3 4 5 6 7 8 9 10 11 12 13

import pymssql    conn = pymssql.connect(host='111111', database='111111', user='1111111', password='11111111', autocommit=True)　　 #核心代码     cursor = conn.cursor(as_dict=True)     sql2 = "SELECT * FROM [dbo].[Stats_Gov_V_Indicator] WHERE VersionId = " + str(VersionId) + " and IsParent = 0 ;"     cursor.execute(sql2)     result_list = cursor.fetchall()     cursor.close()     conn.close()       print len(result_list)       for item in result_list:         get_first_url(item)

　　结果是：