pagescount.jsp

来自「jsp写的学生管理系统 可以好好看看 初学者」· JSP 代码 · 共 35 行

<%!
 int PageSize =3;
 int showPage=1;
 int RowCount=0;
 int PageCount=0;
 Connection con = null;
 Statement stmt = null;
 ResultSet rs=null;
 public void jspInit()
 {
    try{
     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
     con=DriverManager.getConnection("jdbc:odbc:student");
     stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
     rs=stmt.executeQuery("select * from student");
     rs.last();
     RowCount=rs.getRow();
     PageCount=((RowCount % PageSize) == 0 ?(RowCount/PageSize):(RowCount/PageSize)+1);
     }
     catch(Exception ex)
     {System.out.println(ex.toString());
     }
}
public void jspDestroy()
{
    try{
      rs.close();
      stmt.close();
      con.close();
      }
    catch(Exception ex)
    {System.out.println(ex.toString());
    }
}
%>