从指定地址获取文件进行正则匹配，输出至指定表格
发布时间：2020-12-14 05:39:34 所属栏目：百科 来源：网络整理
导读：import pymysql import re conn = pymysql.connect( host=‘localhost‘, port=3306, user=‘root‘, passwd=‘123456‘, db=‘test‘, charset=‘utf8‘, ) cursor = conn.cursor() f = open(‘D:文件政策汇有用untitled3txtshangweiwenjian.tx
|
import pymysql
import re
conn = pymysql.connect(
host=‘localhost‘,
port=3306,
user=‘root‘,
passwd=‘123456‘,
db=‘test‘,
charset=‘utf8‘,
)
cursor = conn.cursor()
f = open(‘D:文件政策汇有用untitled3txtshangweiwenjian.txt‘,"r",encoding = ‘utf-8‘)
f=f.read()
sql=cursor.execute("select bds_id from bds")
info=cursor.fetchmany(sql)#获取查询结果
print(info)
for i in info:
sql=cursor.execute(‘select bds_expression from bds where bds_id=%d‘%i[0])
info = cursor.fetchmany(sql)
aa=eval(info[0][0])
f_address=re.findall(aa,f)
print(f_address)
sql = cursor.execute(‘update print_out set print_out_id = %d‘%i[0])
（编辑：李大同） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |