Package org.springframework.orm.hibernate3

Examples of org.springframework.orm.hibernate3.HibernateTemplate.find()

25
26
27
28
29
30
31
32
33
34
35
    return null;
  }
 
  public List getProductSpecialOffer(String productCode) {
    HibernateTemplate t = new HibernateTemplate(getSessionFactory());
    return t.find("from "+ SpecialOffer.class.getName()+" so fetch all properties where so.relatedPrice.product.code = ? and so.validUntil>=? and so.enabled=1 and so.maxSubscription > so.counter.value", new Object[]{productCode, new Long(System.currentTimeMillis())});
  }
 
    /* (non-Javadoc)
     * @see org.jayasoft.woj.portal.data.dao.hibernate.DefaultHibernateWOJDao#newHandledObject()
     */
 
View Full Code Here
48
49
50
51
52
53
54
55
    public void fetch(WOJObject o) throws DaoException {
    }

    public List getAllSpecialOffer() {
        HibernateTemplate t = new HibernateTemplate(getSessionFactory());
        return t.find("from "+ SpecialOffer.class.getName()+" so fetch all properties where so.validUntil>=? and so.enabled=1 and so.maxSubscription > so.counter.value", new Object[]{new Long(System.currentTimeMillis())});
    }
}
View Full Code Here
16
17
18
19
20
21
22
23
24
25
26
        super(helper, Price.class);
    }
   
    public List getAllPriceForProduct(String productCode) {
        HibernateTemplate t = new HibernateTemplate(getSessionFactory());
        return t.find("from "+ Price.class.getName()+" price  where price.product.code = ? and price.enabled=1 order by price.minimunUser asc", new Object[]{productCode});
    }

    public Price getPrice(String productCode, int nbUsers, int nbYears) {
    HibernateTemplate t = new HibernateTemplate(getSessionFactory());
    Integer users = new Integer(nbUsers);
View Full Code Here
23
24
25
26
27
28
29
30
31
32
33
    public Price getPrice(String productCode, int nbUsers, int nbYears) {
    HibernateTemplate t = new HibernateTemplate(getSessionFactory());
    Integer users = new Integer(nbUsers);
    Integer years = new Integer(nbYears);
    List result = t.find("select distinct price from "+ Price.class.getName()+" price ,"+Product.class.getName()+" product where price.product.code = ? and price.minimunUser<=? and price.maximunUser>=? and price.durationInYear<=? and price.enabled=1 order by price.durationInYear desc", new Object[]{productCode, users, users, years});
    if(result != null && result.size()>0) {
      return (Price) result.get(0);
    }
    return null;
  }
View Full Code Here
216
217
218
219
220
221
222
223
224
225
226
        for (final Class< ? > cls : HibernateEntities.instance().getDescOrderedHistoryEntities()) {
          final String name = cls.getName();
          deleteFrom(hibernateTemplate, name);
          log.debug("deleteFrom: " + name);
        }
        List< ? > all = hibernateTemplate.find("from java.lang.Object o");
        if (all != null && all.size() > 0) {
          all = hibernateTemplate.find("from java.lang.Object o");
          assertEquals("Database should be empty", 0, all.size());
          testConfiguration.setInitialized(false);
          // logEnd();
View Full Code Here
218
219
220
221
222
223
224
225
226
227
228
          deleteFrom(hibernateTemplate, name);
          log.debug("deleteFrom: " + name);
        }
        List< ? > all = hibernateTemplate.find("from java.lang.Object o");
        if (all != null && all.size() > 0) {
          all = hibernateTemplate.find("from java.lang.Object o");
          assertEquals("Database should be empty", 0, all.size());
          testConfiguration.setInitialized(false);
          // logEnd();
        }
        return null;
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.