SpringBoot整合JDBC

连接数据库的方式有很多，比如Jpa（参考SpringBoot整合JPA），Mybatis（参考SpringBoot整合Mybatis），原生JDBC等，本文主要详细讲述借助JdbcTemplate来操作数据库
首先新建一个web工程，打开pom.xml引入相关依赖

        <!--JDBC依赖-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>
        <!--mysql依赖-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

配置数据库连接

spring:
  datasource:
    url: jdbc:mysql://localhost:3306/test_jdbc?serverTimezone=UTC
    username: root
    password: root
    driver-class-name: com.mysql.jdbc.Driver

新建表tb_user，添加一条数据

新建实体类User

public class User {
    private Integer id;

    private String lastName;

    private String email;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getLastName() {
        return lastName;
    }

    public void setLastName(String lastName) {
        this.lastName = lastName;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }
}

实现dao层，新建UserDao

@Repository
public class UserDao {

    @Autowired
    JdbcTemplate jdbcTemplate;

    public List<Map<String, Object>> selectUser() {
        List<Map<String, Object>> list = jdbcTemplate.queryForList("select * from tb2_user");
        if (list.size() > 0) {
            return list;
        }
        return null;
    }

}

为了简单就省略service层，直接新建UserController

@RestController
public class Usercontroller {

    @Autowired
    UserDao userDao;

    @GetMapping("/user")
    public List<Map<String, Object>> insertUser() {
        List<Map<String, Object>> list = userDao.selectUser();
        return list;
    }
}

启动项目，浏览器输入localhost:8080/user，得到数据，整合成功