>
<!--namespace必须和dao接口的名称一模一样-->
<mapper namespace="com.aaa.qy168springboot03.dao.UserDao">
<select id="findAll" resultType="com.aaa.qy168springboot03.entity.User">
select * from t_user
</select>
</mapper>
(5)修改配置文件的内容
(6)在主启动类上dao接口的扫描配置
(7)测试
6. springboot整合pageHelper分页插件
<!--pageHelper的依赖-->
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.4.5</version>
</dependency>
测试:
@Test
public void testFindAll(){
PageHelper.startPage(1,3);//拦截器: select * from t_user
List<User> all = userDao.findAll();
//把查询的结果封装到PageInfo类中
PageInfo<User> pageInfo=new PageInfo<>(all);
System.out.println("总条数:"+pageInfo.getTotal());
System.out.println("总页数:"+pageInfo.getPages());
System.out.println("当前页的记录:"+pageInfo.getList());
}
7. 综合案例
springboot+mybatis+druid+pageHelper: CRUD
(1)创建springboot工程并引入相关的依赖
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.3.1</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<optional>true</optional>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>1.2.1</version>
</dependency>
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.4.5</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
</dependencies>
(2)修改配置文件
#修改端口号
server.port=8888
#数据源
spring.datasource.druid.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.druid.username=root
spring.datasource.druid.password=root
spring.datasource.druid.url=jdbc:mysql://localhost:3306/qy168?serverTimezone=Asia/Shanghai
spring.datasource.druid.initial-size=5
spring.datasource.druid.max-active=10
#mybatis映射文件的路径
mybatis.mapper-locations=classpath:/mapper/*.xml
(3)实体类
tbl_dept
@Data
public class Dept {
private Integer did;
private String dname;
private String loc;
}
tbl_emp
@Data
public class Emp {
private Integer id;
private String name;
private double salary;
private Date birthday;
private String headImg;
private Integer deptId;
//查询员工时需要携带该员工对应的部门信息.
private Dept dept;
}