This week's giveaway is in the Spring forum.
We're giving away four copies of REST with Spring (video course) and have Eugen Paraschiv on-line!
See this thread for details.
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

Win a copy of REST with Spring (video course) this week in the Spring forum!
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: 63540

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
It's not a secret anymore!