文章詳情頁

XML 增、刪、改和查示例

瀏覽：164日期：2022-06-04 08:23:46

1.已知有一個(gè)XML文件（bookstore.xml）如下：

1、往<bookstore>節(jié)點(diǎn)中插入一個(gè)<book>節(jié)點(diǎn)：

   XmlDocument xmlDoc=new XmlDocument();
   xmlDoc.Load("bookstore.xml");
   XmlNode root=xmlDoc.SelectSingleNode("bookstore");//查找<bookstore>
   XmlElement xe1=xmlDoc.CreateElement("book");//創(chuàng)建一個(gè)<book>節(jié)點(diǎn)
   xe1.SetAttribute("genre","李贊紅");//設(shè)置該節(jié)點(diǎn)genre屬性
   xe1.SetAttribute("ISBN","2-3631-4");//設(shè)置該節(jié)點(diǎn)ISBN屬性

   XmlElement xesub1=xmlDoc.CreateElement("title");
   xesub1.InnerText="CS從入門到精通";//設(shè)置文本節(jié)點(diǎn)
   xe1.AppendChild(xesub1);//添加到<book>節(jié)點(diǎn)中
   XmlElement xesub2=xmlDoc.CreateElement("author");
   xesub2.InnerText="候捷";
   xe1.AppendChild(xesub2);
   XmlElement xesub3=xmlDoc.CreateElement("price");
   xesub3.InnerText="58.3";
   xe1.AppendChild(xesub3);

   root.AppendChild(xe1);//添加到<bookstore>節(jié)點(diǎn)中
   xmlDoc.Save("bookstore.xml");

//================
結(jié)果為：

<?xml version="1.0" encoding="gb2312"?>
<bookstore>
<book genre="fantasy" ISBN="2-3631-4">
    <title>Oberon"s Legacy</title>
    <author>Corets, Eva</author>
    <price>5.95</price>
</book>
<book genre="李贊紅" ISBN="2-3631-4">
    <title>CS從入門到精通</title>
    <author>候捷</author>
    <price>58.3</price>
</book>
</bookstore>

2、修改節(jié)點(diǎn)：將genre屬性值為“李贊紅“的節(jié)點(diǎn)的genre值改為“update李贊紅”，將該節(jié)點(diǎn)的子節(jié)點(diǎn)<author>的文本修改為“亞勝”。

    XmlNodeList nodeList=xmlDoc.SelectSingleNode("bookstore").ChildNodes;//獲取bookstore節(jié)點(diǎn)的所有子節(jié)點(diǎn)
   foreach(XmlNode xn in nodeList)//遍歷所有子節(jié)點(diǎn)
   {
    XmlElement xe=(XmlElement)xn;//將子節(jié)點(diǎn)類型轉(zhuǎn)換為XmlElement類型
    if(xe.GetAttribute("genre")=="李贊紅")//如果genre屬性值為“李贊紅”
    {
     xe.SetAttribute("genre","update李贊紅");//則修改該屬性為“update李贊紅”

     XmlNodeList nls=xe.ChildNodes;//繼續(xù)獲取xe子節(jié)點(diǎn)的所有子節(jié)點(diǎn)
     foreach(XmlNode xn1 in nls)//遍歷
     {
      XmlElement xe2=(XmlElement)xn1;//轉(zhuǎn)換類型
      if(xe2.Name=="author")//如果找到
      {
       xe2.InnerText="亞勝";//則修改
       break;//找到退出來就可以了
      }
     }
     break;
    }
   }

   xmlDoc.Save("bookstore.xml");//保存。

//=================

最后結(jié)果為：

<?xml version="1.0" encoding="gb2312"?>
<bookstore>
<book genre="fantasy" ISBN="2-3631-4">
    <title>Oberon"s Legacy</title>
    <author>Corets, Eva</author>
    <price>5.95</price>
</book>
<book genre="update李贊紅" ISBN="2-3631-4">
    <title>CS從入門到精通</title>
    <author>亞勝</author>
    <price>58.3</price>
</book>
</bookstore>

3、刪除 <book genre="fantasy" ISBN="2-3631-4">節(jié)點(diǎn)的genre屬性，刪除 <book genre="update李贊紅" ISBN="2-3631-4">節(jié)點(diǎn)。

XmlNodeList xnl=xmlDoc.SelectSingleNode("bookstore").ChildNodes;

   foreach(XmlNode xn in xnl)
   {
    XmlElement xe=(XmlElement)xn;

    if(xe.GetAttribute("genre")=="fantasy")
    {
     xe.RemoveAttribute("genre");//刪除genre屬性
    }
    else if(xe.GetAttribute("genre")=="update李贊紅")
    {
     xe.RemoveAll();//刪除該節(jié)點(diǎn)的全部?jī)?nèi)容
    }
   }
   xmlDoc.Save("bookstore.xml");

//====================

最后結(jié)果為：

<?xml version="1.0" encoding="gb2312"?>
<bookstore>
<book ISBN="2-3631-4">
    <title>Oberon"s Legacy</title>
    <author>Corets, Eva</author>
    <price>5.95</price>
</book>
<book>
</book>
</bookstore>
4、顯示所有數(shù)據(jù)。

XmlNode xn=xmlDoc.SelectSingleNode("bookstore");

   XmlNodeList xnl=xn.ChildNodes;

   foreach(XmlNode xnf in xnl)
   {
    XmlElement xe=(XmlElement)xnf;
    Console.WriteLine(xe.GetAttribute("genre"));//顯示屬性值
    Console.WriteLine(xe.GetAttribute("ISBN"));

    XmlNodeList xnf1=xe.ChildNodes;
    foreach(XmlNode xn2 in xnf1)
    {
     Console.WriteLine(xn2.InnerText);//顯示子節(jié)點(diǎn)點(diǎn)文本
    }
   }

留做參考,原文地址http://blog.yesky.com/75/richsee/1211075.shtml

2前臺(tái)代碼：html

@ Page language="c#" Codebehind="Main.aspx.cs" AutoEventWireup="false" Inherits="DsAndXML.OpXMLFile.Main" %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >

<HTML>

<HEAD>

</HEAD>

<asp:DataGrid id="dgShow" style="Z-INDEX: 100; LEFT: 113px; POSITION: absolute; TOP: 32px" runat="server" Width="480px" Height="178px"></asp:DataGrid>

<asp:Label id="Label3" style="Z-INDEX: 111; LEFT: 187px; POSITION: absolute; TOP: 383px" runat="server" Width="120px" Height="21px">新郵件地址：</asp:Label>

<asp:Label id="Label2" style="Z-INDEX: 107; LEFT: 333px; POSITION: absolute; TOP: 274px" runat="server" Width="83px" Height="21px">郵件地址：</asp:Label>

<asp:Button id="btnAdd" style="Z-INDEX: 104; LEFT: 298px; POSITION: absolute; TOP: 324px" runat="server" Text="添加"></asp:Button>

<asp:Button id="btnDelete" style="Z-INDEX: 103; LEFT: 199px; POSITION: absolute; TOP: 324px" runat="server" Text="刪除"></asp:Button>

<asp:Button id="btnChange" style="Z-INDEX: 102; LEFT: 102px; POSITION: absolute; TOP: 382px" runat="server" Text="修改"></asp:Button>

<asp:Button id="btnQuery" style="Z-INDEX: 101; LEFT: 101px; POSITION: absolute; TOP: 324px" runat="server" Text="查詢"></asp:Button>

<asp:DropDownList id="ddlName" style="Z-INDEX: 105; LEFT: 210px; POSITION: absolute; TOP: 274px" runat="server" Width="95px" Height="78px"></asp:DropDownList>

<asp:Label id="Label1" style="Z-INDEX: 106; LEFT: 100px; POSITION: absolute; TOP: 274px" runat="server" Width="83px" Height="21px">姓名：</asp:Label>

<asp:Label id="lbEmail" style="Z-INDEX: 109; LEFT: 459px; POSITION: absolute; TOP: 274px" runat="server" Width="231px"></asp:Label>

<asp:TextBox id="tbNewMail" style="Z-INDEX: 110; LEFT: 330px; POSITION: absolute; TOP: 381px" runat="server" Width="208px" Height="26px"></asp:TextBox></FONT>

</form>

</body>

</HTML>XML文件dbGuest.xml

<?xml version="1.0" standalone="yes"?>

<User>

<City>shanghai</City>

</User>

<User>

<Name>shaoazhd</Name>

<City>beijing</City>

</User>

<User>

<Name>Guset</Name>

</User>

<User>

<Name>Guset</Name>

</User>

</dbGuest>

using System;

using System.Collections;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Web;

using System.Web.SessionState;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.HtmlControls;

using System.Xml;

using System.Xml.XPath;

namespace DsAndXML.OpXMLFile

{

/**//// <summary>

/// Main 的摘要說明。

/// </summary>

public class Main : System.Web.UI.Page

{

protected System.Web.UI.WebControls.Button btnQuery;

protected System.Web.UI.WebControls.Button btnChange;

protected System.Web.UI.WebControls.Button btnDelete;

protected System.Web.UI.WebControls.Button btnAdd;

protected System.Web.UI.WebControls.DropDownList ddlName;

protected System.Web.UI.WebControls.Label Label1;

protected System.Web.UI.WebControls.Label Label2;

protected System.Web.UI.WebControls.Label lbEmail;

protected System.Web.UI.WebControls.TextBox tbNewMail;

protected System.Web.UI.WebControls.Label Label3;

protected System.Web.UI.WebControls.DataGrid dgShow;

private void Page_Load(object sender, System.EventArgs e)

{

// 在此處放置用戶代碼以初始化頁面

if(!IsPostBack)

Bind();

}

private void Bind()

{

DataSet ds = new DataSet();

ds.ReadXml(Server.MapPath(".\\db\\dbGuest.xml"));

dgShow.DataSource = ds.Tables[0].DefaultView;

dgShow.DataBind();

XmlDocument doc = new XmlDocument();

doc.Load(Server.MapPath(".\\db\\dbGuest.xml"));

XmlNodeList elemList = doc.GetElementsByTagName("Name");

ddlName.Items.Clear();

for(int i=0;i<elemList.Count;i++)

ddlName.Items.Add(elemList[i].InnerXml);

}

Web Form Designer generated code#region Web Form Designer generated code

override protected void OnInit(EventArgs e)

{

// CODEGEN：該調(diào)用是 ASP.NET Web 窗體設(shè)計(jì)器所必需的。

InitializeComponent();

base.OnInit(e);

}

/**//// <summary>

/// 設(shè)計(jì)器支持所需的方法 - 不要使用代碼編輯器修改

/// 此方法的內(nèi)容。

/// </summary>

private void InitializeComponent()

{

this.btnQuery.Click += new System.EventHandler(this.btnQuery_Click);

this.btnChange.Click += new System.EventHandler(this.btnChange_Click);

this.btnDelete.Click += new System.EventHandler(this.btnDelete_Click);

this.btnAdd.Click += new System.EventHandler(this.btnAdd_Click);

this.Load += new System.EventHandler(this.Page_Load);

}

#endregion

private void btnQuery_Click(object sender, System.EventArgs e)

{

XmlDocument doc = new XmlDocument();

doc.Load(Server.MapPath(".\\db\\dbGuest.xml"));

lbEmail.Text = doc.SelectSingleNode("http://User[Name=""+ddlName.SelectedItem.Text+""]").ChildNodes.Item(2).InnerText;

}

private void btnChange_Click(object sender, System.EventArgs e)

{

XmlDocument xmlDoc = new XmlDocument();

xmlDoc.Load(Server.MapPath(".\\db\\dbGuest.xml"));

XmlNodeList nodeList=xmlDoc.SelectSingleNode("dbGuest").ChildNodes;//獲取dbGuest節(jié)點(diǎn)的所有子節(jié)點(diǎn)

foreach(XmlNode xn in nodeList)//遍歷所有子節(jié)點(diǎn)

{

XmlElement xe=(XmlElement)xn;//將子節(jié)點(diǎn)類型轉(zhuǎn)換為XmlElement類型

XmlNodeList node = xe.GetElementsByTagName("Name");

if(node.Count>0)

{

if(node[0].InnerText==ddlName.SelectedItem.Text)

{

XmlNodeList nls=xe.ChildNodes;//繼續(xù)獲取xe子節(jié)點(diǎn)的所有子節(jié)點(diǎn)

foreach(XmlNode xn1 in nls)//遍歷

{

XmlElement xe2=(XmlElement)xn1;//轉(zhuǎn)換類型

if(xe2.Name=="Email")//如果找到

{

xe2.InnerText=tbNewMail.Text;//則修改

break;//找到退出來就可以了

}

break;

}

xmlDoc.Save(Server.MapPath(".\\db\\dbGuest.xml"));

Bind();

}

private void btnDelete_Click(object sender, System.EventArgs e)

{

XmlDocument xmlDoc = new XmlDocument();

xmlDoc.Load(Server.MapPath(".\\db\\dbGuest.xml"));

XmlNodeList xnl=xmlDoc.SelectSingleNode("dbGuest").ChildNodes;

foreach(XmlNode xn in xnl)

{

XmlElement xe=(XmlElement)xn;

XmlNodeList node = xe.GetElementsByTagName("Name");

if(node.Count>0)

{

if(node[0].InnerText==ddlName.SelectedItem.Text)

xe.RemoveAll();//刪除該節(jié)點(diǎn)的全部?jī)?nèi)容

break;

}

xmlDoc.Save(Server.MapPath(".\\db\\dbGuest.xml"));

Bind();

}

private void btnAdd_Click(object sender, System.EventArgs e)

{

XmlDocument xmlDoc = new XmlDocument();

xmlDoc.Load(Server.MapPath(".\\db\\dbGuest.xml"));

XmlNode root=xmlDoc.SelectSingleNode("dbGuest");//查找<dbGuest>

XmlElement xe1=xmlDoc.CreateElement("User");//創(chuàng)建一個(gè)<User>節(jié)點(diǎn)

XmlElement xesub1=xmlDoc.CreateElement("Name");

xesub1.InnerText="Guset";//設(shè)置文本節(jié)點(diǎn)

xe1.AppendChild(xesub1);//添加到<User>節(jié)點(diǎn)中

XmlElement xesub2=xmlDoc.CreateElement("City");

xesub2.InnerText="上海";

xe1.AppendChild(xesub2);

XmlElement xesub3=xmlDoc.CreateElement("Email");

xesub3.InnerText="ss@22.net";

xe1.AppendChild(xesub3);

root.AppendChild(xe1);//添加到<dbGuest>節(jié)點(diǎn)中

xmlDoc.Save(Server.MapPath(".\\db\\dbGuest.xml"));

Bind();

}

XML/RSS

上一條：WML學(xué)習(xí)之一概述和基本規(guī)則下一條：XML五則技巧總結(jié)

相關(guān)文章：

1. XML基本概念XPath、XSLT與XQuery函數(shù)介紹2. xml中的空格之完全解說3. 存儲(chǔ)于xml中需要的HTML轉(zhuǎn)義代碼4. javascript xml xsl取值及數(shù)據(jù)修改第1/2頁5. XML入門的常見問題(一)6. XML解析錯(cuò)誤：未組織好的解決辦法7. 怎樣才能用js生成xmldom對(duì)象，并且在firefox中也實(shí)現(xiàn)xml數(shù)據(jù)島？8. 基于android studio的layout的xml文件的創(chuàng)建方式9. XML 取得元素的字符數(shù)據(jù)10. AJAX實(shí)現(xiàn)JSON與XML數(shù)據(jù)交換方法詳解

排行榜

					
					每日六道java新手入門面試題,通往自由的道路
每日六道java新手入門面試題,通往自由的道路--多線程
低版本IE正常運(yùn)行HTML5+CSS3網(wǎng)站的3種解決方案
JSP數(shù)據(jù)交互實(shí)現(xiàn)過程解析
PHP循環(huán)與分支知識(shí)點(diǎn)梳理
如何在jsp界面中插入圖片
IntelliJ IDEA調(diào)整字體大小的方法
Idea 2019.3 本應(yīng)該搜索到的插件卻搜索不到的解決方法
Spring-Annotation 1.0 發(fā)布
Python headers請(qǐng)求頭如何實(shí)現(xiàn)快速添加
jsp實(shí)現(xiàn)登錄界面
				