retrieving data from the resultset and displaying it int the servlet

[ajos]

hi frnds,
im new to this forum,and i have a problem...here is the situation----
i have a project which has servlets, wat the servlet does is connect to a database and display the result using the resultset inside the same servlet using the htmlstart and htmlend methods.wat i have to do is to seperate the html from the servlet and create a jsp....my problem is how to start doing it? how to display the result into a jsp page??wat all am i supposed to use...im using tomcat 5.5.23 and eclipse 3.2. can aybody guide me regarding....any help regarding this will be appreciated

[madhoriya22]

hi frnds,
im new to this forum,and i have a problem...here is the situation----
i have a project which has servlets, wat the servlet does is connect to a database and display the result using the resultset inside the same servlet using the htmlstart and htmlend methods.wat i have to do is to seperate the html from the servlet and create a jsp....my problem is how to start doing it? how to display the result into a jsp page??wat all am i supposed to use...im using tomcat 5.5.23 and eclipse 3.2. can aybody guide me regarding....any help regarding this will be appreciated

Hi,
U can store ur result set data in any collection(e.g. Vector, Hastable. whichever suited to u or ur application). Then use HttpServletRequest's getParameter() and setParameter() methods to pass this collection to ur jsp....... and display there as u want.

[r035198x]

Hi,
U can store ur result set data in any collection(e.g. Vector, Hastable. whichever suited to u or ur application). Then use HttpServletRequest's getParameter() and setParameter() methods to pass this collection to ur jsp....... and display there as u want.

Topass the data from the servlet to the JSP, you use setAttribute in the servlet and get it using getAttribute in the JSP.
You can't use setParameter in a servlet.

[madhoriya22]

Topass the data from the servlet to the JSP, you use setAttribute in the servlet and get it using getAttribute in the JSP.
You can't use setParameter in a servlet.

Hi,
U r definitely correct.... Sorry I was in hurry... didn't check it... :)

@OP sorry I provide u wrong information(never intended).

[dmjpro]

hi frnds,
im new to this forum,and i have a problem...here is the situation----
i have a project which has servlets, wat the servlet does is connect to a database and display the result using the resultset inside the same servlet using the htmlstart and htmlend methods.wat i have to do is to seperate the html from the servlet and create a jsp....my problem is how to start doing it? how to display the result into a jsp page??wat all am i supposed to use...im using tomcat 5.5.23 and eclipse 3.2. can aybody guide me regarding....any help regarding this will be appreciated

Welcome to TSDN.
Actually here nobody is here to guide you from the first means with the Code.
Anyway!

Make a Connection and all the Database Related Operations then store the Results to request.setAttribute() then forward a Jsp page.
There you will extract the results and simply print those.
Now you try to write some code then come here with specific problem with your code.
Best of luck with your try.

Kind regards,
Dmjpro.

[ajos]

Welcome to TSDN.
Actually here nobody is here to guide you from the first means with the Code.
Anyway!

Make a Connection and all the Database Related Operations then store the Results to request.setAttribute() then forward a Jsp page.
There you will extract the results and simply print those.
Now you try to write some code then come here with specific problem with your code.
Best of luck with your try.

Kind regards,
Dmjpro.

thank u everbdy for their valuable inputs...i'll get bak to u guys when im stuck....thanx again