mysqlpagesqlhelper.java

来自「文件上传用例,纯sql分页源码,有用的着地方请下载 试用」· Java 代码 · 共 41 行

package org.derrick.jdbc.page.sql;
/**
 * 
 * @author 刘冬宝Oct 26, 2006
   版权申明：所有人员均可自由修改源码并再发布，但必须保留此相关信息
 *
 */
public class MysqlPageSqlHelper extends PageSqlHelper {


    public MysqlPageSqlHelper() {
		super();
	}

	public MysqlPageSqlHelper(int recordnumPerPage, String fieldClause, String conditionClause) {
		super(recordnumPerPage, fieldClause, conditionClause);
		}

	/**
     * 返回用于获取第几页的sql，页号从一开始记数
     */
    protected String buildPageSql(int pageNo) {
        StringBuffer sqlBuffer = new StringBuffer("select ");
        sqlBuffer.append(this.getFieldClause());
        sqlBuffer.append(" from ");
        sqlBuffer.append(this.getConditionClause());
        sqlBuffer.append(" order by ");
        sqlBuffer.append(this.getOrderByClause());
        sqlBuffer.append(" limit ");
        sqlBuffer.append((pageNo-1)*this.getRecordnumPerPage());
        sqlBuffer.append(",");
        sqlBuffer.append(this.getRecordnumPerPage());
        if (logger.isDebugEnabled()) {
            logger.debug("getPageSql(" + pageNo + "):" + sqlBuffer.toString());
        }
        return sqlBuffer.toString();
    }

   
}