jeecg框架的高级查询界面如下
后台代码:
controller层:
@GetMapping(value = "/list")public Result<IPage<Receiver>> queryPageList(Receiver receiver,@RequestParam(name="pageNo", defaultValue="1") Integer pageNo,@RequestParam(name="pageSize", defaultValue="10") Integer pageSize,HttpServletRequest req) {QueryWrapper<Receiver> queryWrapper = QueryGenerator.initQueryWrapper(receiver, req.getParameterMap());Page<Receiver> page = new Page<Receiver>(pageNo, pageSize);IPage<Receiver> pageList = receiverService.getPage(page,queryWrapper);return Result.OK(pageList);}
service:
Iservice:IPage<Receiver> getPage(Page<Receiver> page, QueryWrapper<Receiver> queryWrapper);Service:@Overridepublic IPage<Receiver> getPage(Page<Receiver> page,QueryWrapper<Receiver> queryWrapper) {List<Receiver> list = receiverMapper.getPage(page,queryWrapper);return page.setRecords(list);}
Mapper:
Mapper:
List<Receiver> getPage(Page<Receiver> page,@Param(Constants.WRAPPER) QueryWrapper<Receiver> queryWrapper);xml:
<select id="getPage" resultType="org.entity.Receiver">SELECT t.*FROM(SELECT pr.*,u.realname AS name,m.mobile FROM receiver prLEFT JOIN sys_user u ON pr.user_id = u.idLEFT JOIN member m ON pr.member_id = m.idWHERE pr.tenant_id = 0 AND pr.del_flag = "0")AS t ${ew.customSqlSegment}</select>