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()
