#encoding:utf-8
require "o
PEn-uri"
require "nokogiri"
require "
MySQL"
@dbh=My
SQL.real_connect("localhost","root","dengli","pachong")
@file=open("qb.txt","w")
def getQiub
ai(url)
&nbs
p; data=open(url){|f| f.read}
doc=Nokogiri
::HT
ML(data)
doc.css('div.block.untagged.mb15.bs2').
each{|p|
content=p.css('div.content').text
@file.puts("#{content}\n")
img=p.css('div.thumb img').each{|img|
imgAddr=img.attr('src')
@file.puts("#{imgAddr}\n")
time=Time.now
sql="INSERT INTO qiushibaike (`body`,`img`,`time`) VALUES ('#{content}','#{imgAddr}','#{time}')"
@dbh.query(sql)
}
}
end
for i in 1
..10
@file.puts("这是第#{i}页")
url="http://www.qiushibaike
.COM/8
hr/page/#{i}"
getQiubai(url)
end