19771978197919801981198219831984198519861987
Session session = null; try { session = openSession(); Query q = session.createQuery(sql); if (!pagination) { list = (List<LFCertificateSite>) QueryUtil.list(q, getDialect(), start, end, false);
20352036203720382039204020412042204320442045
Session session = null; try { session = openSession(); Query q = session.createQuery(_SQL_COUNT_LFCERTIFICATESITE); count = (Long) q.uniqueResult(); FinderCacheUtil.putResult(FINDER_PATH_COUNT_ALL, FINDER_ARGS_EMPTY, count);
310311312313314315316317318319320
Session session = null; try { session = openSession(); Query q = session.createQuery(sql); QueryPos qPos = QueryPos.getInstance(q); if (certificateID != null) { qPos.add(certificateID.intValue());
649650651652653654655656657658659
800801802803804805806807808809810
12741275127612771278127912801281128212831284
Session session = null; try { session = openSession(); Query q = session.createQuery(sql); QueryPos qPos = QueryPos.getInstance(q); if (certificateIDs != null) { for (Integer certificateID : certificateIDs) {
13781379138013811382138313841385138613871388
14731474147514761477147814791480148114821483
308309310311312313314315316317318
Session session = null; try { session = openSession(); Query q = session.createQuery(sql); QueryPos qPos = QueryPos.getInstance(q); if (bindTincanID) { if (tincanID != null) {
419420421422423424425426427428429