Member Avatar for hoshumaruh

Hi! Is it possible to retrieve XML data and input it to mysql database using JSP? If so, how will I do it? I'm new to java by the way. Thanks in advance to those who will reply!

Edited by hoshumaruh because: n/a
  • 2 Contributors
  • 1 Reply
  • 93 Views
  • 17 Hours Discussion Span
  • Latest Post Latest Post by peter_budo
Member Avatar for peter_budo

1.Read XML from user provided location
2.Use Apache POI library to help you extract data
3.Either temporary store it in some collection of a bean and then save it in one go or do it row by row as you retrieve you can save

PS: You will use JSP just for for to ask user for file location, rest of processing should be done on server side between servlet and controller

Edited by peter_budo because: n/a
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.