my dog learned polymorphism*
The moose likes JDBC 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
Bookmark "I need help" Watch "I need help" New topic
Author

I need help

Lakshmi siri
Ranch Hand

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

Joined: Jan 10, 2002
Posts: 60782
    
  65

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] [Bear's FrontMan] [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.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: I need help
 
Similar Threads
octal, hex
Majji Exm1 :
return value
what is your dream?
Need Guidance