XQuery Examples
In this section, let's learn some basic XQuery syntax by studying an example.
XML Example Document
We will use this XML document in the example below.
"books.xml":
<bookstore>
<book category="COOKING">
<author>Giada De Laurentiis</author>
<year>2005</year>
<price>30.00</price>
</book>
<book category="CHILDREN">
<author>J K. Rowling</author>
<year>2005</year>
<price>29.99</price>
</book>
<book category="WEB">
<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 category="WEB">
<author>Erik T. Ray</author>
<year>2003</year>
<price>39.95</price>
</book>
</bookstore>
。
How to select nodes from "books.xml"?
Functions
XQuery uses functions to extract data from XML documents.
doc() is used to open the "books.xml" file:
Path Expressions
XQuery uses path expressions to navigate through elements in an XML document.
The following path expression is used to select all title elements in the "books.xml" file:
(/bookstore selects the bookstore element, /book selects all book elements under the bookstore element, and /title selects all title elements under each book element)
The XQuery above can extract the following data:
Predicates
XQuery uses predicates to limit the data extracted from an XML document.
The following predicate is used to select all book elements under the bookstore element, and the value of the price element under the selected book element must be less than 30:
The XQuery above can extract the following data:
<author>J K. Rowling</author>
<year>2005</year>
<price>29.99</price>
</book>