search.jsp
901 Bytes
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<jsp:useBean id="RecordSet" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="DepartmentComInfo" class="weaver.hrm.company.DepartmentComInfo" scope="page"/>
<%
String q = request.getParameter("q");
if(q.equals("")) return;
//RecordSet.executeSql("select * from HrmResource where lastname like '%"+q+"%' or workcode like '%"+q+"%'");
RecordSet.executeSql("select * from HrmResource where lastname like '%"+q+"%'");
while(RecordSet.next()){
String id = RecordSet.getString("id");
String lastname = RecordSet.getString("lastname");
String departmentid = RecordSet.getString("departmentid");
String departmentname = DepartmentComInfo.getDepartmentname(departmentid);
String workcode = RecordSet.getString("workcode");
//out.println(workcode+" "+lastname+"|"+id);
out.println(lastname+"/"+departmentname+"|"+id);
}
%>