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:\file\ Policy Exchange\Useful\untitled3\txt\shangweiwenjian.txt’, “r”,encoding =’utf-8′)
f=f.read()
sql=cursor.execute(“select bds_id from bds”)
info=cursor.fetchmany(sql)#Get query results
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])
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: \Documents\Policies\Useful\untitled3\txt\shangweiwenjian.txt’, “r”,encoding =’utf-8′)
f=f.read() < /div>
sql=cursor.execute(“select bds_id from bds”)
info=cursor.fetchmany(sql)#Get query results
print(info) < /div>
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])
import pymysql
import re
conn = pymysql.conne ct(
host=’localhost’,
port=3306,
user=’root’,
passwd=’123456 ‘,
db=’test’,
charset=’utf8′,
)
cursor = conn.cursor()
f = open(‘D:\File\Policy Remittance\Useful\untitled3\txt\shangweiwenjian.txt’, “r”,encoding =’utf-8′)< /p>
f=f.read()
sql=cursor.execute(“select bds_id from bds”)
info=cursor.fetchmany(sql)#Get Query result
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])
< p>