xml相关技术文档Word下载.docx

xml相关技术文档Word下载.docx

《xml相关技术文档Word下载.docx》由会员分享，可在线阅读，更多相关《xml相关技术文档Word下载.docx（41页珍藏版）》请在冰豆网上搜索。

yes"

//bookElement.addAttribute（"

look"

www"

/**加入title节点,为第一个子节点的子节点*/

ElementtitleElement=booksElement.addElement（"

title"

titleElement.setText（"

threw"

ElementtextElement=booksElement.addElement（"

text"

textElement.setText（"

内容是我不知道该咋办阿aaaa！

"

/**类似的完成后两个节点*/

/**类似的完成后两个book*/

//bookElement=booksElement.addElement（"

"

例子

packagewsw;

importjava.io.FileOutputStream;

importjava.io.FileWriter;

importjava.io.Writer;

importjava.sql.Connection;

importjava.sql.DriverManager;

importjava.sql.PreparedStatement;

importjava.sql.ResultSet;

importjava.sql.ResultSetMetaData;

importjava.util.HashMap;

importjava.util.Map;

importorg.dom4j.Document;

importorg.dom4j.DocumentHelper;

importorg.dom4j.Element;

importorg.dom4j.io.OutputFormat;

importorg.dom4j.io.XMLWriter;

importdao.ConnectionManagerDAO;

/**

*@作者：

王树伟

*@功能：

根据主表生成xml文件

*@描述：

deptemp之间的

*@时间：

2010-12-8

*

*/

publicclassCreateXML{

/**

*通过给定的表名导出所有数据生成xml文件

*@paramtableName数据库表名

*/

publicstaticvoidcreateXml（StringtableName,StringRECORDSNUM,Integercode）{

System.out.println（"

==========转换开始=============="

try{

//-------------jdbc代码

Connectioncon=ConnectionManagerDAO.getConn（）;

//一手案卷

Stringsql="

selecte.*from"

+tableName+"

ewheree.RECORDSNUM="

+RECORDSNUM+"

ande.UNITCODE="

+code;

PreparedStatementps=con.prepareStatement（sql）;

ResultSetrs=ps.executeQuery（）;

//-----------------使用DOM4J生成xml文件

Maprecordmap=newHashMap（）;

Documentdoc=DocumentHelper.createDocument（）;

//生成根节点

Elementroot=doc.addElement（"

TB300103"

root.addNamespace（"

xsi"

http:

//www.w3.org/2001/XMLSchema-instance"

while（rs.next（））{

Elementdept=root.addElement（"

HOUSERECORDCON"

ElementHouseNum=dept.addElement（"

HouseNum"

getEle（HouseNum,rs.getObject（"

HOUSENUM"

））;

ElementReCordsNum=dept.addElement（"

ReCordsNum"

getEle（ReCordsNum,rs.getObject（"

RECORDSNUM"

ElementHouseSeller=dept.addElement（"

HouseSeller"

getEle（HouseSeller,rs.getObject（"

HOUSESELLER"

ElementHouseVendee=dept.addElement（"

HouseVendee"

getEle（HouseVendee,rs.getObject（"

HOUSEVENDEE"

ElementNationlity=dept.addElement（"

Nationlity"

getEle（Nationlity,rs.getObject（"

NATIONLITY"

ElementResidencePlaceCode=dept.addElement（"

ResidencePlaceCode"

getEle（ResidencePlaceCode,rs.getObject（"

RESIDENCEPLACECODE"

ElementIdcertificate=dept.addElement（"

Idcertificate"

getEle（Idcertificate,rs.getObject（"

IDCERTIFICATE"

ElementIdcertificateCode=dept.addElement（"

IdcertificateCode"

getEle（IdcertificateCode,rs.getObject（"

IDCERTIFICATECODE"

ElementCoownerShip=dept.addElement（"

CoownerShip"

getEle（CoownerShip,rs.getObject（"

COOWNERSHIP"

ElementSaleRegistDate=dept.addElement（"

SaleRegistDate"

getEle（SaleRegistDate,rs.getObject（"

SALEREGISTDATE"

ElementPurchaseaMount=dept.addElement（"

PurchaseaMount"

getEle（PurchaseaMount,rs.getObject（"

PURCHASEAMOUNT"

ElementPayMentType=dept.addElement（"

PayMentType"

getEle（PayMentType,rs.getObject（"

PAYMENTTYPE"

ElementLoanMethod=dept.addElement（"

LoanMethod"

getEle（LoanMethod,rs.getObject（"

LOANMETHOD"

ElementContractNum=dept.addElement（"

ContractNum"

getEle（ContractNum,rs.getObject（"

CONTRACTNUM"

ElementFreeRecordsDate=dept.addElement（"

FreeRecordsDate"

getEle（FreeRecordsDate,rs.getObject（"

FREERECORDSDATE"

ElementCollectionCityCode=dept.addElement（"

CollectionCityCode"

getEle（CollectionCityCode,rs.getObject（"

COLLECTIONCITYCODE"

ElementUnitCode=dept.addElement（"

UnitCode"

getEle（UnitCode,rs.getObject（"

UNITCODE"

ElementOperateDate=dept.addElement（"

OperateDate"

getEle（OperateDate,rs.getObject（"

OPERATEDATE"

recordmap.put（"

rs.getString（"

}

if（recordmap.get（"

）!

=null||"

.equals（（String）recordmap.get（"

）））{

Stringsql1="

selectt.*fromTBWK_HOUSEPROPERTYtwheret.RECORDSNUM='

+（String）recordmap.get（"

）+"

'

andt.UNITCODE="

+Integer.parseInt（（String）recordmap.get（"

PreparedStatementps1=con.prepareStatement（sql1）;

ResultSetrsp=ps1.executeQuer