doc() funciton in for loop : doc « XQuery « XML






doc() funciton in for loop


File: Data.xml

<prod:car xmlns:prod="http://java2s.com/prod">
  <prod:id>0002</prod:id>
  <prod:name language="en">name 2</prod:name>
</prod:car>

File: Query.xquery

declare namespace cat = "http://java2s.com/cat";
<report xmlns="http://java2s.com/report"
           xmlns:prod="http://java2s.com/prod"> {
  for $car in doc("Data.xml")/prod:car
  return <linecar>
           {$car/prod:id}
           {$car/prod:name}
         </linecar>
} </report>


Output:

<?xml version="1.0" encoding="UTF-8"?>
<report xmlns:prod="http://java2s.com/prod" xmlns="http://java2s.com/report">
   <linecar>
      <prod:id>0002</prod:id>
      <prod:name language="en">name 2</prod:name>
   </linecar>
</report>

 








Related examples in the same category

1.Use doc() function to load XML document
2.Use doc() function to load xml docuCt
3.Load children