JSP page
SQL incoming MAP, need to use ${}, cannot use #{ }<select id= "Findallbycountname" parametertype= "Java.util.Map" resulttype= "bean . Chuhuodan "> <!--select * from Chuhuodan WHERE siji like '% sheet% ' ORDER by createtime DESC limit 0,5;--&G T * from Chuhuodan WHERE Siji like ${mohuname} ORDER by createtime DESC limit ${pagenum},${pagesize}< c8/></select>
Serviceimpl layer @Override public list<chuhuodan> findallbycountname (String Mohuname, Integer pagenum, integer pageSize) { mohuname= "'%" +mohuname+ "% '"; System.out.println (mohuname); " Mohuname ", mohuname); " Pagenum " , pagenum); " PageSize ", pageSize); return chuhuodanmapper.findallbycountname (map); }
Controller layer @RequestMapping ("Findchuhuodanbycountname") Publicstring Findchuhuodanbycountname (model model, string mohuname, @RequestParam (Value= "Pagenum", defaultvalue = "1") Integer pagenum, @RequestParam (value= "PageSize", DefaultValue = "5") (Integer pageSize) {if(pagenum==0) {Pagenum=1; } Count=Chuhuodanservice.findcount (); Limitpage= (int) Math.ceil (Count/pageSize); Allch= Chuhuodanservice.findallbycountname (Mohuname, (pageNum-1) *pageSize, pageSize); Model.addattribute ("Mohuname", Mohuname); Model.addattribute ("List", Allch); Model.addattribute ("Pagenum", Pagenum); Model.addattribute ("FirstPage", 1); Model.addattribute ("LastPage", Limitpage); return"Show.jsp"; }
Map parameter fuzzy query in SQL limit paging