20230604_스프링부트학습

* DataSource

@Bean
@ConditionalOnSingleCandidate(DataSource.class)
@ConditionalOnMissingBean
JdbcTemplate jdbcTemplate(DataSource dataSource) {
return new JdbcTemplate(dataSource);
}

@Bean
@ConditionalOnSingleCandidate(DataSource.class)
@ConditionalOnMissingBean
JdbcTransactionManager jdbcTransactionManager(DataSource dataSource) {
return new JdbcTransactionManager(dataSource);
}

 

 

jdbcTemplate 을 이용한 DB접근 방식

@Repository
public class HelloRepositoryJdbc implements HelloRepository {
private final JdbcTemplate jdbcTemplate;

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


@Override
public Hello findHello(String name) {
return jdbcTemplate.queryForObject("select * from hello where name = '" + name + "'",
(rs, rowNum) -> new Hello(
rs.getString("name"), rs.getInt("count")
));
}

@Override
public void increaseCount(String name) {
Hello hello = findHello(name);
if (hello == null) jdbcTemplate.update("insert into hello values(?,?)", name, 1);
else jdbcTemplate.update("update hello set count = ? where name = ?", hello.getCount() + 1, name);
}
}