python 读取xml表结构数据_利用python实现xml与数据库读取转换的方法

前言

xml课的第三第四个作业都是用java编程来实现xml dom的一些转换, 因为自己没怎么学过java，因此和老师说了下想用python来实现第三第四个作业，下面就直接贴代码了

xml文档

]>

xsi:noNamespaceSchemaLocation="1.xsd">

X86-Windows2000

9 hours 42 minutes

zhangsan

computerZhang

router

24 hours

ruijie

Router2

router

89 hours

Cisco

Router3

解析xml文档用的是python自带的xml库ElementTree, 读取mysql可以安装MySQLdb模块

apt-get install python-MySQLdb

程序运行如下

root@lj /h/s/x/3# python 21.py -h

usage: 21.py [-h] status

positional arguments:

status 0clar,1read,2insert

读取xml保存到数据库

root@lj /h/s/x/3# python 21.py 2

插入语句: insert into info values ('192.168.1.1','X86-Windows2000','9 hours 42 minutes','zhangsan','computerZhang')

插入语句: insert into info values ('192.168.1.3','router','24 hours','ruijie','Router2')

插入语句: insert into info values ('192.168.2.1','router','89 hours','Cisco','Router3')

insert success!!!

读取数据库保存到xml文档

root@lj /h/s/x/3# python 21.py 1

+-------------+-----------------+--------------------+------------+---------------+

| IP地址 | sysDescr.0 | sysUpTime.0 | sysContact | sysName.0 |

+-------------+-----------------+--------------------+------------+---------------+

| 192.168.1.1 | X86-Windows2000 | 9 hours 42 minutes | zhangsan | computerZhang |