国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁 > 編程 > C# > 正文

C#實現(xiàn)XML文檔的增刪改查功能示例

2020-01-24 00:49:27
字體:
供稿:網(wǎng)友

本文實例講述了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.VeVB.COm/code/xmlformat

在線XML/JSON互相轉(zhuǎn)換工具:
http://tools.VeVB.COm/code/xmljson

XML在線壓縮/格式化工具:
http://tools.VeVB.COm/code/xml_format_compress

XML代碼在線格式化美化工具:
http://tools.VeVB.COm/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è)計有所幫助。

發(fā)表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發(fā)表
主站蜘蛛池模板: 保靖县| 西盟| 会昌县| 潍坊市| 清远市| 浦东新区| 富源县| 苍山县| 安国市| 巩义市| 昌宁县| 崇左市| 宜兰市| 尚义县| 鲜城| 桦南县| 大同市| 叙永县| 金寨县| 赣榆县| 茶陵县| 化德县| 贵南县| 永安市| 栖霞市| 阳新县| 泸水县| 大同市| 永登县| 治多县| 南充市| 崇左市| 郎溪县| 屯留县| 清新县| 安龙县| 高雄县| 新宾| 错那县| 宾阳县| 大化|