File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to pull data from database using JSP?

 
Swapna Gouri Kalanidhi
Ranch Hand
Posts: 107
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Ranchers
I have a program where I need to pull data from MySQL database and display it on JSP page. The data should be pulled upon a click of a button by the user. How can I do this? Is there any way I can handle this?

Can anyone help me please ??
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 64180
83
IntelliJ IDE Java jQuery Mac Mac OS X
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Write your data access code in Java classes. Call these classes from a page controller to get the data. Forward the data to the JSP and use JSTL and EL to display it.
 
Bosun Bello
Ranch Hand
Posts: 1510
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Have a servlet/controller talk to the backend and retrieve the data. Then the servlet will add the results from the backend as an attribute in the appropriate scope, and forward it to your JSP.

This is a very common task. You may want to search for MVC.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic