A detailed introduction to teach you how to quickly find information from an XML file

In the Internet era, xml files play a role in saving and transmitting data. The Soap protocol communicates information through Xml, and the database is accessed through Xml files, etc. So how to quickly obtain the required information from an XML file?

We know that both Java's JAXP and Microsoft.Net have Xml parsers. Microsoft.Net analyzes while reading, while JAXP reads it into the memory and then analyzes it (there is also an event mechanism to read), in short, is not conducive to fast reading. Based on this, both Microsoft.Net and JAXP provide the XPATH mechanism to quickly locate the required nodes in the XML file.

For example, there is an XML file: booksort.xml:

<?xml version="1.0"?>

<!-- a fragment of a book store inventory database -->

<bookstore xmlns:bk="urn:samples">

<book genre="novel" publicationdate="1997" bk:ISBN="1-861001-57-8">

<title>PRide And Prejudice</title>

<author>

<first-name>Jane</first-name>

<last-name>Austen</last-name>

</author>

<price>24.95</price>

</book>

<book genre="novel" publicationdate="1992" bk:ISBN="1-861002-30-1">

<title>The Handmaid&#39;s Tale</title>

<author>

<first-name>Margaret</first-name>

<last-name>Atwood</last-name>

</author>

<price>29.95</price>

</book>

<book genre="novel" publicationdate="1991" bk:ISBN="1-861001-57-6">

<title>Emma</title>

<author>

<first-name>Jane</first-name>

<last-name>Austen</last-name>

</author>

<price>19.95</price>

</book>

<book genre="novel" publicationdate="1982" bk:ISBN="1-861001-45-3">

<title>Sense and Sensibility</title>

<author>

<first-name>Jane</first-name>

<last-name>Austen</last-name>

</author>

<price>19.95</price>

</book>

</bookstore>

If we want to quickly find all title names with "last-name" equal to "Austen", we can get it through the following method:

XmlReaderSample.cs

//Corelib.net/System.Xml.Xsl/XPathDocument Class

//Author :Any 


using System;

using System.IO;

using System.Xml;

using System.Xml.XPath;


public class XmlReaderSample

{

public static void Main()

{

XmlTextReader myxtreader = new XmlTextReader("booksort.xml");

XmlReader myxreader = myxtreader;

XPathDocument doc = new XPathDocument(myxreader);

XPathNavigator nav = doc.CreateNavigator();


XPathExpression expr; 

expr = nav.Compile("descendant::book[author/last-name='Austen']");


//expr.AddSort("title", XmlSortOrder.Ascending, XmlCaSEOrder.None, "", XmlDataType.Text);


XPathNodeIterator iterator = nav.Select(expr);

while (iterator.MoveNext())

{

XPathNavigator nav2 = iterator.Current;

nav2.MoveToFirstChild();

Console.WriteLine("Book title: {0}", nav2.Value);

}

}

}

Run this program, the result is:

Book title: Pride And Prejudice

Book title: Emma

Book title: Sense and Sensibility

You can see that the search is correct.

Using some functions in XPATH, simple sorting and simple operations can also be achieved. If you often need to summarize data in a database, you can use XPATH to achieve this.

For example:

order.xml

<!--Represents a customer order-->

<order>

<book ISBN=&#39;10-861003-324&#39;>

<title>The Handmaid&#39;s Tale</title>

<price>19.95</price>

</book>

<cd ISBN=&#39;2-3631-4&#39;>

<title>Americana</title>

<price>16.95</price>

</cd>

</order>

and: books.xml

<?xml version="1.0"?>

<!-- This file represents a fragment of a book store inventory database -->

<bookstore>

<book cc="dd" xmlns:bk="urn:sample" xmlns:ns="http://www.Any.com" genre="autobiography" publicationdate="1981" ISBN="1-861003-11-0">

<title>The Autobiography of Benjamin Franklin</title>

<ns:author>

<first-name>Benjamin</first-name>

<last-name>Franklin</last-name>

</ns:author>

<price>8.99</price>

</book>

<book genre="novel" publicationdate="1967" ISBN="0-201-63361-2">

<title>The Confidence Man</title>

<author>

<first-name>Herman</first-name>

<last-name>Melville</last-name>

</author>

<price>11.99</price>

</book>

<book genre="philosophy" publicationdate="1991" ISBN="1-861001-57-6">

<title>The Gorgias</title>

<author>

<name>Plato</name>

</author>

<price>9.99</price>

</book>

</bookstore>

We can sum the prices in the XML file to get the total price.

Evaluate.cs

//Corelib.net/System.Xml.Xsl/XPathNavigator Class

//Author :Any 


using System;

using System.IO;

using System.Xml;

using System.Xml.XPath;



public class EvaluateSample

{

public static void Main()

{

EvaluateSample myEvaluateSample = new EvaluateSample();

myEvaluateSample.test("books.xml");

}


public void test(String args)

{

try

{

//test Evaluate(String);

XPathDocument myXPathDocument = new XPathDocument(args);

XPathNavigator myXPathNavigator = myXPathDocument.CreateNavigator();

Console.WriteLine(myXPathNavigator.Evaluate("sum(descendant::book/price)"));


//testEvaluate(XPathExpression);

XmlDocument doc = new XmlDocument();

doc.Load("order.xml");

XPathNavigator nav = doc.CreateNavigator();

XPathExpression expr = nav.Compile("sum(//price/text())");

Console.WriteLine(nav.Evaluate(expr));


//testEvaluate(XPathExpression);


XPathNodeIterator myXPathNodeIterator = nav.Select("descendant::book/title");

expr = nav.Compile("sum(//price/text())");

Console.WriteLine(nav.Evaluate(expr,myXPathNodeIterator));


} 

catch (Exception e)

{

Console.WriteLine ("Exception: {0}", e.ToString());

}

}


}

Run this program, the results are as follows:

30.97

36.9

36.9

We can see that 30.97 is the sum of all price values ​​​​in books.xml, and 36.9 is the sum of all price values ​​​​in order.xml sum. Not only can you quickly find information through XPAH, but you can also perform some basic processing on the information.

The above is a detailed introduction to teach you how to quickly find information from an XML file. For more related content, please pay attention to the PHP Chinese website (www.php.cn)!