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")
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])
