pagerutil.java

自己写的一个struts+spring+hibernate测试程序

/*
 * Created on 2006-2-18
 */
package com.common.utils;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2006</p>
 * <p>Company: </p>
 * @author tommy.zeng
 * @version 1.0
 */
public class PagerUtil {
    /*
     * oracle 专用
     * @param sql
     * @param pageNo
     * @param pageSize
     * @return
     *
    public static String getPageSql(final String sql, int pageNo, int pageSize) {
        StringBuffer querySql = new StringBuffer();
        querySql.append(
            "select * from (select my_table.*,rownum as my_rownum from(")
            .append(sql)
            .append(") my_table where rownum<=").append(pageNo * pageSize)
            .append(") where my_rownum>").append((pageNo-1)*pageSize);
        return querySql.toString();
    }*/
	
	/**
     * mysql 专用
     * @param sql
     * @param pageNo
     * @param pageSize
     * @return
     */
	 public static String getPageSql(final String sql, int pageNo, int pageSize) {
	        StringBuffer querySql = new StringBuffer();
	        int startindex=(pageNo-1)*pageSize;
	        int maxperpage=pageSize;
	        //if(min<10)min=0;
	        
	        querySql.append(sql); 
	        querySql.append(" limit ").append(startindex);
	        querySql.append(",").append(maxperpage);
	        return querySql.toString();
	    }
    public static String getQueryCountSql(String sql) {
        int beginIdx = sql.toLowerCase().indexOf("select");
        int endIdx = sql.toLowerCase().indexOf("from");

        StringBuffer newSql = new StringBuffer(sql.length() + 10);
        
        if(beginIdx>=0 && endIdx >=0) {
          sql=sql.substring(endIdx);
          newSql.append("select count(*) as totalcnt ").append(sql);
       }

        //去除 order by语句 added by tommy 2005-12-01
       // int orderBy = newSql.toString().toLowerCase().indexOf("order by");
       // if(orderBy>0) {
        //  newSql.delete(orderBy-1,newSql.length());
       // }
        
     
        System.out.println(newSql.toString());
        return newSql.toString();

      }
/*    public static String getQueryCountSql(final String sql) {
        //int beginIdx = sql.toLowerCase().indexOf("select");
        //int endIdx = sql.toLowerCase().indexOf("from");

        StringBuffer newSql = new StringBuffer(sql.length() + 10);
        //if(beginIdx>=0 && endIdx >=0) {
          newSql.append("select count(*) as totalcnt from (  ").append(sql);
       // }

        //去除 order by语句 added by tommy 2005-12-01
       // int orderBy = newSql.toString().toLowerCase().indexOf("order by");
       // if(orderBy>0) {
        //  newSql.delete(orderBy-1,newSql.length());
       // }
        
        newSql.append(") ");

        return newSql.toString();

      }*/
}