Reading Node from XML

[sandeep lokhande]

Hello,

My XML structure is as follows,

 <Connector>
    <Interaction name="DeactivateGoodDataDeposits">
      <InputRecord>
        <Field sysref="CommonData.testF1" default="" tx="X004" format="MCM004" attribute="FCCGOOD" type="A" length="3" scale="0" transform="" mappable="">
          <Comment>DIVISA DEL VALOR</Comment>
        </Field>
        <Field sysref="CommonData.AssessmentValue" default="" tx="X004" format="MCM004" attribute="AMTGOOD" type="F" length="18" scale="3" transform="" mappable="">
          <Comment>IMPORTE DEL VALOR</Comment>
        </Field>
      </InputRecord>
      <OutputRecord>
        <Field sysref="DepositsData.testW1" default="" tx="G004" format="DDD004" attribute="FLGCAPI" type="A" length="1" scale="0" transform="Bool_YN" mappable="">
          <Comment>CAPITALIZATION FLAG</Comment>
        </Field>
        <Field default="" tx="G004" format="DDD004" attribute="FLGRENE" type="A" length="1" scale="0" mappable="">
          <Comment>RENEWAL FLAG</Comment>
        </Field>
      </OutputRecord>
    </Interaction>
  </Connector>

I want to extract and get all the values of "Field" from two different nodes InputRecord and OutputRecord,

The code for that which i have written is as,

  Document doc = docBuilder.parse(new File("D:\\UnitList.xml"));
  doc.getDocumentElement().normalize();
  NodeList nodeList = doc.getElementsByTagName("Field");
  if (nodeList != null && nodeList.getLength() > 0) {
     for (int fieldCount = 0; fieldCount < nodeList.getLength(); fieldCount++) {					
        // get the node
        Element el = (Element) nodeList.item(fieldCount);
	   String temp = el.getAttribute("sysref");// i am using this temp varible for some other task
     }
  }

How could i get separate values of InputRecord and OutputRecord ?

I want to use InputRecord values for some different purpose and OutputRecord for some different than that of InputRecord ,
here in this case i get all the values in the NodeList by,

doc.getElementsByTagName("Field");

Please suggest me if there is any option as such for separately getting these values.
thank you in advance.

[Nick Oz]

You could either get the parent Node's name then add InputRecord and OutputRecord specific logic based on this value ...

  Node parent = el.getParentNode();
  String parentName = parent.getNodeName();

or instead of going straight for Field you could retrieve InputRecord and OutputRecord separately then declare a new NodeList for Field. Naturally if you choose this option I would make this a function with the parent name as an argument (i.e. InputRecord).

  NodeList nodeList = doc.getElementsByTagName("InputRecord");
  if (nodeList != null && nodeList.getLength() > 0) {
     for (int fieldCount = 0; fieldCount < nodeList.getLength(); fieldCount++) {
        Element el = (Element) nodeList.item(fieldCount);
        NodeList subList = el.getElementsByTagName("Field");
        //Insert empty check, loop for subList and logic to store InputRecord's fields.
     }
  }

Option 1 seems cleaner based on your example but I suppose depending on the size of the XML, number of parents (i.e. InputRecord) and the number of children each parent has it may make more sense to go directly to the parent.

-nick

[Rob Spoor]

Moving to our XML forum.

[Paul Clapham]

I would just use the two XPath expressions "/Connector/Interaction/InputRecord/Field" and "/Connector/Interaction/OutputRecord/Field".

[sandeep lokhande]

thank you for your response, its helped me very much.