web分页

来源：互联网发布：儿童编程培训班编辑：程序博客网时间：2024/05/29 13:38

jsp页面

<ul>            <c:if test="${pageNum>1}">                <li class="">                    <a href="toList?p=${1}&Ntt=${Ntt}"  class="">                       首页                    </a>                </li>                <li class="">                    <a href="toList?p=${pageNum-1}&Ntt=${Ntt}"  class="">                       上一页                    </a>                </li>           </c:if>           <c:if test="${pageNum!=pageCount}">                <li class="">                    <a href="toList?p=${pageNum+1}&Ntt=${Ntt}" class="">                        下一页                    </a>                </li>                <li class="">                    <a href="toList?p=${pageCount}&Ntt=${Ntt}"   class="">                        末页                    </a>                </li>              </c:if>            </ul>

controller页面

//通过关键字查看商品（模糊查询）@RequestMapping("toList")public String toList(HttpSession session,String Ntt,Model model,String p){int pageSize = 2;int pageCount = 1;int pageNum = 1;if (p!=null) {pageNum = Integer.parseInt(p);}int count = gs.selectByGoodsNameCount("%"+Ntt+"%");//查看数据行数if(count%pageSize==0){pageCount = count/pageSize;}else{pageCount = count/pageSize+1;}/*int prePage = pageNum>1 ? pageNum-1:1;int nextPage = pageNum<pageCount ?pageNum+1:pageNum;*/List<Goods> gList = gs.selectByGoodsName("%"+Ntt+"%",(pageNum-1)*pageSize,pageNum*pageSize);if(gList.size()==0||Ntt.equals("")){model.addAttribute("error", "您搜索的商品不存在，请重新搜索！");return "list";}else{session.setAttribute("gList", gList);model.addAttribute("pageNum", pageNum);//当前页/*model.addAttribute("prePage", prePage);//上一页model.addAttribute("nextPage", nextPage);//下一页*/model.addAttribute("pageCount", pageCount);//末页model.addAttribute("Ntt", Ntt);//goodsNamereturn "list";}}

DAO层 .xml页面

<select id="selectByGoodsName"  resultMap="GoodsResult">   select * from(select ROWNUM m,cng_goods.* from cng_goods  where ROWNUM <= #{2} and goods_name like #{0}) g where g.m > #{1}   </select>

须使用转义字符：
原符号 < <= > >= & ' "替换符号<<=>>=&'"

DAO层 .java页面

 List<Goods> selectByGoodsName(String goodsName,int p1,int p2);//分别对应.xml页面的0、1、2

0 0