How can I break XPath child node records

[Farakh khan]

Hello,

<ResumeParserData>
	<SegrigatedQualification> 
		<EducationSplit> 
			<University /> 
			<Degree /> 
			<Year /> 
		</EducationSplit> 
	</SegrigatedQualification> 
</ResumeParserData>

Here is my code:

	
		XPathExpression cPath = xpath.compile("//descendant::EducationSplit/*/text()");
		Object cResult = cPath.evaluate(doc, XPathConstants.NODESET);
  		NodeList cNode = (NodeList) cResult;
		String education="";
			for(int i=0; i<cNode.getLength(); i++){	
			education+=cNode.item(i).getNodeValue()+"\n";				
	  		}			
			out.println(education);

The output is very correct like this:
=======================================
Bogomolets National Medical University
Masters degree
June 2007
O.O. Bogomolets National Medical University
(MBBS)
June 2004
===============================================

I want to read ><University><Degree><Year> in three different variables to insert them in 3 different columns of the database but when am reading like:

XPathExpression cPath = xpath.compile("//descendant::EducationSplit/University/text()");

then its output is showing 2 existing universities whereas I need two or all universities by iterating the records:
Bogomolets National Medical University
O.O. Bogomolets National Medical University

How can I read each university/degree/year in 3 different variables to insert each record in seprate columns of database?

Best regards

[Farakh khan]

Hello,

Can anybody help me?

Best regards

[H Paul]

Here is 1 way I do:

1. I would use expression //EducationSplit to get a NodeList of EducationSplit
2. I loop thru a EducationSplit NodeList and for each Node
I would use expression University to get the value of University
I would use expression Degree to get the value of Degree
I would use expression Year to get the value of Year

		XPath xPath = XPathFactory.newInstance().newXPath();
		String xmlString="<?xml version=\"1.0\" encoding=\"utf-8\"?><ResumeParserData><SegrigatedQualification><EducationSplit><University>ABC</University><Degree>SC</Degree><Year>2001</Year></EducationSplit><EducationSplit><University>XYZ</University><Degree>ART</Degree><Year>2001</Year></EducationSplit></SegrigatedQualification></ResumeParserData>";
		
		try {
			NodeList nodeList = (NodeList) xPath.evaluate("//EducationSplit", new InputSource(new StringReader(xmlString)), XPathConstants.NODESET);
			for (int index=0;index<nodeList.getLength(); index++) {
				Node node = nodeList.item(index);
				String university= xPath.evaluate("University", node);
				String degree= xPath.evaluate("Degree", node);	
				String year= xPath.evaluate("Year", node);
			}
		} catch (XPathExpressionException e) {
			e.printStackTrace();
		}

[g tsuji]

>"//descendant::EducationSplit/*/text()"
This is akin to a monster. // is already a short-hand of descendant-or-self axis starting from the root. If it is meant for anything, it should be written as //EducationSplit/*/text().