boctopnews.py

股票软件 -- 用在外汇交易市场

import urllib
from BeautifulSoup import *
import MySQLdb, sys
from datetime import *

sys.path.append('G:\Jay_Private\Develop\Python\Quote\Stock\core')
import ReadConfig


#page = urllib.urlopen('http://222.73.103.206/news/news_iframe.asp')
page = urllib.urlopen('http://stock.finance.qq.com/ind/static/ind_type_0.xml')

soup = BeautifulSoup(page, fromEncoding='gbk')
table = soup.find('type_xml')

config = ReadConfig.readConfigure('../Stock/core/stock.conf')
host = config.get('mysqlhost')
user = config.get('user')
mysqldb = 'test'

con=MySQLdb.connect(host, user, db=mysqldb)
cur = con.cursor()

for data in table.findAll('data'):
    id = data.p_id.string
    name = data.find('parent').renderContents('cp936')
    print name
    date = datetime.now()
    cur.execute("insert into StockCategory(Name  ) values('%s')" %(name));

con.commit()
con.close()