Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Getting SQL Data in JSP or Servlet  RSS feed

 
Gregg Bolinger
Ranch Hand
Posts: 15304
6
Chrome IntelliJ IDE Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have been using JSTL's sql calls to build a datasource and retrieve information from a database and then iterate through what I need with c:forEach.
My question is 2 fold.
1. Is there a rule of thumb as far as accessing a database through JSTL or from a Servlet the best approach. (keeping in mind I do nothing but display the data, no computations, etc)
2. Is there a Tag way to use a ConnectionPool inside of a JSP page without using scriplets? I am using Resin and I think they may have a tag I can use but can't find the documentation anywhere if there is. (This of course will primarily depend on the answer to the first question.
Thanks.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!