File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes I need help Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "I need help" Watch "I need help" New topic

I need help

Lakshmi siri
Ranch Hand

Joined: Feb 06, 2004
Posts: 44
How we call stored procedures from jsp.
Thanks for help.
Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 63865

Bad idea (DB access direcltly from a JSP), in my opinion. In any case, no differently than any other Java program, so moving this to the JDBC forum.

[Asking smart questions] [About Bear] [Books by Bear]
Yan Lee
Ranch Hand

Joined: Sep 15, 2003
Posts: 94
Hi Lakshmi:
Clean seperation of business rules, presentation and data access is essential for good design of a web app (n-tier design).

You can use MVC based frameworks like Struts for this. You can use the DAO pattern to implement data access for your application.

Depending on how you are implementing your business rules (EJB or Java Beans), you can invoke your DAO's from there.

Look for the DAO pattern on Sun's website.

Hope this helps.
Jeffrey Hunter
Ranch Hand

Joined: Apr 16, 2004
Posts: 305
In specific, look up CallableStatement in the Java API.
I agree. Here's the link:
subject: I need help
jQuery in Action, 3rd edition