xml怎么和数据库交互数据 实现xml与数据库数据交互的完整方案

<users>
    <user>
        <id>1</id>
        <name>张三</name>
        <email>zhangsan@example.com</email>
    </user>
    <user>
        <id>2</id>
        <name>李四</name>
        <email>lisi@example.com</email>
    </user>
</users>

CREATE TABLE users (
    id INT PRIMARY KEY,
    name VARCHAR(50),
    email VARCHAR(100)
);

import xml.etree.ElementTree as ET

tree = ET.parse('users.xml')
root = tree.getroot()

for user in root.findall('user'):
    id = user.find('id').text
    name = user.find('name').text
    email = user.find('email').text
    print(id, name, email)

import sqlite3

conn = sqlite3.connect('test.db')
cursor = conn.cursor()

for user in root.findall('user'):
    id = user.find('id').text
    name = user.find('name').text
    email = user.find('email').text

    cursor.execute('''
        INSERT OR IGNORE INTO users (id, name, email) VALUES (?, ?, ?)
    ''', (id, name, email))

conn.commit()
conn.close()

cursor.execute('SELECT * FROM users')
rows = cursor.fetchall()

import xml.etree.ElementTree as ET

root = ET.Element('users')

for row in rows:
    user = ET.SubElement(root, 'user')
    ET.SubElement(user, 'id').text = str(row[0])
    ET.SubElement(user, 'name').text = row[1]
    ET.SubElement(user, 'email').text = row[2]

tree = ET.ElementTree(root)
tree.write('output.xml', encoding='utf-8', xml_declaration=True)