Action层
@RequestMapping(value = "/adback/adManager.do")
public String page(Model model, HttpServletRequest request, Integer currPage) {
PageModel page = new PageModel();
page.setPageNumber(10);
if (currPage != null) {
page.setCurrentNumber(currPage);
}
Map param = new HashMap();
param.put("adState", request.getParameter("adState"));
if (StringUtil.isEntity(request.getParameter("siteName"))) {
param.put("siteName", request.getParameter("siteName"));
}
if (StringUtil.isEntity(request.getParameter("adClient"))) {
param.put("adClient", request.getParameter("adClient"));
}
if (StringUtil.isEntity(request.getParameter("adSite"))) {
param.put("adSite", request.getParameter("adSite"));
}
page = adService.queryPage(param, page);
model.addAttribute("page", page);
model.addAttribute("param", param);
model.addAttribute("requestUrl", "adManager.do");
return "/adback/adManager";
}
实现层
@Override
public PageModel queryPage(Map param, PageModel page) {
param.put("limitStart", page.getLimitStart());
param.put("limitEnd", page.getLimitEnd());
List> result = myAdMapper.queryAd(param);
int count = myAdMapper.queryAdCount(param);
page.setResult(result);
page.setCountNumber(count);
return page;
}
[/size][size=x-small][size=small][/size] 持久层 List> queryAd(Map param); Integer queryAdCount(Map param); select count(*) as totalcount from ad_point a, ad b where b.point_id=a.id and a.site_name=#{siteName} and b.ad_client like concat('%',#{adClient},'%') and a.site_remark like concat('%',#{adSite},'%') and b.state=#{adState}
522

被折叠的 条评论
为什么被折叠?



