org.apache.torque.util.LargeSelect实现分页查询示例：
Criteria crit = new Criteria();
crit.add(CmsCategoryPeer.CATEGORY_ID, cat.getCategoryId());
crit.addJoin(CmsCategoryPeer.CATEGORY_ID, CmsCatContentPeer.CATEGORY_ID);
crit.addJoin(CmsCatContentPeer.CONTENT_ID, CmsContentPeer.CONTENT_ID);
... ...
LargeSelect largeSelect = new LargeSelect(crit, size, offset);
List rs = largeSelect.getPage(offset);
torque generator代码产生器：
http://db.apache.org/torque/releases/torque-3.3/generator/index.html
