๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ

JDBC3

[TIL] 221110 - SpringBoot Part2 : Embedded DB, Named Parameter Template, ํŠธ๋žœ์žญ์…˜ SpringBoot Part2 (4) 1. Embedded DataBase ๊ธฐ์กด ํ…Œ์ŠคํŠธ : DB ๊ตฌ๋™์ด ๋˜์ง€์•Š์œผ๋ฉด ํ…Œ์ŠคํŠธ์— ์‹คํŒจํ•˜๋Š” ๊ตฌ์กฐ → ์™ธ๋ถ€ํ™˜๊ฒฝ์— ์˜ํ–ฅ์„ ๋ฐ›๋Š” ํ…Œ์ŠคํŠธ → ํ…Œ์ŠคํŠธ ์ž๋™ํ™”(jenkins๊ฐ™์€ CI ํˆด์„ ์ด์šฉํ•œ) ๋ถˆ๊ฐ€ Spring์—์„œ Embedded Database ์ œ๊ณต Data Access Data Access The Data Access Object (DAO) support in Spring is aimed at making it easy to work with data access technologies (such as JDBC, Hibernate, or JPA) in a consistent way. This lets you switch between the aforementioned.. 2022. 11. 11.
[TIL] 221109 - SpringBoot Part2 : Spring์˜ JDBC์ง€์› SpringBoot Part2 (3) org.springframework.boot spring-boot-starter-jdbc DataSource connection์„ ๋งค๋ฒˆ ์ƒ์„ฑํ•˜๊ณ  closeํ•˜๋ฉด ๊ทธ ๊ณผ์ •์—์„œ ๋งŽ์€ ๋ฆฌ์†Œ์Šค๊ฐ€ ํ—ˆ๋น„๋œ๋‹ค. ์ด๋Ÿฌํ•œ ๋ฌธ์ œ๋ฅผ ํ•ด๊ฒฐํ•˜๊ธฐ ์œ„ํ•ด connection pool ๊ฐœ๋…์ด ๋“ฑ์žฅ. JDBC์—์„œ๋Š” driver maneger ์™ธ์— dataSource๋ฅผ ์ด์šฉํ•ด ์ปค๋„ฅ์…˜์„ ๊ฐ€์ ธ์˜ฌ ์ˆ˜ ์žˆ๊ณ , dataSource๊ฐ€ connection์„ ๊ด€๋ฆฌํ•˜๋Š” ๊ฐ์ฒด๊ฐ€๋œ๋‹ค. DataBase Connection Pool(DBCP) dataSource๋ฅผ ํ†ตํ•ด ๋ฐ์ดํ„ฐ๋ฅผ ์–ป๊ฑฐ๋‚˜ ๋ฐ˜๋‚ฉํ•  ์ˆ˜ ์žˆ๋‹ค. close๋ฅผ ํ•˜๋ฉด ์‹ค์ œ ๋ฌผ๋ฆฌ์ ์œผ๋กœ ์—ฐ๊ฒฐ์„ ๋Š๋Š”๊ฒŒ ์•„๋‹ˆ๋ผ ํ’€์— ๋ฐ˜๋‚ฉํ•˜๋Š” ๊ฒƒ DBCP๋ฅผ ๊ตฌํ˜„ํ•œ ๋‹ค์–‘ํ•œ ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ๊ฐ€ ์žˆ๋‹ค. (si.. 2022. 11. 10.
[TIL] 221108 - SpringBoot Part2 : JDBC SprintBoot part2 (2) JDBC ์‹œ์ž‘ํ•˜๊ธฐ JDBC allows a java application to connect a relational database ํฌ๊ฒŒ ๋‘ ๋‹จ๊ณ„ ๋ ˆ์ด์–ด๋กœ ๊ตฌ์„ฑ๋œ๋‹ค. JDBC API JDBS DB Driver docker๋ฅผ ์ด์šฉํ•ด mysql ์‹คํ–‰ IntelliJ ์—ฐ๊ฒฐ maven dependency ์ถ”๊ฐ€ JDBC CURD ์‹ค์Šต 1. jdbc connection public class JdbcCustomerRepository { private static final Logger logger = LoggerFactory.getLogger(JdbcCustomerRepository.class); public static void main(String[] args) throws.. 2022. 11. 8.

ํ‹ฐ์Šคํ† ๋ฆฌํˆด๋ฐ”