搜索: 器材名称： 器材类别：

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

序号	器材编号	器材名称	器材类别	图片	演示视频	详细
<%=i %>	<%=map.get("qicaibianhao") %>	<%=map.get("qicaimingcheng") %>	<%=map.get("qicaileibie") %>		点此播放	" >详细

${page.info }