一、多表关联分页查询 Tuple ,实体类此处忽略
(1)、service
public PagedResult<DrugDosageDTO> getDrugDosageInfoList(String wssdm, String key, Integer pageNum, Integer pageSize) {
JPAQueryFactory jpaQueryFactory = new JPAQueryFactory(entityManager);
QDrugDosageDO qDrugDosageDO = QDrugDosageDO.drugDosageDO;
QYkYpkDO qYkYpkDO = QYkYpkDO.ykYpkDO;
BooleanBuilder builder = new BooleanBuilder();
if (StringUtils.isNotBlank(key)) {
builder.or(qYkYpkDO.ypmc.like("%".concat(key).concat("%")));
builder.or(qYkYpkDO.ypdm.like("%".concat(key).concat("%")));
}
if (StringUtils.isNotBlank(wssdm)) {
builder.and(qYkYpkDO.wssdm.eq(wssdm));
}
Short zt = 0;
builder.and(qYkYpkDO.zt.eq(zt));
QueryResults<Tuple> jpaQuery = jpaQueryFactory.select(qDrugDosageDO, qYkYpkDO)
.from(qYkY