jsp+java分页出现错误

最新推荐文章于 2024-04-11 14:51:07 发布

ceoshunge

最新推荐文章于 2024-04-11 14:51:07 发布

阅读量640

点赞数 1

分类专栏： java 文章标签： jsp java string vector import stylesheet

本文链接：https://blog.csdn.net/ceoshunge/article/details/2317301

版权

java 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

这是JAVA分页类

package Pagination;

import java.sql.*;
import java.util.*;
public class splitPage {
private Connection con=null;
private Statement stmt=null;
private ResultSet rs=null;
private String sqlStr;
private int rowCount;
private int pageCount;
private int pageSize;

public void setCon(Connection con){
  this.con=con;
  if(this.con==null){
   System.out.println("Failure to get a connection!");
  }
  else{
   System.out.println("Success to get a connection!");
  }
}
public void initialize(String sqlStr,int pageSize){
  this.sqlStr=sqlStr;
  this.pageSize=pageSize;
  try{
   stmt=this.con.createStatement();
   rs=stmt.executeQuery(this.sqlStr);
   if(rs!=null){
    rs.last();
    this.rowCount=rs.getRow();
    rs.first();
    this.pageCount=(this.rowCount-1)/this.pageSize+1;
   }
  }
  catch(SQLException e){
   System.out.println(e.toString());
  }
}
public Vector getPage(int ipage){
  Vector vData = new Vector();
  int n=ipage;
  int m=0;
  m=(n-1)*this.pageSize+1;
  try{
   if(rs!=null){
    if(n!=1){
     rs.absolute(m);
    }
    for(int i=0;i<this.pageSize;i++){
     String[] sData = new String[9];
     for(int j=0;j<9;j++){
      sData[j]=rs.getString(j+1);
     }
     if(sData==null){
      break;
     }
     vData.addElement(sData);
     rs.next();
    }
   }
   rs.close();
   stmt.close();
  }
  catch(SQLException e){
   System.out.println(e.toString());
  }
  return vData;
}
public int getPageCount(){
  return this.pageCount;
}
public int getRowCount(){
  return this.rowCount;
}
}

下面是在JSP页面中调用-------->但调用失败

<%@ page language="java"
   import="java.io.*"
  import="java.sql.*"
  import="java.util.*"
  import="Jdbc.Dconn"
   import="Pagination.splitPage"
   pageEncoding="gb2312"%>
<%!
//每页显示的记录数
int pageSize=11;
String sqlStr="";
//总页数
int pageCount=0;
//总记录数
int rowCount=0;
//当前页
int showPage=1;
Connection dbcon;
String url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=D:/MyWorkspace/saleManMS/data/smmdb.mdb";
%>
<jsp:useBean id="pages" scope="session" class="Pagination.splitPage"/>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
try{
  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  dbcon=DriverManager.getConnection(url);
  out.print("conn is ok!");
}
catch(SQLException ex){
  System.out.print(ex.toString());
}
catch(ClassNotFoundException ex){
  System.out.print(ex.toString());
}
pages.setCon(dbcon);
sqlStr="select * from tbcustom ORDER BY cu_id";
pages.initialize(sqlStr,pageSize);
String strPage=null;
strPage= request.getParameter("showPage");
  out.print("init is ok!");
if(strPage==null){
  strPage="1";
}
else{
  try{
   showPage=Integer.parseInt(strPage);
  }
  catch(NumberFormatException ex){
   showPage=1;
  }
  if(showPage<=1){
   showPage=1;
  }
  if(showPage>pages.getPageCount()){
   showPage=pages.getPageCount();
  }
}
Vector vData=pages.getPage(showPage);
out.print("vector is ok!");
%>