This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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 Murach's Java Servlets and JSP this week in the Servlets 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: 18541

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

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
Similar Threads
B&S:Search requirements sanity check!
jsp record with multicolor
pagination in jsp
how to display next and previous records in jsp
Want to refresh Top jsp(Interesting Question)