Pythonはxmlを使用する.etree.ElementTree解析xmlファイル

6977 ワード
スプリング bean mysql xml python
例1、
data.xml 
<?xml version="1.0" encoding="utf-8"?>

<info>
	<intro>       </intro>
	<list id='001'>
		<head>jiaoshe_15</head>
		<name>   </name>
		<number>12345678</number>
		<age>44</age>
		<sex> </sex>
		<hobby>  ，   </hobby>
		<note>             ，              </note>
	</list>
	<list>
		<head>jiaoshe_12</head>
		<name>    </name>
		<number>aa33678</number>
		<age>78</age>
		<sex> </sex>
		<hobby>  </hobby>
		<note>      ，              </note>
	</list>
</info>

readxml.py 
#!/usr/bin/env python
# -*- coding: UTF-8  -*-
'''
Created on 2010-4-14

@author: Administrator
'''
import os
import xml.etree.ElementTree as ET

#  xml  
def load_xml_file(filename):
    root = ET.parse(filename).getroot()
    #      
    intro = root.find('intro').text
    print intro
    all_users = root.findall('list')
    for user in all_users:
        head = user.find('head').text
        name = user.find('name').text
        sex = user.find('sex').text
        print head,name,sex
        
        
if __name__ == '__main__':
    
    workpath = os.getcwd()
#    print workpath
    load_xml_file(r'%s\webUI\data\data.xml' % workpath)

   
出力結果
       
jiaoshe_15      
jiaoshe_12

例2、
1、解析が必要なファイルapp.xml 
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
 <!--       -->
 <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
  <!--      ，       Mysql    -->
  <property name="driverClassName">
   <value>com.mysql.jdbc.Driver</value>
  </property>
  <!--      ，          ，           ！ -->
  <property name="url">
   <value>
       jdbc:mysql://localhost:3306/tie?useUnicode=true&amp;characterEncoding=utf-8
   </value>
  </property>
  <!--         -->
  <property name="username">
   <value>root</value>
  </property>
  <!--        -->
  <property name="password">
   <value>123</value>
  </property>
 </bean>
 <!--        Session   -->
 <bean id="sessionFactory"
  class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
  <property name="dataSource">
   <ref bean="dataSource" />
  </property>
  <!--        -->
  <property name="mappingResources">
   <list>
    <value>com/alonely/vo/User.hbm.xml</value>
   </list>
  </property>
 </bean>
 <!--  Session     hibernateTemplate -->
 <!--     hibernateTemplate：hibernateTemplate          ，         HibernateCallback   ，  ：load()、get()、save、delete()   。 -->
 <bean id="hibernateTemplate"
  class="org.springframework.orm.hibernate3.HibernateTemplate">
  <constructor-arg>
   <ref local="sessionFactory" />
  </constructor-arg>
 </bean>
 <!--  DAO   Session   -->
 <bean id="userDAO" class="com.alonely.dao.UserDAO">
  <property name="sessionFactory">
   <ref bean="sessionFactory" />
  </property>
 </bean>
 <!--  Service   DAO -->
 <bean id="userService" class="com.alonely.service.UserService">
  <property name="userDAO">
   <ref local="userDAO" />
  </property>
 </bean>
 <!--  Action   Service -->
 <bean name="/user" class="com.alonely.struts.action.UserAction">
  <property name="userService">
   <ref bean="userService" />
  </property>
 </bean>
</beans>

2、解析のコードetXml.py 
# -*- coding:UTF-8 -*-

import xml.etree.ElementTree as ET

#    <bean>  
def getAllBean():
    root = ET.parse('app.xml').getroot()
    beans = root.findall('bean')
    
    #    bean
    for bean in beans:
#        print ET.tostring(bean, 'UTF-8')
#        print '==========================================='
        pass

    return beans;
        
#    property  ，         ，   /property  
def getAllProperty():
    beans = getAllBean()
    propList = {}
    for bean in beans:
        propertysE = bean.findall('property')
        for prop in propertysE:
            proname = prop.get('name')
            propList[proname] = prop
#            print ET.tostring(prop, 'UTF-8')
#            print '==========================================='
    return propList
        

#  bean   id  bean class   
def getBeanClassAttr(beanid):
    bean = getBeanById(beanid)
    return bean.get('class')#       class  

#  id  bean  
def getBeanById(beanid):
    beans = getAllBean()
    for bean in beans:
        id = bean.get('id')#      id  
        if beanid == id:
            return bean

#  bean   id     property  
def getPropertysByBeanid(beanid):
    bean = getBeanById(beanid)
    props = bean.findall('property')
    return props;
    
#  bean   id property        
def getPropertyValue(beanid,proname):
    props = getPropertysByBeanid(beanid)
    for prop in props:
        name = prop.get('name')
        if proname == name:
            valueE = prop.find('value')
            if valueE != None:
                return valueE.text


if __name__ == '__main__':
    
    print getPropertyValue('userService','userDAO')
CentOS 7にMySQL 5.6をインストール（SCL）
Python菜鳥教程ノートの例