db2pages.java

天乙代码src_531.rar 天乙代码src_531.rar 天乙代码src_531.rar 天乙代码src_531.rar

package com.laoer.bbscs.db;

import java.sql.ResultSet;

/**
 * <p>Title: 天乙社区V5.0</p>
 * <p>Description: BBS-CS天乙社区V5.0</p>
 * <p>Copyright: Copyright (c) 2003</p>
 * <p>Company: laoer.com</p>
 * @author 龚天乙
 * @version 5.0
 */

public class DB2Pages
    extends Pages {

  public DB2Pages() {
  }

  public ResultSet getRs(TranContext DBSQL, String pk) {
    String SQL = "";
    ResultSet rs = null;
    try {
      SQL = this.getSQLString(pk);
      DBSQL.prepareStatement(SQL);
      rs = DBSQL.executeQuery();
      return rs;
    }
    catch (Exception e) {
      return null;
    }
  }

  public String getSQLString(String pk) {
    String sql = this.sSQL;
    sql = "select * from ( select rownumber() over() as row_next,t.*  from (" +
        sql +
        ") as t) as temp where row_next between " + spage + " and " +
        (spage + this.perpagenum);
    return sql;
  }

}