我现在有一个结果集，通过XSQL里的SQL语句选出。
[select c.company_name,
s.site_name,
i.installation_name installed_product,
step.step_name,
step.seqnum,
sv.server_name,
sv.address,
sva.port_num,
sva.access_method,
sva.username,
sva.pswd, sva.domain
from wmsys.company c,
wmsys.site s,
wmsys.installation i,
wmsys.server sv, 数据挖掘实验室
wmsys.srv_acct sva,
wmsys.site_install si,
wmsys.step
where c.company_id = s.company_id
and s.site_id = si.site_id
and si.installation_id = i.installation_id
and i.installation_id = step.installation_id
and step.server_id=sv.server_id
and step.srv_acct_id = sva.srv_acct_id]
产生了如下的XML：
<rowset>
<row num="1">
<company_name> SONY </company_name>
<site_name> carson007 </site_name>
<installed_product> LABOR </installed_product>
<step_name> APP </step_name>
<seqnum> 2 </seqnum> 数据挖掘研究院
<server_name> App Server </server_name>
<address> 192.168.1.2 </address>
<port_num> 4500 </port_num>
<access_method> TELNET </access_method>
<username> SUPER </username>
<pswd> SUPER </pswd>
<domain> DOM1 </domain>
</row>
<row num="2">
<company_name> SONY </company_name>
<site_name> carson007 </site_name>
<installed_product> LABOR </installed_product>
<step_name> GUI </step_name>
<seqnum> 1 </seqnum>
<server_name> App Server </server_name>
<address> 192.168.1.2 </address>
<port_num> 4500 </port_num>
<access_method> TELNET </access_method>
<username> SUPER </username> 数据挖掘实验室
<pswd> SUPER </pswd>
<domain> DOM1 </domain>
</row>
<row num="3">
<company_name> SONY </company_name>
<site_name> carson007 </site_name>
<installed_product> WMD </installed_product>
<step_name> APP </step_name>
<seqnum> 1 </seqnum>
<server_name> Report Server </server_name>
<address> 192.168.1.4 </address>
<port_num> 4600 </port_num>
<access_method> TELNET </access_method>
<username> SUPER </username>
<pswd> SUPER </pswd>
<domain> DOM1 </domain>
</row>
</rowset>
数据挖掘实验室
但是我想在用xsl显示的时候，该xml的格式能转换成如下的样子，该怎么做？
<rowset>
<row num="1">
<company>
<company_name> SONY </company_name>
<site>
<site_name> carson007 </site_name>
<product>
<installed_product> LABOR </installed_product>
<step>
<step_name> APP </step_name>
<seqnum> 2 </seqnum>
<server_name> App Server </server_name> 数据挖掘交友
<address> 192.168.1.2 </address>
<port_num> 4500 </port_num>
<access_method> TELNET </access_method>
<username> SUPER </username>
<pswd> SUPER </pswd>
<domain> DOM1 </domain>
</step>
<step>
<step_name> GUI </step_name>
<seqnum> 1 </seqnum>
<server_name> App Server </server_name>
<address> 192.168.1.2 </address>
<port_num> 4500 </port_num>
<access_method> TELNET </access_method>
<username> SUPER </username>
<pswd> SUPER </pswd>
<domain> DOM1 </domain> 数据挖掘研究院
</step>
</product>
<product>
<installed_product> WMD </installed_product>
<step>
<step_name> APP </step_name>
<seqnum> 1 </seqnum>
<server_name> App Server </server_name> 数据挖掘工具
<address> 192.168.1.2 </address>
<port_num> 4500 </port_num>
<access_method> TELNET </access_method>
<username> SUPER </username>
<pswd> SUPER </pswd>
<domain> DOM1 </domain>
</step>
</product> 数据挖掘论坛
</site>
</company>
</row>
</rowset> Create By Any-Extract(WL-AE)
