How to use the Java string variables in the XPath query

I have books.xml file which contains author name and book titles. I am using the following code snippet to query books.xml.

XPathFactory factory = XPathFactory.newInstance();
XPath xpath = factory.newXPath();
XPathExpression expr
    = xpath.compile("//book[author= 'Larry Niven']/title/text()");

Now instead of directly putting the name in the query if I want to pass it while the program is running as a String variable how to do it. Just putting the string variable name is not working!

String rawXPath = "//book[author= '" + larrysName + "']/title/text()";

String rawXPath = String.format("//book[author= '%s']/title/text()", larrysName);

where larrysName is a variable of type String coming from somewhere.

How to use the XPath query to get text under a certain element, but not in an element?

Not sure if this title make sense. The piece of HTML is like this: <div id="A"> <span class="B"> XXXX </span> MMM <span class="B"> ZZZZ </span> NNN <div class="C"> <span class=

How to use the ORMLite query builder to get the total records in a table

Similar to select count(*) from tablename; what should be query in ORMLITE i tried something like int total = dao.queryBuilder().("select count(*)"); How to use the ORMLite query builder to get the total records in a table ORMLite has a Dao.coun

Pass a java string variable in a mysql query

How to pass java string variable in sql query .I have done all the JDBC connection . My sql database query is sql = "Select * from production AS cust INNER JOIN location AS comp ON cust.location_id = comp.location_id where comp.name = locationnames A

How to return to the parent node in the XML file using the Xpath query (using XSLT)?

Let us have a xml tree of depth N. I have traveresd the last node means i am at last note. Now i wanted to go back to some level up (say at N-3) in the xml tree from that last node. Please let me know the syntax for the XPATH query so that i can reac

How to use the same query to insert data

I am new at programming. I am trying to create a simple guestbok. i have one index page where you can register a firstname, lastname and email. And if you click on one name you redirect to a new page with id. How can i now insert text to this ID with

How to use the same query with the random value after clicking on the next button

Now the problem is I have that query var question = _repository.tbl_TestQuestion .Where(x => x.nCourseId == courseId && x.nChapterId == chapterId && x.bActive == true) .OrderBy(x => Guid.NewGuid()).Take(10).ToList(); when I click the

entity frame, how to use the object query with a WHERE record, AND to retrieve the entity

I am trying to add and AND condition to my entity framework where clause, but the way I am doing it is not working. Can anyone show me how to do this the correct way please? Before adding the AND condition, the code worked fine. Dim myRecipeStepsHist

How to use the internal query with an inequality condition in the hive

I have the following query which has an inner query with an inequality condition that depends on the outer query. It looks like HIVE does not support refering to the outer query from the the inner query by an inequality condition. How can I write thi

How to use the join query for 4 tables in rails

I have following tables 4 models class ItemCode < ActiveRecord::Base belongs_to :item_point end class ItemPoint < ActiveRecord::Base belongs_to :item has_many :item_codes end class Item < ActiveRecord::Base belongs_to :prodcut_category has_many :

Reading nodes in xml using the xpath query

Hi I have following code snippet which is working, when there is no namespace available but if i make it available then its return no values. xml file : Person.xml <?xml version="1.0" encoding="utf-8" ?> <Persons> <Perso

How to use the native query with the spring repo mapped to the custom object?

I have table t1: id | title 1 | title1 2 | title2 and I have the following spring repo method: @Query(nativeQuery = true, value = "select id, title from t1") public List<T1> getAll(); The custom class is: public class T1 { @JsonProperty(&q

How to use the media query for high-resolution devices

I have made a simple website which is responsive (more or less). I have used media query @media only screen and (max-width: 699.99px). Now I know that this will activate the css inside it when resolution is less than 699.99px. So it is fine with comp

How to use the active query method of another model class via a relationship in Yii2

I have models like below /** * @property integer $id * @property string $title */ class Book extends ActiveRecord { public static function find() { return new BookQuery(self::class); } } class BookQuery extends ActiveQuery { public function andWhereT

How to use the Laravel query builder

How can I use laravel query builder for following query($sql)? I mean I want to use like this $sql=\DB::table('animal).....but I am unable to do so. Please help me foreach ($animalsTypes as $animal) { //some code here... $sql ="SELECT count(*) FROM a

how to use the FIND_IN_SET () query in the codeigniter

I have two tables- One with attendance details and another one with student detail. The following are the table structures: tbl_attendance aid date attendance 1 2017-03-09 5,6,9 2 2017

Related Articles