def writeDailyMetalComments(): link = 'http://www.silver.org.cn/p/' webNet = 'http://www.silver.org.cn' currentList = crawDailyMetalComments(link,webNet) conn = SilverMetalNetSpiderUtils.getMySQLConn() cursor = conn.cursor() try: cursor.execute("DELETE FROM COMMENTS_METAL_RESOURCE_TABLE WHERE SOURCEFLAG = 'SILVERNET'") conn.commit() except conn.Error,e: print "Mysql Error %d: %s" % (e.args[0], e.args[1]) conn.rollback()