Win a copy of Java 9 Revealed this week in the Features new in Java 9 forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

I need help  RSS feed

 
Lakshmi siri
Ranch Hand
Posts: 44
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
How we call stored procedures from jsp.
Thanks for help.
--Lakshmi
 
Bear Bibeault
Author and ninkuma
Marshal
Posts: 65898
135
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Yan Lee
Ranch Hand
Posts: 94
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 305
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
In specific, look up CallableStatement in the Java API.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!