源码网商城,靠谱的源码在线交易网站 我的订单 购物车 帮助

源码网商城

XML 增、删、改和查示例

  • 时间:2022-05-23 13:27 编辑: 来源: 阅读:
  • 扫一扫,手机访问
摘要:XML 增、删、改和查示例
1.已知有一个XML文件(bookstore.xml)如下:

<?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> </bookstore>

  1、往<bookstore>节点中插入一个<book>节点:

   XmlDocument xmlDoc=new XmlDocument();    xmlDoc.Load("bookstore.xml");    XmlNode root=xmlDoc.SelectSingleNode("bookstore");//查找<bookstore>    XmlElement xe1=xmlDoc.CreateElement("book");//创建一个<book>节点    xe1.SetAttribute("genre","李赞红");//设置该节点genre属性    xe1.SetAttribute("ISBN","2-3631-4");//设置该节点ISBN属性    XmlElement xesub1=xmlDoc.CreateElement("title");    xesub1.InnerText="CS从入门到精通";//设置文本节点    xe1.AppendChild(xesub1);//添加到<book>节点中    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>节点中    xmlDoc.Save("bookstore.xml");

  //================   结果为:

<?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、修改节点:将genre属性值为“李赞红“的节点的genre值改为“update李赞红”,将该节点的子节点<author>的文本修改为“亚胜”。

    XmlNodeList nodeList=xmlDoc.SelectSingleNode("bookstore").ChildNodes;//获取bookstore节点的所有子节点    foreach(XmlNode xn in nodeList)//遍历所有子节点    {     XmlElement xe=(XmlElement)xn;//将子节点类型转换为XmlElement类型     if(xe.GetAttribute("genre")=="李赞红")//如果genre属性值为“李赞红”     {      xe.SetAttribute("genre","update李赞红");//则修改该属性为“update李赞红”      XmlNodeList nls=xe.ChildNodes;//继续获取xe子节点的所有子节点      foreach(XmlNode xn1 in nls)//遍历      {       XmlElement xe2=(XmlElement)xn1;//转换类型       if(xe2.Name=="author")//如果找到       {        xe2.InnerText="亚胜";//则修改        break;//找到退出来就可以了       }      }      break;     }    }    xmlDoc.Save("bookstore.xml");//保存。

  //=================   最后结果为:
<?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">节点的genre属性,删除 <book genre="update李赞红" ISBN="2-3631-4">节点。
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();//删除该节点的全部内容     }    }    xmlDoc.Save("bookstore.xml");

  //====================   最后结果为:
<?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、显示所有数据。
 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);//显示子节点点文本     }    }
留做参考,原文地址http://blog.yesky.com/75/richsee/1211075.shtml 2前台代码:html

[img]http://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif[/img] [img]http://www.cnblogs.com/Images/OutliningIndicators/ContractedBlock.gif[/img] <%@ Page language="c#" Codebehind="Main.aspx.cs" AutoEventWireup="false" Inherits="DsAndXML.OpXMLFile.Main" %> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" > [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] <HTML> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]     <HEAD> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]         <title>Main</title> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]         <meta name="GENERATOR" Content="Microsoft Visual Studio 7.0"> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]         <meta name="CODE_LANGUAGE" Content="C#"> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]         <meta name="vs_defaultClientScript" content="JavaScript"> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]         <meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5"> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]     </HEAD> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]     <body MS_POSITIONING="GridLayout"> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]         <form id="Main" method="post" runat="server"> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]             <FONT face="宋体"> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]                 <asp:DataGrid id="dgShow" style="Z-INDEX: 100; LEFT: 113px; POSITION: absolute; TOP: 32px" runat="server" Width="480px" Height="178px"></asp:DataGrid> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]                 <asp:Label id="Label3" style="Z-INDEX: 111; LEFT: 187px; POSITION: absolute; TOP: 383px" runat="server" Width="120px" Height="21px">新邮件地址:</asp:Label> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]                 <asp:Label id="Label2" style="Z-INDEX: 107; LEFT: 333px; POSITION: absolute; TOP: 274px" runat="server" Width="83px" Height="21px">邮件地址:</asp:Label> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]                 <asp:Button id="btnAdd" style="Z-INDEX: 104; LEFT: 298px; POSITION: absolute; TOP: 324px" runat="server" Text="添加"></asp:Button> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]                 <asp:Button id="btnDelete" style="Z-INDEX: 103; LEFT: 199px; POSITION: absolute; TOP: 324px" runat="server" Text="删除"></asp:Button> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]                 <asp:Button id="btnChange" style="Z-INDEX: 102; LEFT: 102px; POSITION: absolute; TOP: 382px" runat="server" Text="修改"></asp:Button> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]                 <asp:Button id="btnQuery" style="Z-INDEX: 101; LEFT: 101px; POSITION: absolute; TOP: 324px" runat="server" Text="查询"></asp:Button> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]                 <asp:DropDownList id="ddlName" style="Z-INDEX: 105; LEFT: 210px; POSITION: absolute; TOP: 274px" runat="server" Width="95px" Height="78px"></asp:DropDownList> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]                 <asp:Label id="Label1" style="Z-INDEX: 106; LEFT: 100px; POSITION: absolute; TOP: 274px" runat="server" Width="83px" Height="21px">姓名:</asp:Label> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]                 <asp:Label id="lbEmail" style="Z-INDEX: 109; LEFT: 459px; POSITION: absolute; TOP: 274px" runat="server" Width="231px"></asp:Label> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]                 <asp:TextBox id="tbNewMail" style="Z-INDEX: 110; LEFT: 330px; POSITION: absolute; TOP: 381px" runat="server" Width="208px" Height="26px"></asp:TextBox></FONT> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]         </form> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]     </body> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] </HTML>
XML文件dbGuest.xml
[img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] <?xml version="1.0" standalone="yes"?> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] <dbGuest> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]   <User> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]     <Name>aaa</Name> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]     <City>shanghai</City> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]     <Email>aaa@263.net</Email> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]     <Message>ok</Message> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]     <STime>2004-07-12T00:00:00.0000000+08:00</STime> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]   </User> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]   <User> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]     <Name>shaoazhd</Name> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]     <City>beijing</City> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]     <Email>sss@22.net</Email> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]     <Message>afsa</Message> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]     <STime>2004-7-12 15:07:39</STime> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]   </User> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]   <User> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]     <Name>Guset</Name> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]     <City>上海</City> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]     <Email>sfaf@22.net</Email> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]   </User> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]   <User> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]     <Name>Guset</Name> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]     <City>上海</City> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]     <Email>ss@22.net</Email> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img]   </User> [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] </dbGuest>
[img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] using System; [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] using System.Collections; [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] using System.ComponentModel; [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] using System.Data; [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] using System.Drawing; [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] using System.Web; [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] using System.Web.SessionState; [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] using System.Web.UI; [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] using System.Web.UI.WebControls; [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] using System.Web.UI.HtmlControls; [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] using System.Xml; [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] using System.Xml.XPath; [img]http://www.cnblogs.com/Images/OutliningIndicators/None.gif[/img] namespace DsAndXML.OpXMLFile [img]http://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif[/img] [img]http://www.cnblogs.com/Images/OutliningIndicators/ContractedBlock.gif[/img] { [img]http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif[/img] [img]http://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif[/img]     /// <summary> [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img]     /// Main 的摘要说明。 [img]http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif[/img]     /// </summary> [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img]     public class Main : System.Web.UI.Page [img]http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif[/img] [img]http://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif[/img]     { [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img]         protected System.Web.UI.WebControls.Button btnQuery; [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img]         protected System.Web.UI.WebControls.Button btnChange; [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img]         protected System.Web.UI.WebControls.Button btnDelete; [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img]         protected System.Web.UI.WebControls.Button btnAdd; [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img]         protected System.Web.UI.WebControls.DropDownList ddlName; [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img]         protected System.Web.UI.WebControls.Label Label1; [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img]         protected System.Web.UI.WebControls.Label Label2; [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img]         protected System.Web.UI.WebControls.Label lbEmail; [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img]         protected System.Web.UI.WebControls.TextBox tbNewMail; [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img]         protected System.Web.UI.WebControls.Label Label3; [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img]         protected System.Web.UI.WebControls.DataGrid dgShow; [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img]      [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img]         private void Page_Load(object sender, System.EventArgs e) [img]http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif[/img] [img]http://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif[/img]         { [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img]             // 在此处放置用户代码以初始化页面 [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img]             if(!IsPostBack) [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img]             Bind(); [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] [img]http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif[/img]         } [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img]         private void Bind() [img]http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif[/img] [img]http://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif[/img]         { [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img]             DataSet ds = new DataSet(); [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img]             ds.ReadXml(Server.MapPath(".\\db\\dbGuest.xml")); [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img]             dgShow.DataSource = ds.Tables[0].DefaultView; [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img]             dgShow.DataBind(); [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img]             XmlDocument doc = new XmlDocument(); [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img]             doc.Load(Server.MapPath(".\\db\\dbGuest.xml")); [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img]             XmlNodeList elemList = doc.GetElementsByTagName("Name"); [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img]             ddlName.Items.Clear(); [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img]             for(int i=0;i<elemList.Count;i++) [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img]              ddlName.Items.Add(elemList[i].InnerXml); [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img]              [img]http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif[/img]         } [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] [img]http://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif[/img] [img]http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif[/img]         Web Form Designer generated code [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img]         private void btnQuery_Click(object sender, System.EventArgs e) [img]http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif[/img] [img]http://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif[/img]         { [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img]             XmlDocument doc = new XmlDocument(); [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img]             doc.Load(Server.MapPath(".\\db\\dbGuest.xml")); [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img]             lbEmail.Text = doc.SelectSingleNode("//User[Name='"+ddlName.SelectedItem.Text+"']").ChildNodes.Item(2).InnerText; [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img]           [img]http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif[/img]         } [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img] [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img]         private void btnChange_Click(object sender, System.EventArgs e) [img]http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif[/img] [img]http://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif[/img]         { [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img]             XmlDocument xmlDoc = new XmlDocument(); [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img]             xmlDoc.Load(Server.MapPath(".\\db\\dbGuest.xml")); [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img]             XmlNodeList nodeList=xmlDoc.SelectSingleNode("dbGuest").ChildNodes;//获取dbGuest节点的所有子节点 [img]http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif[/img]             foreach(XmlNode xn in nodeList)//遍历所有子节点 [img]http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif[/img] [img]http://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif[/img]             
  • 全部评论(0)
联系客服
客服电话:
400-000-3129
微信版

扫一扫进微信版
返回顶部