为什么我的分页操作第二页就不显示了啊

<style>
.leftborder{

left:200px;
top:30px;
}
</style>
</head>
<body>
<h1>银行</h1>

<%! 
    int pagecount;
    int showpage;
%>

<%
    Connection con;
    Statement sql;
    ResultSet rs;
    try{
        Class.forName("com.mysql.cj.jdbc.Driver");
    }catch(ClassNotFoundException e){        
    }
        try{
            con=DriverManager.getConnection("jdbc:mysql://localhost:3306/xml",
                    "root","123456");
            sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
                    ResultSet.CONCUR_READ_ONLY); 
            String name=request.getParameter("username");
            String idcode = request.getParameter("password");
            String sql1="select * from xmlprase where PERSON_NAME='"+name+"'"
                    +" and ID_CODE='"+idcode+"'";
            
            rs=sql.executeQuery(sql1);
            rs.last();
            pagecount=rs.getRow();
            String integer=request.getParameter("showpage");
            if(integer==null){
                integer="1";
            }try{
                showpage=Integer.parseInt(integer);
            }catch(NumberFormatException e){
                showpage=1;
            }
            if(showpage<=1){
                showpage=1;
            }
            if(showpage>=pagecount){
                showpage=pagecount;
            }
            rs.absolute(showpage);    
            for(int i=1;i<=5;i++){
%> 
<div style="position:absolute; left:100px;top:150px;"> 
OPER_TYPE_CODE:<%=rs.getString("OPER_TYPE_CODE")%>
<br>
REASON_CODE:<%=rs.getString("REASON_CODE")%>
<br>
REFNO:<%=rs.getString("REFNO")%>
<br>
CERT_TYPE_CODE:<%=rs.getString("CERT_TYPE_CODE")%>
<br>
PTY_COUNTRY_CODE:<%=rs.getString("PTY_COUNTRY_CODE") %>
<br>
ID_CODE:<%=rs.getString("ID_CODE") %>
<br>
PERSON_NAME:<%=rs.getString("PERSON_NAME") %>
<br>
ACCTNO:<%=rs.getString("ACCTNO") %>
<br>
JY_CCY_CODE:<%=rs.getString("JY_CCY_CODE") %>
<br>
JY_AMT:<%=rs.getString("JY_AMT") %>
<br>
<!-- </div> -->
<!-- <div style="position:absolute; left:500px;top:150px;"> -->
QS_AMT_RMB:<%=rs.getString("QS_AMT_RMB") %>
<br>
MCC_CODE:<%=rs.getString("MCC_CODE") %>
<br>
CARD_TYPE_CODE:<%=rs.getString("CARD_TYPE_CODE") %>
<br>
CARD_CHNL_CODE:<%=rs.getString("CARD_CHNL_CODE") %>
<br>
BANK_CODE:<%=rs.getString("BANK_CODE") %>
<br>
BRANCH_SAFECODE:<%=rs.getString("BRANCH_SAFECODE") %>
<br>
BIZ_DEAL_TIME:<%=rs.getString("BIZ_DEAL_TIME") %>
<br>
COUNTRY_CODE:<%=rs.getString("COUNTRY_CODE") %>
<br>
BANK_SELF_NUM:<%=rs.getString("BANK_SELF_NUM") %>
<br>
CARD_SELF_NUM:<%=rs.getString("CARD_SELF_NUM") %>
<br>  </div> 
<br>

 <%         
        rs.next();  
            }   
        rs.close();  
        con.close();  
        }  
        catch(Exception e){  
        e.printStackTrace();
        }  
 %> 
 <br>
<a href = "show.jsp?showpage=1" >首页</a>
<a href = "show.jsp?showpage=<%=showpage-1 %>" >上一页</a>
<%
    for(int i=1;i<=pagecount;i++){
        

%>
<a href="show.jsp?showpage=<%=i%>"><%=i%></a>
<%
    }
%>
<a href = "show.jsp?page=<%=showpage+1 %>" >下一页</a>
<a href = "show.jsp?page=<%=pagecount %>" >尾页</a>
第<%=showpage %>页/共<%=pagecount %>页 
<form action="" method="get">
<input type="text" name="showpage" size="4">
<input type="submit"  value="tiaozhuan">
</form>
</body>
</html>

写回答
好问题 0 提建议
追加酬金
关注问题
分享
邀请回答
编辑收藏删除
收藏举报

2条回答默认最新

关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
CSDN专家-showbo 2021-08-06 10:32
关注
你的下一页和尾页的参数名称是page，不是showpage。你服务器端获取用的参数名是showpage。String integer=request.getParameter("showpage")。有帮助麻烦点个采纳【本回答右上角】，谢谢~~

<a href = "show.jsp?page=<%=showpage+1 %>" >下一页</a> <a href = "show.jsp?page=<%=pagecount %>" >尾页</a> 参数名称改为showpage就行了===========》 <a href = "show.jsp?showpage=<%=showpage+1 %>" >下一页</a> <a href = "show.jsp?showpage=<%=pagecount %>" >尾页</a>
本回答被题主选为最佳回答 , 对您是否有帮助呢?

解决 2
无用
评论打赏
分享
举报

评论

按下Enter换行，Ctrl+Enter发表内容