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

JSP --> Servlet --> JDBC

Don Clarke

Joined: Jul 25, 2000
Posts: 7
i'm having a problem figuring out how to tie together an JSP page that calls a servlet, with a JDBC java class i have. the jdbc class makes a connection with the database. separatly, i have a working JSP page that calls a servlet. i'm trying to tie together the variables i'd enter into my jsp page with the stored procedure call in my JDBC class that connects to the database.
please help, i'm stumped.
Steve Granton
Ranch Hand

Joined: Jan 13, 2002
Posts: 200
How are you calling the servlet from the JSP? Are you using the request dispatcher, sending a redirect or doing something in a jsp scriptlet? Or is your user submitting a page to the servlet that was produced by the jsp?
If you could give a general description of your architecture, how things work and what classes you have that would be good.
Generally, if the user submits a form then the servlet would process the request (retrieving any parameters it needs), possibly with helper classes. The parameters can then be used raw or encapsulated in value objects. Any calls to the database could be made from the servlet or helper/DAO classes.
[ April 16, 2002: Message edited by: Steve Granton ]
Jessica Sant

Joined: Oct 17, 2001
Posts: 4313

Also, try to use JDBC 2 Datasources -- that way you'll take advantage of any Connection Pooling your Application Server Provides.
Check out Chapter 7, "Connecting to Resources" in the HP-AS Developer's Guide:
[ April 16, 2002: Message edited by: Jessica Sant ]

- Jess
Blog:KnitClimbJava | Twitter: jsant | Ravelry: wingedsheep
I agree. Here's the link:
subject: JSP --> Servlet --> JDBC
It's not a secret anymore!