hellopersionpagintionspeed.java

羽量级数据持久层开发框架

// $Id: HelloPersionPagintionSpeed.java $Date: 2007-10-20 下午11:05:02 $ 
// $Id: HelloPersionPagintionSpeed.java $Date: 2007-10-20 下午11:05:02 $ 
package cn.speed.chapter1;

import java.util.List;

import org.apache.log4j.Logger;
import org.speedframework.engine.Engine;
import org.speedframework.engine.EngineFactory;
import org.speedframework.entity.Pagination;

/**
 * Class HelloPersionPagintionSpeed
 * 分页功能 
 * @author <a href="mailto:[e-mail]"> lizf </a>
 * @version $Revision:1.0.0, $Date: 2007-10-20 下午11:05:02 $
 */
public class HelloPersionPagintionSpeed {
	private static Logger logger = Logger
	.getLogger(HelloPersionPagintionSpeed.class);

	/**
	 * Method main
	 *
	 * @param args
	 */
	public static void main(String[] args) {
		Engine engine = null;
		logger.info("��测试开始..............");
		String sql = "select a.id hid,a.helloworld hname,b.name pname from `helloworld`a ,person b where a.id=b.id";
		engine = EngineFactory.getEngine("link_mysql");
		Pagination pagintion =new Pagination();
		pagintion.setPage(1);//控制当前访问页数
		pagintion.setCount(10);//控制每页条目，默认是10条
		List list = engine.getQuery().getResults(sql, new Object[] {},
				HelloPersionView.class,pagintion);
		logger.info(list.toString());
		//当没有定义视图域对象，会返回Lits队列封装Map对象
		List listNotView = engine.getQuery().getResults(sql, new Object[] {},
				null,pagintion);
		logger.info(listNotView.toString());
		engine.commit();

		engine.closeEngine();
		

		logger.info("测试结束..............����ɹ�����鿴�����ݿ�");
	}

}