搜索: 工号： 性别：所有男女 专长：

<% new CommDAO().delete(request,"jiaolian"); String url = "jiaolianlist.jsp?2=2"; String sql = "select * from jiaolian where 1=1"; if(request.getParameter("gonghao")=="" ||request.getParameter("gonghao")==null ){}else{sql=sql+" and gonghao like '%"+request.getParameter("gonghao")+"%'";} if(request.getParameter("xingbie")=="" ||request.getParameter("xingbie")==null ){}else{sql=sql+" and xingbie like '%"+request.getParameter("xingbie")+"%'";} if(request.getParameter("zhuanchang")=="" ||request.getParameter("zhuanchang")==null ){}else{sql=sql+" and zhuanchang like '%"+request.getParameter("zhuanchang")+"%'";} sql+=" order by id desc"; ArrayList list = PageManager.getPages(url,15,sql, request); int i=0; for(HashMap map:list){ i++; %> <% } %>

序号	工号	密码	姓名	性别	年龄	照片	专长	联系方式	地址	详细
<%=i %>	<%=map.get("gonghao") %>	<%=map.get("mima") %>	<%=map.get("xingming") %>	<%=map.get("xingbie") %>	<%=map.get("nianling") %>		<%=map.get("zhuanchang") %>	<%=map.get("lianxifangshi") %>	<%=map.get("dizhi") %>	" >详细

${page.info }