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

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

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

View Full Code Here

                                   DB.sn_passport+",u."+DB.tp_passport+",u."+
                                   DB.tx_comments,
                                   "x."+DB.gu_acl_group + "=? AND "+
                                   "x."+DB.gu_user+"=u."+DB.gu_user,10);


    oUsers.load (oConn, aGroup);
    return oUsers;
  } // getACLUsers


  // **********************************************************
  // Metodos Estaticos

View Full Code Here

    DBSubset oCalendarsByUser = new DBSubset(DB.k_working_calendar + " c",
                        oWCal.getTable(oConn).getColumnsStr(),
                            DB.gu_workarea+"=? AND "+DB.id_domain+"=? AND "+
                            DB.gu_user+" IS NOT NULL ORDER BY "+DB.nm_calendar, 100);
          
    oCalendarsByUser.load(oConn, new Object[]{new Integer(iDomainId),sWorkAreaId});
    return oCalendarsByUser;
  } // byUser


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

View Full Code Here

    DBSubset oCalendarsByCountry = new DBSubset(DB.k_working_calendar + " c",
                          oWCal.getTable(oConn).getColumnsStr()+", NULL AS nm_country",
                              DB.gu_workarea+"=? AND "+DB.id_domain+"=? AND "+
                              DB.id_country+" IS NOT NULL", 50);
          
    int nCals = oCalendarsByCountry.load(oConn, new Object[]{new Integer(iDomainId),sWorkAreaId});
    PreparedStatement oStmt = oConn.prepareStatement("SELECT "+sTrCol+" FROM "+DB.k_lu_countries+" WHERE "+DB.id_country+"=?",
                             ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
    for (int c=0; c<nCals; c++) {
    oStmt.setString(1, oCalendarsByCountry.getString(DB.id_country,c));
    ResultSet oRSet = oStmt.executeQuery();

View Full Code Here

    DBSubset oCalendarsByState = new DBSubset(DB.k_working_calendar + " c",
                        oWCal.getTable(oConn).getColumnsStr()+", NULL AS "+DB.nm_state,
                            DB.gu_workarea+"=? AND "+DB.id_domain+"=? AND "+
                            DB.id_country+"=? AND "+DB.id_state+" IS NOT NULL", 50);
          
    int nCals = oCalendarsByState.load(oConn, new Object[]{new Integer(iDomainId),sWorkAreaId,sCountryId});
    PreparedStatement oStmt = oConn.prepareStatement("SELECT "+DB.nm_state+" FROM "+DB.k_lu_states+" WHERE "+DB.id_country+"='"+sCountryId+"' AND "+DB.id_state+"=?",
                             ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
    for (int c=0; c<nCals; c++) {
    oStmt.setString(1, oCalendarsByState.getString(DB.id_state,c));
    ResultSet oRSet = oStmt.executeQuery();

View Full Code Here

                        "c."+DB.gu_calendar+",c."+DB.gu_acl_group+",c."+DB.gu_user+",c."+DB.gu_geozone+",c."+DB.id_country+",c."+DB.id_state,
                          "c."+DB.gu_workarea+"=? AND c."+DB.id_domain+"=? AND "+
                        "(c."+DB.gu_user+"=? OR EXISTS (SELECT g."+DB.gu_acl_group+" FROM "+DB.k_x_group_user+" g WHERE g."+DB.gu_acl_group+"=c."+DB.gu_acl_group+" AND g."+DB.gu_user+"=?)) AND "+
                        "(c."+DB.dt_from+" BETWEEN ? AND ? OR c."+DB.dt_to+" BETWEEN ? AND ? OR (c."+DB.dt_from+"<=? AND c."+DB.dt_to+">=?)) "+
                        "ORDER BY c."+DB.dt_from, 4);
    int nCals = oGroupCalendars.load(oConn, new Object[]{oUser.get(DB.gu_workarea),oUser.get(DB.id_domain),
                                                         sUserId, sUserId,
                                                         tmFrom,tmTo,tmFrom,tmTo,tmFrom,tmTo});
    if (0==nCals) {
      oRetCal = null;
    } else {

View Full Code Here

        new Fellow().getTable(oConn).getColumnsStr(),
        "f."+DB.id_domain+"=? AND ("+
        "EXISTS (SELECT m."+DB.gu_fellow+" FROM "+DB.k_meetings+" m WHERE m."+DB.gu_fellow+"=f."+DB.gu_fellow+" AND m."+DB.dt_start+" BETWEEN ? AND ?) OR "+
        "EXISTS (SELECT x."+DB.gu_fellow+" FROM "+DB.k_x_meeting_fellow+" x WHERE x."+DB.gu_fellow+"=f."+DB.gu_fellow+" AND x."+DB.dt_start+" BETWEEN ? AND ?))"+
        " ORDER BY "+DB.tx_name+","+DB.tx_surname, 10);
      nFellows = oFellows.load(oConn, new Object[]{oDomainId,dtFirst,dtLast,dtFirst,dtLast});
    } else {
      oFellows = new DBSubset (
        DB.k_fellows+" f",
        new Fellow().getTable(oConn).getColumnsStr(),
        "f."+DB.id_domain+"=? AND f."+DB.gu_workarea+"=? AND ("+

View Full Code Here

        new Fellow().getTable(oConn).getColumnsStr(),
        "f."+DB.id_domain+"=? AND f."+DB.gu_workarea+"=? AND ("+
        "EXISTS (SELECT m."+DB.gu_fellow+" FROM "+DB.k_meetings+" m WHERE m."+DB.gu_fellow+"=f."+DB.gu_fellow+" AND m."+DB.dt_start+" BETWEEN ? AND ?) OR "+
        "EXISTS (SELECT x."+DB.gu_fellow+" FROM "+DB.k_x_meeting_fellow+" x WHERE x."+DB.gu_fellow+"=f."+DB.gu_fellow+" AND x."+DB.dt_start+" BETWEEN ? AND ?))"+
        " ORDER BY "+DB.tx_name+","+DB.tx_surname, 10);
      nFellows = oFellows.load(oConn, new Object[]{oDomainId,sWorkAreaGuid,dtFirst,dtLast,dtFirst,dtLast});
    } // fi
    if (0==nFellows) {
      aFellows = null;
    } else {
      aFellows = new Fellow[nFellows];

View Full Code Here

        DB.k_rooms+" r",
        new Room().getTable(oConn).getColumnsStr(),
        "r."+DB.id_domain+"=? 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.dt_start+" BETWEEN ? AND ?))"+
        " ORDER BY "+DB.nm_room, 10);
      nRooms = oRooms.load(oConn, new Object[]{oDomainId,oDomainId,dtFirst,dtLast});
    } else {
      oRooms = new DBSubset (
        DB.k_rooms+" r",
        new Room().getTable(oConn).getColumnsStr(),
        "r."+DB.id_domain+"=? AND r."+DB.gu_workarea+"=? AND "+

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.