


xml learning (8) xml addition, deletion, modification and query
在项目开发中,我们经常会对某张表进行增删改查。我们根据条件刷选表中的数据放到gridview中以列表形式展现,同时给gridview添加各种样式,比如一般必用的鼠标经过,鼠标离开颜色变化,行选中等颜色加深,同时给列表数据项赋值,单击保存按钮可以修改一条已存在的数据或者添加一条新的数据,单击按钮添加,列表数据项清空,单击删除,可以删除一条数据。
由于为了方便大家把代码复制一下,在脱离数据的情况下,就可以看到效果,所以,我把数据存放在xml,所以读取数据不是通过数据库,是通过跟xml文件交互实现的。所以做了下面对xml增删改查页面。
效果图:
首先列出XML文件,方便代码参照
内容.xml
<?xml version="1.0" encoding="utf-8"?> <config> <Header ID="ID" class="class" class_name="class_name" year="year" school="school" count="count"> </Header> <rows ID="01" class="一五班" class_name="实验班" year="2013" school="三峡高级中学" count="30"> </rows> <rows ID="02" class="一六班" class_name="奥数班" year="2013" school="三峡高级中学" count="45"> </rows> <rows ID="03" class="一七班" class_name="阳光班" year="2013" school="三峡高级中学" count="60"> </rows> <rows ID="04" class="一八班" class_name="美术班" year="2013" school="三峡高级中学" count="75"> </rows> </config>
一,核心代码:
1) 修改xml
/// <summary> /// 修改XML /// </summary> /// <param name="xmlName">XML文件名</param> /// <param name="ht">存放信息哈希表</param> /// <param name="ID">主键值</param> public void saveXML(string xmlName,Hashtable ht,string ID) { string fileName=HttpContext.Current.Request.PhysicalApplicationPath+"\\Xml\\"+xmlName+".xml";//xml的物理路径 XmlDocument xmlDoc=new XmlDocument (); xmlDoc.Load(fileName); XmlNode node = xmlDoc.SelectSingleNode("config/rows[@ID=" + ID + "]"); foreach (XmlNode node1 in node.Attributes) { if (ht.ContainsKey(node1.Name)&&node1.Name!="ID") { node1.Value = ht[node1.Name].ToString(); } } xmlDoc.Save(fileName); }
ht:
Hashtable ht = new Hashtable(); ht.Add("ID", this.txt_ID.Value); ht.Add("class", this.txt_class.Value); ht.Add("class_name", this.txt_class_name.Value); ht.Add("year", this.txt_year.Value); ht.Add("school", this.txt_school.Value); ht.Add("count", this.txt_count.Value);
2)插入xml
/// <summary> /// 插入xml /// </summary> /// <param name="xmlName">XML文件名</param> /// <param name="ht">存放信息哈希表</param> /// <returns></returns> public string insertXml(string xmlName, Hashtable ht) { string fileName = HttpContext.Current.Request.PhysicalApplicationPath + "\\Xml\\" + xmlName + ".xml";//xml的物理路径 XmlDocument xmlDoc = new XmlDocument(); xmlDoc.Load(fileName); XmlNode node = xmlDoc.SelectSingleNode("//rows[last()]");//最后一个行节点 XmlNode MaxNode = xmlDoc.SelectSingleNode("//rows/@ID[not(.<//rows/@ID)]");//获取主键最大值 if (int.Parse(ht[MaxNode.Name].ToString()) <= int.Parse(MaxNode.Value))//如果小于主键最大值,那么返回- { return "-1"; } XmlElement xe = xmlDoc.CreateElement("rows"); xe.InnerText = ""; foreach (XmlNode node1 in node.Attributes) { if (ht.ContainsKey(node1.Name)) { xe.SetAttribute(node1.Name, ht[node1.Name].ToString()); } else { xe.SetAttribute(node1.Name,""); } } node.ParentNode.AppendChild(xe); xmlDoc.Save(fileName); return "1"; }
3) 删除xml
/// <summary> /// 删除xml节点 /// </summary> /// <param name="xmlName">XML文件名</param> /// <param name="ID">主键值</param> /// <param name="primaryKey">主键名</param> /// <returns></returns> public string deleteXml(string xmlName,string ID,string primaryKey) { string rtn = string.Empty; string fileName = HttpContext.Current.Request.PhysicalApplicationPath + "\\Xml\\" + xmlName + ".xml";//xml的物理路径 XmlDocument xmlDoc = new XmlDocument(); xmlDoc.Load(fileName); XmlNode node = xmlDoc.SelectSingleNode("//rows[@"+primaryKey+"='"+ID+"']");//最后一个行节点 if (node ==null) { rtn = "-1"; } else { node.ParentNode.RemoveChild(node); rtn = "1"; } xmlDoc.Save(fileName); return rtn; }
4)html显示xml在以前的内容已经介绍过
如果是看具体的实现代码,可以下载:
以上就是xml学习(8) xml增删改查的内容,更多相关内容请关注PHP中文网(www.php.cn)!

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics



Can XML files be opened with PPT? XML, Extensible Markup Language (Extensible Markup Language), is a universal markup language that is widely used in data exchange and data storage. Compared with HTML, XML is more flexible and can define its own tags and data structures, making the storage and exchange of data more convenient and unified. PPT, or PowerPoint, is a software developed by Microsoft for creating presentations. It provides a comprehensive way of

Using Python to merge and deduplicate XML data XML (eXtensibleMarkupLanguage) is a markup language used to store and transmit data. When processing XML data, sometimes we need to merge multiple XML files into one, or remove duplicate data. This article will introduce how to use Python to implement XML data merging and deduplication, and give corresponding code examples. 1. XML data merging When we have multiple XML files, we need to merge them

Implementing filtering and sorting of XML data using Python Introduction: XML is a commonly used data exchange format that stores data in the form of tags and attributes. When processing XML data, we often need to filter and sort the data. Python provides many useful tools and libraries to process XML data. This article will introduce how to use Python to filter and sort XML data. Reading the XML file Before we begin, we need to read the XML file. Python has many XML processing libraries,

Convert XML data in Python to CSV format XML (ExtensibleMarkupLanguage) is an extensible markup language commonly used for data storage and transmission. CSV (CommaSeparatedValues) is a comma-delimited text file format commonly used for data import and export. When processing data, sometimes it is necessary to convert XML data to CSV format for easy analysis and processing. Python is a powerful

Importing XML data into the database using PHP Introduction: During development, we often need to import external data into the database for further processing and analysis. As a commonly used data exchange format, XML is often used to store and transmit structured data. This article will introduce how to use PHP to import XML data into a database. Step 1: Parse the XML file First, we need to parse the XML file and extract the required data. PHP provides several ways to parse XML, the most commonly used of which is using Simple

Python implements conversion between XML and JSON Introduction: In the daily development process, we often need to convert data between different formats. XML and JSON are common data exchange formats. In Python, we can use various libraries to convert between XML and JSON. This article will introduce several commonly used methods, with code examples. 1. To convert XML to JSON in Python, we can use the xml.etree.ElementTree module

Handling Errors and Exceptions in XML Using Python XML is a commonly used data format used to store and represent structured data. When we use Python to process XML, sometimes we may encounter some errors and exceptions. In this article, I will introduce how to use Python to handle errors and exceptions in XML, and provide some sample code for reference. Use try-except statement to catch XML parsing errors When we use Python to parse XML, sometimes we may encounter some

Go language is an efficient, concise and easy-to-learn programming language. It is favored by developers because of its advantages in concurrent programming and network programming. In actual development, database operations are an indispensable part. This article will introduce how to use Go language to implement database addition, deletion, modification and query operations. In Go language, we usually use third-party libraries to operate databases, such as commonly used sql packages, gorm, etc. Here we take the sql package as an example to introduce how to implement the addition, deletion, modification and query operations of the database. Assume we are using a MySQL database.
