pagesqlutil.java

日志管理源代码

package com.log.util;

public class PageSqlUtil { 

	public String getPageSql(String sql, int pageNum, int pageSize,
			int pageRowCount) throws Exception {

		String newSql = "";
		String querySql = sql.substring(0, sql.indexOf("order"));
		String order = sql.substring(sql.indexOf("order"), sql.length());

		String sqldescorder = this.changeSqlOrder(order);
		String sqla = "";
		String sqlb = "";

		sqla = "select top " + pageNum * pageSize + " * from (" + querySql
				+ ") tb " + order;
		sqla = "(" + sqla + " ) tb1 ";

		sqlb = "select top " + pageRowCount + " * from " + sqla + sqldescorder;
		
		newSql = "select * from (" + sqlb + ") tb2 " + order;

		return newSql;
	}

	/**
	 * 改变分页排序
	 * 
	 * @return String
	 */
	public String changeSqlOrder(String sqlorder) {
		String orderchanged = "";
		String[] strorder = null;
		strorder = sqlorder.split(",");
		if (strorder.length > 0) {
			for (int i = 0; i < strorder.length; i++) {
				if (strorder[i].length() < 3) {
					if (orderchanged.equals("")) {
						orderchanged = strorder[i] + " desc";
					} else {
						orderchanged = orderchanged + "," + strorder[i]
								+ " desc";
					}
				} else {
					if (strorder[i].substring(strorder[i].length() - 3,
							strorder[i].length()).equals("asc")) {
						if (orderchanged.equals("")) {
							orderchanged = strorder[i]
									.replaceAll("asc", "desc");
						} else {
							orderchanged = orderchanged + ","
									+ strorder[i].replaceAll("asc", "desc");
						}
					} else if (strorder[i].substring(strorder[i].length() - 3,
							strorder[i].length()).equals("esc")) {
						if (orderchanged.equals("")) {
							orderchanged = strorder[i]
									.replaceAll("desc", "asc");
						} else {
							orderchanged = orderchanged + ","
									+ strorder[i].replaceAll("desc", "asc");
						}
					} else {
						if (orderchanged.equals("")) {
							orderchanged = strorder[i] + " desc";
						} else {
							orderchanged = orderchanged + "," + strorder[i]
									+ " desc";
						}
					}
				}
			}
		}
		return orderchanged;
	}

	public static void main(String[] args) {
		
	}
}