testmssqlpagesqlhelper.java.svn-base

文件上传用例,纯sql分页源码,有用的着地方请下载 试用

package org.derrick.jdbc.page.sql;

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

  
    public TestMssqlPageSqlHelper(String name) {
        super(name);
    }

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

    protected void tearDown() throws Exception {
        super.tearDown();
        helper = null;
    }
    
    protected void checkFirstPageSql() {
        String expectSql = "select top 10 * from "
                + "(select top 50 a.id,a.name from pageDemo a where a.id >5 order by a.id desc)"
                + " t order by t.id  asc";
        String actualSql = this.helper.getPageSql(1);
         logger.debug("expectSql:" + expectSql);
        assertEquals(expectSql, actualSql);
    }

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

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

}