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è)務邏輯類(BookInfoBLL.cs)
using System.Xml; //引用相關文件
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"; //默認獲取所有圖書
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相關在線工具供大家使用:
在線XML格式化/壓縮工具:
http://tools.jb51.net/code/xmlformat
在線XML/JSON互相轉換工具:
http://tools.jb51.net/code/xmljson
XML在線壓縮/格式化工具:
http://tools.jb51.net/code/xml_format_compress
XML代碼在線格式化美化工具:
http://tools.jb51.net/code/xmlcodeformat
更多關于C#相關內(nèi)容感興趣的讀者可查看本站專題:《C#中XML文件操作技巧匯總》、《C#常見控件用法教程》、《C#程序設計之線程使用技巧總結》、《WinForm控件用法總結》、《C#數(shù)據(jù)結構與算法教程》、《C#數(shù)組操作技巧總結》及《C#面向對象程序設計入門教程》
希望本文所述對大家C#程序設計有所幫助。
- C#使用xsd文件驗證XML格式是否正確的實現(xiàn)方法
- C#中利用LINQ to XML與反射把任意類型的泛型集合轉換成XML格式字符串的方法
- C#中把任意類型的泛型集合轉換成SQLXML數(shù)據(jù)格式的實例
- C#實現(xiàn)導出List數(shù)據(jù)到xml文件的方法【附demo源碼下載】
- C#實現(xiàn)的xml操作類完整實例
- C#實現(xiàn)XML與實體類之間相互轉換的方法(序列化與反序列化)
- C# XML操作 代碼大全(讀XML,寫XML,更新,刪除節(jié)點,與dataset結合等)
- C#對XML文件的各種操作實現(xiàn)方法
- C# WinForm開發(fā)中使用XML配置文件實例
- C#對象與XMl文件之間的相互轉換
- C#中XmlTextWriter讀寫xml文件詳細介紹
- C# 寫入XML文檔三種方法詳細介紹
- C# 操作XML文檔 使用XmlDocument類方法
相關文章
DevExpress實現(xiàn)GridControl根據(jù)列選中一行
這篇文章主要介紹了DevExpress實現(xiàn)GridControl根據(jù)列選中一行,比較實用的功能,需要的朋友可以參考下2014-08-08
DevExpress實現(xiàn)TreeList按條件隱藏節(jié)點CheckBox的方法
這篇文章主要介紹了DevExpress實現(xiàn)TreeList按條件隱藏節(jié)點CheckBox的方法,需要的朋友可以參考下2014-08-08

