• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

JSP --> Servlet --> JDBC

 
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
hello,
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.
 
Ranch Hand
Posts: 200
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,
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.
Cheers,
Steve
[ April 16, 2002: Message edited by: Steve Granton ]
 
Sheriff
Posts: 4313
Android IntelliJ IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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 ]
 
New rule: no elephants at the chess tournament. Tiny ads are still okay.
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic