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

    throws SQLException {
    
    DBSubset oCats = new DBSubset (DB.k_categories+" c, "+DB.k_cat_tree+" t",
                       DB.nm_category,
                       "c."+DB.gu_category+"=t."+DB.gu_child_cat+" AND t."+DB.gu_parent_cat+"=?", 10);
  int iCats = oCats.load(oConn, new Object[]{getMailRoot(oConn)});
  String[] aRetVal = new String[iCats];
  for (int c=0; c<iCats; c++) aRetVal[c] = oCats.getString(0,c);
  return aRetVal;
  } // getMailFolderNames

View Full Code Here

        oStmt.close();
        Category.delete(oConn, sGuRootCat);
      }


      oCats = new DBSubset(DB.k_categories, DB.gu_category, DB.gu_owner + "=?", 10);
      iCats = oCats.load(oConn, new Object[]{sUserGUID});


      for (int r=0; r<iCats; r++)
         Category.delete(oConn, oCats.getString(0,r));


      oCats = null;

View Full Code Here

    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));

View Full Code Here

    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));

View Full Code Here

    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));

View Full Code Here

    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));

View Full Code Here

    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));

View Full Code Here

    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));

View Full Code Here

    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));

View Full Code Here

    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));

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.