Package com.jeecms.common.hibernate3

Examples of com.jeecms.common.hibernate3.Finder.createQuery()

72
73
74
75
76
77
78
79
80
81
82
    }
    if (before != null) {
      f.append(" and bean.time<=:before");
      f.setParam("before", before);
    }
    Query q = f.createQuery(getSession());
    return q.executeUpdate();
  }

  @Override
  protected Class<CmsLog> getEntityClass() {
View Full Code Here
241
242
243
244
245
246
247
248
249
250
251
      f.append(" and bean.id<:id");
      f.setParam("id", id);
      f.append(" and bean.status=" + ContentCheck.CHECKED);
      f.append(" order by bean.id desc");
    }
    Query query = f.createQuery(getSession());
    query.setCacheable(cacheable).setMaxResults(1);
    return (Content) query.uniqueResult();
  }

  @SuppressWarnings("unchecked")
View Full Code Here
51
52
53
54
55
56
57
58
59
60
61
    f.append(" order by bean.id asc");
    if (max != null) {
      f.setMaxResults(max);
    }
    Session session = getSession();
    ScrollableResults contents = f.createQuery(getSession()).setCacheMode(
        CacheMode.IGNORE).scroll(ScrollMode.FORWARD_ONLY);
    int count = 0;
    Content content = null;
    while (contents.next()) {
      content = (Content) contents.get(0);
View Full Code Here
170
171
172
173
174
175
176
177
178
179
180
    }
    if (endDate != null) {
      f.append(" and bean.accessTime <= :endDate");
      f.setParam("endDate", endDate);
    }
    Query query = f.createQuery(getSession());
    query.executeUpdate();
  }

  public long flowAnalysisTotal(Integer siteId) {
    Finder f = createCacheableFinder("select count(*) from CmsSiteFlow bean where bean.site.id=:siteId");
View Full Code Here
59
60
61
62
63
64
65
66
67
68
69
    } else if (siteId != null) {
      finder.append(" where bean.site.id=:siteId");
      finder.setParam("siteId", siteId);
    }
    Session session = getSession();
    ScrollableResults channels = finder.createQuery(session).setCacheMode(
        CacheMode.IGNORE).scroll(ScrollMode.FORWARD_ONLY);
    int count = 0;
    CmsSite site;
    Channel c;
    PageInfo info;
View Full Code Here
248
249
250
251
252
253
254
255
256
257
258
      f.append(" and bean.sortDate>=:start");
      f.setParam("start", start);
    }
    f.append(" and bean.status=" + ContentCheck.CHECKED);
    Session session = getSession();
    ScrollableResults contents = f.createQuery(session).setCacheMode(
        CacheMode.IGNORE).scroll(ScrollMode.FORWARD_ONLY);
    int count = 0;
    int totalPage;
    String url, real;
    File file, parent;
View Full Code Here
27
28
29
30
31
32
33
34
35
36
37
      f.append(" and bean.site.id=:siteId");
      f.setParam("siteId", siteId);
    }
    f.append(" and bean.def=true");
    f.setMaxResults(1);
    return (CmsVoteTopic) f.createQuery(getSession()).uniqueResult();
  }

  public CmsVoteTopic findById(Integer id) {
    CmsVoteTopic entity = get(id);
    return entity;
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.