Mybatis Generator 根据数据库自动生成相关对象及接口,默认不支持分页功能,通过plugin得以实现,使用方式,在generatorconfig.xml里引用即可:
<classPathEntry location="D:\\adintel\\projects\\hgghome\\trunk\\WebContent\\WEB-INF\\lib\mysql-connector-java-5.1.22-bin.jar" />
<context id="MysqlContext" targetRuntime="MyBatis3" defaultModelType="flat">
<property name="beginningDelimiter" value="`"/>
<property name="endingDelimiter" value="`"/>
<!-- 这里引入扩展插件 -->
<plugin type="com.addintel.pub.plugin.PaginationPlugin" />
...........
使用
UsersMapper mapper = ctx.getBean(UsersMapper.class);
PageBean pager = new PageBean(Constants.PAGE_PC);
pager.setCurrentPage(1);
UsersExample example = new UsersExample();
UsersExample.Criteria criteria = example.createCriteria();
//criteria.andSnameEqualTo("");
int totalCount = mapper.countByExample(example);
pager.setTotalCount(totalCount);
example.setLimitStart(pager.getRownumBegin());
example.setPageSize(pager.getPageSize());
List<Users> users = mapper.selectByExample(example);
...........