Examples of com.knowgate.dataobjs.DBSubset

com.knowgate.dataobjs.DBSubset

A bidimensional array representing data readed from a database table.
The DBSubset object is used for reading a collection of registers from the database and kept them in memory for inmediate access. As hipergate reuses database connections by recycling them at the {@link JDCConnectionPool}, it is a good programming practice to read just the needed number of registers in a single step operation and then free the connection as soon as possible for being used by another processs. Another reason for this "read fast and leave" tactic is that some JDBC drivers have problems managing multiple open resultsets with pending results in a single connection. @author Sergio Montoro Ten @version 3.0

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


  public Contact[] getContacts(JDCConnection oConn)
    throws SQLException {
    Contact[] aContacts = null;
    DBSubset oBooks = new DBSubset(DB.k_x_course_bookings+" b,"+DB.k_contacts+" c",                  
                                   new Contact().getTable(oConn).getColumnsStr(),
                                   "b."+DB.gu_contact+"=c."+DB.gu_contact+" AND "+
                                   "b."+DB.gu_acourse+"=?",50);
    int nBooks = oBooks.load(oConn, new Object[]{get(DB.gu_acourse)});
    if (nBooks>0) {
      aContacts = new Contact[nBooks];
      for (int b=0; b<nBooks; b++) {
        aContacts[b] = new Contact();
        aContacts[b].putAll(oBooks.getRowAsMap(b));
      } // next
    } // fi


    return aContacts;
  } // getContacts

View Full Code Here

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


  public AcademicCourseAlumni[] getAlumni(JDCConnection oConn)
    throws SQLException {
    AcademicCourseAlumni[] aAlmni = null;
    DBSubset oAlmni = new DBSubset(DB.k_x_course_alumni,
                                   new AcademicCourseAlumni().getTable(oConn).getColumnsStr(),
                                   DB.gu_acourse+"=? ORDER BY "+DB.gu_alumni,50);
    int nBooks = oAlmni.load(oConn, new Object[]{get(DB.gu_acourse)});
    if (nBooks>0) {
      aAlmni = new AcademicCourseAlumni[nBooks];
      for (int b=0; b<nBooks; b++) {
        aAlmni[b] = new AcademicCourseAlumni();
        aAlmni[b].putAll(oAlmni.getRowAsMap(b));
      } // next
    } // fi


    return aAlmni;
  } // getAlumni

View Full Code Here

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


  public AcademicCourseBooking[] getAllBookings(JDCConnection oConn)
    throws SQLException {
    AcademicCourseBooking[] aBooks = null;
    DBSubset oBooks = new DBSubset(DB.k_x_course_bookings,
                                   new AcademicCourseBooking().getTable(oConn).getColumnsStr(),
                                   DB.gu_acourse+"=? ORDER BY "+DB.dt_created,50);
    int nBooks = oBooks.load(oConn, new Object[]{get(DB.gu_acourse)});
    if (nBooks>0) {
      aBooks = new AcademicCourseBooking[nBooks];
      for (int b=0; b<nBooks; b++) {
        aBooks[b] = new AcademicCourseBooking();
        aBooks[b].putAll(oBooks.getRowAsMap(b));
      } // next
    } // fi
    return aBooks;
  } // getAllBookings

View Full Code Here

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


  public AcademicCourseBooking[] getActiveBookings(JDCConnection oConn)
    throws SQLException {
    AcademicCourseBooking[] aBooks = null;
    DBSubset oBooks = new DBSubset(DB.k_x_course_bookings,
                                   new AcademicCourseBooking().getTable(oConn).getColumnsStr(),
                                   DB.gu_acourse+"=? AND "+DB.bo_canceled+"<>1 "+
                                   "ORDER BY "+DB.dt_created,50);
    int nBooks = oBooks.load(oConn, new Object[]{get(DB.gu_acourse)});
    if (nBooks>0) {
      aBooks = new AcademicCourseBooking[nBooks];
      for (int b=0; b<nBooks; b++) {
        aBooks[b] = new AcademicCourseBooking();
        aBooks[b].putAll(oBooks.getRowAsMap(b));
      } // next
    } // fi
    return aBooks;
  } // getActiveBookings

View Full Code Here

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


  public AcademicCourseBooking[] getCancelledBookings(JDCConnection oConn)
    throws SQLException {
    AcademicCourseBooking[] aBooks = null;
    DBSubset oBooks = new DBSubset(DB.k_x_course_bookings,
                                   new AcademicCourseBooking().getTable(oConn).getColumnsStr(),
                                   DB.gu_acourse+"=? AND "+DB.bo_canceled+"<>1 "+
                                   "ORDER BY "+DB.dt_created,50);
    int nBooks = oBooks.load(oConn, new Object[]{get(DB.gu_acourse)});
    if (nBooks>0) {
      aBooks = new AcademicCourseBooking[nBooks];
      for (int b=0; b<nBooks; b++) {
        aBooks[b] = new AcademicCourseBooking();
        aBooks[b].putAll(oBooks.getRowAsMap(b));
      } // next
    } // fi
    return aBooks;
  } // getCancelledBookings

View Full Code Here

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


  public AcademicCourseBooking[] getConfirmedBookings(JDCConnection oConn)
    throws SQLException {
    AcademicCourseBooking[] aBooks = null;
    DBSubset oBooks = new DBSubset(DB.k_x_course_bookings,
                                   new AcademicCourseBooking().getTable(oConn).getColumnsStr(),
                                   DB.gu_acourse+"=? AND "+DB.bo_confirmed+"<>0 "+
                                   "ORDER BY "+DB.dt_created,50);
    int nBooks = oBooks.load(oConn, new Object[]{get(DB.gu_acourse)});
    if (nBooks>0) {
      aBooks = new AcademicCourseBooking[nBooks];
      for (int b=0; b<nBooks; b++) {
        aBooks[b] = new AcademicCourseBooking();
        aBooks[b].putAll(oBooks.getRowAsMap(b));
      } // next
    } // fi
    return aBooks;
  } // getConfirmedBookings

View Full Code Here

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


  public AcademicCourseBooking[] getUnconfirmedBookings(JDCConnection oConn)
    throws SQLException {
    AcademicCourseBooking[] aBooks = null;
    DBSubset oBooks = new DBSubset(DB.k_x_course_bookings,
                                   new AcademicCourseBooking().getTable(oConn).getColumnsStr(),
                                   DB.gu_acourse+"=? AND "+DB.bo_confirmed+"<>1 "+
                                   "ORDER BY "+DB.dt_created,50);
    int nBooks = oBooks.load(oConn, new Object[]{get(DB.gu_acourse)});
    if (nBooks>0) {
      aBooks = new AcademicCourseBooking[nBooks];
      for (int b=0; b<nBooks; b++) {
        aBooks[b] = new AcademicCourseBooking();
        aBooks[b].putAll(oBooks.getRowAsMap(b));
      } // next
    } // fi
    return aBooks;
  } // getConfirmedBookings

View Full Code Here

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


  public AcademicCourseBooking[] getWaitingBookings(JDCConnection oConn)
    throws SQLException {
    AcademicCourseBooking[] aBooks = null;
    DBSubset oBooks = new DBSubset(DB.k_x_course_bookings,
                                   new AcademicCourseBooking().getTable(oConn).getColumnsStr(),
                                   DB.gu_acourse+"=? AND "+DB.bo_waiting+"<>0 "+
                                   "ORDER BY "+DB.dt_created,50);
    int nBooks = oBooks.load(oConn, new Object[]{get(DB.gu_acourse)});
    if (nBooks>0) {
      aBooks = new AcademicCourseBooking[nBooks];
      for (int b=0; b<nBooks; b++) {
        aBooks[b] = new AcademicCourseBooking();
        aBooks[b].putAll(oBooks.getRowAsMap(b));
      } // next
    } // fi
    return aBooks;
  } // getWaitingBookings

View Full Code Here

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


  public AcademicCourseBooking[] getPaidBookings(JDCConnection oConn)
    throws SQLException {
    AcademicCourseBooking[] aBooks = null;
    DBSubset oBooks = new DBSubset(DB.k_x_course_bookings,
                                   new AcademicCourseBooking().getTable(oConn).getColumnsStr(),
                                   DB.gu_acourse+"=? AND "+DB.bo_paid+"<>0 "+
                                   "ORDER BY "+DB.dt_created,50);
    int nBooks = oBooks.load(oConn, new Object[]{get(DB.gu_acourse)});
    if (nBooks>0) {
      aBooks = new AcademicCourseBooking[nBooks];
      for (int b=0; b<nBooks; b++) {
        aBooks[b] = new AcademicCourseBooking();
        aBooks[b].putAll(oBooks.getRowAsMap(b));
      } // next
    } // fi
    return aBooks;
  } // getPaidBookings

View Full Code Here

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


  public AcademicCourseBooking[] getUnpaidBookings(JDCConnection oConn)
    throws SQLException {
    AcademicCourseBooking[] aBooks = null;
    DBSubset oBooks = new DBSubset(DB.k_x_course_bookings,
                                   new AcademicCourseBooking().getTable(oConn).getColumnsStr(),
                                   DB.gu_acourse+"=? AND "+DB.bo_paid+"<>1 "+
                                   "ORDER BY "+DB.dt_created,50);
    int nBooks = oBooks.load(oConn, new Object[]{get(DB.gu_acourse)});
    if (nBooks>0) {
      aBooks = new AcademicCourseBooking[nBooks];
      for (int b=0; b<nBooks; b++) {
        aBooks[b] = new AcademicCourseBooking();
        aBooks[b].putAll(oBooks.getRowAsMap(b));
      } // next
    } // fi
    return aBooks;
  } // getUnpaidBookings

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of com.knowgate.dataobjs.DBSubset

com.knowgate.acl.ACLDomain

com.knowgate.acl.ACLGroup

com.knowgate.acl.ACLUser

com.knowgate.addrbook.DayPlan

com.knowgate.addrbook.jical.ICalendarFactory

com.knowgate.addrbook.Meeting

com.knowgate.addrbook.MonthPlan

com.knowgate.addrbook.WeekPlan

com.knowgate.addrbook.WorkingCalendar

com.knowgate.crm.Company

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.