retrieving data from the resultset into the jsp page

[ajos]

hi frnds,
im doing some db related operations in my web project,im using mysql 5.0,i have the following piece of code in my action class-

               for(resultset = statement.executeQuery(s2); resultset.next();)
            {
                s10 = resultset.getString(1);
                s11 = resultset.getString(2);
                s12 = resultset.getString(3);
            }
            resultset.close();

how do i retrieve the result of s10,s11,s12 in my jsp page?? wat changes do i have to do in my code??(i.e form bean and jsp page)??
wud appreciate ur thoughts...thanx in advance..
regards,
ajos

[r035198x]

hi frnds,
im doing some db related operations in my web project,im using mysql 5.0,i have the following piece of code in my action class-

               for(resultset = statement.executeQuery(s2); resultset.next();)
            {
                s10 = resultset.getString(1);
                s11 = resultset.getString(2);
                s12 = resultset.getString(3);
            }
            resultset.close();

how do i retrieve the result of s10,s11,s12 in my jsp page?? wat changes do i have to do in my code??(i.e form bean and jsp page)??
wud appreciate ur thoughts...thanx in advance..
regards,
ajos

You can write that same code in a JSP. Or extract the results in some other class and then send the results to the JSP as an attribute.

[ajos]

You can write that same code in a JSP. Or extract the results in some other class and then send the results to the JSP as an attribute.

hi r035198x,
thanx for ur reply yet again.....ive opted for the 2nd solution i.e using setAttribute
this is wat ive done-

s10 = resultset.getString(1);
                httpservletrequest.setAttribute("s10", s10);
                s11 = resultset.getString(2);
                httpservletrequest.setAttribute("s11", s11);
                s12 = resultset.getString(3);
                httpservletrequest.setAttribute("s12", s12);
 
 

is this the right way?
how do i call this in my jsp page--->which is like this

[HTML]<font face="Tahoma">"+ s11 +"</font>[/HTML]
[HTML]<font face="Tahoma">" +s12+ "</font>[/HTML]
regards,
ajos

[r035198x]

hi r035198x,
thanx for ur reply yet again.....ive opted for the 2nd solution i.e using setAttribute
this is wat ive done-

s10 = resultset.getString(1);
                httpservletrequest.setAttribute("s10", s10);
                s11 = resultset.getString(2);
                httpservletrequest.setAttribute("s11", s11);
                s12 = resultset.getString(3);
                httpservletrequest.setAttribute("s12", s12);
 
 

is this the right way?
how do i call this in my jsp page--->which is like this

[HTML]<font face="Tahoma">"+ s11 +"</font>[/HTML]
[HTML]<font face="Tahoma">" +s12+ "</font>[/HTML]
regards,
ajos

<%
String s10 = (String)request.getAttribute("s10");
%>

[ajos]

<%
String s10 = (String)request.getAttribute("s10");
%>

hi,
im getting the values of that particular columns as null....this is wat i did

<%String s11=(String)request.getAttribute("s11"); %>
<font face="Tahoma"> <%=s11 %> </font>

i think this is right...wats wrong with this????

[r035198x]

hi,
im getting the values of that particular columns as null....this is wat i did


i think this is right...wats wrong with this????

How did you call the JSP in the code?

[ajos]

How did you call the JSP in the code?

ok this is how i called in the jsp page-->

 
<%String s11=(String)request.getAttribute("s11"); %>
<font face="Tahoma"> <%=s11 %> </font>
 
 

where <%=s11%> is the values that will be displayed...
regards,
ajos

[r035198x]

ok this is how i called in the jsp page-->

 
<%String s11=(String)request.getAttribute("s11"); %>
<font face="Tahoma"> <%=s11 %> </font>
 
 

where <%=s11%> is the values that will be displayed...
regards,
ajos

No that's not what I'm asking. Are you calling the JSP from a servlet? You should be. Otherwise if you are not using servlets then you should use the other option I talked about earlier.

[ajos]

No that's not what I'm asking. Are you calling the JSP from a servlet? You should be. Otherwise if you are not using servlets then you should use the other option I talked about earlier.

my code,-->

for(resultset = statement.executeQuery(s2); resultset.next();)
            {
                s10 = resultset.getString(1);
                httpservletrequest.setAttribute("s10", s10);
                s11 = resultset.getString(2);
                httpservletrequest.setAttribute("s11", s11);
                s12 = resultset.getString(3);
                httpservletrequest.setAttribute("s12", s12);
            }
 

this is in the action class...
im calling getAttribute in my jsp page

[r035198x]

my code,-->

for(resultset = statement.executeQuery(s2); resultset.next();)
            {
                s10 = resultset.getString(1);
                httpservletrequest.setAttribute("s10", s10);
                s11 = resultset.getString(2);
                httpservletrequest.setAttribute("s11", s11);
                s12 = resultset.getString(3);
                httpservletrequest.setAttribute("s12", s12);
            }
 

this is in the action class...
im calling getAttribute in my jsp page

You should call the JSP from the code using

request.getRequestDispatcher("JSPPathAndName.jsp").include(request, response);

That way you pass the attributes to the JSP as well. You can't call this JSP by just double clicking it because then it wont have the attributes set.

[ajos]

That way you pass the attributes to the JSP as well. You can't call this JSP by just double clicking it because then it wont have the attributes set.

You should call the JSP from the code using

request.getRequestDispatcher("JSPPathAndName.jsp").include(request, response);

im already forwarding the control to the jsp page using

return(mapping.findForward("pathname"));

the method u mentioned above,wud had gone well if i use servlets...but

return(mapping.findForward("pathname"));

also does wat RequestDispatcher does..
i better check my database records coz in the form bean ive set the value as null eg-private xyz=null; and since that is printing i think its ok...correct me if im wrong...

regards,
ajos

[r035198x]

im already forwarding the control to the jsp page using

return(mapping.findForward("pathname"));

the method u mentioned above,wud had gone well if i use servlets...but

return(mapping.findForward("pathname"));

also does wat RequestDispatcher does..
i better check my database records coz in the form bean ive set the value as null eg-private xyz=null; and since that is printing i think its ok...correct me if im wrong...

regards,
ajos

Yep check with println statements to see that you are forwarding non null values in the first place.
P.S I'm going to have to move this to the Java forum as it doesn;t have much to do with MySQL

[ajos]

Yep check with println statements to see that you are forwarding non null values in the first place.
P.S I'm going to have to move this to the Java forum as it doesn;t have much to do with MySQL

hi r035198x,
i think its right.i checked the database,and to my disbelief the records entered in the table wasnt enough hence the queries requirement wasnt matching....
thanx for the help yet again.....(i think this will never stop!!!)
regards,
ajos

[r035198x]

hi r035198x,
i think its right.i checked the database,and to my disbelief the records entered in the table wasnt enough hence the queries requirement wasnt matching....
thanx for the help yet again.....(i think this will never stop!!!)
regards,
ajos

What will never stop?