wood burning stoves
The moose likes JDBC and Relational Databases and the fly likes XML  to database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "XML  to database" Watch "XML  to database" New topic

XML to database

Anna Anna

Joined: Nov 13, 2008
Posts: 4
Hi all
I need your help,I am having XML files that are coming from out side which will contain table data and I am parsing that XML file and able to extract that data using SAX parser.now I want to insert the data into the database maybe mysql or sqlserver.please can any body suggest me how to insert the data in to the data base.
Ben Souther

Joined: Dec 11, 2004
Posts: 13410

Please check your private messages regarding an important administrative matter.

Java API J2EE API Servlet Spec JSP Spec How to ask a question... Simple Servlet Examples jsonf
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1141

You requested:

can anybody suggest how to insert the data into the database

Using an SQL "insert" statement?
Or is this a trick question?

Good Luck,
Sagar Rohankar
Ranch Hand

Joined: Feb 19, 2008
Posts: 2904

Once you parsed the values, you can insert them into database, Now to do this DB operation through Java program, you need a complete information about JDBC connection , statements , result set. For that, I suggest you to look here !

This is what you want, else Please elaborate your query !

[LEARNING bLOG] | [Freelance Web Designer] | [and "Rohan" is part of my surname]
I agree. Here's the link: http://aspose.com/file-tools
subject: XML to database
It's not a secret anymore!