jeecgboot多表联合查询

在数据大屏中需要多表联合查询的业务处理，而Jeecgboot提供的生成工具只能满足最普遍的简单代码，mybatis-plus框架使用的QueryWrapper显然无法满足多表联合查询，需要重写API接口。

1.新建返回对象的实体类

import lombok.Data; @Data public class Vendorcount {     private Integer vendor;     private Integer material; }

2.mapper层接口

public interface VendorcountMapper extends BaseMapper<Vendorcount> {     List<Vendorcount> pageByVendor(); }

3.xml中写入sql

<select id="pageByVendor" resultType="org.jeecg.modules.demo.vendorquery.entity.Vendorcount">         select count(DISTINCT material13.Vendor) as vendor,count(DISTINCT material13.Material) as material         from material13 INNER JOIN stock on material13.Vendor=stock.create_by and material13.Plant=stock.plant         and material13.Material=stock.partno </select>

4.service接口

public interface IVendorcountService extends IService<Vendorcount> {     List<Vendorcount> pageByVendorService(); }

5.serviceImpl

@Service public class VendorcountServiceImpl extends ServiceImpl<VendorcountMapper, Vendorcount> implements IVendorcountService {     @Autowired     private VendorcountMapper vendorcountMapper;     @Override     public List<Vendorcount> pageByVendorService() {         return vendorcountMapper.pageByVendor();     } }

6.control层

@Api(tags = "供应商查询") @RestController @RequestMapping("/Vendorcount/vendorcount") @Slf4j public class VendorcountController extends JeecgController<Vendorcount, IVendorcountService> {     @Autowired     private IVendorcountService vendorcountService;     @AutoLog(value = "供应商查询-统计个数")     @ApiOperation(value = "供应商查询-统计个数", notes = "供应商查询-统计个数")     @GetMapping(value = "/list")     public Result<?> queryVendor(HttpServletRequest req) {         List<Vendorcount> pageList = vendorcountService.pageByVendorService();         return Result.ok(pageList);     } }

7.Shiro配置

// 配置不会被拦截的链接 filterChainDefinitionMap.put("/Vendorcount/vendorcount/**", "anon"); //

8.调试API接口

9.前端定时调用接口刷新数据

getAction("/Vendorcount/vendorcount/list").then((res) => {     if (res.success) {       let a = res.result       this.titleItem[0].number.number = [a[0]["material"]]       this.titleItem[1].number.number = [a[0]["vendor"]]       this.titleItem = {         ...this.titleItem       }       this.show = false       this.$nextTick(() => {         this.show = true       })

大屏展示