This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
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 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: 1138

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’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link:
subject: XML to database
jQuery in Action, 3rd edition