SSM框架 用ajax实现模糊查询分页和列表

主要使用ajax实现模糊查询分页和列表 三者合一

1. jsp代码

<div class="pages"> <ul class="tcdPageCode tcdPageCode1" id="pagesert"></ul></div>
<script type="text/javascript">
//基础搜索等
 	 var thispage = 1;
	 submits(1,1);
	 function submits(page,examine){	
	     if(!arguments[0]) page = 1;
	     if(!arguments[1]) examine = 0;
	     $("#searchbase").ajaxSubmit({										
	 	type:'POST',
		url:"url路径?page="+page,
		data: {'status':1},
	 	beforeSubmit: function(){                    
	 	    window.index = layer.load(1);					
	 	},
	 	success: function(data){ 		
	 		dataarr = data.split("@#");		
	 		addContent(dataarr[1]);
	 	    $("#pagesert").html(dataarr[0]);
	 	    layer.close(window.index);
	 	    window.thispage = page;
	 	},
	 	resetForm: false,
	 	clearForm: false										
	    }); 
	}
	//添加分页内容
		function addContent(content){
		 	$("#contetss").html("");
		 	data =  eval('(' + content + ')');
			$.each(data, function(i, item) { 
				var compDatas = "<p><a class='wentihuifu' href='javascript:void(0);' onclick=\"helpss(\'"+item.id+"\')\">"+item.title+"<i>&gt;</i></a></p>";
		        $("#contetss").append(compDatas);
		    });
		}	
</script>

2. 控制层代码

/**
 * 模糊查询带分页
 * @param help
 * @param response
 */
@RequestMapping("gamestitle")
public void gamestitle(Help help,HttpServletResponse response){
		List<Help> titles = gamesService.titles(help);
		String pages = "";
		if(titles.size()>0){
			pages=ManyPages.getPageStyleOne(titles.get(0).getTotal(), help.getPage(), help.getDistance());
		}
		OutPrint.echo(response, pages+"@#"+JSON.toJSONString(titles).toString());
}

3. 两个实体

public class ManyPages {
	/**	 
	 * @param total:总数条数
	 * @param page:页码
	 * @param distance:每页显示数量
	 * @return
	 */
    public static String getPageStyleOne(int total,int page,int distance){
    	
    	int total_page = total%distance == 0 ? total/distance : (int)(total/distance)+1;
        int ppage = page-1<=0?1:page-1;
        int npage = page+1>total_page?1:page+1;
        String PageData = "<li class='pr_ne pali'><a href='javascript:submits("+ppage+",0)'>上一页</a></li>";  
        for(int i=1;i<=total_page;i++){ 
            if(i!=page&&i!=page+1&&i!=page-1&&i!=page+2) continue;
            String  onpage = i==page?"active":"";
            PageData += "<li class='pali panum page_hover "+onpage+"'><a href='javascript:submits("+i+",0)'>"+i+"</a></li>";
        }         
        PageData +=  "<li class='pr_ne pali'><a href='javascript:submits("+npage+",0)'>下一页</a></li>"+
                       "<li class='pali panone' style='background:none;border:none'><span style='display:inline-block;padding:5px 8px;background:none'>共"+total_page+"页</span><span style='display:inline-block;padding:5px 8px;background:none'>到第</span>"+
                       "<input type='text' class='panum' style='width:40px;padding:5px 7px' id='gotpage' />"+
                       "</li>"+
                       "<li class='pali'><a href=\"javascript:submits($('#gotpage').val(),0)\">确定</a></li>";                        
        return  PageData;     	    	
    }
}

public class PageBase{
	
    private int page ;
  
    private int distance;
  
    private int total;
    
    private int isPage;
    
    private int begen ;
    
    public PageBase(){ 
    	this.isPage = 1;
    	this.page = 1;
    	this.distance = 7;
    	this.begen = (this.page-1)*this.distance;
    }

	public int getPage() {		
		return page;
	}
	
	public void setPage(int page) {
		this.begen = (page-1)*this.distance;
		
		this.page = page;
	}
	
	public int getDistance() {
		return distance;
	}
	
	public void setDistance(int distance) {
		this.begen = (page-1)*distance;
		this.distance = distance;
	}
	
	public int getIsPage() {
		return isPage;
	}

	public void setIsPage(int isPage) {
		this.isPage = isPage;
	}

	public int getTotal() {
		return total;
	}

	public void setTotal(int total) {
		this.total = total;
	}

	public int getBegen() {
		return begen;
	}

	public void setBegen(int begen) {
		this.begen = begen;
	}
}

4. sql

<select id="titles" resultType="util">
  		select
  		id,title,date,photos,content
  		<if test="isPage != 0">
	  		,(select count(*) from gam_help where 1=1
	  		  <if test="title != null and title != ''">and title like concat(concat('%',#{title}),'%')</if>
	  		  ) as total  		 
  		</if>
  		from gam_help where 1=1 <if test="title != null and title != ''">and title like concat(concat('%',#{title}),'%')</if> 
  			order by date desc
  		<if test="isPage != 0">
		     limit #{begen},#{distance}
	    </if> 
  	</select>