コード例 #1
0
def writeMorningForexDailyNews():
    link = 'http://news.fx168.com/top/forex/'
    currentList = crawMorningForexDailyNews(link)
    conn = FXNewsForexNetSpiderUtils.getMySQLConn()
    cursor = conn.cursor()
    try:
        cursor.execute("DELETE  FROM  MORNING_OTHERNEWS_RESOURCE_TABLE  WHERE  SOURCEFLAG = 'FXNET' AND  NEWSFLAG='FOREX'")
        conn.commit()
    except conn.Error,e:
        print "Mysql Error %d: %s" % (e.args[0], e.args[1])
        conn.rollback()