课程-day19练习-jdbc条件查询分页

//获取表单id,提交表 ementById("表单}publicpublicvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)ServletException,IOException//获取客户端复选框的值,返回字符串数String[]pids=request.getParameterValues("checkItem");ProductServiceservice=newProductService(); }publicpublicvoidpids){ProductDaodao=newProductDao();try{if(pids!=nullpids.length>0){for(Stringpid:}}}catch(SQLExceptione)}第2章案例：分页查相关知识：sql格式：格式：select*fromlimit参数2：每页显示个数pageSizeselect*fromproductslimit0,5;#5条。select*fromproductslimit5,5;#5条。select*fromproductslimit10,55条。select*fromproductslimit?,5;#pageNumber5startIndex=(pageNumber-1)*publicpublicclassPageBean ongtotalPage;//总页数privateintpageNum;//当前页privateintpageSize;//每页条数 ongtotalCount;//总条 ist<T>list显示的商品数据publiclonggetTotalPage(){return}publicvoidsetTotalPage(long{this.totalPage=}publicint{return}publicvoidsetPageNum(int{this.pageNum=}publicint{return}publicvoidsetPageSize(int{this.pageSize=}publicpubliclong{return}publicvoidsetTotalCount(long{this.totalCount=}publicList<T>{return}publicvoidsetList(List<T>{this.list=}}publicvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{publicvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{request.setCharacterEncoding("UTF-//获取页面提交的方法调Stringmethod=request.getParameter("method");if("list".equals(method)){//不带分页查询数list(request,}elseif("pageList".equals(method))//带分页查询数pageList(request,}}throwsServletException,IOException{//获取当前页StringpageNumStr=if(pageNumStr==null||"".equals(pageNumStr)){}intpageNum=Integer.parseInt(pageNumStr);ProductServiceservice=newProductService();//调用业务层方法,每页显12条,获取PageBeanPageBean<Product>pageBean=request.setAttribute("pageBean",pageBean);request.setAttribute("pageBean",pageBean);}privatevoidlist(HttpServletRequestrequest,HttpServletResponseresponse)}publicvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{doGet(request,}publicpublicPageBean<Product>findByPage(intpageNum,int******ongtotalPage;//总页privateintpageNum;//privateintpageSize;//每页条ongtotalCount;//总条业务层封装对象PageBean,返回视图PageBean<Product>pageBean=ne ProductDaodao=newProductDao();longtotalCount=dao.getTotalCount();inttotalPage=(int)Math.ceil(1.0*totalCount/pageSize);//sql="select*fromproductlimit(当前页-1*每页显示条数),pageSize"List<Product>listdao.findByPage((pageNum-1)*pageSize,pageSize);ex){;}return}publicpublicList<Product>findByPage(inti,intpageSize)throws{QueryRunnerrunner=newQueryRunner(DataSourceUtils.getDataSource());Stringsql="select*fromproductlimit?,?"; }publiclonggetTotalCount()throwsQueryRunnerrunner=newQueryRunner(DataSourceUtils.getDataSource());Stringsql="selectcount(*)fromproduct";return(long)runner.query(sql,new} <!--如果已经是第一页,不能点击<c:iftest="${pageBean.pageNum==1<li<ahref="javascript:void(0);"aria-<spanaria-<c:iftest="${pageBean.pageNum!=1<liontextPathan.pageNum-1}"aria-<spanaria-<!-循环显示页循环1开始,到从页数结--<c:forEachbegin="1"end="${pageBean.totalPage}"<!--如果是当前页,背景色设置蓝色<c:if<c:iftest="${pageBean.pageNum==i ontextPath}/pageProduct?method=pageList&pageNum=${pageSc${pageScope.i<c:iftest="${pageBean.pageNum!=iontextPath${pageScope.i<!--判断如果最后一页,下一页不能点击<li<ahref="javascript:void(0);"aria-<spanaria-<c:iftest="${pageBean.pageNum!=pageBean.totalPage<li ontextPath}/pageProduct?method=pageList&pageNum=${pageBe<spanaria-第3章案例：条件查商商品名称<inputtype="text" ; name="minPrice">--是否热门<optionvalue="-1">不限<optionvalue="1">是<optionvalue="0">否 <button<buttontype="button"id="del"name="del"value="删除class="button_add"onclick="findProduct()"查询publicpublicvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)ServletException,ServletException,IOExceptionrequest.setCharacterEncoding("UTF-//Map<String,String[]>parameterMap=request.getParameterMap();Findfind=newFind();tryBeanUtils.populate(find,}catch(IllegalAccessException| Exception{}ProductServiceservice=newProductService();List<Product>productList=service.findProduct(find);request.setAttribute("productList",productList);}publicList<Product>findProduct(Findfind){List<Product>list=null;ProductDaopublicList<Product>findProduct(Findfind){List<Product>list=null;ProductDaodao=newProductDao();try{list=}catch(SQLExceptione)}return}publicpublicList<Product>findProduct(Findfind)throwsQueryRunnerrunner=new////sqlStringsql="select*fromproductwhere//定义集合 查询条List<Object>list=new//判断查询的条件,拼接sql&&!find.getPname().eq