xml数据内容:
<items>
<item id="1">
<name>AAA</name>
<problem>
<A>
<A1>
<A1_1>
<max_point>10</max_point>
<off_point>9</off_point>
<text>bbbbbbb</text>
</A1_1>
<A1_2>
<max_point>10</max_point>
<off_point>9</off_point>
</A1_2>
</A1>
<A2>
<max_point>10</max_point>
<off_point>3</off_point>
</A2>
</A>
<B>
<max_point>10</max_point>
<off_point>5</off_point>
</B>
<C><text>aaaaaaa</text></C>
</problem>
</item>
<item id="2">
.....
</item>
.....
</items>
问题一:
如何把以上xml转换成以下表的形式?
rowid C1 C2 C3 mp op text
1 A A1 A1_1 10 9
1 A A1 A1_2 10 9 bbbbbb
1 A A2 10 3
1 B 10 5
1 C aaaaaaaaa
......
问题二:
如何直接统计出以下结果?
rowid program point text
1 total 14
1 A 9
1 A1 2
1 A1_1 1
1 A1_2 1 bbbbbb
1 A2 7
1 B 5
1 C aaaaaaaa
