code: public String forPaginate(int pageNumber, int pageSize, StringBuilder findSql) {
  		int end = pageNumber * pageSize;
  		if (end <= 0) {
  			end = pageSize;
  		}
  		int begin = (pageNumber - 1) * pageSize;
  		if (begin < 0) {
  			begin = 0;
  		}
  		StringBuilder ret = new StringBuilder();
  		ret.append("SELECT * FROM ( SELECT row_number() over (order by tempcolumn) temprownumber, * FROM ");
  		ret.append(" ( SELECT TOP ").append(end).append(" tempcolumn=0,");
  		ret.append(findSql.toString().replaceFirst("(?i)select", ""));
  		ret.append(")vip)mvp where temprownumber>").append(begin);
  		return ret.toString();
  	}
docs: sql.replaceFirst("(?i)select", "") 正则中带有 "(?i)" 前缀，指定在匹配时不区分大小写