permaculture playing cards
The moose likes JSP and the fly likes display all record  in Jsp Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
JavaRanch » Java Forums » Java » JSP
Bookmark "display all record  in Jsp" Watch "display all record  in Jsp" New topic

display all record in Jsp

priyanaka jaiswal
Ranch Hand

Joined: Jun 03, 2011
Posts: 79
Hi All,

How to retrieve all record from Database and display in one Jsp page?

Thanks in advance
Seetharaman Venkatasamy
Ranch Hand

Joined: Jan 28, 2008
Posts: 5575

your question is not clear to me. what do you mean all values from database?
I assume you want to display all rows from a table(or join tables) in a jsp? if data is huge then implement paging.

*also i assumed you know how to display a value from database table.
priyanaka jaiswal
Ranch Hand

Joined: Jun 03, 2011
Posts: 79

i want to display all 100 row of database in one jsp page.i dont want to use pagination.then how to do it?
Paul Clapham

Joined: Oct 14, 2005
Posts: 19757

Just display them, then.

Are you having some particular problem with this task? What have you tried so far?
RajeshKumar Nayak

Joined: Jul 02, 2012
Posts: 6
First Retrieve All record From Database then
create session object
and just set value like
session. setAttribute("stdId",stdid);
after create a Jsp page then
Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 63352

Scoped variables should not be put into the session unless there's a good reason for it. Placing the scoped variables into request scope is usually most appropriate.

[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
I agree. Here's the link:
subject: display all record in Jsp
It's not a secret anymore!