python自动翻译实现方法

#encoding=utf-8## eagle_91@sina.com## created 2014-07-22import urllibimport urllib2import MySQLdbimport jsonimport gcimport timeurl = 'http://openapi.baidu.com/public/2.0/bmt/translate'_sleepTime = 0.5_limit = 1000## 链接mysqlconn = MySQLdb.connect(host='localhost',user='root',passwd='',charset='utf8')curs = conn.cursor()conn.select_db('test')## 搜索要操作的表count=curs.execute("""SELECT * FROM sb_parameters WHERE ISNULL(en_name) ORDER BY id ASC""")## print curs.fetchall()## print countresults = curs.fetchmany(_limit)for r in results:  gc.collect()  chin = unicode(r[3]).encode('utf-8')  ## print chin  values = {'client_id':'PWrGllvVAIFcD0sYqaipwkAV','q':chin,'from':'zh','to':'en'}  data = urllib.urlencode(values)  req = urllib2.Request(url, data)  response = urllib2.urlopen(req)  the_page = response.read()  returnData = json.loads(the_page)  ## print returnData  if returnData.has_key("error_code"):    continue;  inputData = returnData["trans_result"][0]["dst"]  try:    sql = "UPDATE `sb_parameters` SET `en_name`='%s' WHERE `id` = %d" % (MySQLdb.escape_string(unicode(inputData).encode('utf-8')),r[0])    print sql    curs.execute(sql)    conn.commit()    time.sleep(_sleepTime)  except EOFError:    sql = "UPDATE `sb_parameters` SET `en_name`='%s' WHERE `id` = %d" % ('',r[0])    print sql    curs.execute(sql)    conn.commit()    continueconn.commit()## 关闭链接curs.close()## 关闭数据库conn.close()