splitpagesql.java

java开发的系统,主要用SS框架,以供大家研究和参考学习.

package com.fpms.wwyz.model.utils;

public class SplitPageSql {

	public static String splitPageSql(String sql, Page page,String order){
		
		StringBuffer selectBuff = new StringBuffer();
		if(page != null){
			int firArg = page.getPerPageNum();
			int seArg = page.getPageNo()*page.getPerPageNum();
			if(seArg > page.getMaxRowNum()){
				firArg=page.getMaxRowNum() - (page.getPageNo() - 1)*page.getPerPageNum();
			}
			selectBuff.append("select * from ( ");
			selectBuff.append("select top "+firArg+" * from ( ").append(
					"select top "+seArg+" * from ( ").append(sql).append(
					" ) as t1 order by "+order+" asc ").append(
					" ) as t2  order by "+order+" desc ").append(
					" ) as t3 order by "+order+" asc ");
		}else{
			selectBuff.append(sql);
		     }
	   return selectBuff.toString();
	   
	}
	
	
	
}