cursor这里有个属性:description。获取的是数据库每个栏位(字段,列)情况: (('id', 3, None, 11, 11, 0, False), ('type', 253, None, 5, 5, 0, False)
result_dict = dict(zip([col[0] for col in cursor.description],[col for col in cursor.fetchone()]))
查询结果有多个记录,获取最后一条记录并以字典返回:
result_dict = dict(zip([col[0] for col in cursor.description],[col for col in cursor.fetchall()[-1]]))