Question abt.reading xml file using java

gvi · #1 (**permalink**) 11-02-2007, 06:49 AM

Hi Everyone
I am not an advanced user and pardon me if this is not an advanced topic for you.

My requirement is this. I have a xml file from which I have to extract data part alone and write to a data file according to the database tables(relations) I have created

I have the following xml

Code:

<items>
<item id="film">
<category>entertainment </category>
<category>drama</category>
<category>music </category>
</item>
<item id="sitcom">
<category>entertainment </category>
<category>tv</category>
</item>

</items>

when I traverse through the elements
I am able to extract entertainment
entertainment

but not
entertainment
drama
music
entertainment
tv
I hope you understand my issue. Its just that I want all the categories (it would be great to eliminate duplicate values).

This is the code I wrote:

Code:

for (int i =0; i< items.length; i++)
{
  String catStr = getElementTextByTagNameNR(items[i], "Category");
  String catStr1 = getElementTextByTagNameNR(items[i], "Category");
  String catStr2 = getElementTextByTagNameNR(items[i], "Category");
  String catStr3 = getElementTextByTagNameNR(items[i], "Category");
  System.out.println(catStr + catStr1+ catStr2 + catStr3 + columnSeparator);

}

My question is how would I make sure it goes to the next Category and not read the first category. I would not be able to make the category name different.

This is the DTD for the xml document

<!Element item(Name,Category+)>

So I would like to get all categories an item belong to and not the first one alone

Thanks
G

murali_java · #2 (**permalink**) 11-02-2007, 08:44 AM

try the following code:

Code:

Document doc = db.parse (new File("c:\\exp\\item.xml"));
		NodeList nl =doc.getElementsByTagName("category");
		 
		System.out.println(" no of nodes for root =  "+ nl.getLength());
		for(int i =0 ;i<nl.getLength();i++){
			Node n = nl.item(i);			
			System.out.print(n.getNodeName());				
			NodeList nll=n.getChildNodes();
			for(int ii =0 ;ii<nll.getLength();ii++){
				Node nn = nll.item(ii);				
				System.out.println("==>"+nn.getNodeValue());				
			}
		}

others please optimise the code.

JavaBean · #3 (**permalink**) 11-02-2007, 09:33 AM

Hello friends,

I placed your codes inside [code] tag. Please use [code] tag for your codes in your further posts.

gvi · #4 (**permalink**) 11-02-2007, 10:48 PM

Thanks Murali for your time and code

That did work.

gvi · #5 (**permalink**) 11-03-2007, 12:50 AM

Murali I have another question

from the xml below I need the following output

Code:

<items>
<item id="film">
<category>entertainment </category>
<category>drama</category>
<category>music </category>
</item>
<item id="sitcom">
<category>entertainment </category>
<category>tv</category>
</item>

</items>

Code:

 static void GetItem(Document doc){
        Element root = doc.getDocumentElement();
        Element[] items = getElementsByTagNameNR(root,"Item");
        for(int i=0;i<items.length;i++){
                String itemIDStr = items[i].getAttribute("ItemID");
                NodeList nl = doc.getElementsByTagName("Category");
                   for (int j = 0; j < nl.getLength(); j++){
                                Node n = nl.item(j);
                                NodeList nll = n.getChildNodes();
                                   for(int k=0; k<nll.getLength(); k++){  
                                        Node nn = nll.item(k);
                                        streamItemCategory.println(itemIDStr + nn.getNodeValue() + columnSeparator);
                                }
    
                        }
        }

I know I have to check somewhere where when the itemId changes it no more should read the previous ones categories but not sure where to include the condition

As again your help needed

Thanks
G

JavaBean · #6 (**permalink**) 11-03-2007, 07:35 AM

gvi, when you use [code] tag, you start it with [ code ] (without spaces) and finish it with [ /code ] (without spaces) tag just like in html except that we are using square brackets around the tag here. I am fixing your post now.

made.putrama · #7 (**permalink**) 11-08-2007, 05:48 PM

Hi gvi,

try this code:

Code:

static void GetItem(Document doc){
        Element root = doc.getDocumentElement();
        NodeList items = root.getElementsByTagName("item");
        for(int i=0;i<items.getLength();i++){
        	Element item = (Element)items.item(i);
        	String id = item.getAttribute("id");
        	NodeList categs = item.getChildNodes();
        	for(int j=0;j<categs.getLength();j++){
        		Node categ = categs.item(j);
        		if( categ instanceof Element){
        			Element el = (Element)categ;
        			Text t = (Text)el.getFirstChild();
        			System.out.println(id+"|"+ t.getNodeValue() );
        		}
        	}
        }
}

Regards,
Putrama