第一步:先获取到参数 (id)
//控制层
@Autowired
DemoDemoService demoDemoService ;
public Page listData(DemoDemoEntity demoDemoEntity , HttpServletRequest request, HttpServletResponse response) {
String id=demoEntity.getId();
Page page=new Page<>(request,response);
psge.setPageSize(10);
page=demoDemoService .findfage(id);
return page;}
//业务层
@Autowired
DemoDao demoDao;
public Page findfage(String id){
Page page=new Page<>();
List list=new List<>();
//这里需要对id进行判断是否为blank,注意不是null
if(StringUtils.isBlank(id)){
list =demoDao.findAll();
}else{
list =demoDao.findOne(id);
}
page.setList(list); //根据查询结果封装类型,也可以是map型
return page;
}
//数据层
@Select(select * from demo group by xxx)
List findAll();
List findOne(@Param(id)String id); [email protected]
//xml文件内
select a.id,count(create_time) as demoTimes from demo a
a.id=#{id}
GROUP BY a.id
原文:https://www.cnblogs.com/pureray-hui/p/12784497.html