提取oracle数据库HTML内容转换成正文格式(去标签)在更新到同表的TZNR
# -*- coding:utf-8 -*-
import cx_Oracle
from bs4 import BeautifulSoup
conn = cx_Oracle.connect('用户名', '用户密码', 'localhost:1521/ORCL')
cur = conn.cursor()
sql_search = 'select WZ,HTML from 表名'
res = cur.execute(sql_search)
# html = cur.fetchone()
rows = cur.fetchall() #得到所有数据集
for row in rows:
# print(row[0])
html = BeautifulSoup(row[1],'lxml').text
# print(html)
upsql = "UPDATE 表名 t SET t.TZNR = :TZNR WHERE t.WZ = :WZ"
cur.prepare(upsql)
cur.execute(None, {'TZNR': html,'WZ': row[0]})
print('sucess!!!')
conn.commit()
cur.close()
conn.close()