Java Query类代码示例

import com.liferay.portal.kernel.dao.orm.Query; //导入依赖的package包/类
/**
 * Returns the number of dict collections.
 *
 * @return the number of dict collections
 */
@Override
public int countAll() {
	Long count = (Long)finderCache.getResult(FINDER_PATH_COUNT_ALL,
			FINDER_ARGS_EMPTY, this);

	if (count == null) {
		Session session = null;

		try {
			session = openSession();

			Query q = session.createQuery(_SQL_COUNT_DICTCOLLECTION);

			count = (Long)q.uniqueResult();

			finderCache.putResult(FINDER_PATH_COUNT_ALL, FINDER_ARGS_EMPTY,
				count);
		}
		catch (Exception e) {
			finderCache.removeResult(FINDER_PATH_COUNT_ALL,
				FINDER_ARGS_EMPTY);

			throw processException(e);
		}
		finally {
			closeSession(session);
		}
	}

	return count.intValue();
}
 

import com.liferay.portal.kernel.dao.orm.Query; //导入依赖的package包/类
/**
 * Returns the number of votings.
 *
 * @return the number of votings
 */
@Override
public int countAll() {
	Long count = (Long)finderCache.getResult(FINDER_PATH_COUNT_ALL,
			FINDER_ARGS_EMPTY, this);

	if (count == null) {
		Session session = null;

		try {
			session = openSession();

			Query q = session.createQuery(_SQL_COUNT_VOTING);

			count = (Long)q.uniqueResult();

			finderCache.putResult(FINDER_PATH_COUNT_ALL, FINDER_ARGS_EMPTY,
				count);
		}
		catch (Exception e) {
			finderCache.removeResult(FINDER_PATH_COUNT_ALL,
				FINDER_ARGS_EMPTY);

			throw processException(e);
		}
		finally {
			closeSession(session);
		}
	}

	return count.intValue();
}
 

import com.liferay.portal.kernel.dao.orm.Query; //导入依赖的package包/类
/**
 * Returns the number of voting results.
 *
 * @return the number of voting results
 */
@Override
public int countAll() {
	Long count = (Long)finderCache.getResult(FINDER_PATH_COUNT_ALL,
			FINDER_ARGS_EMPTY, this);

	if (count == null) {
		Session session = null;

		try {
			session = openSession();

			Query q = session.createQuery(_SQL_COUNT_VOTINGRESULT);

			count = (Long)q.uniqueResult();

			finderCache.putResult(FINDER_PATH_COUNT_ALL, FINDER_ARGS_EMPTY,
				count);
		}
		catch (Exception e) {
			finderCache.removeResult(FINDER_PATH_COUNT_ALL,
				FINDER_ARGS_EMPTY);

			throw processException(e);
		}
		finally {
			closeSession(session);
		}
	}

	return count.intValue();
}
 

import com.liferay.portal.kernel.dao.orm.Query; //导入依赖的package包/类
/**
 * Returns the number of dict items.
 *
 * @return the number of dict items
 */
@Override
public int countAll() {
	Long count = (Long)finderCache.getResult(FINDER_PATH_COUNT_ALL,
			FINDER_ARGS_EMPTY, this);

	if (count == null) {
		Session session = null;

		try {
			session = openSession();

			Query q = session.createQuery(_SQL_COUNT_DICTITEM);

			count = (Long)q.uniqueResult();

			finderCache.putResult(FINDER_PATH_COUNT_ALL, FINDER_ARGS_EMPTY,
				count);
		}
		catch (Exception e) {
			finderCache.removeResult(FINDER_PATH_COUNT_ALL,
				FINDER_ARGS_EMPTY);

			throw processException(e);
		}
		finally {
			closeSession(session);
		}
	}

	return count.intValue();
}
 

import com.liferay.portal.kernel.dao.orm.Query; //导入依赖的package包/类
/**
 * Returns the number of dict item groups.
 *
 * @return the number of dict item groups
 */
@Override
public int countAll() {
	Long count = (Long)finderCache.getResult(FINDER_PATH_COUNT_ALL,
			FINDER_ARGS_EMPTY, this);

	if (count == null) {
		Session session = null;

		try {
			session = openSession();

			Query q = session.createQuery(_SQL_COUNT_DICTITEMGROUP);

			count = (Long)q.uniqueResult();

			finderCache.putResult(FINDER_PATH_COUNT_ALL, FINDER_ARGS_EMPTY,
				count);
		}
		catch (Exception e) {
			finderCache.removeResult(FINDER_PATH_COUNT_ALL,
				FINDER_ARGS_EMPTY);

			throw processException(e);
		}
		finally {
			closeSession(session);
		}
	}

	return count.intValue();
}
 

import com.liferay.portal.kernel.dao.orm.Query; //导入依赖的package包/类
/**
 * Returns the number of dict groups.
 *
 * @return the number of dict groups
 */
@Override
public int countAll() {
	Long count = (Long)finderCache.getResult(FINDER_PATH_COUNT_ALL,
			FINDER_ARGS_EMPTY, this);

	if (count == null) {
		Session session = null;

		try {
			session = openSession();

			Query q = session.createQuery(_SQL_COUNT_DICTGROUP);

			count = (Long)q.uniqueResult();

			finderCache.putResult(FINDER_PATH_COUNT_ALL, FINDER_ARGS_EMPTY,
				count);
		}
		catch (Exception e) {
			finderCache.removeResult(FINDER_PATH_COUNT_ALL,
				FINDER_ARGS_EMPTY);

			throw processException(e);
		}
		finally {
			closeSession(session);
		}
	}

	return count.intValue();
}
 

import com.liferay.portal.kernel.dao.orm.Query; //导入依赖的package包/类
/**
 * Returns the number of comments.
 *
 * @return the number of comments
 */
@Override
public int countAll() {
	Long count = (Long)finderCache.getResult(FINDER_PATH_COUNT_ALL,
			FINDER_ARGS_EMPTY, this);

	if (count == null) {
		Session session = null;

		try {
			session = openSession();

			Query q = session.createQuery(_SQL_COUNT_COMMENT);

			count = (Long)q.uniqueResult();

			finderCache.putResult(FINDER_PATH_COUNT_ALL, FINDER_ARGS_EMPTY,
				count);
		}
		catch (Exception e) {
			finderCache.removeResult(FINDER_PATH_COUNT_ALL,
				FINDER_ARGS_EMPTY);

			throw processException(e);
		}
		finally {
			closeSession(session);
		}
	}

	return count.intValue();
}
 

import com.liferay.portal.kernel.dao.orm.Query; //导入依赖的package包/类
/**
 * Returns the number of regions.
 *
 * @return the number of regions
 */
@Override
public int countAll() {
	Long count = (Long)finderCache.getResult(FINDER_PATH_COUNT_ALL,
			FINDER_ARGS_EMPTY, this);

	if (count == null) {
		Session session = null;

		try {
			session = openSession();

			Query q = session.createQuery(_SQL_COUNT_REGION);

			count = (Long)q.uniqueResult();

			finderCache.putResult(FINDER_PATH_COUNT_ALL, FINDER_ARGS_EMPTY,
				count);
		}
		catch (Exception e) {
			finderCache.removeResult(FINDER_PATH_COUNT_ALL,
				FINDER_ARGS_EMPTY);

			throw processException(e);
		}
		finally {
			closeSession(session);
		}
	}

	return count.intValue();
}
 

import com.liferay.portal.kernel.dao.orm.Query; //导入依赖的package包/类
/**
 * Returns the number of countries.
 *
 * @return the number of countries
 */
@Override
public int countAll() {
	Long count = (Long)finderCache.getResult(FINDER_PATH_COUNT_ALL,
			FINDER_ARGS_EMPTY, this);

	if (count == null) {
		Session session = null;

		try {
			session = openSession();

			Query q = session.createQuery(_SQL_COUNT_COUNTRY);

			count = (Long)q.uniqueResult();

			finderCache.putResult(FINDER_PATH_COUNT_ALL, FINDER_ARGS_EMPTY,
				count);
		}
		catch (Exception e) {
			finderCache.removeResult(FINDER_PATH_COUNT_ALL,
				FINDER_ARGS_EMPTY);

			throw processException(e);
		}
		finally {
			closeSession(session);
		}
	}

	return count.intValue();
}
 

import com.liferay.portal.kernel.dao.orm.Query; //导入依赖的package包/类
/**
 * Returns the number of foos.
 *
 * @return the number of foos
 */
@Override
public int countAll() {
	Long count = (Long)finderCache.getResult(FINDER_PATH_COUNT_ALL,
			FINDER_ARGS_EMPTY, this);

	if (count == null) {
		Session session = null;

		try {
			session = openSession();

			Query q = session.createQuery(_SQL_COUNT_FOO);

			count = (Long)q.uniqueResult();

			finderCache.putResult(FINDER_PATH_COUNT_ALL, FINDER_ARGS_EMPTY,
				count);
		}
		catch (Exception e) {
			finderCache.removeResult(FINDER_PATH_COUNT_ALL,
				FINDER_ARGS_EMPTY);

			throw processException(e);
		}
		finally {
			closeSession(session);
		}
	}

	return count.intValue();
}
 

import com.liferay.portal.kernel.dao.orm.Query; //导入依赖的package包/类
/**
 * Returns the number of applications.
 *
 * @return the number of applications
 * @throws SystemException if a system exception occurred
 */
@Override
public int countAll() throws SystemException {
	Long count = (Long)FinderCacheUtil.getResult(FINDER_PATH_COUNT_ALL,
			FINDER_ARGS_EMPTY, this);

	if (count == null) {
		Session session = null;

		try {
			session = openSession();

			Query q = session.createQuery(_SQL_COUNT_APPLICATION);

			count = (Long)q.uniqueResult();

			FinderCacheUtil.putResult(FINDER_PATH_COUNT_ALL,
				FINDER_ARGS_EMPTY, count);
		}
		catch (Exception e) {
			FinderCacheUtil.removeResult(FINDER_PATH_COUNT_ALL,
				FINDER_ARGS_EMPTY);

			throw processException(e);
		}
		finally {
			closeSession(session);
		}
	}

	return count.intValue();
}
 

import com.liferay.portal.kernel.dao.orm.Query; //导入依赖的package包/类
/**
 * Returns the number of dossier doc2 templates.
 *
 * @return the number of dossier doc2 templates
 * @throws SystemException if a system exception occurred
 */
@Override
public int countAll() throws SystemException {
	Long count = (Long)FinderCacheUtil.getResult(FINDER_PATH_COUNT_ALL,
			FINDER_ARGS_EMPTY, this);

	if (count == null) {
		Session session = null;

		try {
			session = openSession();

			Query q = session.createQuery(_SQL_COUNT_DOSSIERDOC2TEMPLATE);

			count = (Long)q.uniqueResult();

			FinderCacheUtil.putResult(FINDER_PATH_COUNT_ALL,
				FINDER_ARGS_EMPTY, count);
		}
		catch (Exception e) {
			FinderCacheUtil.removeResult(FINDER_PATH_COUNT_ALL,
				FINDER_ARGS_EMPTY);

			throw processException(e);
		}
		finally {
			closeSession(session);
		}
	}

	return count.intValue();
}
 

import com.liferay.portal.kernel.dao.orm.Query; //导入依赖的package包/类
/**
 * Returns the number of a h subscriptions.
 *
 * @return the number of a h subscriptions
 * @throws SystemException if a system exception occurred
 */
@Override
public int countAll() throws SystemException {
    Long count = (Long) FinderCacheUtil.getResult(FINDER_PATH_COUNT_ALL,
            FINDER_ARGS_EMPTY, this);

    if (count == null) {
        Session session = null;

        try {
            session = openSession();

            Query q = session.createQuery(_SQL_COUNT_AHSUBSCRIPTION);

            count = (Long) q.uniqueResult();

            FinderCacheUtil.putResult(FINDER_PATH_COUNT_ALL,
                FINDER_ARGS_EMPTY, count);
        } catch (Exception e) {
            FinderCacheUtil.removeResult(FINDER_PATH_COUNT_ALL,
                FINDER_ARGS_EMPTY);

            throw processException(e);
        } finally {
            closeSession(session);
        }
    }

    return count.intValue();
}
 

import com.liferay.portal.kernel.dao.orm.Query; //导入依赖的package包/类
/**
 * Returns the number of doc files.
 *
 * @return the number of doc files
 * @throws SystemException if a system exception occurred
 */
@Override
public int countAll() throws SystemException {
	Long count = (Long)FinderCacheUtil.getResult(FINDER_PATH_COUNT_ALL,
			FINDER_ARGS_EMPTY, this);

	if (count == null) {
		Session session = null;

		try {
			session = openSession();

			Query q = session.createQuery(_SQL_COUNT_DOCFILE);

			count = (Long)q.uniqueResult();

			FinderCacheUtil.putResult(FINDER_PATH_COUNT_ALL,
				FINDER_ARGS_EMPTY, count);
		}
		catch (Exception e) {
			FinderCacheUtil.removeResult(FINDER_PATH_COUNT_ALL,
				FINDER_ARGS_EMPTY);

			throw processException(e);
		}
		finally {
			closeSession(session);
		}
	}

	return count.intValue();
}
 

import com.liferay.portal.kernel.dao.orm.Query; //导入依赖的package包/类
/**
 * Returns the number of dossier proc bookmarks.
 *
 * @return the number of dossier proc bookmarks
 * @throws SystemException if a system exception occurred
 */
@Override
public int countAll() throws SystemException {
	Long count = (Long)FinderCacheUtil.getResult(FINDER_PATH_COUNT_ALL,
			FINDER_ARGS_EMPTY, this);

	if (count == null) {
		Session session = null;

		try {
			session = openSession();

			Query q = session.createQuery(_SQL_COUNT_DOSSIERPROCBOOKMARK);

			count = (Long)q.uniqueResult();

			FinderCacheUtil.putResult(FINDER_PATH_COUNT_ALL,
				FINDER_ARGS_EMPTY, count);
		}
		catch (Exception e) {
			FinderCacheUtil.removeResult(FINDER_PATH_COUNT_ALL,
				FINDER_ARGS_EMPTY);

			throw processException(e);
		}
		finally {
			closeSession(session);
		}
	}

	return count.intValue();
}