Using multiple parameters in an XQuery?

Question

I have the following Java Method that uses XQuery:

 public String getLocationByName(String name) {
            final String nameToQueryFor = name;
            return engine.new Query<String>(MY_COLLECTION) {

                @Override
                protected String query(Collection collection) throws Exception {
                    XQueryService service = queryService();

                    ResourceSet resourceSet = service.query(
                            format("//Products/Product[name='%s']" +
                                            "/attribute"
                                    , StringEscapeUtils.escapeXml(nameToQueryFor)
                            ));

                    List<String> results = newArrayList();

                    for (String resource : new IterableStringResources(resourceSet)) {
                        results.add(resource);
                    }
                    return results.get(0);
                }
            }.execute();
        }

As can be seen I currently am only querying using one parameter, i.e. name.

I am a beginner with XQuery, How can I alter this Xquery to take an additional parameter: price

My method would now become:

 public String getLocationByNameAndPrice(String name)

Also note that it might be safer and easier to use exist-db.org/api/org/exist/xmldb/… to set up variables for your Query so that you can then use //Products/Product[name=$name] instead of string formatting and concatenation. — Martin Honnen
– Martin Honnen, Commented Oct 17, 2016 at 11:30

Markus · Accepted Answer · 2016-10-17 11:28:40Z

1

Just include the condition into your XPath, e.g.:

format("//Products/Product[name='%s' and price='%s']/attribute",
  StringEscapeUtils.escapeXml(nameToQueryFor),
  StringEscapeUtils.escapeXml(priceToQueryFor))

The exact syntax of the query of course depends on your XML document.

answered Oct 17, 2016 at 11:28

Markus

3,4872 gold badges27 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using multiple parameters in an XQuery?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related