display all record in Jsp

[priyanaka jaiswal]

Hi All,


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


Thanks in advance

[Seetharaman Venkatasamy]

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]

hi,

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]

Just display them, then.

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

[RajeshKumar Nayak]

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
write
${stdid}

[Bear Bibeault]

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.