用javabean来实现MySQL的分页显示

用javabean来实现MySQL的分页显示,标签：sql数据库教程,access数据库教程,http://www.xxk123.com
    last = (this.TPages - 1) * MaxLine;
        
    if(Offset >= MaxLine)
      str +=  " <A href=" + FilePath + "?offset=" + first + ">首页</A> ";
    else str += " 首页 ";
    if(prev >= 0)
      str +=  " <A href=" + FilePath + "?offset=" + prev + ">前页</A> ";
    else str += " 前页 ";
    if(next < Total)
      str +=  " <A href=" + FilePath + "?offset=" + next + ">后页</A> ";
    else str += " 后页 ";
    if(TPages != 0 && CPages < TPages)
      str +=  " <A href=" + FilePath + "?offset=" + last + ">尾页</A>";
    else str += " 尾页 ";

    str += " 页次：" + getCurrenPages() + "/" + getTotalPages() + "页 ";
    str += MaxLine + "条/页 " + "共" + Total + "条";
    return str;
  }
}

=========================== dbClass.java ===================================
/**
* a class use to connect the MySQL database and do some query
* use mm.MySQL.Drive
* Jeru Liu ,November 2, 2000 , ver - 1.1
*
*/

package dbclass;
import java.sql.*;

public class dbClass  {
    
  // public: connection parameters
  String dbName = "Kernel";
  String Login = "root";
  String Password = "MySQL";  
  
  String DBDriver = "org.gjt.mm.MySQL.Driver";
  String ConnStr = "jdbc:MySQL://localhost/"+dbName+"?user="+Login+";password="+Password;    
  Connection con = null;  
  Statement stmt = null;
  ResultSet rs = null;        
  ResultSetMetaData resultsMeta =null;
  int rows = 0;
    
  // public: constructor to load driver and connect db
  public dbClass()  {           
        // load mm.MySQL.driver
      try  
      {       
          Class.forName("org.gjt.mm.MySQL.Driver");             
      }
      // display corresponding error message when onload error occur      
      catch (java.lang.ClassNotFoundException e)  

上一页  [1] [2] [3] [4] [5]  下一页