viewbbs.jsp

简单实现的商品购物系统

<%@ page contentType="text/html; charset=GBK" %>
<%@ page  import="java.util.*,bookshop.BbsBean" %>
<%
   String id=request.getParameter("pageid");
                if(id.equals("")||id==null)
                   id="1";
                int pageid=Integer.parseInt(id);

       BbsBean xie=new BbsBean();
       String str="select  b.images,b.qq,b.email,b.home ,a.content,a.ip ,a.submittime ,b.userName,a.reply,a.replytime,a.bbsid from userbbs  a,userinformation b  where a.userName=b.userName order by a.submittime  desc ";
      int  totalPage = xie.getTotalPage(3,str);
       Collection coll=   xie.getPageData(pageid,3,str);
       RequestDispatcher dis =request.getRequestDispatcher("bbsmanager.jsp");
         request.setAttribute("pageid",new Integer(pageid));
         request.setAttribute("totalPage",new Integer(totalPage));
        request.setAttribute("coll",coll);
         dis.forward(request,response);//跳转

%>