com.cyssxt.common.basedao.util

Class QueryUtil

java.lang.Object

com.cyssxt.common.basedao.util.QueryUtil

public class QueryUtil
extends Object

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static interface	QueryUtil.Parameter

Constructor Summary

Constructors

Constructor and Description
QueryUtil()

Method Summary

Modifier and Type	Method and Description
static Long	count(String sql, javax.persistence.EntityManager manager, QueryUtil.Parameter parameter)
static <T> List<T>	selectList(javax.persistence.EntityManager entityManager, String sql, QueryUtil.Parameter parameter, Class clazz)
static <T> ListResult<T>	selectList(javax.persistence.EntityManager entityManager, String sql, QueryUtil.Parameter parameter, KeyTransformer keyTransformer)
static <T> ListResult<T>	selectList(javax.persistence.EntityManager entityManager, String sql, QueryUtil.Parameter parameter, KeyTransformer keyTransformer, int offset, int length)
static <T> T	selectOne(javax.persistence.EntityManager entityManager, String sql, QueryUtil.Parameter parameter, KeyTransformer keyTransformer)
static <T> PageResponse<T>	selectPage(javax.persistence.EntityManager entityManager, String sql, QueryUtil.Parameter parameter, PageReq pageReq, Class clazz)
static <T> PageResult<T>	selectPage(javax.persistence.EntityManager entityManager, String sql, QueryUtil.Parameter parameter, PageReq pageReq, KeyTransformer transformer)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

QueryUtil

public QueryUtil()

Method Detail

selectList

public static <T> ListResult<T> selectList(javax.persistence.EntityManager entityManager,
                                           String sql,
                                           QueryUtil.Parameter parameter,
                                           KeyTransformer keyTransformer)
                                    throws ValidException

Throws:

ValidException

selectList

public static <T> ListResult<T> selectList(javax.persistence.EntityManager entityManager,
                                           String sql,
                                           QueryUtil.Parameter parameter,
                                           KeyTransformer keyTransformer,
                                           int offset,
                                           int length)
                                    throws ValidException

Throws:

ValidException

selectList

public static <T> List<T> selectList(javax.persistence.EntityManager entityManager,
                                     String sql,
                                     QueryUtil.Parameter parameter,
                                     Class clazz)
                              throws ValidException

Throws:

ValidException

selectPage

public static <T> PageResult<T> selectPage(javax.persistence.EntityManager entityManager,
                                           String sql,
                                           QueryUtil.Parameter parameter,
                                           PageReq pageReq,
                                           KeyTransformer transformer)
                                    throws ValidException

Throws:

ValidException

selectPage

public static <T> PageResponse<T> selectPage(javax.persistence.EntityManager entityManager,
                                             String sql,
                                             QueryUtil.Parameter parameter,
                                             PageReq pageReq,
                                             Class clazz)
                                      throws ValidException

Throws:

ValidException

selectOne

public static <T> T selectOne(javax.persistence.EntityManager entityManager,
                              String sql,
                              QueryUtil.Parameter parameter,
                              KeyTransformer keyTransformer)
                       throws ValidException

Throws:

ValidException

count

public static Long count(String sql,
                         javax.persistence.EntityManager manager,
                         QueryUtil.Parameter parameter)