java 多表连接查询模板实现类

最新推荐文章于 2023-09-14 14:46:42 发布

moty2011

最新推荐文章于 2023-09-14 14:46:42 发布

阅读量293

点赞数

分类专栏： java 文章标签： java hibernate 开发语言

本文链接：https://blog.csdn.net/moty2011/article/details/124610493

版权

package com.mes.em.service.common.impl;

import cn.hutool.core.collection.CollUtil;
import cn.hutool.core.util.StrUtil;
import com.alibaba.fastjson.JSONArray;
import com.mes.em.service.common.FactoryService;
import com.mes.em.dto.common.Condition;
import com.mes.em.dto.common.JoinPocoInfos;
import com.mes.em.dto.common.SqlParams;
import org.hibernate.SQLQuery;
import org.hibernate.Session;
import org.hibernate.query.NativeQuery;
import org.hibernate.query.Query;
import org.hibernate.transform.Transformers;
import org.springframework.stereotype.Service;

import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import java.io.Serializable;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;

/**
 * @Title:
 * @Description:
 * @Author 
 * @Date 2021/12/20 15:19
 */
@Service
public class FactoryServiceImpl<T extends Serializable> implements FactoryService<T> {

    @PersistenceContext
    private EntityManager entityManager;

    @Override
    public List<T> selectFactoryHql(String hql, List<SqlParams<Long>> sqlParams, List<Condition> conList, Class<T> cls) {

        Session session = (Session) entityManager.getDelegate();
        Query<T> hqlQuery = session.createQuery(hql, cls);
        if (null != sqlParams) {
            sqlParams.forEach(e -> {