File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and the fly likes XML  to database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
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: 1121

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: 2902

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:
subject: XML to database
Similar Threads
Java program to Convert java.lang.String to java.sql.CLOB Object
Finding matching column name
How to insert data into xml ?
inserting data from XML to database
Match XML data value with the mysql database