oraclepages.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 OraclePages
    extends Pages {

  public OraclePages() {
  }

  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 rownum r_id,t.*  from (" + sql +
        ") t where rownum <= " + (spage + this.perpagenum) + ") where r_id >" +
        spage;
    return sql;
  }

}