8,906
社区成员
发帖
与我相关
我的任务
分享
<?xml version="1.0" encoding="UTF-8"?>
<ETLs><ETL><ETLId>1</ETLId><ETLName>ETL1</ETLName><ETLRecordSize>1000</ETLRecordSize><SourceDataSourceType>AdminRemoteDatabase</SourceDataSourceType><SourceId>0001</SourceId><SourceName>配置1</SourceName><SourceTable>users</SourceTable><SourceTableSQL>select usersId,usersName from user</SourceTableSQL><TargetDataSourceType>LocalDatabase</TargetDataSourceType><TargetId>0001</TargetId><TargetName>配置1</TargetName><TargetTable>user</TargetTable><TargetTableSQL>insert user (usersId,usersName)</TargetTableSQL><Sort>1</Sort><Columns><Column><ColumnId>1</ColumnId><SourceField>usersId</SourceField><SourceType>uniqueidentifier</SourceType><SourceLength>16</SourceLength><SourceNull>false</SourceNull><SourceDefault>NULL</SourceDefault><SourcePrecision/><SourceScale>0</SourceScale><TargetField>userId</TargetField><TargetType>varchar</TargetType><TargetLength>36</TargetLength><TargetNull>true</TargetNull><TargetDefault>NULL</TargetDefault><TargetPrecision/><TargetScale/></Column></Columns></ETL></ETLs>
File file = new File(InfoPath.ADMINETL);
SAXReader reader = new SAXReader();
Document document = null;
try {
document = reader.read(file);
document.setXMLEncoding("UTF-8");
Element root = document.getRootElement(); // 获得根元素
Element element = (Element) root.selectNodes("/ETLs/ETL[ETLId='1']/Columns").get(0);
Element itemElement = DocumentHelper.createElement("Column");
element.add(itemElement);
Element sourceTypeElement = DocumentHelper.createElement("SourceType");
sourceTypeElement.setText("ethan");
itemElement.add(sourceTypeElement);
// System.out.println(element.asXML());
document.add(element);
} catch (Exception e) {
e.printStackTrace();
}
System.out.println(document.asXML());