Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

importing data from excel to Mysql database using jsp code

 
shyamkumar bopannachengalaiah
Ranch Hand
Posts: 100
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i need to import data from excel to mysql database using jsp. How can i achieve this? Kindly help me.if there is any sample code kindly give me.
 
Brijesh Sah
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You can use java's poi jar functionality. It will work for you i guess.
 
Bauke Scholtz
Ranch Hand
Posts: 2458
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
To be more precise: Apache POI HSSF/XSSF. It isn't part of Sun Java or so as you seem to think.

You can use Apache POI to read Excel files and convert them to useable Java objects.

That said, you shouldn't be doing this in a JSP. Writing raw Java code in a JSP file instead of Java classes is receipt for trouble. JSP is a presentation technology, use it where it is for. Use taglibs and EL only, no scriptlets.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic