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

   */
  public DBSubset getObjects(JDCConnection oConn) throws SQLException {
    DBSubset oObjs = new DBSubset(DB.k_x_cat_objs, DB.gu_object + "," + DB.id_class + "," + DB.bi_attribs,            
                         DB.gu_category + "=? ORDER BY " + DB.od_position, 64);


    oObjs.load(oConn, new Object[]{getString(DB.gu_category)});


    return oObjs;
  } // getObjects


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

View Full Code Here

    } else {
      oObjs = new DBSubset(DB.k_x_cat_objs, DB.gu_object + "," + DB.id_class + "," + DB.bi_attribs,
                 DB.id_class+"=? AND "+DB.gu_category + "=? ORDER BY " + DB.od_position, 64);
    }


    oObjs.load(oConn, new Object[]{new Short(iClassId), getString(DB.gu_category)});


    return oObjs;
  } // getObjectsOfClass


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

View Full Code Here

                   "p."+Gadgets.replace(oProd.getTable(oConn).getColumnsStr(),",",",p."),
                   "x."+DB.gu_object+"=p."+DB.gu_product+" AND "+
                  "x."+DB.id_class+"="+String.valueOf(Product.ClassId)+" AND x."+DB.gu_category + "=? "+sOrderClause, 64);
    } catch (Exception neverthrown) {}


    oProds.load(oConn, new Object[]{getString(DB.gu_category)});
    int nProds = oProds.getRowCount();
    if (0!=nProds) {
    aProds = new Product[nProds];
    for (int p=0; p<nProds; p++) {
      aProds[p] = new Product();

View Full Code Here


    oObjs = null;


    if (DBBind.exists(oConn, DB.k_mime_msgs, "U")) {
      oObjs = new DBSubset(DB.k_mime_msgs, DB.gu_mimemsg, DB.gu_category + "='" + sCategoryGUID + "'", 1000);
      iObjs = oObjs.load(oConn);


      if (oConn.getDataBaseProduct()==JDCConnection.DBMS_POSTGRESQL) {
        PreparedStatement oDlte = oConn.prepareStatement("SELECT k_sp_del_mime_msg(?)");
        ResultSet oRSet;
        for (int m=0; m<iObjs; m++) {

View Full Code Here

   * @since 3.0
   */
  public BugAttachment[] attachments(JDCConnection oConn)
    throws SQLException {
    DBSubset oAttachs = new DBSubset(DB.k_bugs_attach, DB.tx_file+","+DB.len_file, DB.gu_bug+"=?", 10);
    int iAttachs = oAttachs.load(oConn, new Object[]{getString(DB.gu_bug)});
    if (0==iAttachs)
      return null;
    else {
      BugAttachment[] aAttachs = new BugAttachment[iAttachs];
      for (int a=0; a<iAttachs; a++)

View Full Code Here

    throws SQLException {
    BugChangeLog[] aBcl;
    DBSubset oLog = new DBSubset(DB.k_bugs_changelog,
                                 DB.gu_bug+","+DB.pg_bug+","+DB.nm_column+","+DB.dt_modified+","+DB.gu_writer+","+DB.tx_oldvalue,
                                 DB.gu_bug+"=? ORDER BY 4", 10);
    int iLog = oLog.load(oConn, new Object[]{getString(DB.gu_bug)});
    if (0==iLog) {
      aBcl = null;
    } else {
      aBcl = new BugChangeLog[iLog];
      for (int l=0; l<iLog; l++) {

View Full Code Here

    throws SQLException {
    BugChangeLog[] aBcl;
    DBSubset oLog = new DBSubset(DB.k_bugs_changelog,
                                 DB.gu_bug+","+DB.pg_bug+","+DB.nm_column+","+DB.dt_modified+","+DB.gu_writer+","+DB.tx_oldvalue,
                                 DB.gu_bug+"=? AND "+DB.nm_column+"=? ORDER BY 4", 10);
    int iLog = oLog.load(oConn, new Object[]{getString(DB.gu_bug), sColumnName});
    if (0==iLog) {
      aBcl = null;
    } else {
      aBcl = new BugChangeLog[iLog];
      for (int l=0; l<iLog; l++) {

View Full Code Here

    throws SQLException {
    BugTrack[] aTrk;
    DBSubset oTrk = new DBSubset(DB.k_bugs_track,
                                 DB.gu_bug+","+DB.pg_bug_track+","+DB.dt_created+","+DB.nm_reporter+","+DB.tx_rep_mail+","+DB.gu_writer+","+DB.tx_bug_track,
                                 DB.gu_bug+"=? ORDER BY 2 DESC", 20);
    int iTrk = oTrk.load(oConn, new Object[]{getString(DB.gu_bug)});
    if (0==iTrk) {
      aTrk = null;
    } else {
      aTrk = new BugTrack[iTrk];
      for (int l=0; l<iTrk; l++) {

View Full Code Here

                       "p."+DB.gu_product+",p."+DB.id_ref,
                       "p."+DB.gu_product+"=l."+DB.gu_product+" AND "+
                       "p."+DB.gu_owner+"=? AND "+
                       "l."+DB.gu_quotation + "=?", 50);
     
     int nProdCount = oProdDetail.load(oConn, new Object[]{getString(DB.gu_workarea),getString(DB.gu_quotation)});
     
     for (int p=0; p<nProdCount; p++) {
       int l = oLines.find(9, oProdDetail.get(0,p));
       if (!oProdDetail.isNull(1,p)) {
         oLines.setElementAt(oProdDetail.get(1,p),13,l);

View Full Code Here

  } // removeProduct
  
  public Product[] getProducts (JDCConnection oConn) throws SQLException {
    Product[] aProds;
    DBSubset oProds = new DBSubset(DB.k_products,"*","gu_product=? ORDER BY "+DB.pg_prod_locat,10);
    int nProds = oProds.load(oConn, new Object[]{getString(DB.gu_product)});
    if (0==nProds) {
      aProds = null;
    } else {
      aProds = new Product[nProds];
      for (int p=0; p<nProds; p++) {

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.