
i am a beginer in jsp so please help me out..... in file create project i am entering proj details such as id name cost and manager name and storing it in the data base. in search proj fiel if user enters any one of the feild such as id name cost and manager the full details of the project should be displayed.
SearchProjDAO import java.io.IOException; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.util.ArrayList; import java.util.PropertyResourceBundle; import javax.naming.InitialContext; import javax.naming.NoInitialContextException; import javax.sql.DataSource;
import oracle.sql.ARRAY; import weblogic.jdbc.pool.ResultSet;
import cruit.util.DBConnection;
import cruit.vo.SearchProjVO;
public final class SearchProjDAO { private static InitialContext context; String CLASS_NAME="DBConnectionFactory";
public void submitProjectDetails(SearchProjVO searchprojVO)
{
String methodname="createConnection";
Connection conn = null;
PreparedStatement psmt;
try {
System.out.println("searchprojVO id=="+searchprojVO.getProjid());
System.out.println("in DAO");
conn = DBConnection.getJNDIConnection();
ArrayList ar = new ArrayList();
ResultSet rs = null;
while(rs.next())
{
SearchProjVO searchprojVO = new SearchProjVO();
psmt= conn.prepareStatement("select * from CR_EMPLOYEE_DETAILS");
psmt.setString(1,searchprojVO.getProjid());
psmt.setString(2,searchprojVO.getProjname());
psmt.setString(3,searchprojVO.getCost());
psmt.setString(4,searchprojVO.getManager());
psmt.executeQuery();
ar.add(searchprojVO);
}
System.out.println("conn==="+conn);
} catch (Exception e) {
e.printStackTrace(System.err);
}
}
} SearchProjVO import java.io.IOException; import java.sql.Connection; import java.sql.DriverManager; import java.util.PropertyResourceBundle; import javax.naming.InitialContext; import javax.naming.NoInitialContextException; import javax.sql.DataSource;
public final class SearchProjVO {
String projid;
String projname;
String cost;
String manager;
public String getCost() {
return cost;
}
public void setCost(String cost) {
this.cost = cost;
}
public String getManager() {
return manager;
}
public void setManager(String manager) {
this.manager = manager;
}
public String getProjid() {
return projid;
}
public void setProjid(String projid) {
this.projid = projid;
}
public String getProjname() {
return projname;
}
public void setProjname(String projname) {
this.projname = projname;
}
}
in SearchProjDAO i have to call servlet also how can i do this i have connected to data base