def writeLPRConceptDataSource(): link = 'http://www.shibor.org/shibor/web/html/LPR.html' dict = crawLPRDataSource(link) conn = LPRDataNetSpiderUtils.getMySQLConn() cursor = conn.cursor() flag = LPRDataNetSpiderUtils.decideMessageExist(dict['CURRENTTIME']) if(flag): SQL = ' UPDATE DATACENTER_LPR_RESOURCE_TABLE RESOURCE SET RESOURCE.LRPIY=%s ' \ ' WHERE 1=1 AND RESOURCE.CURRENTTIME=%s ' params = (dict['LPR1Y'],dict['CURRENTTIME']) try: cursor.execute(SQL,params) conn.commit() except conn.Error,e: print "Mysql Error %d: %s" % (e.args[0], e.args[1]) conn.rollback()