def select_table(self,conn,sql_cmd,parmas): # ??????sql
try:
ret = []
conn=MySQLdb.connect(host=conn["host"],user=conn["user"],passwd=conn["password"],db=conn["database"],port=conn["port"],charset="utf8")
cursor = conn.cursor()
n = cursor.execute(sql_cmd,parmas)
for row in cursor.fetchall():
for i in row:
ret.append(i)
conn.commit()
cursor.close()
conn.close()
except MySQLdb.Error,e:
ret.append(e)
return ret
评论列表
文章目录