testoraclepagesqlhelper.java

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

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

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

	}

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

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

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

	protected void checkLastPageSql() {
		String expectSql = "select * from (select rownum row_id, id,name "
				+ "from ( select  a.id,a.name from pageDemo a where a.id >5 order by a.id asc))"
				+ "where row_id between 41 and 50";
		String actualSql = this.helper.getPageSql(5);
		logger.debug("expectSql:" + expectSql);
		assertEquals(expectSql, actualSql);
	}

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

}