Examples of com.knowgate.dataobjs.DBPersist

com.knowgate.dataobjs.DBPersist

Core class for persisting Java objects as registers in a RDMS.

Althought not an abstract class, DBPersist is mainly designed to be inherited by a child class implementing specific behavior for reading a writting a Java object from and to a relational database.

DBPersist mantains an internal collection of values each one mapped to a database field.
This mapping is done automatically by DBPersist reading the target table metadata definition and preparing the proper internal value set.

This object keeps the internal value set in memory as long as it is not garbage collected, but it does not mantaing any session information nor transaction management with the database. It is the programmer's responsability to pass an open database connection on each method call and to commit or rollback transaction involving the usage of a DBPersist object. @author Sergio Montoro Ten @version 6.0


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


  public static DBSubset byUser(JDCConnection oConn, int iDomainId, String sWorkAreaId)
    throws SQLException,NullPointerException {
    DBPersist oWCal = new DBPersist(DB.k_working_calendar,"WorkingCalendar");
    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;

View Full Code Here


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


  public static DBSubset byCountry(JDCConnection oConn, int iDomainId, String sWorkAreaId, String sLanguage)
    throws SQLException,NullPointerException {
    DBPersist oWCal = new DBPersist(DB.k_working_calendar,"WorkingCalendar");
    DBPersist oCntr = new DBPersist(DB.k_lu_countries,"Countries");
    String sTrCol;
    if (oCntr.getTable(oConn).getColumnsStr().indexOf(DB.tr_+sLanguage)>=0)
      sTrCol = DB.tr_+"country_"+sLanguage;
    else
      sTrCol = DB.tr_+"country_"+"en";


    DBSubset oCalendarsByCountry = new DBSubset(DB.k_working_calendar + " c",

View Full Code Here


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


  public static DBSubset byState(JDCConnection oConn, int iDomainId, String sWorkAreaId, String sCountryId)
    throws SQLException,NullPointerException {
    DBPersist oWCal = new DBPersist(DB.k_working_calendar,"WorkingCalendar");
    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+"=?",

View Full Code Here

0 1 2

TOP

Related Classes of com.knowgate.dataobjs.DBPersist

com.knowgate.addrbook.WorkingCalendar

com.knowgate.crm.ListMember

com.knowgate.hipergate.AbstractOrder

com.knowgate.hipergate.QueryByForm

com.knowgate.hipergate.SalePoint

com.knowgate.hipergate.Warehouse

com.knowgate.hipermail.DBInetAddr

com.knowgate.hipermail.SendMail

com.knowgate.http.HttpDataObjsServlet

com.knowgate.projtrack.ProjectSnapshot

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.