File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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 Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "XML  to database" Watch "XML  to database" New topic
Author

XML to database

Anna Anna
Greenhorn

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
Sheriff

Joined: Dec 11, 2004
Posts: 13410

"AnnaVA",
Please check your private messages regarding an important administrative matter.
-Ben


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

Anna,
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,
Avi.
Sagar Rohankar
Ranch Hand

Joined: Feb 19, 2008
Posts: 2902
    
    1

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