springboot整合jdbc数据源、mybatis和pageHelper

springboot整合jdbc数据源

（1）加入依赖

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
</dependency>

（2）测试

import javax.sql.DataSource;

@Autowired
private DataSource dataSource;

@Test
public void DataSource() throws Exception {
    System.out.println(dataSource.getConnection());
}

springboot整合mybatis

1.加入依赖

<!--mybatis依赖-->
<dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>3.0.2</version>
</dependency>

2.创建实体类

@Data
public class User {
    private Integer id;
    private String name;
    private String pwd;
    private String status;
    private String u_role;
}

3.Dao

@Mapper//为该接口生成代理实现类
public interface UserDao {
    public User findById(Integer userId);
    public List<User> findAll();
}

4.映射文件

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.yc.dao.UserDao" >
    <select id="findById" resultType="com.yc.entity.User">
        select * from user1 where id=#{userId}
    </select>
    
    <select id="findAll" resultType="com.yc.entity.User">
        select * from user1;
    </select>
</mapper>

5.在配置文件中指定映射文件的路径（我是直接在建立Mapper映射文件的时候把路径和接口文件路径一致了，就没有写这个了），以及数据库的属性

#指定mybatis映射文件所在的路径
mybatis.mapper-locations=classpath:mapper/*.xml

6.测试

@Test
public void findById() {
    User user = userDao.findById(1);
    System.out.println(user);
}

springboot整合pageHelper分页插件

1.依赖

<!--引入pageHelper依赖-->

        <dependency>

            <groupId>com.github.pagehelper</groupId>

            <artifactId>pagehelper-spring-boot-starter</artifactId>

            <version>1.2.5</version>

        </dependency>

2.测试

@Autowired
private UserDao userDao;
@Test
public void findAll() {
    PageHelper.startPage(1, 3);//开启分页
    List<User> users = userDao.findAll();
    PageInfo<User> pageInfo = new PageInfo<>(users);
    System.out.println("总条数：" + pageInfo.getTotal());
    System.out.println("总页码：" + pageInfo.getPages());
    System.out.println("当前页的记录：" + pageInfo.getList());
}