def writeMorningMetalDailyNews(): link = 'http://news.fx168.com/top/gold/' currentList = crawMorningMetalDailyNews(link) conn = FXNewsMetalNetSpiderUtils.getMySQLConn() cursor = conn.cursor() try: cursor.execute("DELETE FROM MORNING_OTHERNEWS_RESOURCE_TABLE WHERE SOURCEFLAG = 'FXNET' AND NEWSFLAG='METAL'") conn.commit() except conn.Error,e: print "Mysql Error %d: %s" % (e.args[0], e.args[1]) conn.rollback()