testpagehelper.java.svn-base

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

package org.derrick.jdbc.page;

import java.util.List;

import junit.framework.TestCase;

import org.apache.commons.beanutils.DynaBean;
import org.apache.log4j.LogManager;
import org.apache.log4j.Logger;
import org.derrick.jdbc.page.sql.PageSqlHelper;
/**
 * 
 * @author 刘冬宝Oct 26, 2006
   版权申明：所有人员均可自由修改源码并再发布，但必须保留此相关信息
 *
 */
public abstract class TestPageHelper extends TestCase {
	protected final Logger logger = LogManager.getLogger(getClass());

    private PageSqlHelper helper = null;

    private DbToObject dbToObject = null;

    private PageHelper pageHelper = null;

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

    protected void setUp() throws Exception {
        super.setUp();
        helper = getPageSqlHelper();
        helper.setFieldClause("a.id,a.name,a.createdate");
        helper.setConditionClause("pageDemo a ");
        helper.setOrderByClause("a.id asc");
        helper.setRecordnumPerPage(100);
        dbToObject = new PageDemoOR();
        pageHelper = new PageHelper(TestPageHelperSetup.conn, helper);
    }

 
 
    protected abstract PageSqlHelper getPageSqlHelper();


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

    public void testGetTotalPage() {
        assertEquals(10, pageHelper.getTotalPage());
    }

    public void testGetSpecialObjectPage() {
        this.pageHelper.setDbToObject(this.dbToObject);
        List list = this.pageHelper.getPage(1);
        assertEquals(100, list.size());
    }

    public void testGetDynaObjectFirstPage() {
        List list = this.pageHelper.getPage(1);
        outPutTypeAndValue(list);
        assertEquals(100, list.size());
        DynaBean bean = (DynaBean) list.get(0);
        int actualFirstId = Integer.parseInt(bean.get("id").toString());
        assertEquals(1, actualFirstId);
        bean = (DynaBean) list.get(99);
        int actualLastId = Integer.parseInt(bean.get("id").toString());
        assertEquals(100, actualLastId);

    }

    public void testGetDynaObjectLastPage() {
        List list = this.pageHelper.getPage(10);
        outPutTypeAndValue(list);
        assertEquals(100, list.size());
        DynaBean bean = (DynaBean) list.get(0);
        int actualFirstId = Integer.parseInt(bean.get("id").toString());
        assertEquals(901, actualFirstId);
        bean = (DynaBean) list.get(99);
        int actualLastId = Integer.parseInt(bean.get("id").toString());
        assertEquals(1000, actualLastId);

    }

    public void testGetDynaObjectMiddlePage() {
        List list = this.pageHelper.getPage(4);
        outPutTypeAndValue(list);
        assertEquals(100, list.size());
        DynaBean bean = (DynaBean) list.get(0);
        int actualFirstId = Integer.parseInt(bean.get("id").toString());
        assertEquals(301, actualFirstId);
        bean = (DynaBean) list.get(99);
        int actualLastId = Integer.parseInt(bean.get("id").toString());
        assertEquals(400, actualLastId);

    }

    private void outPutTypeAndValue(List list) {
        if (true) {
            DynaBean bean = (DynaBean) list.get(0);
            logger.debug(bean.get("id").getClass() + " and value: "
                    + bean.get("id"));
            logger.debug(bean.get("name").getClass() + " and value: "
                    + bean.get("name"));
            logger.debug(bean.get("createdate").getClass()
                    + " and value: " + bean.get("createdate"));

        }
    }
}