1. 배경

Springboot 기반으로 PostgreSQL 연동하여 작업 실행.

2. Maven Dependency

<dependency>
  <groupid>org.postgresql</groupid>
  <artifactid>postgresql</artifactid>
</dependency></pre>

3. application.properties에 JDBC 설정 추가

spring.datasource.hikari.jdbcUrl=jdbc:postgresql://[주소:포트/DB이름]
spring.datasource.hikari.username=[계정]
spring.datasource.hikari.password=[패스워드]
spring.datasource.hikari.pool-name=[풀이름]

4. DataSource 설정

import javax.sql.DataSource;

import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

import com.zaxxer.hikari.HikariConfig;
import com.zaxxer.hikari.HikariDataSource;

@Configuration
public class DatabaseConfig {
    @Bean
    @ConfigurationProperties(prefix = "spring.datasource.hikari")
    public HikariConfig hikariConfig() {
        return new HikariConfig();
    }

    @Bean
    public DataSource dataSource() {
        return new HikariDataSource(hikariConfig());
    }
}

5. 실제 코드 부분

5.1. DataSource

   @Autowired
    private DataSource dataSource;

5.2. 데이터 인서트 예제

   public void add(String key, String value) {
        String sql = "INSERT INTO key_log ";
        sql += " ( key, value )";
        sql += " VALUES ( ?, ? )";

        try (Connection conn = dataSource.getConnection();
            PreparedStatement preparedStmt = conn.prepareStatement(sql);) {
            preparedStmt.setString(1, key);
            preparedStmt.setString(2, value);
            preparedStmt.execute();
        } catch (SQLException e) {
            log.error(e.getMessage());
            e.printStackTrace();
        } finally {
                        //
        }