XML problem when trying to loop through child nodes

[jismon]

Hi,
I have one problem when i'm trying to loop thorugh the child nodes in a XML string in JAVA. The first Loop is working but in the child node there i want to loop and get the values but it doesn't change the value. Always print the first child node value. I got the length of the child nodes but ..... Pls see the xml string.

I want to print the service class and availabilty in the each flightinfo node. I got he lenth of flightinfo also the infoonClasses. But it always print the first Class and Avalibilty in the entire loop.

can any on tell me how can loopthrough the child nodes......

<MultiAvailabilityReply>
    <flightInfo>
        <basicFlightInfo>
            <flightDetails>
                <departureDate>250307</departureDate>
                <departureTime>0030</departureTime>
                <arrivalDate>250307</arrivalDate>
                <arrivalTime>0820</arrivalTime>
            </flightDetails>
            <departureLocation>
                <cityAirport>BOM</cityAirport>
            </departureLocation>
            <arrivalLocation>
                <cityAirport>SIN</cityAirport>
            </arrivalLocation>
            <marketingCompany>
                <identifier>SQ</identifier>
            </marketingCompany>
            <flightIdentification>
                <number>423</number>
            </flightIdentification>
            <productTypeDetail>
                <productIndicators>D</productIndicators>
                <productIndicators>EN</productIndicators>
            </productTypeDetail>
            <lineItemNumber>1</lineItemNumber>
        </basicFlightInfo>
        <infoOnClasses>
            <productClassDetail>
                <serviceClass>F</serviceClass>
                <availabilityStatus>4</availabilityStatus>
            </productClassDetail>
        </infoOnClasses>
        <infoOnClasses>
            <productClassDetail>
                <serviceClass>P</serviceClass>
                <availabilityStatus>4</availabilityStatus>
            </productClassDetail>
        </infoOnClasses>
        <infoOnClasses>
            <productClassDetail>
                <serviceClass>A</serviceClass>
                <availabilityStatus>4</availabilityStatus>
            </productClassDetail>
        </infoOnClasses>
        <infoOnClasses>
            <productClassDetail>
                <serviceClass>Z</serviceClass>
                <availabilityStatus>4</availabilityStatus>
            </productClassDetail>
        </infoOnClasses>
        <infoOnClasses>
            <productClassDetail>
                <serviceClass>C</serviceClass>
                <availabilityStatus>4</availabilityStatus>
            </productClassDetail>
        </infoOnClasses>
        <infoOnClasses>
            <productClassDetail>
                <serviceClass>J</serviceClass>
                <availabilityStatus>4</availabilityStatus>
            </productClassDetail>
        </infoOnClasses>
        <infoOnClasses>
            <productClassDetail>
                <serviceClass>D</serviceClass>
                <availabilityStatus>4</availabilityStatus>
            </productClassDetail>
        </infoOnClasses>
        <infoOnClasses>
            <productClassDetail>
                <serviceClass>Y</serviceClass>
                <availabilityStatus>9</availabilityStatus>
            </productClassDetail>
        </infoOnClasses>
        <infoOnClasses>
            <productClassDetail>
                <serviceClass>B</serviceClass>
                <availabilityStatus>9</availabilityStatus>
            </productClassDetail>
        </infoOnClasses>
        <infoOnClasses>
            <productClassDetail>
                <serviceClass>M</serviceClass>
                <availabilityStatus>9</availabilityStatus>
            </productClassDetail>
        </infoOnClasses>
        <infoOnClasses>
            <productClassDetail>
                <serviceClass>W</serviceClass>
                <availabilityStatus>9</availabilityStatus>
            </productClassDetail>
        </infoOnClasses>
        <infoOnClasses>
            <productClassDetail>
                <serviceClass>Q</serviceClass>
                <availabilityStatus>9</availabilityStatus>
            </productClassDetail>
        </infoOnClasses>
        <infoOnClasses>
            <productClassDetail>
                <serviceClass>N</serviceClass>
                <availabilityStatus>9</availabilityStatus>
            </productClassDetail>
        </infoOnClasses>
        <infoOnClasses>
            <productClassDetail>
                <serviceClass>V</serviceClass>
                <availabilityStatus>1</availabilityStatus>
            </productClassDetail>
        </infoOnClasses>
        <infoOnClasses>
            <productClassDetail>
                <serviceClass>T</serviceClass>
                <availabilityStatus>0</availabilityStatus>
            </productClassDetail>
        </infoOnClasses>
        <infoOnClasses>
            <productClassDetail>
                <serviceClass>L</serviceClass>
                <availabilityStatus>0</availabilityStatus>
            </productClassDetail>
        </infoOnClasses>
        <infoOnClasses>
            <productClassDetail>
                <serviceClass>K</serviceClass>
                <availabilityStatus>0</availabilityStatus>
            </productClassDetail>
        </infoOnClasses>
        <infoOnClasses>
            <productClassDetail>
                <serviceClass>S</serviceClass>
                <availabilityStatus>9</availabilityStatus>
            </productClassDetail>
        </infoOnClasses>
        <infoOnClasses>
            <productClassDetail>
                <serviceClass>E</serviceClass>
                <availabilityStatus>9</availabilityStatus>
            </productClassDetail>
        </infoOnClasses>
        <infoOnClasses>
            <productClassDetail>
                <serviceClass>H</serviceClass>
                <availabilityStatus>9</availabilityStatus>
            </productClassDetail>
        </infoOnClasses>
        <additionalFlightInfo>
            <flightDetails>
                <typeOfAircraft>773</typeOfAircraft>
                <numberOfStops>0</numberOfStops>
                <legDuration>0520</legDuration>
            </flightDetails>
            <departureStation>
                <terminal>2</terminal>
            </departureStation>
            <arrivalStation>
                <terminal>2</terminal>
            </arrivalStation>
            <productFacilities>
                <type>AS</type>
            </productFacilities>
            <productFacilities>
                <type>DA</type>
            </productFacilities>
            <productFacilities>
                <type>LSA</type>
            </productFacilities>
            <productFacilities>
                <type>M</type>
            </productFacilities>
        </additionalFlightInfo>
    </flightInfo>
    <flightInfo>
        <basicFlightInfo>
            <flightDetails>
                <departureDate>250307</departureDate>
                <departureTime>0645</departureTime>
                <arrivalDate>250307</arrivalDate>
                <arrivalTime>1425</arrivalTime>
            </flightDetails>
            <departureLocation>
                <cityAirport>BOM</cityAirport>
            </departureLocation>
            <arrivalLocation>
                <cityAirport>SIN</cityAirport>
            </arrivalLocation>
            <marketingCompany>
                <identifier>AI</identifier>
            </marketingCompany>
            <flightIdentification>
                <number>472</number>
            </flightIdentification>
            <productTypeDetail>
                <productIndicators>D</productIndicators>
                <productIndicators>ET</productIndicators>
            </productTypeDetail>
            <lineItemNumber>2</lineItemNumber>
        </basicFlightInfo>
        <infoOnClasses>
            <productClassDetail>
                <serviceClass>J</serviceClass>
                <availabilityStatus>4</availabilityStatus>
            </productClassDetail>
        </infoOnClasses>
        <infoOnClasses>
            <productClassDetail>
                <serviceClass>C</serviceClass>
                <availabilityStatus>4</availabilityStatus>
            </productClassDetail>
        </infoOnClasses>
        <infoOnClasses>
            <productClassDetail>
                <serviceClass>D</serviceClass>
                <availabilityStatus>4</availabilityStatus>
            </productClassDetail>
        </infoOnClasses>
        <infoOnClasses>
            <productClassDetail>
                <serviceClass>W</serviceClass>
                <availabilityStatus>4</availabilityStatus>
            </productClassDetail>
        </infoOnClasses>
        <infoOnClasses>
            <productClassDetail>
                <serviceClass>Y</serviceClass>
                <availabilityStatus>R</availabilityStatus>
            </productClassDetail>
        </infoOnClasses>
        <infoOnClasses>
            <productClassDetail>
                <serviceClass>B</serviceClass>
                <availabilityStatus>4</availabilityStatus>
            </productClassDetail>
        </infoOnClasses>
        <infoOnClasses>
            <productClassDetail>
                <serviceClass>H</serviceClass>
                <availabilityStatus>4</availabilityStatus>
            </productClassDetail>
        </infoOnClasses>
        <infoOnClasses>
            <productClassDetail>
                <serviceClass>K</serviceClass>
                <availabilityStatus>4</availabilityStatus>
            </productClassDetail>
        </infoOnClasses>
        <infoOnClasses>
            <productClassDetail>
                <serviceClass>L</serviceClass>
                <availabilityStatus>4</availabilityStatus>
            </productClassDetail>
        </infoOnClasses>
        <infoOnClasses>
            <productClassDetail>
                <serviceClass>M</serviceClass>
                <availabilityStatus>4</availabilityStatus>
            </productClassDetail>
        </infoOnClasses>
        <infoOnClasses>
            <productClassDetail>
                <serviceClass>V</serviceClass>
                <availabilityStatus>4</availabilityStatus>
            </productClassDetail>
        </infoOnClasses>
        <infoOnClasses>
            <productClassDetail>
                <serviceClass>G</serviceClass>
                <availabilityStatus>4</availabilityStatus>
            </productClassDetail>
        </infoOnClasses>
        <additionalFlightInfo>
            <flightDetails>
                <typeOfAircraft>310</typeOfAircraft>
                <numberOfStops>0</numberOfStops>
                <legDuration>0510</legDuration>
            </flightDetails>
            <departureStation>
                <terminal>2</terminal>
            </departureStation>
            <arrivalStation>
                <terminal>1</terminal>
            </arrivalStation>
            <productFacilities>
                <type>AS</type>
            </productFacilities>
            <productFacilities>
                <type>DA</type>
            </productFacilities>
            <productFacilities>
                <type>M</type>
            </productFacilities>
        </additionalFlightInfo>
    </flightInfo>
    <MultiAvailabilityReply>
 

[dorinbogdan]

Welcome to TheScripts TSDN...

Please also post the Java code necessary for a quick test.

Thanks,
Dorin.

[jismon]

Thanks for a quick reply,
pls check the below code,

import javax.xml.parsers.DocumentBuilder;
import javax.xml.parsers.DocumentBuilderFactory;
import java.io.StringReader;
 
 
import org.w3c.dom.Document;
import org.w3c.dom.Element;
import org.w3c.dom.Node;
import org.w3c.dom.NodeList;
import org.xml.sax.InputSource;
import org.xml.sax.SAXException;
import org.xml.sax.SAXParseException;
 
import com.sun.org.apache.xerces.internal.dom.ChildNode;
 
public class FlightAvailability {
 
    public static void main(String[] args) {
 
        multiAvailResPage();
    }
 
    public static void multiAvailResPage(){
        try {
 
            DocumentBuilderFactory docBuilderFactory = DocumentBuilderFactory.newInstance();
            DocumentBuilder docBuilder = docBuilderFactory.newDocumentBuilder();
            String strOutPut="";
            String strOutPut1="";
            String source;
            String destination;
            String[] depDate;
            String[] arrDate;
            String[] deptTime;
            String[] arrTime;
            String[] carrierName;
            String[] flightNo;
            String[] serClass;
            String[] vacantSeats;
            depDate    =new String[100];
            arrDate=new String[100];
            deptTime = new String[100];
            arrTime    = new String[100];
            carrierName=new String[100];
            flightNo=new String[100];
            serClass= new String[500];
            vacantSeats=new String[500];
 
            String xmlString = <Pls pate the xml string here>;
            StringReader sr = new StringReader((String) xmlString);
            InputSource iSrc = new InputSource(sr);
            Document doc = docBuilder.parse(iSrc);
            doc.getDocumentElement().normalize();
            //System.out.println ("Root element of the doc is " + doc.getDocumentElement().getNodeName());
 
 
 
            strOutPut="<table border='0'>";
 
            NodeList departure = doc.getElementsByTagName("origin");
            Element departurePlace = (Element)departure.item(0);
            NodeList originValue = departurePlace.getChildNodes();
            source=((Node)originValue.item(0)).getNodeValue();
 
            NodeList arrival = doc.getElementsByTagName("destination");
            Element arrivalPlace    =(Element)arrival.item(0);
            NodeList arrivalValue    = arrivalPlace.getChildNodes();
            destination= ((Node)arrivalValue.item(0)).getNodeValue();
 
            System.out.println("Source        " + source);
            System.out.println("Destination " + destination);
 
            strOutPut1="<tr><td border=0>From:</td><td border=0><input type='text' readOnly name='source' value=" + source+"></td>";
            strOutPut1=strOutPut1+ "<td border=0>Destination:</td><td border=0><input type='text' readOnly name='destination' value=" + destination+"></td></tr>";
            //ChildNode rootNode = doc.getElementsByTagName("flightInfo");
            NodeList rootNode = doc.getElementsByTagName("flightInfo");        
 
            int nodeLength = rootNode.getLength();
            //System.out.println("Total no of flightInfo : " + nodeLength);
 
            for(int s=0; s<nodeLength; s++){
 
                Node firstNode = rootNode.item(s);
                System.out.println("Total no of Innder Child : " + firstNode.getChildNodes().getLength());
                if(firstNode.getNodeType() == Node.ELEMENT_NODE){
 
 
                    // System.out.println("My Class : " +  getNodeValue.getNodDetails("serviceClass",firstNode));
                    // System.out.println("Available Seat : " +  getNodeValue.getNodDetails("availabilityStatus",firstNode));
 
                    Node innerChildNode=firstNode.getFirstChild();
 
//                    
                    arrDate[s]=getNodeValue.getNodDetails("arrivalDate",firstNode);
                    depDate[s]= getNodeValue.getNodDetails("departureDate",firstNode);
                    deptTime[s]= getNodeValue.getNodDetails("departureTime",firstNode);
                    arrTime[s]=    getNodeValue.getNodDetails("arrivalTime",firstNode);
                    carrierName[s]=getNodeValue.getNodDetails("identifier",firstNode);
                    flightNo[s]    =getNodeValue.getNodDetails("number",firstNode);
 
                    int childLength=firstNode.getChildNodes().getLength();
 
                    for(int childNodeLen=0;childNodeLen < childLength;childNodeLen++)
                    {                    
                        System.out.println("Loop No : " + childNodeLen);
                        Node myInnderNode= innerChildNode.getNextSibling();
                        String nodeName= myInnderNode.getNodeName();
                        System.out.println("nodeName : "+nodeName );
                        if(nodeName == "serviceClass"){
                            System.out.println("Jismon : " );
                        }
                        System.out.println("Class : " +  getNodeValue.getNodDetails("serviceClass",myInnderNode));
                        System.out.println("Available Seat : " +  getNodeValue.getNodDetails("availabilityStatus",myInnderNode));
                        //myInnderNode=firstNode.getChildNodes().item(childNodeLen);
                        myInnderNode=innerChildNode.getNextSibling();
 
 
                    }
                    //Node innerNode = firstNode.getNextSibling();
 
 
                    //for(int myInt=0;myInt<firstNode.getChildNodes().getLength();myInt++)
                    //{
                        /*if( firstNode.getChildNodes().item(s).getNodeName().equalsIgnoreCase("infoOnClasses"))
                        {
 
                             Node InnerNode=firstNode.getChildNodes().item(s).getFirstChild();
                             System.out.println("i st loop : " +  InnerNode.getChildNodes().getLength());
 
                             for(int InnerNodeLength=0;InnerNodeLength < InnerNode.getChildNodes().getLength();InnerNodeLength++)
                             {
                                // serClass[InnerNodeLength]=getNodeValue.getNodDetails("productClassDetail",InnerNode);
                                 System.out.println("My Class : " +  getNodeValue.getNodDetails("serviceClass",InnerNode));
                                 System.out.println("Available Seat : " +  getNodeValue.getNodDetails("availabilityStatus",InnerNode));
                             }
 
                        }*/
                    //}
 
                    /*if(firstNode.getNodeName().equalsIgnoreCase("infoOnClasses"))
                    {
                        //Node myInnerChild=firstNode.get);
 
                        NodeList myNode = firstNode.getChildNodes();
                        System.out.println("My Print : " + myNode.getLength());
                    }*/
 
                    //int innernodLen = innerNode.getLength();
 
                    /*
 
                    for(int p=0; p<innernodLen; p++){
                        Node innerfirstNode = innerNode.item(p);
                        if(innerfirstNode.getNodeType() == Node.ELEMENT_NODE){
 
                            serClass[p]=getNodeValue.getNodDetails("serviceClass",innerfirstNode);
                            vacantSeats[p]=getNodeValue.getNodDetails("availabilityStatus",innerfirstNode);
                            System.out.println("Service Class " + serClass[p]);
                            System.out.println("Availability  " + vacantSeats[p]);
 
                            //System.out.println("Loop No " + p);
 
                        }
 
                    }*/
                    System.out.println("+++++++++++++++++++++++++++++++");
                    //System.out.println("Inner Node Length  " + innernodLen);
                    System.out.println("Depat date    " + depDate[s]);
                    System.out.println("Depat Time    " + deptTime[s]);
                    System.out.println("Arrival date  " + arrDate[s]);
                    System.out.println("Arrival Time  " + arrTime[s]);
                    System.out.println("Carrier Name  " + carrierName[s]);
                    System.out.println("Flight No     " + flightNo[s]);
 
 
                }
            }
            strOutPut1=strOutPut1 + "<tr><td>Departure Date:</td><td><input type='text' readOnly name='deptDate' value=" +depDate+"></td></tr>";
            strOutPut=strOutPut+strOutPut1+"</table>";
            System.out.println("HTML STRING : " +strOutPut);
 
        }catch (SAXParseException err) {
            System.out.println ("** Parsing error" + ", line " + err.getLineNumber () + ", uri " + err.getSystemId ());
            System.out.println(" " + err.getMessage ());
 
            }catch (SAXException e) {
            Exception x = e.getException ();
            ((x == null) ? e : x).printStackTrace ();
 
            }catch (Throwable t) {
            t.printStackTrace ();
            }
 
 
        }
 
}
 
 
 
 
 
 
import org.w3c.dom.Element;
import org.w3c.dom.Node;
import org.w3c.dom.NodeList;
 
/**
 * @Jismon Raju K
 *
 */
public class getNodeValue {
 
    public static String getNodDetails(String tagName,Node myNode){
        String tagValue="";
        Element firstDatasourceElement = (Element)myNode; 
        NodeList departureDate = firstDatasourceElement.getElementsByTagName(tagName);
        Element departureDateValue = (Element)departureDate.item(0);
        NodeList deptValue = departureDateValue.getChildNodes();
        //System.out.println("Departure Date : " + ((Node)childNodes.item(0)).getNodeValue().trim());
        tagValue=((Node)deptValue.item(0)).getNodeValue();
        return tagValue;
    }
 
 
}

[dorinbogdan]

Ok,
I will copy this thread to Java forum too, they may answer quicker.