用python爬取网页数据并存_python 网页爬取数据并存到数据库中

# -*- coding: utf-8 -*-

import urllib

import xml.dom.minidom

import MySQLdb

import datetime

TimePoint = datetime.datetime.now()

#mysql

db=MySQLdb.Connect(host="localhost",user="root",passwd="root",db="pythondb",charset="utf8")

cursor = db.cursor()

urlPrefix = 'http://121.28.49.85:8080/datas/hour/'

regiondIds = ['130000']

for regiondId in regiondIds:

fullUrl = urlPrefix + regiondId + '.xml'

data=urllib.urlopen(fullUrl).read()

dom = xml.dom.minidom.parseString(data)

root = dom.documentElement

pointers = root.getElementsByTagName("Pointer")

#print len(pointers)

'''

INSERT INTO DATARETEST(Province, City, Area,

PositionName, Stati