从指定地址获取文件进行正则匹配，输出至指定表格

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:\\文件\\政策汇\\有用\\untitled3\\txt\\shangweiwenjian.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])

转载于:https://www.cnblogs.com/zyl-kx/p/11304213.html