hibernate自定义查询

最新推荐文章于 2024-04-18 03:43:49 发布

天下武功无坚不摧唯快不破

最新推荐文章于 2024-04-18 03:43:49 发布

阅读量293

点赞数 1

文章标签： hibernate java

本文链接：https://blog.csdn.net/qq296861734/article/details/124548527

版权

public PageData getPageData(String sql, Integer page, Integer pageSize,Map<String,Object> paramMap, Class resultClass) {
        NativeQuery countQuery = getSession().createNativeQuery("select count(*) from (" + sql + ")tmp");
        NativeQuery nativeQuery = getSession().createNativeQuery(sql);

        for(Entry<String, Object> entry : paramMap.entrySet()) {
            Object val=entry.getValue();
            countQuery.setParameter(entry.getKey(), val);
            nativeQuery.setParameter(entry.getKey(), val);
        }

        int count = ((BigInteger) countQuery.uniqueResult()).intValue();

        if (count == 0) {
            return new PageData<T>(page, 0, pageSize, new ArrayList<T>());
        }

        //设置开始位置（下标从0开始）
        nativeQuery.setFirstResult((page - 1) * pageSize);
        //这是偏移量，就是一页展示几条数据
        nativeQuery.setMaxResults(pageSize);
        // 封装成指定对象列表
        nativeQuery.unwrap(NativeQueryImpl.class).setResultTransformer(Transformers.aliasToBean(resultClass));
        return new PageData<>(page, count, pageSize, nativeQuery.list());
    }

public List list(String sql, Map<String,Object> paramMap, Class resultClass) {
        NativeQuery nativeQuery = getSession().createNativeQuery(sql);
        for(Entry<String, Object> entry : paramMap.entrySet()) {
            Object val=entry.getValue();
            nativeQuery.setParameter(entry.getKey(), val);
        }
        if(Objects.isNull(resultClass)){
            return nativeQuery.list();
        }
        nativeQuery.unwrap(NativeQueryImpl.class).setResultTransformer(Transformers.aliasToBean(resultClass));
        return nativeQuery.list();
    }