1.1、代码示例
package com.wondertek.oes.workbench.manage.repository.customize;
import com.google.common.collect.Lists;
import com.querydsl.core.QueryResults;
import com.querydsl.core.Tuple;
import com.querydsl.core.types.Predicate;
import com.querydsl.jpa.impl.JPAQuery;
import com.wondertek.oes.workbench.commons.enums.NodeResultEnum;
import com.wondertek.oes.workbench.commons.model.*;
import com.wondertek.oes.workbench.manage.vo.baseQuery.AssetInfoVo;
import com.wondertek.oes.workbench.manage.vo.baseQuery.AssetPageVo;
import com.wondertek.oes.workbench.manage.vo.baseQuery.McnRecordVo;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.PageImpl;
import org.springframework.data.domain.Pageable;
import org.springframework.stereotype.Repository;
import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import java.util.List;
@Repository
public class EnRepositoryCustomImpl implements EnRepositoryCustom {
@PersistenceContext
private EntityManager em;
@Override
public List<McnRecordVo> McnRecordInfo(Long groupId, Long programId) {
JPAQuery<McnRecordVo> query = new JPAQuery<>(em);
QMcnInfo m = QMcnInfo.mcnInfo;
QSubpInfo s = QSubpInfo.subpInfo;
QTask t = QTask.task;
QWorkGroup w = QWorkGroup.workGroup;
List<Tuple> list = query.select(
m.programId,
s.contentId,
m.assetId,
s.assetName,
m.disposeChannel,
m.endTime,
t.name,
m.url,
w.groupName)
.from(m)