📄 pageshow.jsp

📁 一本jsp自学教材
💻 JSP
字号:
<%@ page contentType="text/html;charset=GBK"%> 
<%@ page import="java.sql.* "%> 
<%@ page import="javax.naming.* "%> 
<%@ page import="javax.sql.DataSource "%> 
<%@ page import="test.DBConn"%> 
<HTML>
<HEAD><TITLE>记录显示的分页</TITLE></HEAD>
<BODY>
<% 
String pageid=request.getParameter("pageid"); 
int pagesize=5;    //定义每页显示5条记录
int pagecount=0; 
int showpage=1;  
try{ 
//连接数据源
//Context initCtx = new InitialContext(); 
//Context ctx = (Context) initCtx.lookup("java:comp/env"); 
//获取连接池对象 
//DataSource ds =(DataSource)ctx.lookup("jdbc/rot"); 
//创建连接
//Connection conn = ds.getConnection(); 
DBConn dbc=new DBConn("jdbc/rot");
Statement stmt = dbc.getStmt(); 
String strSql ="SELECT * FROM product"; 
ResultSet rs = stmt.executeQuery(strSql); 
    rs.last();
    int lastrow=rs.getRow();
    //计算分页后的总页数
    pagecount=(lastrow%pagesize==0)?(lastrow/pagesize):(lastrow/pagesize+1);
    //处理没有参数时的默认页为1              
    if(request.getParameter("pageid")==null||pageid.equals(""))
     { 
       pageid="1";
     }
    showpage=Integer.parseInt(pageid);
            
    if(showpage<=1)
      {
        showpage=1;
      }
    if(showpage>=pagecount)
      {
        showpage=pagecount;
      }
    int posion=(showpage-1)*pagesize;
    if(posion==0)
      {
        posion=1;
      }
   //将指针移动到指定位置
  rs.absolute(posion);
  out.print("数据源配置并连接成功！<BR>");  
  out.print("<TABLE BORDER=1 bordercolorlight=#000000 >");
  out.print("<TR><TD width=40>序号</TD>");
  out.print("<TD width=60>代码</TD><TD width=80>商品名称</TD>");
  out.print("<TD width=60>品牌</TD>");
  out.print("<TD width=150>产品简介</TD><TD width=80>存货数量</TD>");
  out.print("<TD width=80>价格/元</TD></TR>");
  for(int i=1;i<=pagesize;i++)
   {
     out.print("<TR>");
     out.print("<TD>"+rs.getInt(1)+"</TD>");
     out.print("<TD>"+rs.getString("pdm")+"</TD>");
     out.print("<TD>"+rs.getString("pname")+"</TD>");     
     out.print("<TD>"+rs.getString("provider")+"</TD>");
     out.print("<TD>"+rs.getString("info")+"</TD>");
     out.print("<TD>"+rs.getString("stock")+"</TD>");
     out.print("<TD>"+rs.getString("price")+"</TD>");
     out.print("</TR>");
     if(!rs.next())
      break;          
   }
  out.print("</TABLE>"); 
rs.close();
//conn.close();
}catch(Exception e){  
out.print("不能连接到数据源！"); 
} 
/*-----------------------------------------------*/
//显示分页导航
out.print("<BR>");
out.print("[共"+pagecount+"页]>>>");
for(int j=1;j<=pagecount;j++)
   { 
    if(j==showpage){
     out.print("[");}
    out.print("<A href=pageshow.jsp?pageid="+j+">");
    out.print(""+j);
    out.print("</A>");
    if(j==showpage)
    {
     out.print("]");
    }
    out.print("  ");
  }
  /*-----------------------------------------------*/
%> 
</BODY>
</HTML>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -