Esempio n. 1
0
  public static Date selectMinDate(DbConnection conn, String tblName, String colName, String qual)
      throws Exception {
    Date val = null;
    DbSelectStatement stmt = null;
    String stmtText;
    try {
      stmt = new DbSelectStatement();
      if (qual == null) stmtText = "SELECT MIN(" + colName + ") AS " + colName + " FROM " + tblName;
      else stmtText = "SELECT MIN(" + colName + ") AS " + colName + " FROM " + tblName + " " + qual;

      stmt.create(conn, stmtText);
      stmt.execute();

      if (stmt.next()) {
        val = stmt.getDateTime(1);
        stmt.release();
      }
      stmt.release();
      if (val == DbDataType.NULL_DATE_TIME) val = null;
      return val;
    } catch (Exception e) {
      DbSelectStatement.ensureRelease(stmt, e);
      throw e;
    }
  }
Esempio n. 2
0
  public static int selectMinInt(DbConnection conn, String tblName, String colName, String qual)
      throws Exception {
    int val = 0;
    DbSelectStatement stmt = null;
    String stmtText;
    try {
      stmt = new DbSelectStatement();
      if (qual == null) stmtText = "SELECT MIN(" + colName + ") AS " + colName + " FROM " + tblName;
      else stmtText = "SELECT MIN(" + colName + ") AS " + colName + " FROM " + tblName + " " + qual;

      stmt.create(conn, stmtText);
      stmt.execute();

      if (stmt.next()) {
        val = stmt.getShortInteger(1);
        stmt.release();
      }
      stmt.release();
      if (val == DbDataType.NULL_SHORT_INTEGER) val = 0;
      return val;
    } catch (Exception e) {
      DbSelectStatement.ensureRelease(stmt, e);
      throw e;
    }
  }
Esempio n. 3
0
  public static long selectMaxLong(
      DbConnection conn, String tblName, String colName, String alias, String qual)
      throws Exception {
    long val = 0;
    DbSelectStatement stmt = null;
    String stmtText;

    try {
      stmt = new DbSelectStatement();

      if (qual == null) stmtText = "SELECT MAX(" + colName + ") AS " + alias + " FROM " + tblName;
      else stmtText = "SELECT MAX(" + colName + ") AS " + alias + " FROM " + tblName + " " + qual;

      stmt.create(conn, stmtText);
      stmt.execute();

      if (stmt.next()) {
        val = stmt.getLong(1);
        stmt.release();
      }
      /*
       * else throw new IeciTdException(DbError.EC_NOT_FOUND,
       * DbError.EM_NOT_FOUND);
       */

      stmt.release();

      if (val == DbDataType.NULL_LONG) val = 0;
      return val;
    } catch (Exception e) {
      DbSelectStatement.ensureRelease(stmt, e);
      throw e;
    }
  }
Esempio n. 4
0
  public static void select(
      DbConnection conn,
      String tblName,
      String colName,
      String qual,
      boolean distinct,
      IeciTdDateTimeArrayList vals)
      throws Exception {

    DbSelectStatement stmt = null;

    try {

      stmt = new DbSelectStatement();
      /* String sql = */ stmt.create(conn, tblName, colName, qual, distinct);
      stmt.execute();

      while (stmt.next()) {
        vals.add(stmt.getDateTime(1));
      }

      stmt.release();

    } catch (Exception e) {
      DbSelectStatement.ensureRelease(stmt, e);
    }
  }
Esempio n. 5
0
  public static void select(
      DbConnection conn,
      String tblNames,
      String colNames,
      String qual,
      boolean distinct,
      String hint,
      DbOutputRecordSet rs)
      throws Exception {

    DbSelectStatement stmt = null;
    DbOutputRecord rec;

    try {
      if (rs.getMaxNumItems() > 0) {
        stmt = new DbSelectStatement();

        if (conn.isAllowHint()) {
          /* String sql = */ stmt.create(conn, null, tblNames, colNames, qual, distinct, hint);
        } else {
          /* String sql = */ stmt.create(conn, null, tblNames, colNames, qual, distinct);
        }
        stmt.execute();
        int count = 0;
        while (stmt.next() && count++ < rs.getMaxNumItems()) {
          rec = rs.newRecord();
          rec.getStatementValues(stmt);
        }

        stmt.release();
      }
    } catch (Exception e) {
      DbSelectStatement.ensureRelease(stmt, e);
    }
  }
Esempio n. 6
0
  public static void select(
      DbConnection conn, String sqlCompleta, DbOutputPaginatedRecordSet rs, PageInfo pageInfo)
      throws Exception {
    DbSelectStatement stmt = null;
    DbOutputRecord rec;

    try {
      stmt = new DbSelectStatement();
      /* String sql = */ stmt.createScrollable(conn, sqlCompleta);
      stmt.execute();

      int initialRecordNumber = pageInfo.getInitialRecordNumber();
      if (initialRecordNumber > 0) stmt.absolut(initialRecordNumber);

      int count = 0;
      while (stmt.next() && count++ < rs.getMaxNumItems()) {
        rec = rs.newRecord();
        rec.getStatementValues(stmt);
      }

      stmt.release();
    } catch (Exception e) {
      DbSelectStatement.ensureRelease(stmt, e);
    }
  }
Esempio n. 7
0
  public static void select(
      DbConnection conn,
      String tblNames,
      String colNames,
      String qual,
      String hint,
      DbOutputRecord rec)
      throws Exception {

    DbSelectStatement stmt = null;

    try {

      stmt = new DbSelectStatement();

      if (conn.isAllowHint()) {
        /* String sql = */ stmt.create(conn, null, tblNames, colNames, qual, false, hint);
      } else {
        /* String sql = */ stmt.create(conn, null, tblNames, colNames, qual, false);
      }
      stmt.execute();

      if (stmt.next()) rec.getStatementValues(stmt);
      else throw new IeciTdException(DbError.EC_NOT_FOUND, DbError.EM_NOT_FOUND);

      stmt.release();

    } catch (Exception e) {
      DbSelectStatement.ensureRelease(stmt, e);
    }
  }
Esempio n. 8
0
  public static int selectCountDistinct(
      DbConnection conn, String with, String tblName, String qual, String distinctFields)
      throws Exception {

    int val = 0;
    DbSelectStatement stmt = null;
    String stmtText;

    try {
      stmt = new DbSelectStatement();
      if (qual == null) stmtText = "SELECT COUNT(DISTINCT " + distinctFields + ") FROM " + tblName;
      else stmtText = "SELECT COUNT(DISTINCT " + distinctFields + ") FROM " + tblName + " " + qual;

      if (with != null) {
        stmtText = with + Constants.BLANK + stmtText;
      }

      stmt.create(conn, stmtText);
      stmt.execute();

      if (stmt.next()) val = stmt.getLongInteger(1);
      else val = 0;

      stmt.release();

      return val;

    } catch (Exception e) {
      DbSelectStatement.ensureRelease(stmt, e);
      throw e;
    }
  }
Esempio n. 9
0
  public static long selectMinString(DbConnection conn, String tblName, String colName, String qual)
      throws Exception {
    long val = 0;
    DbSelectStatement stmt = null;
    String stmtText;
    try {
      stmt = new DbSelectStatement();
      if (qual == null)
        stmtText =
            "SELECT MIN("
                + DBUtils.getNativeToNumberSyntax(conn, colName, 16)
                + ") AS "
                + colName
                + " FROM "
                + tblName;
      else
        stmtText =
            "SELECT MIN("
                + DBUtils.getNativeToNumberSyntax(conn, colName, 16)
                + ") AS "
                + colName
                + " FROM "
                + tblName
                + " "
                + qual;

      stmt.create(conn, stmtText);
      stmt.execute();

      if (stmt.next()) {
        val = stmt.getLong(1);
        stmt.release();
      }
      stmt.release();
      if (val == DbDataType.NULL_SHORT_INTEGER) val = 0;
      return val;
    } catch (Exception e) {
      DbSelectStatement.ensureRelease(stmt, e);
      throw e;
    }
  }
Esempio n. 10
0
  public static void selectUnionAll(
      DbConnection conn,
      String tblNames1,
      String tblNames2,
      String colNames1,
      String colNames2,
      String qual1,
      String qual2,
      String orderBy,
      boolean distinct,
      DbOutputRecordSet rs)
      throws Exception {

    DbSelectStatement stmt = null;
    DbOutputRecord rec;
    int count = 0;

    try {
      if (rs.getMaxNumItems() > 0) {
        stmt = new DbSelectStatement();
        String sql1 = stmt.create(conn, tblNames1, colNames1, qual1, distinct);
        String sql2 = stmt.create(conn, tblNames2, colNames2, qual2, distinct);
        String sqlUnion = "(" + sql1 + ")" + " UNION ALL " + "(" + sql2 + ")";

        if (!StringUtils.isBlank(orderBy)) {
          sqlUnion += orderBy;
        }

        stmt.create(conn, sqlUnion);
        stmt.execute();
        // int count = 0;
        while (stmt.next() && count++ < rs.getMaxNumItems()) {
          rec = rs.newRecord();
          rec.getStatementValues(stmt);
        }

        stmt.release();
      }
    } catch (Exception e) {
      DbSelectStatement.ensureRelease(stmt, e);
    }
  }
Esempio n. 11
0
  public static void select(
      DbConnection conn,
      String tblNames,
      String colNames,
      String qual,
      boolean distinct,
      String hint,
      DbOutputPaginatedRecordSet rs,
      PageInfo pageInfo)
      throws Exception {
    DbSelectStatement stmt = null;
    DbOutputRecord rec;

    try {
      stmt = new DbSelectStatement();

      if (conn.isAllowHint()) {
        /* String sql = */ stmt.createScrollable(conn, tblNames, colNames, qual, distinct, hint);
      } else {
        /* String sql = */ stmt.createScrollable(conn, tblNames, colNames, qual, distinct);
      }
      stmt.execute();

      int initialRecordNumber = pageInfo.getInitialRecordNumber();
      if (initialRecordNumber > 0) stmt.absolut(initialRecordNumber);

      int count = 0;
      while (stmt.next() && count++ < rs.getMaxNumItems()) {
        rec = rs.newRecord();
        rec.getStatementValues(stmt);
      }

      stmt.release();
    } catch (Exception e) {
      DbSelectStatement.ensureRelease(stmt, e);
    }
  }
Esempio n. 12
0
  public static long selectLong(DbConnection conn, String tblName, String colName, String qual)
      throws Exception {

    long val = DbDataType.NULL_LONG;
    DbSelectStatement stmt = null;

    try {
      stmt = new DbSelectStatement();
      /* String sql = */ stmt.create(conn, tblName, colName, qual, false);
      stmt.execute();

      if (stmt.next()) {
        val = stmt.getLong(1);
        stmt.release();
        return val;
      } else throw new IeciTdException(DbError.EC_NOT_FOUND, DbError.EM_NOT_FOUND);
    } catch (Exception e) {
      DbSelectStatement.ensureRelease(stmt, e);
      throw e;
    }
  }
Esempio n. 13
0
  private static int selectCountBase(DbConnection conn, String stmtText) throws Exception {
    int val = 0;
    DbSelectStatement stmt = null;
    try {
      stmt = new DbSelectStatement();

      stmt.create(conn, stmtText);
      stmt.execute();

      if (stmt.next()) val = stmt.getLongInteger(1);
      else val = 0;

      stmt.release();

      return val;

    } catch (Exception e) {
      DbSelectStatement.ensureRelease(stmt, e);
      throw e;
    }
  }
Esempio n. 14
0
  public static void select(DbConnection conn, String sqlCompleta, DbOutputRecord rec)
      throws Exception {
    DbSelectStatement stmt = null;

    try {
      stmt = new DbSelectStatement();

      stmt.create(conn, sqlCompleta);
      stmt.execute();

      if (stmt.next()) rec.getStatementValues(stmt);
      else throw new IeciTdException(DbError.EC_NOT_FOUND, DbError.EM_NOT_FOUND);

      stmt.release();

    } catch (Exception e) {
      DbSelectStatement.ensureRelease(stmt, e);
    }
  }
Esempio n. 15
0
  public static int selectCount(
      DbConnection conn, String tblName, String colName, String qual, boolean distinct)
      throws Exception {

    int val = 0;
    DbSelectStatement stmt = null;
    StringBuffer stmtText = new StringBuffer();

    try {
      stmt = new DbSelectStatement();

      stmtText.append("SELECT ");

      stmtText.append("COUNT(");

      if (distinct) {
        stmtText.append("DISTINCT ");
      }

      stmtText.append(colName).append(") FROM ").append(tblName);

      if (qual != null) stmtText.append(" ").append(qual);

      stmt.create(conn, stmtText.toString());
      stmt.execute();

      if (stmt.next()) val = stmt.getLongInteger(1);
      else val = 0;

      stmt.release();

      return val;

    } catch (Exception e) {
      DbSelectStatement.ensureRelease(stmt, e);
      throw e;
    }
  }
Esempio n. 16
0
  /**
   * Ejecuta la consulta que se le pasa
   *
   * @param conn
   * @param sql
   * @param rec
   * @throws Exception
   */
  public static void select(DbConnection conn, String sqlCompleta, DbOutputRecordSet rs)
      throws Exception {
    DbSelectStatement stmt = null;
    DbOutputRecord rec;
    try {
      stmt = new DbSelectStatement();
      stmt.create(conn, sqlCompleta);
      stmt.execute();

      int count = 0;
      while (stmt.next() && count++ < rs.getMaxNumItems()) {
        rec = rs.newRecord();
        rec.getStatementValues(stmt);
      }

      stmt.release();

    } catch (Exception e) {
      DbSelectStatement.ensureRelease(stmt, e);
    }
  }