1.引入相关依赖
com.baomidou mybatis-plus-boot-starter ${mybatisplus.version} org.projectlombok lombok true
2.我们以查询省份疫情数据,数量为例做一个echarts疫情数据填充
NameNumber.java
@Data@AllArgsConstructor@NoArgsConstructorpublic class NameNumber { @JsonProperty("value") //echarts 要求返回的名称,要不封装不上数据 private int number; @JsonProperty("name") //echarts 要求返回的名称,要不封装不上数据 private String goodsname;}
3.PieVo.java 用来返回json数据的实体,里面装着List<NameNumber>
@Data@NoArgsConstructor@AllArgsConstructorpublic class PieVo { private ListnameNumberList;}
4.EchartsController.java
@RestController@RequestMapping("/echarts")public class EchartsController { @Autowired PieMapper pieMapper; @RequestMapping("/pie") public PieVo loadAll(){ PieVo pieVo = new PieVo(); ListpieVoList = pieMapper.findNameNumber(); pieVo.setNameNumberList(pieVoList); return pieVo; }}
5.PieMapper.java
@Mapperpublic interface PieMapper { @Select("select goodsname,number from bus_goods") public ListfindNameNumber();}
6.echarts中国疫情地图页面
Title