reading results from javabean into JSP

[aliya sharma]

Hello,
I'm new to JSP. I have already posted a question in servlet forum but have figured out that problem and my servlet is working fine. I have a bean that store the query results and then send them to a controller servlet which in turns forwards the result to JSP to read and display it. My bean and servlet is working fine(i tested them both with some System.out statement). Below is a part of my servlet code(its passing part_no parameter to the bean:

BoxPart box = BoxPart.findByPart(part_no);
req.setAttribute("result", box);
RequestDispatcher dispatcher =
req.getRequestDispatcher("/result.jsp");
dispatcher.forward(req, resp);  

I'm accessing this through result.jsp by:

<jsp:useBean id="result" class="bean.BoxPart" scope="request">

Part_No: <%= result.getPart()%>
 
<BR>
Contents: <%=result.getContent()%>
</jsp:useBean>  

but when i try to access this page..it doesn't show me any result.just the static "hello" that i added. I'm realy confused now. COuld anyone please guide me in right direction or tell me whats wrong with my code. I would really appreciate your help.

[Adeel Ansari]

Originally posted by aliya sharma:

<jsp:useBean id="result" class="bean.BoxPart" scope="request">

Part_No: <%= result.getPart()%>
 
<BR>
Contents: <%=result.getContent()%>
</jsp:useBean>  

you should do something like,

<jsp:getProperty name="result" property="part"/>
<jsp:getProperty name="result" property="content"/>

try this. hope this will solve your problem.

[aliya sharma]

Hello Adeel,
I changed my code as you mentioned but i'm still only getting static parts of result.java. here's my JSP code.

<jsp:useBean id="result" class="bean.BoxPart" scope="request">

Part_No: <jsp:getProperty name="result" property="part"/>
 
<BR>
Contents: <jsp:getProperty name="result" property="content"/>
</jsp:useBean>  

heres my javabean

 private String part = "";
private String content = "";
public String getPart() {
return part;
}
public String getContent() {
return content;
}
public void setPart(String value) {
part = value;
}
public void setContent(String value) {
content = value;
}
public static final String findByPart =
"SELECT * FROM boxcontents where part_no = ? ";
public static BoxPart findByPart(String part) {
java.sql.Connection con = null;
BoxPart box = new BoxPart();
try {
 
con = DataSourceTest.getConnection();
System.out.println("it switched");
PreparedStatement ps = con.prepareStatement(findByPart);
ps.setString(1, part);
ResultSet rs = ps.executeQuery();
System.out.println("read to get result");
while (rs.next()) {
box.part = rs.getString("part_no");
box.content = rs.getString("content");
System.out.println("Part_no" + box.part);
System.out.println("Content" + box.content);
}
System.out.println("closing connection");
con.close();
} catch (Exception e) {
//System.out.println("this is the problem");
e.printStackTrace();
}
return box;
 
} 

Any other suggestions??.I would really appreciate your help with this.

[aliya sharma]

I finally got it working!!!. I changed the scope to session and got the desired results. Could anyone please tell me why it wasn't working when i had set the scope to "request". like this:

 <jsp:useBean id="result" class="bean.BoxPart" scope="request"> 

[aliya sharma]

any takers???..

[Sonny Gill]

Cant see any obvious reason for it from looking at your code.
Try to look at the generated Java file for the JSP, that might help you find the reason for it.