雪一更--软件开发--数据--Spring JDBC

目的：使用Spring data Jdbc 构建应用程序数据领域核心，非databse

Spring JdbcTemplate NamedJdbcTemplate 简化了DAO 及常用 CRUD 操作。

基础：从 Jdbc 开始，而后基于 JPA 规范和其实现 Hibernate 深入.

JdbcTemplate 是线程安全的，因此Config 配置一个单例。

dataSource 基于 HakariCP.HikariCPDataSource() . 替代默认的 DataSourceManager()；

1.Spring boot 引入依赖

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

        <dependency>
            <groupId>com.mysql</groupId>
            <artifactId>mysql-connector-j</artifactId>
            <scope>runtime</scope>
        </dependency>

application.properties

spring.datasource.url=jdbc:mysql://localhost:3306/PRACTICE_SPRING_JDBC?userUnicode=true&characterEncoding=utf-8&serverTimezone=GMT

spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.username=PRACTICE_SPRING_JDBC
spring.datasource.password=admin

# cp hikari
spring.datasource.hikari.maximum-pool-size=50
spring.datasource.hikari.minimum-idle=2
spring.datasource.hikari.leak-detection-threshold=20000
spring.datasource.hikari.connection-timeout=60000

批量更新

@Configuration
@ComponentScan(basePackages = {"org.tech.road.springjdbc"})
@EnableAutoConfiguration
public class Config {
  @Bean
  public JdbcTemplate jdbcTemplate(DataSource dataSource) {
    return new JdbcTemplate(dataSource);
  }
}

config

public interface VehicleDao {
    Vehicle findByVehicleNo(String vehicleNo);
    List<Vehicle> findAll();
    void insert(Vehicle vehicle);
    void insert(Collection<Vehicle> vehicles);
    void update(Vehicle vehicle);
    void delete(Vehicle vehicle);
}

Dao

@SpringBootApplication
public class SpringJdbcApplication {

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

  @Component
  class DBApp implements ApplicationRunner{

    @Autowired
    VehicleDao vehicleDao;

    @Override
    public void run(ApplicationArguments args) throws Exception {
      Vehicle vehicle1 = new Vehicle("TEM0022","Blue",4,4);
      Vehicle vehicle2 = new Vehicle("SEM0022","Red",4,6);
      Vehicle vehicle3 = new Vehicle("QEM0022","Yellow",4,6);
      vehicleDao.insert(List.of(vehicle1,vehicle2,vehicle3));
    }
  }
}