mysql点保存没反应_保存到mysql数据库没反应，打印时正常的但是没插入任何数据，写入文件也没用...

Love The Way You Lie 2022-10-28 03:51 173阅读 0赞

\#-\*- conding:utf-8 -\*-

import requests,re,pymysql

from pyquery import PyQuery as pq

url\_index = \['http://finance.eastmoney.com/news/cgnjj\_\{\}.html'.format(pages) for pages in range(1,2)\]

def index\_content(url\_index,title=0,time=0):

\#print('起始页：' + url\_index)

index\_req = requests.get(url\_index,timeout = 10)

index\_req.encoding = 'utf-8'

index\_content = index\_req.text

content\_url = re.findall('<div class="text text-no-img">.\*?<p class="title">.\*?<a href="(.\*?)" target="\_blank">',index\_content,re.S)

title = re.search('<p class="title">.\*?<a href=".\*?" target="\_blank">(.\*?)</a>',index\_content,re.S).group(1)

time = re.search('<p class="time">(.\*?)</p>',index\_content,re.S).group(1).replace("年", "-").replace("月", "-").replace("日", "")

\#time = time\_content

\#re.sub(".", "", title)

\#print('标题：' + title)

\#print('时间：' + time)

return content\_url

def content(content\_url):

content\_req = requests.get(content\_url,timeout = 10)

content\_req.encoding = 'utf-8'

content = content\_req.text

title = re.search('<h1>(.\*?)</h1>',content,re.S).group(1)

time = re.search('<div class="time">(.\*?)</div>',content,re.S).group(1).replace("年", "-").replace("月", "-").replace("日", "")

sources = re.search('<div class="source">.\*?<span>来源：</span>(.\*?)</div>',content,re.S).group(1)

content\_content = re.search('(.\*?)',content,re.S).group(1)

pic = re.findall('''.\*?src="https://z1.dfcfw.com(.\*?)"''',content\_content,re.S)\#.sub('.\*?same.\*?','',content\_content)

content\_body = \{'title:':title,

'time:':time,

'source:':sources,

'content:':content\_content,

'pic:':pic

\#         print('网址：' + content\_url)

\#         print ('标题：' + title)

\#         print ('时间：' + time)

\#         print ('来源:' + source)

\#         print ('内容：' + content\_content )

\#         print (pic)

print(type(title))

return content\_body

def save\_sql(content\_body):

try:

db = pymysql.connect("localhost","root","root","test" )

cursor = db.cursor()

\#sql = """INSERT INTO test(title,source\_time, source, content\_body, pageurl,pic)VALUES (title,time,source,content\_content,content\_url,pic)"""

\# 执行sql语句

sql = """INSERT INTO test(title,source\_time, sources, content\_body, pageurl,pic)VALUES (%s,%s,%s,%s,%s,%s)"""

\# 执行 sql 语句

cursor.execute(sql,(title,time,sources,content\_content,content\_url,pic))

\#cursor.execute(sql)

\# 提交到数据库执行

db.commit()

except:

\# 如果发生错误则回滚

db.rollback()

\# 关闭数据库连接

db.close()

def save\_csv(con):

with open('C:\\\\Users\\\\Administrator\\\\Desktop\\\\finance.csv','wb+') as f: \#wb为以二进制方式打开

con = str.encode('utf-8')

f.write(con)

f.close()

for url\_list in url\_index:

content\_url = index\_content(url\_list,title=0,time=0)

for con\_url in content\_url:

cons = content(con\_url)

print(cons)

save\_sql(cons)

\#         for con in cons:

\#             \#print(con)

\#             save\_csv(con)

\#save\_sql(con)

mysql点保存没反应_保存到mysql数据库没反应，打印时正常的但是没插入任何数据，写入文件也没用...

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 vue ui没反应

相关 mysql 输入show databases 没反应

相关 el-checkbox点击没反应

相关解决cnpm没反应

相关记Layui新增保存没反应的问题

相关 mysql点保存没反应_保存到mysql数据库没反应，打印时正常的但是没插入任何数据，写入文件也没用...

相关 app按钮没反应android,求助，uni-app按钮点击没反应

相关 DELL笔记本插入耳机没反应

相关 apm install 没反应

相关点击a标签没反应