求大神帮忙啊！！将这个xml文件使用sax进行解析并导入到excel文件中。急求啊！！！

紫气天堂 2015-05-05 05:25:36

]<?xml version="1.0" encoding="UTF-8"?>
<data>
<tab name="ordinarytablespaceinfo">
<head columns="表空间名,表空间大小(M),已使用空间(M),使用比,空闲空间(M),最大块(M)"/>
<row>
<column value="SYSAUX"/>
<column value="620"/>
<column value="579.5"/>
<column value=" 93.47"/>
<column value="40.5"/>
<column value="36"/>
</row>
<row>
<column value="UNDOTBS1"/>
<column value="45"/>
<column value="25.06"/>
<column value=" 55.69"/>
<column value="19.94"/>
<column value="17.19"/>
</row>
</tab>
<tab name="sort_top100sql"<head columns="PARSING_USER_ID,EXECUTIONS,SORTS,COMMAND_TYPE,DISK_READS,SQL_TEXT,HASH_VALUE"/>

<row>

<column value="85"/>

<column value="76,150"/>

<column value="76,150"/>

<column value="3"/>

<column value="0"/>

<column value="SELECT TRIGGER_NAME, TRIGGER_GROUP, NEXT_FIRE_TIME FROM QRTZ_TRIGGERS WHERE TRIGGER_STATE = :1 AND NEXT_FIRE_TIME < :2 AND (NEXT_FIRE_TIME >= :3) ORDER BY NEXT_FIRE_TIME ASC, PRIORITY DESC"/>

<column value="877,148,557"/>

</row>

<row>

<column value="85"/>

<column value="19"/>

<column value="26,918"/>

<column value="3"/>

<column value="1,178"/>

<column value="select s.synonym_name object_name, o.object_type from all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', :schema) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE','TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE') "/>

<column value="3,767,872,888"/>

</row>

<row>

<column value="85"/>

<column value="161"/>

<column value="161"/>

<column value="3"/>

<column value="0"/>

<column value="SELECT CONF_TYPE FROM MOCHA_SYS_CONFIGURATION GROUP BY CONF_TYPE ORDER BY CONF_TYPE "/>

<column value="339,373,266"/>

</row>

<row>

<column value="85"/>

<column value="54"/>

<column value="104"/>

<column value="3"/>

<column value="4"/>

<column value="select t.*, o.*, m.comments from sys.all_tables t, sys.all_tab_comments m, sys.all_objects o where t.owner = :object_owner and t.table_name = :object_name and m.owner (+) = :object_owner and m.table_name (+) = :object_name and o.owner (+) = :object_owner and o.object_name (+) = :object_name and :object_type is not null and :sub_object is null "/>

<column value="3,148,698,940"/>

</row>

<row>

<column value="85"/>

<column value="60"/>

<column value="60"/>

<column value="3"/>

<column value="1"/>

<column value="SELECT * FROM MOCHA_BO_OPERATION WHERE OPERATION_NAME = :1 ORDER BY STATE "/>

<column value="2,946,917,090"/>

</row>

</tab>

</data>

...全文