从数据库中读取记录集到层叠式XML

文章作者 100test 发表时间 2007:09:15 12:08:19
来源 100Test.Com百考试题网

从数据库中读取记录集到层叠式XML

注意本系列文件使用环境:Oracle数据和JDOM1.0版本
总计四篇文件中都使用到以下表和数据。
Oracle表结构如下：
/*此表中最关键的就是CID和PID两个字段，其它的跟据需要可以增减字段*/
CREATE TABLE SCOTT.COMPANY
(
CID NUMBER(4) NOT NULL, /*记录ID号*/
CNAME VARCHAR2(20) NOT NULL, /*名字*/
DESCPT VARCHAR2(40) NULL, /*描述*/
PID NUMBER(4) NULL /*父ID号*/
).
/*向表中插入数据*/
INSERT
INTO company( company.cid, company.cname, company.descpt, company.pid )
VALUES( 1, ´.中南迈特´., ´.湖南省长沙市´., 0 ).
INSERT
INTO company( company.cid, company.cname, company.descpt, company.pid )
VALUES( 2, ´.系统集成´., ´.各种系统集成´., 1 ).
INSERT
INTO company( company.cid, company.cname, company.descpt, company.pid )
VALUES( 3, ´.软件开发´., ´.软件开发´., 1 ).
INSERT
INTO company( company.cid, company.cname, company.descpt, company.pid )
VALUES( 6, ´.NetOA开发组´., ´.Net项目开发´., 3 ).
INSERT
INTO company( company.cid, company.cname, company.descpt, company.pid )
VALUES( 7, ´.王军´., ´.J2EE组王军´., 5 ).
INSERT
INTO company( company.cid, company.cname, company.descpt, company.pid )
VALUES( 8, ´.湘红´., ´.J2EE组湘红´., 5 ).
INSERT
INTO company( company.cid, company.cname, company.descpt, company.pid )
VALUES( 9, ´.Windows集成组´., ´.Windows系统集成´., 2 ).
INSERT
INTO company( company.cid, company.cname, company.descpt, company.pid )
VALUES( 10, ´.Linux集成组´., ´.Linux相关系统集成´., 2 ).
INSERT
INTO company( company.cid, company.cname, company.descpt, company.pid )
VALUES( 11, ´.王非´., ´.Linux组´., 10 ).
INSERT
INTO company( company.cid, company.cname, company.descpt, company.pid )
VALUES( 12, ´.张万´., ´.NetOA组´., 6 ).
INSERT
INTO company( company.cid, company.cname, company.descpt, company.pid )
VALUES( 13, ´.李兵´., ´.J2EE李兵´., 5 ).
INSERT
INTO company( company.cid, company.cname, company.descpt, company.pid )
VALUES( 14, ´.武成´., ´.Linux组´., 10 ).
INSERT
INTO company( company.cid, company.cname, company.descpt, company.pid )
VALUES( 4, ´.人事部´., ´.公司人事管理部门´., 1 ).
INSERT
INTO company( company.cid, company.cname, company.descpt, company.pid )
VALUES( 5, ´.J2EE项目组´., ´.J2EE项目开发´., 3 ).
INSERT
INTO company( company.cid, company.cname, company.descpt, company.pid )
VALUES( 15, ´.王义´., ´.J2EE组王义´., 5 ).


package jing.xml.

/**
*

Title: 从数据库中读取记录集到层叠XML文件

*

Description:

*

Copyright: Copyright (c) 2004

*

Company:

* @author 欧朝敬 13873195792
* @version 1.0
*/