English Readme | 中文说明
add maven
<dependency>
<groupId>com.github.liuanxin</groupId>
<artifactId>mybatis-page</artifactId>
<version>1.2.8</version>
</dependency>
add config for this
@Bean
public SqlSessionFactory sqlSessionFactory() throws Exception {
SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean();
sessionFactory.setDataSource(datasource());
sessionFactory.setPlugins(new Interceptor[] { new PageInterceptor("MySQL") });
/*
sessionFactory.setPlugins(new Interceptor[] { new PageInterceptor("postgresql") });
sessionFactory.setPlugins(new Interceptor[] { new PageInterceptor("sqlite") });
sessionFactory.setPlugins(new Interceptor[] { new PageInterceptor("oracle") });
sessionFactory.setPlugins(new Interceptor[] { new PageInterceptor("h2") });
sessionFactory.setPlugins(new Interceptor[] { new PageInterceptor("sqlserver2000") });
sessionFactory.setPlugins(new Interceptor[] { new PageInterceptor("sqlserver") });
sessionFactory.setPlugins(new Interceptor[] { new PageInterceptor("sqlserver2012") });
*/
// load xml & handler
sessionFactory.setMapperLocations(...);
sessionFactory.setTypeHandlers(...);
return sessionFactory.getObject();
}
or use mybatis-config.xml
<plugins>
<plugin interceptor="com.github.liuanxin.page.PageInterceptor">
<property name="dialect" value="sqlserver2012"/>
</plugin>
</plugins>
and a new method in Mapper, for example:
List<User> selectByExample(UserExample example, com.github.liuanxin.page.model.PageBounds page);