<div style=";text-align:center;;height:auto;" class="datagrid-cell datagrid-cell-c1-checkId">已通过</div></td><td field="button"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-button"><a href="#" style="color: red" onclick="fileManager(0)">图片管理</a></div></td><td field="truckNo"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-truckNo">辽PD6885</div></td><td field="truckCardColor"><div style=";text-align:center;;height:auto;" class="datagrid-cell datagrid-cell-c1-truckCardColor">黄牌</div></td><td field="vtNam"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-vtNam">秦皇岛九福物流有限公司</div></td><td field="driverNam"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-driverNam">叶红建</div></td> <div style=";text-align:center;;height:auto;" class="datagrid-cell datagrid-cell-c1-checkId">已通过11</div></td><td field="button"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-button"><a href="#" style="color: red" onclick="fileManager(0)">图片管理</a></div></td><td field="truckNo"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-truckNo">辽PD6885</div></td><td field="truckCardColor"><div style=";text-align:center;;height:auto;" class="datagrid-cell datagrid-cell-c1-truckCardColor">黄牌</div></td><td field="vtNam"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-vtNam">秦皇岛九福物流有限公司</div></td><td field="driverNam"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-driverNam">叶红建1</div></td> 以上代码为网页源码,帮我写一段python程序从以上代码中找出drivernam和datagrid-cell-c1-checkId并保存数据库中
时间: 2023-07-19 10:47:23 浏览: 134
可以使用BeautifulSoup库来解析网页源码,找到对应的信息并保存到数据库中。以下是示例代码:
```python
import requests
from bs4 import BeautifulSoup
import sqlite3
# 发送HTTP请求获取网页源码
url = "http://example.com/page.html"
response = requests.get(url)
html = response.text
# 使用BeautifulSoup解析网页源码
soup = BeautifulSoup(html, "html.parser")
# 找到所有的tr标签
tr_list = soup.find_all("tr")
# 创建数据库连接
conn = sqlite3.connect("data.db")
cursor = conn.cursor()
# 遍历每个tr标签,找到drivernam和datagrid-cell-c1-checkId并保存到数据库中
for tr in tr_list:
driverNam = tr.find("td", {"field": "driverNam"}).text.strip()
checkId = tr.find("div", {"class": "datagrid-cell datagrid-cell-c1-checkId"}).text.strip()
cursor.execute("INSERT INTO table (driverNam, checkId) VALUES (?, ?)", (driverNam, checkId))
# 提交事务并关闭数据库连接
conn.commit()
conn.close()
```
在以上示例代码中,我们首先使用requests库发送HTTP请求获取网页源码,然后使用BeautifulSoup库解析网页源码。接着,我们遍历每个tr标签,找到drivernam和datagrid-cell-c1-checkId的值,并将它们保存到数据库中。最后,我们提交事务并关闭数据库连接。请注意,以上代码中的table需要替换为你的表名,同时还需要根据需要修改数据库连接的参数。
阅读全文
相关推荐


















