search_leaveword.jsp

来自「非常完整的Java开发的网络办公系统」· JSP 代码 · 共 46 行

<%@ page errorPage="/vnex/ErrorPage.jsp" %>
<%@ page import = "com.vnex.intranet.pub.BaseJdbcDAO"%>
<jsp:useBean id="leaveWordProxy" scope="application" class="com.vnex.intranet.communication.leaveword.proxy.LeaveWordProxyBean" />
<%
    String addConTime = leaveWordProxy.getYesterday();
    session.removeAttribute("condition");
    String condition = " (end_date>\'"+addConTime+"\' or end_date is null) ";
    String pageTo = "/mainctrl/leaveword/nameResult";
	BaseJdbcDAO jdbcDAO =new BaseJdbcDAO();
    if(request.getParameter("s") != null)
    {
	    if(!request.getParameter("deptId").equals("0"))
	    {
	       if(!request.getParameter("empId").equals("0"))
	       {
	          condition += " and emp_id in ("+request.getParameter("empId")+")";
	          pageTo = "/mainctrl/leaveword/searchResult?empId="+request.getParameter("empId");
	       }   
	       else
	       {
	          condition += " and emp_id in (select emp_id from t_emp where division_id="+request.getParameter("deptId")+") group by emp_id ";
	       }
	    }
	    else
	    {
	       if(!request.getParameter("empId").equals("0"))
	       {
	          condition += " and emp_id in ("+request.getParameter("empId")+")";
	          pageTo = "/mainctrl/leaveword/searchResult?empId="+request.getParameter("empId");
	       }   
	       else
	       {
	          condition += " group by emp_id ";
	       }
	    }
	}    
    else
    {
          condition += " and emp_id in ((select emp_id from t_emp where name like '%"+jdbcDAO.changeCode(request.getParameter("search_name"))+"%')) group by emp_id";      
    }      
    session.setAttribute("condition", condition);   
%>

<jsp:forward page="<%=pageTo%>" />