王冀邢spring-boot集成mybatis的分页插件PageHelper版本问题
Pagehelper 5.0.0及以上版本。使⽤的是这个类Pagehelper，我们在项⽬中可以这样写:企业退休
PageInterceptor pageHelper = new PageInterceptor();
properties.tProperty(“helperDialect”, “mysql”);
@Bean(name = "sqlSessionFactory")
public SqlSessionFactory sqlSessionFactoryBean() {
SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
furniture可数吗
bean.tDataSource(dataSource);
bean.tTypeAliasPackage("com.springboot.demo");
// 分页插件
PageInterceptor pageHelper = new PageInterceptor();
Properties properties = new Properties();
properties.tProperty("reasonable", "true");
properties.tProperty("supportMethodsArguments", "true");
properties.tProperty("returnPageInfo", "check");
properties.tProperty("params", "count=countSql");
properties.tProperty("helperDialect", "mysql");
pageHelper.tProperties(properties);
日常关系// 添加插件
bean.tPlugins(new Interceptor[]{pageHelper});
// 添加XML⽬录
ResourcePatternResolver resolver = new PathMatchingResourcePatternResolver();
try { bean.Resources("classpath:/mapper/*.xml"));
// 驼峰匹配 Object().getConfiguration().tMapUnderscoreToCamelCa(true);
Object();
} catch (Exception e) {
e.printStackTrace();
throw new RuntimeException(e);
描写玫瑰的诗句
装饰公司简介}
}
Pagehelper 5.0.0以下版本。使⽤的是这个类Pagehelper，我们在项⽬中可以这样写:
PageHelper pageHelper = new PageHelper();
properties.tProperty(“dialect”, “mysql”);
public SqlSessionFactory sqlSessionFactoryBean() {
霸气动漫头像
防寒SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
bean.tDataSource(dataSource);
bean.tTypeAliasPackage("com.springboot.demo");
// 分页插件
PageHelper pageHelper = new PageHelper();
Properties properties = new Properties();
properties.tProperty("reasonable", "true");
properties.tProperty("supportMethodsArguments", "true");
properties.tProperty("returnPageInfo", "check");
properties.tProperty("params", "count=countSql");
properties.tProperty("dialect", "mysql");
pageHelper.tProperties(properties);
// 添加插件
bean.tPlugins(new Interceptor[] { pageHelper });
// 添加XML⽬录
ResourcePatternResolver resolver = new PathMatchingResourcePatternResolver(); try {
bean.Resources("classpath:/mapper/*.xml")); // 驼峰匹配
Object();
} catch (Exception e) {
e.printStackTrace();
throw new RuntimeException(e);
}
}
