Values from bean to a servlet

[aliya sharma]

Hello I'm new to J2EE. I have a table called boxcontents that has 2 fields(part_no, content). I'm trying to search by part_no using MVC. I have 1 html page where user enters the part_no. Servlet then reads this part_no and forwrds it to java bean which performs a lookup based on the part_no. Servlet then reads the result and forwards it to a jsp that displays it. My problem is: i'm able to send the Parameter via servlet to java bean by:

 String part_no = req.getParameter("part_no");
 BoxContent.findByPart(part_no);
//i want to read the result here. but don't know how to do it

this is my javabean

public static final String findByPart = "SELECT * FROM boxcontents where part_no = ? ";
public static BoxContent findByPart(String part){
java.sql.Connection con = null;
BoxContent box = new BoxContent();
try{

con = DataSourceTest.getConnection();
PreparedStatement ps = con.prepareStatement(findByPart);
ps.setString(1,part);
ResultSet rs = ps.executeQuery();
while (rs.next()){
box.part = rs.getString("part_no");
box.content = rs.getString("content");

}
con.close();
} catch (Exception e) {
//System.out.println("this is the problem");
e.printStackTrace();
}
return box;

}  

How do i read this result into a servlet and forward it to a JSP?. I would really appreciate it if anyone can point me to a right direction. THanks a lot.

[aliya sharma]

this is my whole code:
servlet code:

String part_no = req.getParameter("part_no");
String message = "";
if (part_no == null || part_no.equals("")) {
message = "Please enter a part_no";
}
BoxContent box = new BoxContent();
BoxContent.findByPart(part_no);
req.setAttribute("result", box);
RequestDispatcher dispatcher =
req.getRequestDispatcher("/BoxContent/result.jsp");
dispatcher.forward(req, resp);
 
}  

bean code (class called BoxContent.java):

 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 BoxContent findByPart(String part){
java.sql.Connection con = null;
BoxContent box = new BoxContent();
try{

con = DataSourceTest.getConnection();
PreparedStatement ps = con.prepareStatement(findByPart);
ps.setString(1,part);
ResultSet rs = ps.executeQuery();
while (rs.next()){
box.part = rs.getString("part_no");
box.content = rs.getString("content");
}
con.close();
} catch (Exception e) {
//System.out.println("this is the problem");
e.printStackTrace();
}
return box;

} 

JSP code:

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

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

COuld someone please tell me what im doing wrong or point me to the right direction. THanks

[Adeel Ansari]

any exception or error you are gettin??

[Rahul kapoor]

Apparently your problem lies in the following code.

You have initialised BoxContent but not storing the results of findByPart(..) in box.

use box = BoxContent.findByPart(part_no);

and check.

BoxContent box = new BoxContent();BoxContent.findByPart(part_no);req.setAttribute("result", box);

[aliya sharma]

Hello,
i changed my controller code as:

String part_no = req.getParameter("part_no");
String message = "";
if (part_no == null || part_no.equals("")) {
message = "Please enter a part_no";
}
BoxContent box = BoxContent.findByPart(part_no);
req.setAttribute("result", box);
RequestDispatcher dispatcher =
req.getRequestDispatcher("/WEB-INF/BoxContent/result.jsp");
dispatcher.forward(req, resp);  

Its still not working. WHen i enter a value in my html page and hit submit. It gives me a

 [Servlet Error]-[Controller]: java.lang.ClassNotFoundException: Controller 

Any ideas or leads...As, this is my first MVC project, i would appreciate any help. THanks

[Senthil B Kumar]

Has your Controller Servlet been registered in you Server through a web descriptor (web.xml). I guess its not been registred.