Member Avatar for shruwin

Hi,
I have to insert data into a database table using jsp and jdbc, query the table data and convert it into an xml file. I am using NetBeans IDE. I'm really stuck and i have a project due. Please do help:'(.
Thanks in advance.

  • 2 Contributors
  • 3 Replies
  • 260 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by Dean_Grobler
Member Avatar for Dean_Grobler

If you have no problems reading the information from the database and you get to save it in variables... Check out this tutorial on creating an XML file using the DOM classes...

Edited by Dean_Grobler because: n/a
Member Avatar for shruwin

If you have no problems reading the information from the database and you get to save it in variables... Check out this tutorial on creating an XML file using the DOM classes...

Thanks for your reply.:)
Al the data from the table must be retrieved using select statement and xml file must be created using this resultset. In the link u gave we are manually inserting text.

Member Avatar for Dean_Grobler

if you think about it, what is a resultset? It's basically a just a String, so break the resultset down into seperate parts and write it to the XML file. I doubt you'll be able to parse a Resultset to create a XML file. You need to parse Strings... So you are going to have to break that resultset into seperate Strings...

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.