import MySQLdb import urllib import webbrowser as web import json 

conn=MySQLdb.connect(host=”localhost”,user=”root”,passwd=”sf123456″,port=3306,charset=”utf8″) cur=conn.cursor()

#cur.execute(‘create database if not exists stock_db’) conn.select_db(“db_stock”)

for i in range(1,4): print i url=”http://q.10jqka.com.cn/interface/stock/fl/zdf/desc/”+str(i)+”/hsb/quote” content=urllib.urlopen(url).read() open(“E:\data\stock\stock_b.json”,”w”).write(content) #web.open_new_tab(“E:\data\stock\stock0617.json”) f=file(“E:\data\stock\stock_b.json”) s=json.load(f) length=len(s[‘data’]) for i in range(0,length):

sql = “INSERT INTO stock_information_b(cje,cjl,hsl,jk,jlr,rtime,stockcode, stockid,stockname,zde,zdf,zdj,zgj,zs,zxj)values(‘%s’,’%s’,’%s’,’%s’, ‘%s’,’%s’,’%s’,’%s’,’%s’,’%s’,’%s’,’%s’,’%s’,’%s’,’%s’)”%(s[‘data’][i][‘cje’],s[‘data’][i][‘cjl’], s[‘data’][i][‘hsl’],s[‘data’][i][‘jk’],s[‘data’][i][‘jlr’],s[‘data’][i][‘rtime’], s[‘data’][i][‘stockcode’],s[‘data’][i][‘stockid’],s[‘data’][i][‘stockname’],s[‘data’][i][‘zde’], s[‘data’][i][‘zdf’],s[‘data’][i][‘zdj’],s[‘data’][i][‘zgj’],s[‘data’][i][‘zs’],s[‘data’][i][‘zxj’] )

cur.execute(sql) conn.commit() print “hello” # except: #  print e #  conn.rollback()

conn.close()

import urllib import webbrowser as web

url=”http://q.10jqka.com.cn/hk/hzcf/” content=urllib.urlopen(url).read() open(“E:\data\stock\hengSengIndex0623.html”,”w”).write(content) web.open_new_tab(“E:\data\stock\hengSengIndex0623.html”)