testmysqlpagesqlhelper.java.svn-base

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

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

    public TestMysqlPageSqlHelper(String name) {
        super(name);

    }

    protected void setUp() throws Exception {
        super.setUp();
        this.helper = new MysqlPageSqlHelper();
    }

    protected void tearDown() throws Exception {
        super.tearDown();
        helper = null;
    }

    protected void checkFirstPageSql() {
        String expectSql = "select a.id,a.name from pageDemo a where a.id >5 order by a.id asc limit 0,10";
        String actualSql = this.helper.getPageSql(1);
        logger.debug("expectSql:" + expectSql);
        assertEquals(expectSql, actualSql);
    }

    protected void checkLastPageSql() {
        String expectSql = "select a.id,a.name from pageDemo a where a.id >5 order by a.id asc limit 40,10";
        String actualSql = this.helper.getPageSql(5);
        logger.debug("expectSql:" + expectSql);
        assertEquals(expectSql, actualSql);
    }

    protected void checkMiddlePageSql() {
        String expectSql = "select a.id,a.name from pageDemo a where a.id >5 order by a.id asc limit 20,10";
        String actualSql = this.helper.getPageSql(3);
        logger.debug("expectSql:" + expectSql);
        assertEquals(expectSql, actualSql);
    }

}