select s.SERVICEOID,s.ORG_ID as ORGAN_ID,o.org_name as ORGAN_NAME,s.ITEMNAME as TITLE,
t.typetext as TYPENAME,s.WORKDAYS,s.APPFILEEXP as MATERIALLIST,WORKFLOW
from xzfw_service_base s,sys_organ o ,XZFW_SERVICE_TYPE t where s.ORG_ID = o.ORG_ID and s.typeid = t.typeid将上面列查询出来的数据导出到xml中.
t.typetext as TYPENAME,s.WORKDAYS,s.APPFILEEXP as MATERIALLIST,WORKFLOW
from xzfw_service_base s,sys_organ o ,XZFW_SERVICE_TYPE t where s.ORG_ID = o.ORG_ID and s.typeid = t.typeid将上面列查询出来的数据导出到xml中.
<orgId>显示 ORGAN_ID列的数据</orgId>
<organName>显示ORGAN_NAME列数据</organName>
.....先谢谢了!
执行查询语句,结果窗口那里全选,
右键 --> Export Results --> XML file
我想以xml自定义节点显示对应的数据。