1、我们要进行操作的xml文件,这个xml文件是表中的一个xml字段
<?xml version="1.0" encoding="utf-8"?>
<data>
<fdin>
<basic_info>
<available_bal>5875.40</available_bal>
<cur_in_amt>1.00</cur_in_amt>
<invoice_type_value>0</invoice_type_value>
<invoice_type_name>不开</invoice_type_name>
<prp_amt>1.00</prp_amt>
</basic_info>
<invoice_attachs>
<attach_file seq_no="1">
<invoice_id>14650</invoice_id>
<invoice_no>11112</invoice_no>
<invoice_amt>3.00</invoice_amt>
<invoice_rate_value>2</invoice_rate_value>
</attach_file>
<attach_file seq_no="2">
<invoice_id>14700</invoice_id>
<invoice_no>222222</invoice_no>
<invoice_amt>3.00</invoice_amt>
<invoice_rate_value>1</invoice_rate_value>
</attach_file>
</invoice_attachs>
</fdin>
</data>
2、给指定的节点,添加子节点,在这里我们需要给invoice_attachs节点增加一个attach_file的子节点。
String xmlData = fdPlanH.getPlanXml();//获取fdPlanH表中的xml字段
BaseXmlDocument xmlDoc = new BaseXmlDocument(xmlData);
Node invoice_attachs = xmlDoc.getNode("/data/fdin/invoice_attachs");
if(invoice_attachs!=null){
/**给invoice_attachs添加子节点**/
Element attach_file = ((Element) invoice_attachs).addElement("attach_file");
attach_file.addAttribute("seq_no","3");//给节点增加属性
Element invoice_id = attach_file.addElement("invoice_id");
invoice_id.setText("14701");
Element invoice_no = attach_file.addElement("invoice_no");
invoice_no.setText("333333");
Element invoice_amt = attach_file.addElement("invoice_amt");
invoice_amt.setText("4.00");
Element invoice_rate_value = attach_file.addElement("invoice_rate_value");
invoice_rate_value.setText("3");
}
//最后把改好的xmlData赋值给原来的xmlData,就完成了xml的增加节点了
xmlData=xmlDoc.getXmlDocument().asXML();
3、删除节点:删除seq_no属性为2的attach_file节点
String xmlData = fdPlanH.getPlanXml();//获取fdPlanH表中的xml字段
BaseXmlDocument xmlDoc = new BaseXmlDocument(xmlData);
Node invoice_attachs = xmlDoc.getNode("/data/fdin/invoice_attachs");
if(invoice_attachs!=null){
String attr="2";
Node attach_file=invoice_attachs.
selectSingleNode("attach_file[@seq_no='"+attr+"']");
((Element) attach_file).getParent().remove(attach_file);//删除步骤
}
3、修改节点的值
String xmlData = fdPlanH.getPlanXml();//获取fdPlanH表中的xml字段
BaseXmlDocument xmlDoc = new BaseXmlDocument(xmlData);
Node invoice_attachs = xmlDoc.getNode("/data/fdin/invoice_attachs");
if(invoice_attachs!=null){
List<Node> attachFileList = invoice_attachs.selectNodes("attach_file");
for (Node invoice : attachFileList) {
Node invoiceIdNode = invoice.selectSingleNode("invoice_id");
Node invoiceAmtNode = invoice.selectSingleNode("invoice_amt");
Node invoiceNoNode = invoice.selectSingleNode("invoice_no");
/**节点的值 更新**/
Node invoiceRateNode = invoice.selectSingleNode("invoice_rate_value");
invoiceIdNode.setText("");
invoiceAmtNode.setText(ObjectUtils.toString(new BigDecimal("2.00")));
invoiceNoNode.setText("");
invoiceRateNode.setText("");
/**节点的属性值更新**/
Attribute seq_no = ((Element) invoice).attribute("seq_no");
seq_no.setValue(fdInInvoice.getSeqNo().toString());
}
}
//最后把改好的xmlData赋值给原来的xmlData,就完成了xml的修改节点了
xmlData=xmlDoc.getXmlDocument().asXML();