python MySQLdb连接测试

#!/usr/bin/env python
#encoding=utf-8
import sys
reload(sys)
sys.setdefaultencoding("utf-8")
import MySQLdb
mysql=MySQLdb.connect(host="10.10.243.182",user="root",passwd="123",db="pop_cis_uat",charset="utf8")
sql="select sku_id as id,article_no as `model` from product_vender_shop limit 1"
sql="select sku_id as id,article_no as `model` from product_vender_shop"
hit=mysql.cursor(MySQLdb.cursors.DictCursor)
hit.execute(sql)
result=hit.fetchall()
f=open("/home/mlzboy/work/sh/model2.txt","w")
for row in result:
    model=row["model"]
    if model is None:
        model=""
    else:
        model=row["model"].decode("utf8","ignore").encode("gbk","ignore")
    f.write("%s|||%s\n"%(row["id"],model))
f.close()
mysql.commit()
mysql.close()
print result