C#實現(xiàn)XML文檔的增刪改查功能示例
本文實例講述了C#實現(xiàn)XML文檔的增刪改查功能。分享給大家供大家參考,具體如下:
1、 創(chuàng)建實例XML文件(Books.xml)
<?xml version="1.0" encoding="iso-8859-1"?> <bookstore> <book id="1" category="COOKING"> <title lang="en">Everyday Italian</title> <author>Giada De Laurentiis</author> <year>2005</year> <price>30.00</price> </book> <book id="2" category="CHILDREN"> <title lang="en">Harry Potter</title> <author>J K. Rowling</author> <year>2005</year> <price>29.99</price> </book> <book id="3" category="WEB"> <title lang="en">XQuery Kick Start</title> <author>James McGovern</author> <author>Per Bothner</author> <author>Kurt Cagle</author> <author>James Linn</author> <author>Vaidyanathan Nagarajan</author> <year>2003</year> <price>49.99</price> </book> <book id="4" category="WEB"> <title lang="en">Learning XML</title> <author>Erik T. Ray</author> <year>2003</year> <price>39.95</price> </book> </bookstore>
2、 創(chuàng)建圖書信息實體類(BookInfo.cs)
public class BookInfo { /// <summary> /// 圖書ID /// </summary> public int BookId { set; get; } /// <summary> /// 圖書名稱 /// </summary> public string Title { set; get; } /// <summary> /// 圖書分類 /// </summary> public string Category { set; get; } /// <summary> /// 圖書語言 /// </summary> public string Language { set; get; } /// <summary> /// 圖書作者 /// </summary> public string Author { set; get; } /// <summary> /// 出版時間 /// </summary> public string Year { set; get; } /// <summary> /// 銷售價格 /// </summary> public decimal Price { set; get; } }
3、 創(chuàng)建圖書信息業(yè)務(wù)邏輯類(BookInfoBLL.cs)
using System.Xml; //引用相關(guān)文件 public class BookInfoBLL { private string _basePath = AppDomain.CurrentDomain.SetupInformation.ApplicationBase + @"/xml/Books.xml"; //XML文件路徑 private XmlDocument _booksXmlDoc = null; //創(chuàng)建XML文檔對象 public BookInfoBLL() { try { _booksXmlDoc = new XmlDocument(); //初始化XML文檔對象 _booksXmlDoc.Load(_basePath); //加載指定的XML文檔 } catch (Exception ex) { throw new Exception("加載XML文檔出錯:" + ex.Message); } } /// <summary> /// 獲取圖書列表(查) /// </summary> /// <param name="param">參數(shù)條件</param> /// <returns>圖書列表</returns> public List<BookInfo> GetBookInfoList(BookInfo param) { List<BookInfo> bookInfoList = new List<BookInfo>(); string xPath = "bookstore/book"; //默認(rèn)獲取所有圖書 if (param.BookId != 0) //根據(jù)圖書ID查詢 { xPath = String.Format("/bookstore/book[@id='{0}']", param.BookId); } else if (!String.IsNullOrEmpty(param.Category)) //根據(jù)圖書類別查詢 { xPath = String.Format("/bookstore/book[@category='{0}']", param.Category); } else if (!String.IsNullOrEmpty(param.Title)) //根據(jù)圖書名稱查詢 { xPath = String.Format("/bookstore/book[title='{0}']", param.Title); } XmlNodeList booksXmlNodeList = _booksXmlDoc.SelectNodes(xPath); foreach (XmlNode bookNode in booksXmlNodeList) { BookInfo bookInfo = new BookInfo(); bookInfo.BookId = Convert.ToInt32(bookNode.Attributes["id"].Value); //獲取屬性值 bookInfo.Category = bookNode.Attributes["category"].Value; bookInfo.Language = bookNode.SelectSingleNode("title").Attributes["lang"].Value; //獲取子節(jié)點的屬性值 bookInfo.Title = bookNode.SelectSingleNode("title").InnerText; //獲取元素值 bookInfo.Author = bookNode.SelectSingleNode("author").InnerText; bookInfo.Year = bookNode.SelectSingleNode("year").InnerText; bookInfo.Price = Convert.ToDecimal(bookNode.SelectSingleNode("price").InnerText); bookInfoList.Add(bookInfo); } return bookInfoList; } /// <summary> /// 增加圖書信息(增) /// </summary> /// <param name="param"></param> /// <returns></returns> public bool AddBookInfo(BookInfo param) { bool result = false; XmlNode root = _booksXmlDoc.SelectSingleNode("bookstore"); //查找<bookstore> //創(chuàng)建節(jié)點 XmlElement bookXmlElement = _booksXmlDoc.CreateElement("book"); XmlElement titleXmlElement = _booksXmlDoc.CreateElement("title"); XmlElement authorXmlElement = _booksXmlDoc.CreateElement("author"); XmlElement yearXmlElement = _booksXmlDoc.CreateElement("year"); XmlElement priceXmlElement = _booksXmlDoc.CreateElement("price"); //給節(jié)點賦值 bookXmlElement.SetAttribute("id", param.BookId.ToString()); bookXmlElement.SetAttribute("category", param.Category); titleXmlElement.InnerText = param.Title; //給節(jié)點添加元素值 titleXmlElement.SetAttribute("lang", param.Language);//給節(jié)點添加屬性值 authorXmlElement.InnerText = param.Author; yearXmlElement.InnerText = param.Year; priceXmlElement.InnerText = param.Price.ToString(); //AppendChild 將指定的節(jié)點添加到該節(jié)點的子節(jié)點列表的末尾 bookXmlElement.AppendChild(titleXmlElement); bookXmlElement.AppendChild(authorXmlElement); bookXmlElement.AppendChild(yearXmlElement); bookXmlElement.AppendChild(priceXmlElement); root.AppendChild(bookXmlElement); _booksXmlDoc.Save(_basePath); result = true; return result; } /// <summary> /// 修改圖書信息(改) /// </summary> /// <param name="param"></param> /// <returns></returns> public bool EditBookInfo(BookInfo param) { bool result = false; if(param.BookId>0) { string xPath = String.Format("/bookstore/book[@id='{0}']", param.BookId); XmlNode editXmlNode = _booksXmlDoc.SelectSingleNode(xPath); XmlElement editXmlElement = (XmlElement)editXmlNode; if (editXmlElement != null) { editXmlElement.Attributes["category"].Value = param.Category; editXmlElement.SelectSingleNode("title").Attributes["lang"].Value = param.Language; editXmlElement.SelectSingleNode("title").InnerText = param.Title; editXmlElement.SelectSingleNode("author").InnerText = param.Author; editXmlElement.SelectSingleNode("year").InnerText = param.Year; editXmlElement.SelectSingleNode("price").InnerText = param.Price.ToString(); _booksXmlDoc.Save(_basePath); result = true; } } return result; } /// <summary> /// 刪除圖書信息(刪) /// </summary> /// <param name="param"></param> /// <returns></returns> public bool DeleteBookInfo(BookInfo param) { bool result = false; if (param.BookId > 0) { string xPath = String.Format("/bookstore/book[@id='{0}']", param.BookId); XmlNode delXmlNode = _booksXmlDoc.SelectSingleNode(xPath); if (delXmlNode != null) { _booksXmlDoc.SelectSingleNode("bookstore").RemoveChild(delXmlNode); //移除指定的子節(jié)點 _booksXmlDoc.Save(_basePath); result = true; } } return result; } }
PS:這里再為大家提供幾款比較實用的xml相關(guān)在線工具供大家使用:
在線XML格式化/壓縮工具:
http://tools.jb51.net/code/xmlformat
在線XML/JSON互相轉(zhuǎn)換工具:
http://tools.jb51.net/code/xmljson
XML在線壓縮/格式化工具:
http://tools.jb51.net/code/xml_format_compress
XML代碼在線格式化美化工具:
http://tools.jb51.net/code/xmlcodeformat
更多關(guān)于C#相關(guān)內(nèi)容感興趣的讀者可查看本站專題:《C#中XML文件操作技巧匯總》、《C#常見控件用法教程》、《C#程序設(shè)計之線程使用技巧總結(jié)》、《WinForm控件用法總結(jié)》、《C#數(shù)據(jù)結(jié)構(gòu)與算法教程》、《C#數(shù)組操作技巧總結(jié)》及《C#面向?qū)ο蟪绦蛟O(shè)計入門教程》
希望本文所述對大家C#程序設(shè)計有所幫助。
- C#使用xsd文件驗證XML格式是否正確的實現(xiàn)方法
- C#中利用LINQ to XML與反射把任意類型的泛型集合轉(zhuǎn)換成XML格式字符串的方法
- C#中把任意類型的泛型集合轉(zhuǎn)換成SQLXML數(shù)據(jù)格式的實例
- C#實現(xiàn)導(dǎo)出List數(shù)據(jù)到xml文件的方法【附demo源碼下載】
- C#實現(xiàn)的xml操作類完整實例
- C#實現(xiàn)XML與實體類之間相互轉(zhuǎn)換的方法(序列化與反序列化)
- C# XML操作 代碼大全(讀XML,寫XML,更新,刪除節(jié)點,與dataset結(jié)合等)
- C#對XML文件的各種操作實現(xiàn)方法
- C# WinForm開發(fā)中使用XML配置文件實例
- C#對象與XMl文件之間的相互轉(zhuǎn)換
- C#中XmlTextWriter讀寫xml文件詳細(xì)介紹
- C# 寫入XML文檔三種方法詳細(xì)介紹
- C# 操作XML文檔 使用XmlDocument類方法
相關(guān)文章
DevExpress實現(xiàn)GridControl根據(jù)列選中一行
這篇文章主要介紹了DevExpress實現(xiàn)GridControl根據(jù)列選中一行,比較實用的功能,需要的朋友可以參考下2014-08-08DevExpress實現(xiàn)TreeList按條件隱藏節(jié)點CheckBox的方法
這篇文章主要介紹了DevExpress實現(xiàn)TreeList按條件隱藏節(jié)點CheckBox的方法,需要的朋友可以參考下2014-08-08