How to read XML file ?

[sandeep balyan]

I have one XML file which have lot of data and one DB column file .
How can i open this XML file in readable format that is .... user can view data saved in XML file
DB column file have data like
name[profession[place
XML file have
anil[IT[delhi[sanjay[IT[LA
thanks

[Lasse Koskela]

How exactly do you want to display the XML and where?

[sandeep balyan]

First of all thanks for your reply ,

This is a file named as database column db.txt
ID]A.NAME]E.NAME]SEX]NATIONALITY.
Data file i.e in XML format is like data.xml
ID]A.NAME]E.NAME]SEX]NATIONALITY
1234] ]Anil kumar] M]USA]

I want to load this file to database .AS we want to see report of all data .
or read it in HTML format .
TIA

[Lasse Koskela]

Ok. First of all, I'd suggest you should try to search this forum with keywords "xml jdbc" or "xml database". That should give you more than enough of discussions about moving data between XML documents and a database.
Generally speaking, there are two approaches to read stuff from an XML file and insert it into the database. The first one is to use a mapping tool that does all the work for you. I can't name such a tool, however. The other is to write your own code for reading records from the XML file and inserting them into the database.
The second approach, in pseudo-code, would look something like:

public void xmlToDatabase(Document myDoc) {
    // find all <record>...</record> elements from the given XML document
    NodeList records = myDoc.getElementsByTagName("record");
    for (int i = 0; i < records.getLength(); i++) {
        Element recordElement = (Element) records.item(i);
        // this method converts the DOM element object into your
        // application's internal representation of a record
        Record record = convertToRecordObject(recordElement);
        // this method inserts the given record into the database
        insertToDatabase(record);
    }
}