Hello room,
I am having one bean DataAccessBean.From the
main.jsp I called the Search_servlet .There I am getting the search parameter
and created an instance of DataAccessBean connected to the database and populate
some info on bean variable.
After calling the servlet from main.jsp I called
search.jsp to display the bean property.But its not displaying.can anybody help
me.
Daison
main.jsp
html
headbody text="#00"
bgcolor="#FF" link="#EE" vlink="#551A8B"
alink="#FF"
CENTER
FORM method=get
pfont color="#FF0080"font
size=+3
Vendor Lookup :/font/fontfont
color="#FF0080"font
size=+3/font/fontnbsp;input type =text name
=searchpBR/CENTERCENTERTABLETR
TDINPUT TYPE=SUBMIT name =Add value
=Add/TDTDINPUT TYPE=SUBMIT name =submit value
=submit/TDTDINPUT TYPE=SUBMIT name =Delete value
=Delete/TD
/TR/TABLE
%if(request.getParameter("search")!=null){%
h1results/h1
SERVLET NAME = "Search_servlet1" code =
"Search_servlet" /SERVLET
h1results1/h1
%}else{%
hr ALIGN=CENTER SIZE=1
WIDTH="750"pCENTERimg SRC="customer.jpg"
height=254 width=432p/CENTER
%}%
/FORM/body/html
search.jsp
h1in search.jsp /h1bean
name="searchBean" type="DataAccesBean" introspect="yes" create = "yes" scope =
"session" /beanPBCENTERSearch
Results/B/CENTERH1H1
INSERT BEAN ="searchBean" PROPERTY
="VendorName"/INSERT
Here its not diaplaying
the VendorName Please Help me.
/h1/h1
Search_servlet.java
import java.io.*;
import javax.servlet.*;import
javax.servlet.http.*;import java.sql.*;import java.util.*; import
test1.*;
public class Search_servlet1 extends
HttpServlet{ public void
init(ServletConfig
config)
throws ServletException{
super.init(config);
}
public void doGet
(HttpServletRequestrequest,HttpServletResponseresponse
) throws ServletException, IOException
{PrintWriterout;Stringtitle =
"Database connectivity test on
NOVA"; int
Vendorid=0;
response.setContentType("text/html");
// then write the data of the
responseout = response.getWriter();
DataAccessBean data = new
DataAccessBean();
Vendorid =
Integer.parseInt(request.getParameter("search"));data.getDBConnection(Vendorid);
data.populateVendor();
response.sendRedirect("/IBMWebAS/samples/vendor_search/search.jsp");
out.close(); }}//
DataAccessBaen.java
import java.io.*;
import javax.servlet.*;import
javax.servlet.http.*;import java.sql.*;import java.util.*;
/*** This is a simple example of an
HTTP Servlet. It responds to the GET* and HEAD methods of the
HTTP protocol.*/public class DataAccessBean implements
Serializable{ /** *
Handle the GET and HEAD methods by building a simple web
page. * HEAD is just like GET, except that the
server returns only the * headers (including content
length) not the body we write. */
Statement stmt;ResultSet rs=null;int
VendorId=0;String VendorName="";
public void dbConnect(){
System.out.println("HI");}
public String getColumn(String
columnName){String
tempColumn="";try{tempColumn =
rs.getString(columnName);}catch(SQLException e){
System.out.println("Unable to retrieve the column -" + e);}
return tempColumn;
}
public void
moveCursor(){try{rs.next();}catch(SQLException
e){ System.out.println("Unable to move to next row -" +
e);}
}
public void
populateVendor(){try{
setVendorId(getColumn("vendor_id"));
setVendorName(getColumn("vendor_name")); }catch(Exception
e){ System.out.println("Unable to Populate info -" +
e);} }
public void setVendorId(String
Id){VendorId =Integer.parseInt(Id);}
public void setVendorName(String
Name){VendorName =Name;}
public int getVendorId(){return
VendorId;}\
public String getVendorName(){return
VendorName;}
}//