Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

xml conversion

 
Rajusa Raj
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I need a help on XML parsing. My requirement is 1. read an XML file and has to create a database(MYSQL) table, based on the XML structure. 2. Need to insert the parsed XML file data into that table. XML file size will be 1+ MB. 3. XML file structure will be changed thoroughly, So, Table should be created programmatically. No manual changes again. Could anyone help me on this.
The XML structure will be like this.

Thanks,
Raj
raj786_bangalore@yahoo.co.in
 
William Brogden
Author and all-around good cowpoke
Rancher
Posts: 13064
6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
How far have you gotten in this project? Do you know how to parse an XML document with DOM or SAX methods? If not you should find a tutorial and start simply. Worry about the database side after you are comfortable with parsing.

Harold's VERY complete book is available online for free.

Bill
I see that you have asked this question several times - WHY? Are you expecting somebody to hand you a complete solution?
[ June 07, 2008: Message edited by: William Brogden ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic