Springboot+jdbcTemplate+HikariDataSource

1.pom.xml

<!-- 属性配置 -->
<!-- 可以自定义所需的配置 -->
<properties>
    <java.version>1.8</java.version>
    <spring-boot.version>2.5.0</spring-boot.version>
    <mysql.version>5.1.8</mysql.version>
</properties>

<!-- Spring Boot的基础依赖项 -->
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter</artifactId>
    <version>${spring-boot.version}</version>
</dependency>
<!-- Spring Boot测试的依赖项 -->
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-test</artifactId>
    <version>${spring-boot.version}</version>
</dependency>

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>${mysql.version}</version>
</dependency>

<dependency>
    <groupId>org.projectlombok</groupId>
    <artifactId>lombok</artifactId>
</dependency>

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

2.application.yml

spring:
  datasource:
    driver-class-name: com.mysql.jdbc.Driver
    url: jdbc:mysql://{ip}:{port}/{dbname}?useUnicode=true&characterEncoding=utf-8&useSSL=false
    username: root
    password: {password}
    type: com.zaxxer.hikari.HikariDataSource # 数据源类型：HikariCP
    hikari:
      minimum-idle: 10 # 最小空闲连接，默认值10，小于0或大于maximum-pool-size，都会重置为maximum-pool-size
      maximum-pool-size: 20 # 最大连接数，小于等于0会被重置为默认值10；大于零小于1会被重置为minimum-idle的值
      idle-timeout: 500000 # 空闲连接超时时间，默认值600000ms（10分钟），大于等于max-lifetime且max-lifetime>0，会被重置为0；不等于0且小于10秒，会被重置为10秒。
      max-lifetime: 540000 # 连接最大存活时间，不等于0且小于30秒，会被重置为默认值30分钟.设置应该比mysql设置的超时时间短
      connection-timeout: 60000 # 连接超时时间：毫秒，小于250毫秒，否则被重置为默认值30秒
      connection-test-query: SELECT 1 # 用于测试连接是否可用的查询语句

3.启动类

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
public class SpringbootJdbcHikariApplication {

    public static void main(String[] args) {
        SpringApplication.run(SpringbootJdbcHikariApplication.class, args);
    }

}

4.StudentDao.java

import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Repository;

import javax.annotation.Resource;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Map;

@Repository
public class StudentDao {

    @Resource
    private JdbcTemplate jdbcTemplate;

    public List<Map<String,Object>> findAll(){
        StringBuilder sql = new StringBuilder();
        sql.append(" select * from t_student ");
        return jdbcTemplate.queryForList(sql.toString());
    }

    public int saveStudent(Map<String,Object> student){
        StringBuilder sql = new StringBuilder();
        sql.append(" insert into t_student(name,brith_date,create_time,score) values (?,?,?,?) ");
        List<Object> paramsList = new ArrayList<>();
        paramsList.add(student.get("name"));
        paramsList.add(student.get("brithDate"));
        paramsList.add(new Date());
        paramsList.add(student.get("score"));

        return jdbcTemplate.update(sql.toString(), paramsList.toArray());
    }
}

5.单元测试类 SpringbootJdbcHikariApplicationTests.java

import com.example.springbootjdbchikari.dao.StudentDao;
import lombok.extern.slf4j.Slf4j;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

@SpringBootTest
@Slf4j
class SpringbootJdbcHikariApplicationTests {

    @Autowired
    private StudentDao studentDao;

    @Test
    void findAllStudent() {
        List<Map<String,Object>> list = studentDao.findAll();
        log.info("list===="+ list);
    }

    @Test
    void saveStudent() {
        Map<String,Object> student = new HashMap<>();
        student.put("name", "王五");
        student.put("brithDate", "2010-08-08");
        student.put("score", "85");
        int row = studentDao.saveStudent(student);
        log.info("row===="+row);
    }

}