第七色在线视频,2021少妇久久久久久久久久,亚洲欧洲精品成人久久av18,亚洲国产精品特色大片观看完整版,孙宇晨将参加特朗普的晚宴

#!/usr/bin/env?python??
#?encoding:?utf-8

from?urllib.request?import?urlopen

req?=?urlopen("https://en.wikipedia.org/robots.txt")

print(req.read().decode('utf-8'))

1 采集 收起 來源：python讀取TXT文檔

2018-04-11

#!/usr/bin/env?python??
#?encoding:?utf-8

import?pymysql

connection?=?pymysql.connect(host='localhost',
????????????????????????????user='root',
????????????????????????????password='',
????????????????????????????db='wiki',
????????????????????????????charset='utf8')
try:
????with?connection.cursor()?as?cursor:
????????sql?=?"select?`urlname`,?`urlhref`?from?`urls`?where?`id`?is?not?null"
????????count?=?cursor.execute(sql)
????????print(count)

????????#result?=?cursor.fetchall()
????????#print(result)

????????result?=?cursor.fetchmany(size=5)
????????print(result)



finally:
????connection.close()

0 采集 收起 來源：查詢MySQL數(shù)據(jù)

2018-04-11

#!/usr/bin/env?python??
#?encoding:?utf-8

#引入開發(fā)包
from?urllib.request?import?urlopen
from?bs4?import?BeautifulSoup
import?re
import?pymysql


resp?=?urlopen("https://en.wikipedia.org/wiki/Main_Page").read().decode("utf-8")
soup?=?BeautifulSoup(resp,?"html.parser")

listUrls?=?soup.find_all("a",?href=re.compile("^/wiki/"))

#print(listUrls)
connection?=?pymysql.connect(host='localhost',
????????????????????????????user='root',
????????????????????????????password='',
????????????????????????????db='wiki',
????????????????????????????charset='utf8')
print(connection)
try:
????with?connection.cursor()?as?cursor:
????????for?url?in?listUrls:
????????????if?not?re.search("\.(jpg|jpeg)$",?url['href']):
????????????????sql?=?"insert?into?`urls`(`urlname`,`urlhref`)values(%s,?%s)"
????????????????#print(sql)
????????????????#print(url.get_text())
????????????????cursor.execute(sql,?(url.get_text(),?"https://en.wikipedia.org"?+?url["href"]))
????????????????connection.commit()
finally:
????connection.close();

0 采集 收起 來源：存儲(chǔ)數(shù)據(jù)到MySQL

2018-04-11

0 采集 收起 來源：urllib基本用法

2018-04-07

0 采集 收起 來源：python讀取TXT文檔

2018-03-30

0 采集 收起 來源：python讀取TXT文檔

2018-03-30

1 采集 收起 來源：獲取維基百科詞條信息

2018-03-26

0 采集 收起 來源：python讀取PDF文檔(二)

2018-03-19

0 采集 收起 來源：獲取維基百科詞條信息

2018-03-15

0 采集 收起 來源：python數(shù)據(jù)采集-課程介紹

2018-03-13

0 采集 收起 來源：使用urllib發(fā)送post請(qǐng)求

2018-02-22

0 采集 收起 來源：urllib基本用法

2018-02-22

0 采集 收起 來源：python開發(fā)環(huán)境搭建

2018-02-01

0 采集 收起 來源：python讀取TXT文檔

2018-03-22

0 采集 收起 來源：python讀取TXT文檔

2018-01-26