Python数据库从XML更新仅更新最后一条记录

import xml.etree.ElementTree as ET
import sqlite3

def update_last_record(xml_file, db_file, table_name):
    # 解析XML文件
    tree = ET.parse(xml_file)
    root = tree.getroot()

    # 获取最后一条记录的数据
    last_record = root[-1]

    # 连接到数据库
    conn = sqlite3.connect(db_file)
    cursor = conn.cursor()

    # 更新最后一条记录
    sql = f"UPDATE {table_name} SET field1 = ?, field2 = ? WHERE id = ?"
    cursor.execute(sql, (last_record.find('field1').text, last_record.find('field2').text, last_record.find('id').text))

    # 提交更改并关闭连接
    conn.commit()
    conn.close()

# 示例用法
xml_file = 'data.xml'
db_file = 'data.db'
table_name = 'records'
update_last_record(xml_file, db_file, table_name)