Python中返回SQL字段名

def ReturnInfo(self, avalue, akey): cursor = connection.cursor() if type(avalue) == int:

Sql = \"select * from %s where %s=%s\" % (self.table, akey, avalue) else:

Sql = \"select * from %s where %s = '%s'\" % (self.table, akey, avalue) cursor.execute(Sql)

SqlDomain = cursor.description #### DomainNum = len(SqlDomain)

SqlDomainName = [None]*DomainNum for i in range(DomainNum):

SqlDomainName[i] = SqlDomain[i][0] SqlResult = cursor.fetchall() #### cursor.close() result = [None]*2

result[0] = SqlDomainName result[1] = SqlResult return result

cursor.description ⽅法，列出table中每个字段的属性。返回⼀个⼆元元祖，（(.., .., .., ..), (), (), )cursor.fetchall ⽅法， 按字段顺序，列出每⼀⾏的值。返回⼀个⼆元元组,（(.., .., .., ..), (), (), )