CustomBaseSqlDaoImpl.java 文件源码

@SuppressWarnings("rawtypes")
public List queryByMapParams(String hql, Map<String, Object> params, Integer currentPage,Integer pageSize){
    //EntityManager em = this.emf.createEntityManager();
    Query query = em.createQuery(hql);
    List list = null;
    try {
        if(params != null && !params.isEmpty()){
            for(Map.Entry<String,Object> entry: params.entrySet()){
                query.setParameter(entry.getKey(), entry.getValue());
            }
        }

        if(currentPage != null && pageSize != null){
            query.setFirstResult((currentPage-1)*pageSize);
            query.setMaxResults(pageSize);
        }
        list = query.getResultList();
    } catch (Exception e) {
        e.printStackTrace();
    }finally{
        em.close();
    }

    return list;
}