sqlserverpages.java

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

package com.laoer.bbscs.db;

import java.sql.ResultSet;
import com.laoer.bbscs.sysinfo.*;

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

  public SQLServerPages() {
  }

  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.toLowerCase(Sys.getLocale());
    String sqltotal = "";
    String con1 = "select";
    String con2 = "from";
    String con3 = "where";
    String con4 = "order";
    int i1 = sql.indexOf(con1);
    int i2 = sql.indexOf(con2);
    int i3 = sql.indexOf(con3);
    int i4 = sql.indexOf(con4);
    String selectitem = "";
    String tablename = "";
    String cond = "";
    String orders = "";

    selectitem = sql.substring(i1 + 6, i2);

    if (i3 != -1) {
      tablename = sql.substring(i2 + 4, i3);
      if (i4 != -1) {
        cond = sql.substring(i3 + 5, i4);
        orders = sql.substring(i4 + 5, sql.length());
      }
      else {
        cond = sql.substring(i3 + 5, sql.length());
      }
    }
    else {
      if (i4 != -1) {
        tablename = sql.substring(i2 + 4, i4);
        orders = sql.substring(i4 + 5, sql.length());
      }
      else {
        tablename = sql.substring(i2 + 4, sql.length());
      }
    }

    String _orders = "";
    if (i4 != -1) {
      _orders = "order " + orders;
    }
    //sql = "select Top "+ipage+" * from "+tablename+" where ID NOT IN (select Top "+(spage+ipage)+" ID from "+tablename+" "+_orders+") "+_orders;
    sql = "select Top " + perpagenum + " * from " + tablename + " where ";
    if (i3 != -1) {
      sql += "(" + cond + ") and ";
    }
    sql += pk + " NOT IN (select Top " + spage + " " + pk + " from " +
        tablename + " ";
    if (i3 != -1) {
      sql += "where " + cond;
    }
    sql += _orders + ") " + _orders;
    return sql;
  }

}