天下之事常成于困约,而败于奢靡。这篇文章主要讲述springboot mybatis集成mapper与pagehelper相关的知识,希望能为你提供帮助。
1、引入jar到pom.xml
<
dependency>
<
groupId>
org.mybatis.spring.boot<
/groupId>
<
artifactId>
mybatis-spring-boot-starter<
/artifactId>
<
version>
1.1.1<
/version>
<
/dependency>
<
dependency>
<
groupId>
tk.mybatis<
/groupId>
<
artifactId>
mapper<
/artifactId>
<
version>
3.4.0<
/version>
<
/dependency>
<
!-- https://mvnrepository.com/artifact/com.github.pagehelper/pagehelper -->
<
dependency>
<
groupId>
com.github.pagehelper<
/groupId>
<
artifactId>
pagehelper<
/artifactId>
<
version>
4.1.0<
/version>
<
/dependency>
2、配置mapper
创建application-bean.xml,文件内容如下
<
?xml version="1.0" encoding="UTF-8"?>
<
beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd">
<
!-- 注入spring boot无法扫描到的bean. -->
<
bean class="tk.mybatis.spring.mapper.MapperScannerConfigurer">
<
property name="basePackage" value="https://www.songbingjia.com/android/study.boot.config。MyMapper" />
<
property name="properties">
<
value>
mappers=tk.mybatis.mapper.common.Mapper
<
/value>
<
/property>
<
/bean>
<
/beans>
3、创建配置类
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.ImportResource;
@Configuration
@ImportResource(value=https://www.songbingjia.com/android/{"classpath:application-bean.xml"})
public class ConfigClass {
}
import java.util.Properties;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import com.github.pagehelper.PageHelper;
@Configuration
public class MyBatisConfiguration {
private static final Logger logger = LoggerFactory.getLogger(MyBatisConfiguration.class);
@Bean
public PageHelper pageHelper() {
logger.info("注册MyBatis分页插件PageHelper");
PageHelper pageHelper = new PageHelper();
Properties p = new Properties();
p.setProperty("offsetAsPageNum", "true");
p.setProperty("rowBoundsWithCount", "true");
p.setProperty("reasonable", "true");
pageHelper.setProperties(p);
return pageHelper;
}
}
import tk.mybatis.mapper.common.Mapper;
import tk.mybatis.mapper.common.mysqlMapper;
public interface MyMapper<
T>
extends Mapper<
T>
, MySqlMapper<
T>
{
}
4、实际运用
mybatis的mapper继承通用mapper
@Mapper
public interface CityMapper extends MyMapper<
City>
{
}
直接使用
@RestController
@RequestMapping("/boot")
public class HelloWorld {
@Autowired
CityMapper cityMapper;
@RequestMapping("/hello")
public List<
City>
greeting() {
PageHelper.startPage(1, 5);
return cityMapper.selectAll();
}
【springboot mybatis集成mapper与pagehelper】}
推荐阅读
- Android 解决WebView和ScrollView滚轮滑动冲突
- 关于Android创建虚拟机出现Failed to allocate memory: 8解决办法
- Android studio 代码突然报错解决方案
- Deep Learning Enables You to Hide Screen when Your Boss is Approaching
- java-mybaits-00401-Mapper-输入输出
- mybatis学习之路别名(typeAliases)mapper接口加载映射文件
- Android编程(底部弹出的对话框)
- android中init.rc文件的解析问题
- mybatis学习之路mapper代理开发方法-开发规范及实现