def writeDailyStockComments():
link = 'http://stock.huagu.com/hgsd/'
webNet = 'http://stock.huagu.com'
currentList = crawDailyStockComments(link,webNet)
conn = HGStockNetSpiderUtils.getMySQLConn()
cursor = conn.cursor()
try:
cursor.execute("DELETE FROM COMMENTS_STOCK_RESOURCE_TABLE WHERE SOURCEFLAG = 'HGNET'")
conn.commit()
except conn.Error,e:
print "Mysql Error %d: %s" % (e.args[0], e.args[1])
conn.rollback()
