Cannot find bean: "employeeObj" in scope: "request"

[vikas dembla]

Can someone help?

ERROR:

javax.servlet.jsp.JspException: Cannot find bean: "employeeObj" in scope: "request"
at org.apache.struts.taglib.TagUtils.lookup(TagUtils.java:866)
at org.apache.struts.taglib.bean.DefineTag.doEndTag(DefineTag.java:219)
at org.apache.jsp.jsp.Success_jsp._jspService(Success_jsp.java:93)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:770)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:369)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:322)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:249)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:770)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:638)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:444)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:382)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:310)
at org.apache.struts.chain.commands.servlet.PerformForward.handleAsForward(PerformForward.java:113)
at org.apache.struts.chain.commands.servlet.PerformForward.perform(PerformForward.java:96)
at org.apache.struts.chain.commands.AbstractPerformForward.execute(AbstractPerformForward.java:54)
at org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
at org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304)
at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
at org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:770)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)
at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Unknown Source)


Here are the config and action files i amusing:

[u]EmployeeAction.java[/u]

package com.subaru.hr.actions;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import com.subaru.hr.beans.EmployeeDetailsObj;
import com.subaru.hr.daoimpl.EmployeeDaoImpl;

public class EmployeeAction extends Action {

	String message;
	EmployeeDaoImpl employeeDAO;

	public String getMessage() {
		return message;
	}

	public void setMessage(String message) {
		this.message = message;
	}

	public EmployeeDaoImpl getEmployeeDAO() {
		return employeeDAO;
	}

	public void setEmployeeDAO(EmployeeDaoImpl employeeDAO) {
		this.employeeDAO = employeeDAO;
	}

	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		ActionErrors errors = new ActionErrors();
		ActionForward forward = new ActionForward();
		
		String searchBy = request.getParameter("searchBy");	
		String searchId = request.getParameter("searchId");	
		EmployeeDetailsObj employeeObj = null;
		try{
		employeeObj = employeeDAO.search(searchBy, searchId);
		}catch(Exception e)
		{
			e.printStackTrace();
		}
		System.out.println(employeeObj);
		request.setAttribute("employeeObj", employeeObj);
		return mapping.findForward("success");
	}


}

EmployeeDaoImpl

public EmployeeDetailsObj search(String searchBy, String searchId)throws Exception {

		System.out.println("searchBy " + searchBy + " searchId " + searchId);
		//String qry = "select * from Employee";
		String qry = "select * from Employee as e join empcostcode as ecc on e.Badge_no=ecc.Badge_No join costcode as cc on ecc.costcode_id=cc.id join department as d on cc.department_id = d.id join section as sec on cc.section_id=sec.id join costcenter as cocent on cc.costcenter_id=cocent.id";
		if (searchBy != null) {
			if (searchBy.equals("SSN"))
				qry = qry + " where e.SSN=?";
			else if (searchBy.equals("badgeNo"))
				qry = qry + " where e.BADGE_NO=?";
		}
		System.out.println("qry " + qry);
		EmployeeDetailsObj employeeObj = jdbcTemplate.queryForObject(qry,
				new Object[] { searchId }, new RowMapper<EmployeeDetailsObj>() {
					public EmployeeDetailsObj mapRow(ResultSet rs, int rowNum)
							throws SQLException {
						EmployeeDetailsObj employeeObj = new EmployeeDetailsObj();
						employeeObj.setBadgeNo(rs.getInt("badge_no"));
						employeeObj.setFirstName(rs.getString("first_name"));
						employeeObj.setLastName(rs.getString("last_name"));
						employeeObj.setHireDate(rs.getString("hire_Date"));
						employeeObj.setTermDate(rs.getString("term_Date"));
						employeeObj.setSSN(rs.getInt("ssn"));
						employeeObj.setEmail(rs.getString("email"));
						employeeObj.setPhoneNo(rs.getString("phone_no"));
						//employeeObj.setDepartment(rs.getString("Department"));

						/*
						 * employeeObj.setAddr1(rs.getString("addr1"));
						 * employeeObj.setAddr2(rs.getString("addr2"));
						 * employeeObj.setAptmtno(rs.getString("aptmtno"));
						 * employeeObj.setCity(rs.getString("city"));
						 * employeeObj.setCounty(rs.getString("county"));
						 * employeeObj.setState(rs.getString("state"));
						 * employeeObj.setZip(rs.getInt("zip"));
						 * employeeObj.setCountry(rs.getString("country"));
						 */

						
						
						
						
						
						return employeeObj;
					}
				});
		return employeeObj;

	}

Struts-config

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE struts-config PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 1.2//EN"
                               "http://struts.apache.org/dtds/struts-config_1_2.dtd">
<struts-config>
	<data-sources />
	<form-beans />
	<global-exceptions />
	<global-forwards />


	<action-mappings>
		<action path="/employeeSearch1" type="org.apache.struts.actions.ForwardAction"
			parameter="/jsp/EmployeeSearch1.jsp" />
		<action path="/getMessage"
			type="org.springframework.web.struts.DelegatingActionProxy" scope="request"
			validate="false">
			<forward name="failure" path="/jsp/error.jsp"></forward>
			<forward name="success" path="/jsp/Success.jsp"></forward>
		</action>
		<action path="/getHintsData"
			type="org.springframework.web.struts.DelegatingActionProxy" scope="request"
			validate="false">
			<forward name="failure" path="/jsp/error.jsp"></forward>
			<forward name="success" path="/jsp/getHintsData.jsp"></forward>
		</action>

	</action-mappings>

	<message-resources parameter="com.Subaru.HR.Properties.ApplicationResources" />

	<plug-in className="org.springframework.web.struts.ContextLoaderPlugIn">
		<set-property property="contextConfigLocation" value="WEB-INF/springContext1.xml" />
	</plug-in>

</struts-config>

springcontext1.xml

<?xml version="1.0" encoding="UTF-8"?>


<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd http://www.springframework.org/schema/jee
        http://www.springframework.org/schema/jee/spring-jee-3.0.xsd">


	<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
		<property name="jndiName" value="java:jdbc/HRSQLDB" />
		<property name="lookupOnStartup" value="false" />
		<property name="cache" value="true" />
		<property name="proxyInterface" value="javax.sql.DataSource" />
	</bean>

	<bean name="/getMessage" class="com.subaru.hr.actions.EmployeeAction">
		<property name="message" value="hello" />
		<property name="employeeDAO" ref="EmployeeDatabaseBean" />

	</bean>
	<bean name="/getHintsData" class="com.subaru.hr.actions.AutoPromptAction">
		<property name="employeeDAO" ref="EmployeeDatabaseBean" />

	</bean>


	<bean id="EmployeeDatabaseBean" class="com.subaru.hr.daoimpl.EmployeeDaoImpl">
		<property name="dataSource" ref="dataSource" />
	</bean>
	
	



</beans>

Employeesearch1.jsp

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
	pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<%@ taglib uri="/WEB-INF/taglib/struts-html.tld" prefix="html"%>
<%@ taglib uri="/WEB-INF/taglib/struts-bean.tld" prefix="bean"%>
<%@ taglib uri="/WEB-INF/taglib/struts-logic.tld" prefix="logic"%>
<html>
<HEAD>
<link rel="stylesheet" type="text/css" href="/Emp/cssdev/report.css">
<link href="../css/bootstrap.min.css" rel="stylesheet">
<link rel="stylesheet" type="text/css" href="/Emp/css/jquery.autocomplete.css" />
<script language="javascript" src="/Emp/js/jquery-1.6.1.min.js"></script>
<script src="/Emp/js/jquery.autocomplete.js"></script> 

<META http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<META name="GENERATOR" content="IBM WebSphere Studio">
<META http-equiv="Content-Style-Type" content="text/css">

<TITLE></TITLE>
<script type="text/javascript"><!--
$(document).ready(function(){
    $("#displayDetails").click(function(){	
        alert($("#searchId").val());
        alert($('input:radio[name=searchBy]:checked').val());
    	 $.ajax({
		 	 url: "/Emp/getMessage.do?searchId="+$("#searchId").val()+"&searchBy="+$('input:radio[name=searchBy]:checked').val(), 
		 	 cache: false, 
		 	 dataType: "html", 
		 	 success: function(data, textStatus, XMLHttpRequest){ $("#employeeDetails").html(data); }
			 });
    });
    
    $("#searchId").autocomplete("/Emp/getData.do?searchId="+$("#searchId").val());
});
        
</script>


</HEAD>
<BODY>
<!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->
<script src="https://code.jquery.com/jquery.js"></script>
<!-- Include all compiled plugins (below), or include individual files as needed -->
<script src="../js/bootstrap.min.js"></script>
 
<div id="info">
<h2 align="center">Employee Information</h2>

<form class="navbar-form navbar-center" role="search">
	<div class="form-group">
		<div class="btn-group" data-toggle="buttons">
			  <label class="btn btn-primary">
			    <input type="radio" name="searchBy" id="searchBy" value="badgeNo" />BADGE NO.
			  </label>
			  <label class="btn btn-primary">
			    <input type="radio"  name="searchBy" id="searchBy" value="SSN" />   SSN
			  </label>
 			  <label class="btn btn-primary">
			    <input type="radio"  name="searchBy" id="searchBy" value="Name" />   Name
			  </label>

  		</div>

		<input type="text" class="form-control" placeholder="BadgeNo./SSN"	name="searchId" id="searchId" />
		<button type="button" class="btn btn-default" id="displayDetails"	name="displayDetails">Search</button>
	</div>
</form>
</div>
<div id="employeeDetails"></div>

</BODY>
</html>

[vikas dembla]

Please help!

[Joe Ess]

vikas dembla wrote:Please help!

PatienceIsAVirtue: We are all volunteers answering questions in our spare time.
Are you aware that Struts 1 is past end of life and will not be updated? Do not use it unless absolutely necessary.
I don't see employeeObj referenced in your JSP. Does the problem occur when you load Employeesearch1.jsp or when you click the search button on that page?

[vikas dembla]

I see error when I click on search button.

[Joe Ess]

If I read your code correctly, there's another JSP page involved here. The search button triggers a call to /Emp/getMessage.do which, if successful, returns /jsp/Success.jsp. Why didn't you show this JSP?
Are you trying to adapt some working code to do a new task?

[vikas dembla]

Success.jsp is just populating the fields, if search is successful



Success.jsp

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<%@ taglib uri="/WEB-INF/taglib/struts-html.tld" prefix="html"%>
<%@ taglib uri="/WEB-INF/taglib/struts-bean.tld" prefix="bean"%>

<%@ taglib uri="/WEB-INF/taglib/struts-logic.tld" prefix="logic"%>

<html>
<HEAD>
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
	pageEncoding="ISO-8859-1"%>
<script language="javascript" src="/Emp/js/jquery-1.6.1.min.js"></script>

<bean:define id="employeeObj" name="employeeObj"	type="com.subaru.hr.beans.EmployeeDetailsObj" scope="request" />

<TITLE></TITLE>

<link rel="stylesheet" type="text/css" href="/Emp/cssdev/report.css">
</HEAD>
<BODY>
<!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->
<script src="https://code.jquery.com/jquery.js"></script>
<!-- Include all compiled plugins (below), or include individual files as needed -->
<script src="../js/bootstrap.min.js"></script>

<br>
<center>
<div class="panel-group" id="accordion">
<div class="panel panel-default">

<div class="panel-heading">
<h4 class="panel-title"><a data-toggle="collapse"
	data-parent="#accordion" href="#collapseOne"> <i><b>Personal
Information</b> </i></a></h4>
</div>
<div id="collapseOne" class="panel-collapse collapse in">
<div class="panel-body">
<table width="70%" align="center" border="0">
	<tr>
		<td><b>Badge No</b></td>
		<td align="left"><bean:write name="employeeObj"
			property="badgeNo" /></td>
	</tr>
	<tr class="alternateColumnClass">
		<td><b>First Name</b></td>
		<td align="left"><bean:write name="employeeObj"
			property="firstName" /></td>
	</tr>
	<tr>
		<td><b>Last Name</b></td>
		<td align="left"><bean:write name="employeeObj"
			property="lastName" /></td>
	</tr>

	<tr class="alternateColumnClass">
		<td><b>SSN</b></td>
		<td align="left"><b><bean:write name="employeeObj"
			property="SSN" /></b></td>
	</tr>

	<tr>
		<td><b>Hire date</b></td>
		<td align="left"><bean:write name="employeeObj"
			property="hireDate" /></td>
	</tr>

	<tr class="alternateColumnClass">
		<td><b>Term Date</b></td>
		<td align="left"><b><bean:write name="employeeObj"
			property="termDate" /></b></td>
	</tr>


	<tr>
		<td><b>Email_ID</b></td>
		<td align="left"><bean:write name="employeeObj" property="email" /></td>
	</tr>

	<tr class="alternateColumnClass">
		<td><b>Phone No.</b></td>
		<td align="left"><b><bean:write name="employeeObj"
			property="phoneNo" /></b></td>
	</tr>



	<tr>
		<td colspan="2"> </td>
	</tr>
</table>
</DIV>
</div>
</DIV>

<div class="panel panel-default">
<div class="panel-heading">
<h4 class="panel-title"><a data-toggle="collapse"
	data-parent="#accordion" href="#collapseTwo"><i> <B>Address
Information</B></i> </a></h4>
</div>
<div id="collapseTwo" class="panel-collapse collapse">
<div class="panel-body">
<table width="50%" align="center" border="0">
	<tr>
		<td><b>Address 1</b></td>
		<td align="left"><bean:write name="employeeObj" property="addr1" /></td>
	</tr>
	<tr class="alternateColumnClass">
		<td><b>Address 2</b></td>
		<td align="left"><bean:write name="employeeObj" property="addr2" /></td>
	</tr>


	<tr>
		<td><b>Apartment No.</b></td>
		<td align="left"><bean:write name="employeeObj"
			property="aptmtno" /></td>
	</tr>

	<tr class="alternateColumnClass">
		<td><b>City</b></td>
		<td align="left"><bean:write name="employeeObj" property="city" /></td>
	</tr>


	<tr>
		<td><b>County</b></td>
		<td align="left"><bean:write name="employeeObj" property="county" /></td>
	</tr>

	<tr class="alternateColumnClass">
		<td><b>State</b></td>
		<td align="left"><bean:write name="employeeObj" property="state" /></td>
	</tr>
	<tr>
		<td><b>Zip Code</b></td>
		<td align="left"><bean:write name="employeeObj" property="zip" /></td>
	</tr>

	<tr class="alternateColumnClass">
		<td><b>Country</b></td>
		<td align="left"><bean:write name="employeeObj"
			property="country" /></td>
	</tr>
</table>

</div>
</div>
</div>




<div class="panel panel-default">
<div class="panel-heading">
<h4 class="panel-title"><a data-toggle="collapse"
	data-parent="#accordion" href="#collapseThree"><i> <B>CostCode Information</B></i> </a></h4>
</div>
<div id="collapseThree" class="panel-collapse collapse">
<div class="panel-body">
<table width="50%" align="center" border="0">
	<tr>
		<td><b>CostCode</b></td>
		<td align="left"><bean:write name="employeeObj" property="addr1" /></td>
	</tr>
	<tr class="alternateColumnClass">
		<td><b>Department</b></td>
		<td align="left"><bean:write name="employeeObj" property="department" /></td>
	</tr>


	<tr>
		<td><b>Section</b></td>
		<td align="left"><bean:write name="employeeObj"
			property="aptmtno" /></td>
	</tr>

	<tr class="alternateColumnClass">
		<td><b>Shift</b></td>
		<td align="left"><bean:write name="employeeObj" property="city" /></td>
	</tr>


	
</table>

</div>
</div>
</div>
</div>



</center>
</BODY>
</html>

Here are the another files

EmployeeDetailsObj

public class EmployeeDetailsObj {
private int emp_id;
private int badgeNo;
private String firstName;
private String lastName;
private String hireDate;
private int SSN;
private String termDate;
private String email;
private String phoneNo;
private int addressid;
private String addr1;
private String addr2;
private String aptmtno;
private String city;
private String county;
private String state;
private int zip;
private String country;
private String costcode;
private String costcenter;
private String department;
private String section;
private String shift;
private String product;




And complete EmployeeDaoaiml.java

package com.subaru.hr.daoimpl;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import javax.sql.DataSource;

import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.jdbc.core.simple.ParameterizedRowMapper;

import com.subaru.hr.beans.EmployeeDetailsObj;

public class EmployeeDaoImpl {
private JdbcTemplate jdbcTemplate;
private DataSource dataSource;

public void setDataSource(DataSource dataSource) {
System.out.println("dataSource" + dataSource);
this.dataSource = dataSource;
this.jdbcTemplate = new JdbcTemplate(dataSource);
}

public DataSource getDataSource() {
return dataSource;
}

/*
* public JdbcTemplate getJdbcTemplate() { return jdbcTemplate; } public
* void setJdbcTemplate(JdbcTemplate jdbcTemplate) { this.jdbcTemplate =
* jdbcTemplate; }
*/

public boolean isEmployeeExists(int badgeNo) {
try {
int number = jdbcTemplate.queryForInt(
"select count(*) from Employee where BADGE_NO=?", badgeNo);

if (number > 0) {
System.out.println("Record Count" + number);
return true;
}
} catch (Exception exception) {
exception.printStackTrace();
}
return false;
}

public EmployeeDetailsObj getEmployeeDetails(int badgeNo) {
String qry = "select * from Employee where BADGE_NO=?";

EmployeeDetailsObj employeeObj = jdbcTemplate.queryForObject(qry,
new Object[] { badgeNo }, new RowMapper<EmployeeDetailsObj>() {
public EmployeeDetailsObj mapRow(ResultSet rs, int rowNum)
throws SQLException {
EmployeeDetailsObj employeeObj = new EmployeeDetailsObj();
employeeObj.setBadgeNo(rs.getInt("badge_no"));
employeeObj.setFirstName(rs.getString("first_name"));
employeeObj.setLastName(rs.getString("last_name"));
employeeObj.setHireDate(rs.getString("hire_Date"));
employeeObj.setTermDate(rs.getString("term_Date"));
employeeObj.setSSN(rs.getInt("ssn"));
employeeObj.setEmail(rs.getString("email"));
employeeObj.setPhoneNo(rs.getString("phone_no"));

/*
* employeeObj.setAddr1(rs.getString("addr1"));
* employeeObj.setAddr2(rs.getString("addr2"));
* employeeObj.setAptmtno(rs.getString("aptmtno"));
* employeeObj.setCity(rs.getString("city"));
* employeeObj.setCounty(rs.getString("county"));
* employeeObj.setState(rs.getString("state"));
* employeeObj.setZip(rs.getInt("zip"));
* employeeObj.setCountry(rs.getString("country"));
*/

return employeeObj;
}
});
return employeeObj;
}






public EmployeeDetailsObj search(String searchBy, String searchId)throws Exception {

System.out.println("searchBy " + searchBy + " searchId " + searchId);
//String qry = "select * from Employee";
String qry = "select * from Employee as e join empcostcode as ecc on e.Badge_no=ecc.Badge_No join costcode as cc on ecc.costcode_id=cc.id join department as d on cc.department_id = d.id join section as sec on cc.section_id=sec.id join costcenter as cocent on cc.costcenter_id=cocent.id";
if (searchBy != null) {
if (searchBy.equals("SSN"))
qry = qry + " where e.SSN=?";
else if (searchBy.equals("badgeNo"))
qry = qry + " where e.BADGE_NO=?";
}
System.out.println("qry " + qry);
EmployeeDetailsObj employeeObj = jdbcTemplate.queryForObject(qry,
new Object[] { searchId }, new RowMapper<EmployeeDetailsObj>() {
public EmployeeDetailsObj mapRow(ResultSet rs, int rowNum)
throws SQLException {
EmployeeDetailsObj employeeObj = new EmployeeDetailsObj();
employeeObj.setBadgeNo(rs.getInt("badge_no"));
employeeObj.setFirstName(rs.getString("first_name"));
employeeObj.setLastName(rs.getString("last_name"));
employeeObj.setHireDate(rs.getString("hire_Date"));
employeeObj.setTermDate(rs.getString("term_Date"));
employeeObj.setSSN(rs.getInt("ssn"));
employeeObj.setEmail(rs.getString("email"));
employeeObj.setPhoneNo(rs.getString("phone_no"));
//employeeObj.setDepartment(rs.getString("Department"));

/*
* employeeObj.setAddr1(rs.getString("addr1"));
* employeeObj.setAddr2(rs.getString("addr2"));
* employeeObj.setAptmtno(rs.getString("aptmtno"));
* employeeObj.setCity(rs.getString("city"));
* employeeObj.setCounty(rs.getString("county"));
* employeeObj.setState(rs.getString("state"));
* employeeObj.setZip(rs.getInt("zip"));
* employeeObj.setCountry(rs.getString("country"));
*/






return employeeObj;
}
});
return employeeObj;

}


public List<EmployeeDetailsObj> autoComplete(final String searchBy, String searchId)throws Exception {
searchId = searchId+"%";
System.out.println("searchBy " + searchBy + " searchId " + searchId);
String qry = "select * from Employee";
//String qry = "select * from Employee as e join empcostcode as ecc on e.Badge_no=ecc.Badge_No join costcode as cc on ecc.costcode_id=cc.id join department as d on cc.department_id = d.id join section as sec on cc.section_id=sec.id join costcenter as cocent on cc.costcenter_id=cocent.id";
if (searchBy != null) {
if (searchBy.equals("SSN"))
qry = qry + " where e.SSN like ?";
else if (searchBy.equals("badgeNo"))
qry = qry + " where e.BADGE_NO like ?";
}
System.out.println("qry " + qry);
return jdbcTemplate.query(qry,
new ParameterizedRowMapper<EmployeeDetailsObj>() {
public EmployeeDetailsObj mapRow(ResultSet rs, int rowNum)
throws SQLException {
EmployeeDetailsObj employeeObj = new EmployeeDetailsObj();
if (searchBy.equals("badgeNo"))
employeeObj.setBadgeNo(rs.getInt("badge_no"));
//employeeObj.setFirstName(rs.getString("first_name"));
//employeeObj.setLastName(rs.getString("last_name"));
if (searchBy.equals("SSN"))
employeeObj.setSSN(rs.getInt("ssn"));
return employeeObj;
}
},searchId);

}







}