search
  • Sign In
  • Sign Up
Password reset successful

Follow the proiects vou are interested in andi aet the latestnews about them taster

Home Backend Development XML/RSS Tutorial xml learning (8) xml addition, deletion, modification and query

xml learning (8) xml addition, deletion, modification and query

Feb 23, 2017 pm 02:42 PM

        在项目开发中,我们经常会对某张表进行增删改查。我们根据条件刷选表中的数据放到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中文网(m.sbmmt.com)! 


Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undress AI Tool

Undress AI Tool

Undress images for free

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

ArtGPT

ArtGPT

AI image generator for creative art from text prompts.

Stock Market GPT

Stock Market GPT

AI powered investment research for smarter decisions

Popular tool

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

JSON vs. XML: Why RSS Chose XML JSON vs. XML: Why RSS Chose XML May 05, 2025 am 12:01 AM

RSS chose XML instead of JSON because: 1) XML's structure and verification capabilities are better than JSON, which is suitable for the needs of RSS complex data structures; 2) XML was supported extensively at that time; 3) Early versions of RSS were based on XML and have become a standard.

Understanding RSS Documents: A Comprehensive Guide Understanding RSS Documents: A Comprehensive Guide May 09, 2025 am 12:15 AM

RSS documents are a simple subscription mechanism to publish content updates through XML files. 1. The RSS document structure consists of and elements and contains multiple elements. 2. Use RSS readers to subscribe to the channel and extract information by parsing XML. 3. Advanced usage includes filtering and sorting using the feedparser library. 4. Common errors include XML parsing and encoding issues. XML format and encoding need to be verified during debugging. 5. Performance optimization suggestions include cache RSS documents and asynchronous parsing.

Building XML Applications with C  : Practical Examples Building XML Applications with C : Practical Examples May 03, 2025 am 12:16 AM

You can use the TinyXML, Pugixml, or libxml2 libraries to process XML data in C. 1) Parse XML files: Use DOM or SAX methods, DOM is suitable for small files, and SAX is suitable for large files. 2) Generate XML file: convert the data structure into XML format and write to the file. Through these steps, XML data can be effectively managed and manipulated.

RSS, XML and the Modern Web: A Content Syndication Deep Dive RSS, XML and the Modern Web: A Content Syndication Deep Dive May 08, 2025 am 12:14 AM

RSS and XML are still important in the modern web. 1.RSS is used to publish and distribute content, and users can subscribe and get updates through the RSS reader. 2. XML is a markup language and supports data storage and exchange, and RSS files are based on XML.

XML in C  : Handling Complex Data Structures XML in C : Handling Complex Data Structures May 02, 2025 am 12:04 AM

Working with XML data structures in C can use the TinyXML or pugixml library. 1) Use the pugixml library to parse and generate XML files. 2) Handle complex nested XML elements, such as book information. 3) Optimize XML processing code, and it is recommended to use efficient libraries and streaming parsing. Through these steps, XML data can be processed efficiently.

Beyond Basics: Advanced RSS Features Enabled by XML Beyond Basics: Advanced RSS Features Enabled by XML May 07, 2025 am 12:12 AM

RSS enables multimedia content embedding, conditional subscription, and performance and security optimization. 1) Embed multimedia content such as audio and video through tags. 2) Use XML namespace to implement conditional subscriptions, allowing subscribers to filter content based on specific conditions. 3) Optimize the performance and security of RSSFeed through CDATA section and XMLSchema to ensure stability and compliance with standards.

Understanding RSS: An XML Perspective Understanding RSS: An XML Perspective Apr 25, 2025 am 12:14 AM

RSS is an XML-based format used to publish frequently updated content. 1. RSSfeed organizes information through XML structure, including title, link, description, etc. 2. Creating RSSfeed requires writing in XML structure, adding metadata such as language and release date. 3. Advanced usage can include multimedia files and classified information. 4. Use XML verification tools during debugging to ensure that the required elements exist and are encoded correctly. 5. Optimizing RSSfeed can be achieved by paging, caching and keeping the structure simple. By understanding and applying this knowledge, content can be effectively managed and distributed.

Inside the RSS Document: Essential XML Tags and Attributes Inside the RSS Document: Essential XML Tags and Attributes May 03, 2025 am 12:12 AM

The core structure of RSS documents includes XML tags and attributes. The specific parsing and generation steps are as follows: 1. Read XML files, process and tags. 2. Extract,,, etc. tag information. 3. Handle custom tags and attributes to ensure version compatibility. 4. Use cache and asynchronous processing to optimize performance to ensure code readability.

Related articles