This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma 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


JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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: 63208
    
  69

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.
 
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
 
subject: I need help
 
It's not a secret anymore!