File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
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: 19973

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: 63865

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] [About Bear] [Books by Bear]
I agree. Here's the link:
subject: display all record in Jsp
It's not a secret anymore!