Displaying db retrieved values in JSP

[jith87]

Hi,

I ve retrieved values from MySql db. From the result set i ve used the getXXX() to get the values in seperate variables. Earlier i used getParameter() to get the values from JSP page to be stored in db.

Now i need to display the retrieved data in their corresponding controls such as textbox etc.. back in the JSP page....Can u help me out????


Thanx in advance........

[madhoriya22]

Hi,

I ve retrieved values from MySql db. From the result set i ve used the getXXX() to get the values in seperate variables. Earlier i used getParameter() to get the values from JSP page to be stored in db.

Now i need to display the retrieved data in their corresponding controls such as textbox etc.. back in the JSP page....Can u help me out????


Thanx in advance........

Hi,
You can use any Collection( such as Vector or ArrayList) to store the values retreived from database. Then use

 
request.setAttribute(String attributeName, Object object)

to forward those values to to ur jsp page.

[jith87]

Hi,
You can use any Collection( such as Vector or ArrayList) to store the values retreived from database. Then use

 
request.setAttribute(String attributeName, Object object)

to forward those values to to ur jsp page.

I ve stored the values in seperate variables. How to re direct them to the JSP page.??? Also what do u mean by Object here???

[dmjpro]

Hi,

I ve retrieved values from MySql db. From the result set i ve used the getXXX() to get the values in seperate variables. Earlier i used getParameter() to get the values from JSP page to be stored in db.

Now i need to display the retrieved data in their corresponding controls such as textbox etc.. back in the JSP page....Can u help me out????


Thanx in advance........

You know the "Scriptlet" part of Jsp.

Simply use this .

<%
var1 = rs.getXXX(Y);
%>
<input type = "text" value = "<%=var1%>" name = "some_name" .... >

Got me :-)

Debasis Jana

[madhoriya22]

I ve stored the values in seperate variables. How to re direct them to the JSP page.??? Also what do u mean by Object here???

Hi,
Object here could be ur collection object, it could be string .. etc. U should store those(which u hav stored in separate variables) values in Collection. Then it will be easy for you to pass those values to jsp. Have tried something ?