postgresqlpages.java

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

package com.laoer.bbscs.db;

import java.sql.ResultSet;
import org.apache.log4j.*;

/**
 * <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 PostgreSQLPages
    extends Pages {

  static Logger logger = Logger.getLogger(PostgreSQLPages.class.getName());

  public PostgreSQLPages() {
  }

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

  }

  public String getSQLString(String pk) {
    String sql = this.sSQL;
    sql = sql + " limit " + perpagenum + " OFFSET " + spage;
    return sql;
  }

}