Portfolio


// config
@Configuration
public class JdbcTemplateConfig {

    @Bean
    public DataSource dataSource(){
        DriverManagerDataSource dataSource = new DriverManagerDataSource();
        dataSource.setUsername("root");
        dataSource.setPassword("geunomysql!@#$");
        dataSource.setUrl("jdbc:mysql://localhost:3306/book_manager?serverTimezone=UTC");
        return dataSource;
    }

    @Bean
    public JdbcTemplate jdbcTemplate(){
        return new JdbcTemplate(dataSource());
    }
}

// repository
@Repository
public class StudentRepository {
    private final JdbcTemplate jdbcTemplate;

    public StudentRepository(JdbcTemplate jdbcTemplate) {
        this.jdbcTemplate = jdbcTemplate;
    }

    public void insert(Student... students){
        for(Student student : students){
            this.jdbcTemplate.update("insert into student (`name`, `id`, `age`) values (?, ?, ?)", student.getName(), student.getId(), student.getAge());
        }
    }

    public List<Student> select(){
        List<Student> result = this.jdbcTemplate.query("select id, name, age from student", (resultSet, rowNum) -> {
           Student stu = new Student();
           stu.setName(resultSet.getString(2));
           stu.setAge(Integer.parseInt(resultSet.getString(3)));
           stu.setId(Integer.parseInt(resultSet.getString(1)));
           return stu;
        });
        return result;
    }
}


return jdbcTemplate.queryForObject("SELECT * FROM customers WHERE customer_id = UUID_TO_BIN(:customerId);",
  Map.of("customerId", customerId.toString()),
  (rs, i) -> Optional.of(this.mapperToCustomer(rs, i)));

JDBC Template

이용이유

JDBC Template 이용

NamedParameterJdbcTemplate

Mapping a Jdbc ResultSet To an Object