Examples of com.knowgate.dataobjs.DBSubset.load()

com.knowgate.dataobjs.DBSubset.load()

Execute a JDBC Statement and load query ResultSet in an internal bidimensional matrix
@param oConn Database Connection @return Number of rows retrievedthe maximum number of rows to be retrieved is determined by calling method setMaxRows(), if setMaxRows() is not called before call() then all rows existing are retrieved. @throws SQLException

        DB.k_rooms+" r",
        new Room().getTable(oConn).getColumnsStr(),
        "r."+DB.id_domain+"=? AND r."+DB.gu_workarea+"=? AND "+
        "EXISTS (SELECT x."+DB.nm_room+" FROM "+DB.k_x_meeting_room+" x WHERE x."+DB.nm_room+"=r."+DB.nm_room+" AND x."+DB.gu_meeting+" IN (SELECT "+DB.gu_meeting+" FROM "+DB.k_meetings+" WHERE "+DB.id_domain+"=? AND "+DB.gu_workarea+"=? AND "+DB.dt_start+" BETWEEN ? AND ?))"+
        " ORDER BY "+DB.nm_room, 10);
      nRooms = oRooms.load(oConn, new Object[]{oDomainId,sWorkAreaGuid,oDomainId,sWorkAreaGuid,dtFirst,dtLast});
    } // fi
    if (0==nRooms) {
      aRooms = null;
    } else {
      aRooms = new Room[nRooms];

View Full Code Here

      oAddresses = new DBSubset (
        DB.k_addresses+" a",
        new Address().getTable(oConn).getColumnsStr(),
        "EXISTS (SELECT m."+DB.gu_address+" FROM "+DB.k_meetings+" m WHERE m."+DB.gu_address+"=a."+DB.gu_address+" AND m."+DB.id_domain+"=? AND m."+DB.dt_start+" BETWEEN ? AND ?)",
        10);
      nAddresses = oAddresses.load(oConn, new Object[]{oDomainId,dtFirst,dtLast});
    } else {
      oAddresses = new DBSubset (
        DB.k_addresses+" a",
        new Address().getTable(oConn).getColumnsStr(),
        "EXISTS (SELECT m."+DB.gu_address+" FROM "+DB.k_meetings+" m WHERE m."+DB.gu_address+"=a."+DB.gu_address+" AND m."+DB.id_domain+"=? AND m."+DB.gu_workarea+"=? AND m."+DB.dt_start+" BETWEEN ? AND ?)",

View Full Code Here

      oAddresses = new DBSubset (
        DB.k_addresses+" a",
        new Address().getTable(oConn).getColumnsStr(),
        "EXISTS (SELECT m."+DB.gu_address+" FROM "+DB.k_meetings+" m WHERE m."+DB.gu_address+"=a."+DB.gu_address+" AND m."+DB.id_domain+"=? AND m."+DB.gu_workarea+"=? AND m."+DB.dt_start+" BETWEEN ? AND ?)",
        10);
      nAddresses = oAddresses.load(oConn, new Object[]{oDomainId,sWorkAreaGuid,dtFirst,dtLast});
    } // fi
    if (0==nAddresses) {
      aAddresses = null;
    } else {
      aAddresses = new Address[nAddresses];

View Full Code Here

   */
  public DBSubset getGroups(JDCConnection oConn) throws SQLException {
    Object aContact[] = { get(DB.gu_contact) };
    DBSubset oGroups = new DBSubset(DB.k_x_group_contact,DB.gu_acl_group,DB.gu_contact + "=?",10);


    oGroups.load (oConn, aContact);
    return oGroups;
  } // getGroups


  // ----------------------------------------------------------

View Full Code Here

    Address oAddr = new Address();


    DBSubset oAddrs = new DBSubset (DB.k_addresses,
                                    oAddr.getTable(oConn).getColumnsStr(),
                                    DB.gu_address + " IN (SELECT " + DB.gu_address +  " FROM " + DB.k_x_contact_addr + " WHERE " + DB.gu_contact + "='" + getString(DB.gu_contact) + "')", 10);
    int iAddrs = oAddrs.load (oConn);


    oAddr = null;


    if (DebugFile.trace) {
      DebugFile.decIdent();

View Full Code Here


    DBSubset oAccs = new DBSubset (DB.k_bank_accounts,
                                   DB.nu_bank_acc+","+DB.dt_created+","+DB.bo_active+","+DB.tp_account+","+DB.nm_bank+","+DB.tx_addr+","+DB.nm_cardholder+","+DB.nu_card+","+DB.tp_card+","+DB.tx_expire+","+DB.nu_pin+","+DB.nu_cvv2+","+DB.im_credit_limit+","+DB.de_bank_acc,
                                   DB.gu_workarea+"=? AND "+DB.nu_bank_acc+" IN (SELECT "+DB.nu_bank_acc+" FROM "+DB.k_x_contact_bank+" WHERE "+DB.gu_workarea+"=? AND "+DB.gu_contact+"=?)",10);


    oAccs.load(oConn, new Object[]{get(DB.gu_workarea),get(DB.gu_workarea),get(DB.gu_contact)});
    return oAccs;
  } // getAllBankAccounts


  // ----------------------------------------------------------

View Full Code Here


    DBSubset oAccs = new DBSubset (DB.k_bank_accounts,
                                   DB.nu_bank_acc+","+DB.dt_created+","+DB.tp_account+","+DB.nm_bank+","+DB.tx_addr+","+DB.nm_cardholder+","+DB.nu_card+","+DB.tp_card+","+DB.tx_expire+","+DB.nu_pin+","+DB.nu_cvv2+","+DB.im_credit_limit+","+DB.de_bank_acc,
                                   DB.gu_workarea+"=? AND "+DB.bo_active+"<>0 AND "+DB.nu_bank_acc+" IN (SELECT "+DB.nu_bank_acc+" FROM "+DB.k_x_contact_bank+" WHERE "+DB.gu_workarea+"=? AND "+DB.gu_contact+"=?)",10);


    oAccs.load(oConn, new Object[]{get(DB.gu_workarea),get(DB.gu_workarea),get(DB.gu_contact)});
    return oAccs;
  } // getActiveBankAccounts


  // ----------------------------------------------------------

View Full Code Here


    DBSubset oAccs = new DBSubset (DB.k_bank_accounts,
                                   DB.nu_bank_acc+","+DB.dt_created+","+DB.tp_account+","+DB.nm_bank+","+DB.tx_addr+","+DB.nm_cardholder+","+DB.nu_card+","+DB.tp_card+","+DB.tx_expire+","+DB.nu_pin+","+DB.nu_cvv2+","+DB.im_credit_limit+","+DB.de_bank_acc,
                                   DB.gu_workarea+"=? AND "+DB.bo_active+"=0 AND "+DB.nu_bank_acc+" IN (SELECT "+DB.nu_bank_acc+" FROM "+DB.k_x_contact_bank+" WHERE "+DB.gu_workarea+"=? AND "+DB.gu_company+"=?)",10);


    oAccs.load(oConn, new Object[]{get(DB.gu_workarea),get(DB.gu_workarea),get(DB.gu_contact)});
    return oAccs;
  } // getUnactiveBankAccounts


  // ----------------------------------------------------------

View Full Code Here

    Attachment oAttach = new Attachment();
    Attachment[] aAttachs;
    DBSubset oAttachs = new DBSubset(DB.k_contact_attachs,
                                     oAttach.getTable(oConn).getColumnsStr(),
                                     DB.gu_contact+"=?", 10);
    int iAttachs = oAttachs.load(oConn, new Object[]{get(DB.gu_contact)});
    if (0==iAttachs) {
      aAttachs = null;
    } else {
      aAttachs = new Attachment[iAttachs];
      ListIterator oCols = oAttach.getTable(oConn).getColumns().listIterator();

View Full Code Here


    /* Borrar los pedidos, si existen */
    if (DBBind.exists(oConn, DB.k_orders, "U")) {
      DBSubset oOrders = new DBSubset(DB.k_orders, DB.gu_order, DB.gu_contact + "='" + sContactGUID + "'", 1000);


      int iOrders = oOrders.load(oConn);


      for (int o=0; o<iOrders; o++)
        com.knowgate.hipergate.Order.delete (oConn, oOrders.getString(0,o));
    } // fi (exists(DB.k_orders))

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.