๐Ÿ“–
Kyu9's Repo
  • Library of mameil
  • ์ด์Šˆ ๊ฒฝํ—˜
    • 20230220_ํŠธ๋žœ์žญ์…˜
    • 20230306_์บ์‹ฑ์ด์Šˆ
    • 20230722_ํ…Œ์ŠคํŠธ์ฝ”๋“œ์—์„œ @Transactional
    • 20230807_deadlock
  • ์ธํ„ด ์Šคํ„ฐ๋””
    • Gradle
    • Stream, Optional, ๋žŒ๋‹ค์‹
    • JVM์˜ ๋ฉ”๋ชจ๋ฆฌ ๊ตฌ์กฐ, Garbage Collector
    • RESTful API
    • Microservice Architecture
    • HTTP
    • ์›น์„œ๋ฒ„๋ž€ ๋ฌด์—‡์ธ๊ฐ€
    • Git Branch
    • TDD
    • Redis์„ ์ด์šฉํ•œ ์บ์‹œ
    • Thymeleaf
    • ์ •๋ฆฌ๊ฐ€ ํ•„์š”ํ•œ ์ž๋ฃŒ๋“ค
    • SpringBoot Management
    • ํ…Œ์Šคํฌ ์ฝ”๋“œ ๋ถ„ํ• 
  • ๋™์•„๋ฆฌ ์Šคํ„ฐ๋””
    • ๊ธฐ๋ณธ SQL ๊ณต๋ถ€
      • SQL์˜ ๊ธฐ๋ณธ ๊ฐœ๋…
      • SELECT ๋ฌธ์žฅ์„ ์ด์šฉํ•˜์—ฌ ์›ํ•˜๋Š” ๋ฐ์ดํ„ฐ ์ถœ๋ ฅํ•˜๊ธฐ
        • ์ง‘ํ•ฉ ์—ฐ์‚ฐ์ž ์‚ฌ์šฉํ•˜๊ธฐ
        • where์ ˆ์— ๋น„๊ต ์—ฐ์‚ฐ์ž๋ฅผ ์‚ฌ์šฉํ•ด๋ณด๊ธฐ
        • SELECT_EX
        • ์‚ฐ์ˆ  ์—ฐ์‚ฐ์ž ์‚ฌ์šฉํ•ด๋ณด๊ธฐ
      • ๋‹จ์ผ ํ–‰ ํ•จ์ˆ˜ ์‚ฌ์šฉ
        • lower/upper ํ•จ์ˆ˜ ์‚ฌ์šฉํ•˜๊ธฐ
        • lengthํ•จ์ˆ˜ ์‚ฌ์šฉํ•˜๊ธฐ
        • concatํ•จ์ˆ˜ ์‚ฌ์šฉ
        • substr/mid/substring ํ•จ์ˆ˜ ์‚ฌ์šฉ
        • instrํ•จ์ˆ˜ ์‚ฌ์šฉํ•˜๊ธฐ
        • lpad/rpad ํ•จ์ˆ˜ ์‚ฌ์šฉํ•˜๊ธฐ
        • trim/ltrim/rtrim ํ•จ์ˆ˜ ์‚ฌ์šฉํ•˜๊ธฐ
        • replace ํ•จ์ˆ˜ ์‚ฌ์šฉํ•˜๊ธฐ
        • round ํ•จ์ˆ˜ ์‚ฌ์šฉํ•˜๊ธฐ
        • truncate ํ•จ์ˆ˜ ์‚ฌ์šฉํ•˜๊ธฐ
        • modํ•จ์ˆ˜ ์‚ฌ์šฉํ•˜๊ธฐ
        • ceilํ•จ์ˆ˜ ์‚ฌ์šฉํ•˜๊ธฐ
        • floorํ•จ์ˆ˜ ์‚ฌ์šฉํ•˜๊ธฐ
        • power ํ•จ์ˆ˜ ์‚ฌ์šฉํ•˜๊ธฐ
        • Date fn(๋‚ ์งœ ํ•จ์ˆ˜)
        • ํ˜• ๋ณ€ํ™˜ ํ•จ์ˆ˜
        • ์ผ๋ฐ˜ํ•จ์ˆ˜๋ž€
    • a-ha ์‹ค์Šต
    • ํ˜ผ์ž์„œ ๋งŒ๋“ค์–ด๋ณธ ๊ฒŒ์‹œํŒ
    • AWS ๊ฐ•์˜
  • ํ•™๊ต ๋‚˜๋จธ์ง€ ๊ณต๋ถ€ ์ž๋ฃŒ
    • ์›นํ”„๋ ˆ์ž„์›Œํฌ(Spring)
      • Spring์ด๋ž€?
      • Webframework1-1
      • Webframework1-2
      • SpringBoot์˜ ํŠน์ง•
      • SpringBoot ์ƒ์„ฑ ๋ฐฉ๋ฒ•
      • Spring Data JPA
      • SpringBoot Security
      • SpringBoot HATEOAS
  • ๊ณต๋ถ€ ์ž๋ฃŒ๋“ค
  • WS ์˜จ๋ผ์ธ ์ž๋ฐ” ์Šคํ„ฐ๋””
    • Week1(JVM์€ ๋ฌด์—‡์ด๋ฉฐ ์ž๋ฐ” ์ฝ”๋“œ๋Š” ์–ด๋–ป๊ฒŒ ์‹คํ–‰ํ•˜๋Š” ๊ฒƒ์ธ๊ฐ€.)
    • Week2(์ž๋ฐ” ๋ฐ์ดํ„ฐ ํƒ€์ž…, ๋ณ€์ˆ˜ ๊ทธ๋ฆฌ๊ณ  ๋ฐฐ์—ด)
    • Week3(์—ฐ์‚ฐ์ž)
    • Week4(์ œ์–ด๋ฌธ)
    • Week5(ํด๋ž˜์Šค)
    • Week6(์ƒ์†)
    • Week7(ํŒจํ‚ค์ง€)
    • Week8(์ธํ„ฐํŽ˜์ด์Šค)
    • Week9(์˜ˆ์™ธ์ฒ˜๋ฆฌ)
    • Week10(๋ฉ€ํ‹ฐ์“ฐ๋ ˆ๋“œ ํ”„๋กœ๊ทธ๋ž˜๋ฐ)
    • Week11(Enum)
    • Week12(Annotation)
    • Week13(I/O)
    • Week14(Generic)
    • Week15(๋žŒ๋‹ค์‹)
  • ๋ฐฑ์ค€๋ฌธ์ œ
    • ์ž…์ถœ๋ ฅ๊ณผ ์‚ฌ์น™์—ฐ์‚ฐ
      • We love kriii(10718)
      • ๊ณ ์–‘์ด(10171)
      • ๊ฐœ(10172)
      • A+B(1000)
      • A-B(1001)
      • AxB(10998)
      • A/B(1008)
      • ์‚ฌ์น™์—ฐ์‚ฐ(10869)
      • ๋‚˜๋จธ์ง€(10430)
      • ๊ณฑ์…ˆ(2588)
    • for๋ฌธ
      • ๊ตฌ๊ตฌ๋‹จ(2739)
      • A+B - 3(10950)
      • ํ•ฉ(8393)
      • ๋น ๋ฅธ A+B(15552)
      • N ์ฐ๊ธฐ(2741)
      • ๊ธฐ์ฐ N(2742)
      • A+B - 7(11021)
      • A+B - 8(11022)
      • ๋ณ„ ์ฐ๊ธฐ - 1(2438)
      • ๋ณ„ ์ฐ๊ธฐ - 2(2439)
      • X๋ณด๋‹ค ์ž‘์€ ์ˆ˜(10871)
    • if๋ฌธ
      • ๋‘ ์ˆ˜ ๋น„๊ตํ•˜๊ธฐ(1330)
      • ์‹œํ—˜ ์„ฑ์ (9498)
      • ์œค๋…„(2753)
      • ์‚ฌ๋ถ„๋ฉด ๊ณ ๋ฅด๊ธฐ(14681)
      • ์•Œ๋žŒ ์‹œ๊ณ„(2884)
      • ์˜ค๋ธ ์‹œ๊ณ„(2525)
      • ์ฃผ์‚ฌ์œ„ ์„ธ๊ฐœ(2480)
      • ์˜์ˆ˜์ฆ(25304)
    • While๋ฌธ
      • A+B - 5(10952)
      • A+B - 4(10951)
      • ๋”ํ•˜๊ธฐ ์‚ฌ์ดํด(1110)
    • 1์ฐจ์› ๋ฐฐ์—ด
      • ์ตœ์†Œ, ์ตœ๋Œ€(10818)
      • ์ตœ๋Œ“๊ฐ’(2562)
      • ์ˆซ์ž์˜ ๊ฐœ์ˆ˜(2577)
      • ๋‚˜๋จธ์ง€(3052)
      • ํ‰๊ท (1546)
      • OXํ€ด์ฆˆ(8958)
      • ํ‰๊ท ์€ ๋„˜๊ฒ ์ง€(4344)
    • ํ•จ์ˆ˜
      • ์ •์ˆ˜N๊ฐœ์˜ ํ•ฉ(15596)
      • ์…€ํ”„ ๋„˜๋ฒ„(4673)
      • ํ•œ์ˆ˜(1065)
    • ๋ฌธ์ž์—ด
      • ์•„์Šคํ‚ค์ฝ”๋“œ(11654)
      • ์ˆซ์ž์˜ ํ•ฉ(11720)
      • ์•ŒํŒŒ๋ฒณ ์ฐพ๊ธฐ(10809)
      • ๋ฌธ์ž์—ด ๋ฐ˜๋ณต(2675)
      • ๋‹จ์–ด ๊ณต๋ถ€(1157)
      • ๋‹จ์–ด์˜ ๊ฐœ์ˆ˜(1152)
      • ์ƒ์ˆ˜(2908)
      • ๋‹ค์ด์–ผ(5622)
      • ํฌ๋กœ์•„ํ‹ฐ์•„ ์•ŒํŒŒ๋ฒณ(2941)
      • ๊ทธ๋ฃน ๋‹จ์–ด ์ฒด์ปค(1316)
    • ๊ธฐ๋ณธ์ˆ˜ํ•™-1
      • ์†์ต๋ถ„๊ธฐ์ (1712)
      • ๋ฒŒ์ง‘(2292)
      • ๋ถ„์ˆ˜์ฐพ๊ธฐ(1193)
      • ๋‹ฌํŒฝ์ด๋Š” ์˜ฌ๋ผ๊ฐ€๊ณ  ์‹ถ๋‹ค(2869)
      • ACM ํ˜ธํ…”(10250)
      • ๋ถ€๋…€ํšŒ์žฅ์ด ๋ ํ…Œ์•ผ(2775)
      • ์„คํƒ• ๋ฐฐ๋‹ฌ(2839)
      • ํฐ ์ˆ˜ A+B(10757)
      • Fly me to the Alpha Centauri(1011)
    • ๊ธฐ๋ณธ์ˆ˜ํ•™-2
      • ์†Œ์ˆ˜ ์ฐพ๊ธฐ(1978)
      • ์†Œ์ˆ˜(2581)
      • ์†Œ์ธ์ˆ˜๋ถ„ํ•ด(11653)
      • ์†Œ์ˆ˜ ๊ตฌํ•˜๊ธฐ(1929)
      • ๋ฒ ๋ฅดํŠธ์™€ ๊ณต์กด(4948)
    • ์žฌ๊ท€
      • ํ•˜๋…ธ์ด ํƒ‘ ์ด๋™ ์ˆœ์„œ(11729)
      • ํ”ผ๋ณด๋‚˜์น˜ ์ˆ˜ 5(10870)
      • ๋ณ„ ์ฐ๊ธฐ(2447)
    • ๋ธŒ๋ฃจํŠธ ํฌ์Šค
      • ๋ธ”๋ž™์žญ(2798)
      • ๋ถ„ํ•ดํ•ฉ(2231)
      • ๋ฉ์น˜(7568)
      • ์ฒด์ŠคํŒ ๋‹ค์‹œ ์น ํ•˜๊ธฐ(1018)
      • ์˜ํ™”๊ฐ๋… ์Š˜(1436)
    • ์ง‘ํ•ฉ๊ณผ ๋งต
      • ์ˆซ์ž ์นด๋“œ(10815)
      • ๋ฌธ์ž์—ด ์ง‘ํ•ฉ(14425)
      • ์ˆซ์ž ์นด๋“œ2(10816)
      • ๋“ฃ๋ณด์žก(1764)
      • ๋Œ€์นญ ์ฐจ์ง‘ํ•ฉ(1269)
      • ์„œ๋กœ ๋‹ค๋ฅธ ๋ถ€๋ถ„ ๋ฌธ์ž์—ด ๊ฐฏ์ˆ˜(11478)
    • ์ •๋ ฌ
      • ์ˆ˜ ์ •๋ ฌํ•˜๊ธฐ(2750)
      • ์ˆ˜ ์ •๋ ฌํ•˜๊ธฐ 2(2751)
      • ์ˆ˜ ์ •๋ ฌํ•˜๊ธฐ 3(10989)
      • ํ†ต๊ณ„ํ•™(2108)
      • ์†ŒํŠธ์ธ์‚ฌ์ด๋“œ(1427)
      • ์ขŒํ‘œ ์ •๋ ฌํ•˜๊ธฐ(11650)
      • ์ขŒํ‘œ ์ •๋ ฌํ•˜๊ธฐ2(11651)
      • ๋‹จ์–ด ์ •๋ ฌ(1181)
      • ๋‚˜์ด์ˆœ ์ •๋ ฌ(10814)
      • ์ปคํŠธ๋ผ์ธ(25305)
      • ์ขŒํ‘œ์••์ถ•(18870)
    • ๋ฐฑํŠธ๋ž˜ํ‚น
      • N๊ณผ M - 1(15649)
      • N๊ณผ M - 2(15650)
      • N๊ณผ M - 3(15651)
      • N๊ณผ M - 4(15652)
      • N-Queen(9663)
      • ์Šค๋„์ฟ (2580)
      • ์—ฐ์‚ฐ์ž ๋ผ์›Œ๋„ฃ๊ธฐ(14888)
      • ์Šคํƒ€ํŠธ์™€ ๋งํฌ(14889)
    • ์ด๋ถ„ ํƒ์ƒ‰
      • ์ˆ˜ ์ฐพ๊ธฐ(1920)
    • ๋™์ ๊ณ„ํš๋ฒ•
      • ํ”ผ๋ณด๋‚˜์น˜ ํ•จ์ˆ˜(1003)
      • ์‹ ๋‚˜๋Š” ํ•จ์ˆ˜ ์‹คํ–‰(9184)
      • 01ํƒ€์ผ(1904)
      • ํŒŒ๋„๋ฐ˜ ์ˆ˜์—ด(9461)
      • RGB๊ฑฐ๋ฆฌ(1149)
      • ์ •์ˆ˜ ์‚ผ๊ฐํ˜•(1932)
      • ๊ณ„๋‹จ ์˜ค๋ฅด๊ธฐ(2579)
      • 1๋กœ ๋งŒ๋“ค๊ธฐ(1463)
      • ์‰ฌ์šด ๊ณ„๋‹จ ์ˆ˜(10844)
      • ํฌ๋„์ฃผ ์‹œ์‹(2156)
      • ๊ฐ€์žฅ ๊ธด ์ฆ๊ฐ€ํ•˜๋Š” ๋ถ€๋ถ„ ์ˆ˜์—ด(11053)
      • ๊ฐ€์žฅ ๊ธด ๋ฐ”์ดํ† ๋‹‰ ๋ถ€๋ถ„ ์ˆ˜์—ด(11504)
      • ์ „๊นƒ์ค„(2565)
      • LCS(9251)
      • ์—ฐ์†ํ•ฉ(1912)
      • ํ‰๋ฒ”ํ•œ ๋ฐฐ๋‚ญ(12865)
      • ๋”ํ•˜๊ธฐ(9095)
    • DFS์™€ BFS
      • ๋ฏธ๋กœํƒ์ƒ‰(2178)
      • ๋ฐ”์ด๋Ÿฌ์Šค(2606)
      • DFS์™€ BFS(1260)
      • ๋‹จ์ง€๋ฒˆํ˜ธ๋ถ™์ด๊ธฐ(2667)
      • ์ „์Ÿ - ์ „ํˆฌ(1303)
      • ์ˆจ๋ฐ”๊ผญ์งˆ(1697)
      • ๋ฐ์Šค ๋‚˜์ดํŠธ(16948)
      • ๋‚˜์ดํŠธ์˜ ์ด๋™(7562)
      • ๋…น์ƒ‰ ์˜ท ์ž…์€ ์• ๊ฐ€ ์ ค๋‹ค์ง€?(4485)
      • ์Œ์‹๋ฌผ ํ”ผํ•˜๊ธฐ(1743)
      • A->B (16953)
      • ์ˆจ๋ฐ”๊ผญ์งˆ 3(13549)
      • ์ˆจ๋ฐ”๊ผญ์งˆ 2(12851)
    • ๊ตฌํ˜„
      • ์น˜์ฆˆ(2636)
  • ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค ๋ฌธ์ œ
    • SQL
      • Animal Table - Oracle
      • Animal Table - MySQL
      • Animal Table2 - Oracle
      • Animal Table 3,4 - Oracle
    • Lv1
      • ๋‘ ๊ฐœ ๋ฝ‘์•„์„œ ๋”ํ•˜๊ธฐ
      • ์ œ์ผ ์ž‘์€ ์ˆ˜ ์ œ๊ฑฐํ•˜๊ธฐ
      • ๋ฌธ์ž์—ด ๋‚ด p์™€ y์˜ ๊ฐœ์ˆ˜
      • ์˜ˆ์‚ฐ
      • ์ž๋ฆฟ์ˆ˜ ๋”ํ•˜๊ธฐ
      • ๋‘ ์ •์ˆ˜ ์‚ฌ์ด์˜ ํ•ฉ
      • ๊ฐ™์€ ์ˆซ์ž๋Š” ์‹ซ์–ด
      • ๊ฐ€์šด๋ฐ ๊ธ€์ž ๊ฐ€์ ธ์˜ค๊ธฐ
      • ์ˆ˜๋ฐ•์ˆ˜๋ฐ•์ˆ˜๋ฐ•์ˆ˜๋ฐ•์ˆ˜๋ฐ•์ˆ˜?
      • ๋‚˜๋ˆ„์–ด ๋–จ์–ด์ง€๋Š” ์ˆซ์ž ๋ฐฐ์—ด
      • 2016๋…„
      • ํฐ์บฃ๋ชฌ
      • ์„œ์šธ์—์„œ ๊น€์„œ๋ฐฉ ์ฐพ๊ธฐ
      • ๋ฌธ์ž์—ด์„ ์ •์ˆ˜๋กœ ๋ฐ”๊พธ๊ธฐ
      • ์†Œ์ˆ˜ ๋งŒ๋“ค๊ธฐ
      • ๋ฌธ์ž์—ด ๋‹ค๋ฃจ๊ธฐ ๊ธฐ๋ณธ
      • ์†Œ์ˆ˜ ์ฐพ๊ธฐ(์—๋ผํ† ์Šคํ…Œ๋„ค์Šค์˜ ์ฒด)
      • ์ˆซ์ž ๋ฌธ์ž์—ด๊ณผ ์˜๋‹จ์–ด
      • ์ด์ƒํ•œ ๋ฌธ์ž ๋งŒ๋“ค๊ธฐ
      • ์—†๋Š” ์ˆซ์ž ๋”ํ•˜๊ธฐ
      • ๋ฌธ์ž์—ด ๋‚ด๋ฆผ์ฐจ์ˆœ์œผ๋กœ ๋ฐฐ์น˜ํ•˜๊ธฐ
      • ๋ฌธ์ž์—ด ๋‚ด ๋งˆ์Œ๋Œ€๋กœ ์ •๋ ฌํ•˜๊ธฐ
      • ์•ฝ์ˆ˜์˜ ๊ฐœ์ˆ˜์™€ ๋ง์…ˆ
      • ์ฝœ๋ผ์ธ  ์ถ”์ธก
      • ์ž์—ฐ์ˆ˜ ๋’ค์ง‘์–ด ๋ฐฐ์—ด๋กœ ๋งŒ๋“ค๊ธฐ
      • ์‹ ๊ทœ ์•„์ด๋”” ์ถ”์ฒœ
      • ๋น„๋ฐ€์ง€๋„
      • ํฌ๋ ˆ์ธ ์ธํ˜•๋ฝ‘๊ธฐ ๊ฒŒ์ž„
      • ์‹คํŒจ์œจ
      • ๋กœ๋˜์˜ ์ตœ๊ณ  ์ˆœ์œ„์™€ ์ตœ์ € ์ˆœ์œ„
      • ํ‚คํŒจ๋“œ ๋ˆ„๋ฅด๊ธฐ
      • ์ •์ˆ˜ ๋‚ด๋ฆผ์ฐจ์ˆœ์œผ๋กœ ๋ฐฐ์น˜ํ•˜๊ธฐ
    • Lv2
      • ํ–‰๋ ฌ์˜ ๊ณฑ์…ˆ
      • ์˜์–ด ๋๋ง์ž‡๊ธฐ
      • ์˜์–ด ๋๋ง์ž‡๊ธฐ
      • N๊ฐœ์˜ ์ตœ์†Œ ๊ณต๋ฐฐ์ˆ˜
      • ํ”ผ๋ณด๋‚˜์น˜ ์ˆ˜
      • 124 ๋‚˜๋ผ์˜ ์ˆซ์ž
      • ์ง์ง€์–ด ์ œ๊ฑฐํ•˜๊ธฐ
      • ํ”„๋ฆฐํ„ฐ
      • ๋‹ค์Œ ํฐ ์ˆซ์ž
      • ์ตœ๋Œ“๊ฐ’๊ณผ ์ตœ์†Ÿ๊ฐ’
      • ์ตœ์†Œ๊ฐ’ ๋งŒ๋“ค๊ธฐ
      • ์ˆซ์ž์˜ ํ‘œํ˜„
      • JadenCase ๋ฌธ์ž์—ด ๋งŒ๋“ค๊ธฐ
      • ์˜คํ”ˆ์ฑ„ํŒ…๋ฐฉ
      • ์˜์–ด ๋๋ง์ž‡๊ธฐ
      • ๋ฉ€์ฉกํ•œ ์‚ฌ๊ฐํ˜•
      • ์˜ฌ๋ฐ”๋ฅธ ๊ด„ํ˜ธ
      • ์œ„์žฅ
      • ๊ธฐ๋Šฅ๊ฐœ๋ฐœ
      • ๋” ๋งต๊ฒŒ
      • ์Šคํ‚ฌํŠธ๋ฆฌ
    • ์™„์ „ํƒ์ƒ‰
      • ๋ชจ์˜๊ณ ์‚ฌ(Lv1)
      • ์นดํŽซ(Lv2)
      • ์†Œ์ˆ˜ ์ฐพ๊ธฐ(Lv2)
    • ์ •๋ ฌ(Sorting)
      • K๋ฒˆ์งธ ์ˆ˜(Lv1)
      • ๊ฐ€์žฅ ํฐ ์ˆ˜(Lv2)
      • H-Index(Lv2)
    • ํ•ด์‹œ(Hash)
      • ์™„์ฃผํ•˜์ง€ ๋ชปํ•œ ์„ ์ˆ˜(Lv1)
      • ์ „ํ™”๋ฒˆํ˜ธ ๋ชฉ๋ก(Lv2)
    • ํƒ์š•๋ฒ•(Greedy)
      • ์ฒด์œก๋ณต(Lv1)
      • ํฐ ์ˆ˜ ๋งŒ๋“ค๊ธฐ(Lv2)
      • ๊ตฌ๋ช…๋ณดํŠธ(Lv2)
    • ๋™์ ๊ณ„ํš๋ฒ•(DP)
      • ์ •์ˆ˜ ์‚ผ๊ฐํ˜•(Lv3)
    • ๊นŠ์ด/๋„ˆ๋น„ ์šฐ์„  ํƒ์ƒ‰(DFS/BFS)
      • ํƒ€๊ฒŸ ๋„˜๋ฒ„(Lv2)
      • ๋„คํŠธ์›Œํฌ(Lv3)
      • ๋‹จ์–ด ๋ณ€ํ™˜(Lv3)
  • ์Šคํ”„๋ง๋ถ€ํŠธ ์ฑ…
    • Day 1
    • Day 2
    • Day 3
    • Day 4
    • Day 5
    • Day 6
    • Day 7
    • Day 8
    • Day 9
    • Day 10
    • Day 11
    • Day 12
    • Day 13
    • Day 14
    • Day 15
    • Day 16
    • Day 17
  • JPA ์ฑ…
    • ํ”„๋กœ์ ํŠธ ์„ธํŒ… ๋ฐ ๊ธฐ๋ณธ์„ค์ •
    • ์˜์†์„ฑ ๊ด€๋ฆฌ ๊ฐœ๋…
    • ์—”ํ‹ฐํ‹ฐ ๋งคํ•‘
      • ์‹ค์Šต ์˜ˆ์ œ
    • ์—ฐ๊ด€๊ด€๊ณ„ ๋งคํ•‘ ๊ธฐ์ดˆ
      • ์‹ค์Šต ์˜ˆ์ œ
    • ๋‹ค์–‘ํ•œ ์—ฐ๊ด€๊ด€๊ณ„ ๋งคํ•‘
      • ๋‹ค๋Œ€์ผ, ์ผ๋Œ€๋‹ค ๊ด€๊ณ„
      • ์ผ๋Œ€์ผ, ๋‹ค๋Œ€๋‹ค ๊ด€๊ณ„
      • ์‹ค์Šต ์˜ˆ์ œ
    • ๊ณ ๊ธ‰ ๋งคํ•‘
      • ์ƒ์† ๊ด€๊ณ„ ๋งคํ•‘
      • @MappedSuperclass
      • ๋ณตํ•ฉ ํ‚ค์™€ ์‹๋ณ„ ๊ด€๊ณ„ ๋งคํ•‘
      • ์กฐ์ธ ํ…Œ์ด๋ธ”
    • ํ”„๋ก์‹œ์™€ ์—ฐ๊ด€๊ด€๊ณ„ ๊ด€๋ฆฌ
      • ํ”„๋ก์‹œ
      • ์ฆ‰์‹œ ๋กœ๋”ฉ๊ณผ ์ง€์—ฐ ๋กœ๋”ฉ
      • ์˜์†์„ฑ ์ „์ด, ๊ณ ์•„ ๊ฐ์ฒด
    • ๊ฐ’ ํƒ€์ž…
      • ์ž„๋ฒ ๋””๋“œ ํƒ€์ž…
      • ๊ฐ’ ํƒ€์ž…๊ณผ ๋ถˆ๋ณ€ ๊ฐ์ฒด
      • ๊ฐ’ ํƒ€์ž…์˜ ๋น„๊ต, ์ปฌ๋ ‰์…˜
    • ๊ฐ์ฒด์ง€ํ–ฅ ์ฟผ๋ฆฌ ์–ธ์–ด
      • JPQL part1
      • JPQL part2
      • JPQL part3
      • QueryDSL
      • NativeSQL
      • ๊ฐ์ฒด์ง€ํ–ฅ ์ฟผ๋ฆฌ ์‹ฌํ™”
    • ์‘์šฉ ์• ํ”Œ๋ฆฌ์ผ€์ด์…˜
      • ์—”ํ‹ฐํ‹ฐ ์„ค์ •
    • ์Šคํ”„๋ง ๋ฐ์ดํ„ฐ JPA
      • ๊ณตํ†ต ์ธํ„ฐํŽ˜์ด์Šค
  • Kotlin In Action
    • ์ฝ”ํ‹€๋ฆฐ์˜ ํŠน์ง•
    • ์ฝ”ํ‹€๋ฆฐ์˜ ๊ธฐ์ดˆ
    • ํ•จ์ˆ˜ ์ •์˜์™€ ํ˜ธ์ถœ
    • ํด๋ž˜์Šค, ๊ฐ์ฒด, ์ธํ„ฐํŽ˜์ด์Šค
    • ๋žŒ๋‹ค ๋ฐฉ์‹
    • ์ฝ”ํ‹€๋ฆฐ ํƒ€์ž… ์‹œ์Šคํ…œ
    • ์—ฐ์‚ฐ์ž ์˜ค๋ฒ„๋กœ๋”ฉ๊ณผ ๊ธฐํƒ€ ๊ด€๋ก€
    • ๊ณ ์ฐจํ•จ์ˆ˜
    • ์ œ๋„ค๋ฆญ์Šค
    • ์• ๋…ธํ…Œ์ด์…˜๊ณผ ๋ฆฌํ”Œ๋ ‰์…˜
    • ์ฝ”๋ฃจํ‹ด
  • Oracle
    • Oracle ๊ธฐ๋ณธ
    • Oracle ์‹ฌํ™”
  • SQL_์—ฐ์Šต
    • Revising the Select Query
    • Basic Select
    • Advanced Select
    • Basic Select 2
  • SQL ์ฒซ๊ฑธ์Œ(์ฑ…)
    • Day 1
    • Day 2
    • Day 3
    • Day 4
    • Day 5
    • Day 6
    • Day 7
    • Day 8
    • Day 9
    • Day 10
    • Day 11
    • Day 12
    • Day 13
    • Day 14
    • Day 15
    • Day 16
    • Day 17
    • Day 18
    • Day 19
    • Day 20
    • Day 21
    • Day 22
    • Day 23
    • Day 24
    • Day 25
    • Day 26
    • Day 27
    • Day 28
    • Day 29
    • Day 30
  • ๋” ์ž๋ฐ” ์ฝ”๋“œ๋ฅผ ์กฐ์ž‘ํ•˜๋Š” ๋‹ค์–‘ํ•œ ๋ฐฉ๋ฒ•
    • JVM ์ดํ•ดํ•˜๊ธฐ
    • ๋ฐ”์ดํŠธ์ฝ”๋“œ ์กฐ์ž‘
    • ๋ฆฌํ”Œ๋ ‰์…˜
    • ๋‹ค์ด๋‚˜๋ฏน ํ”„๋ก์‹œ
    • ์• ๋…ธํ…Œ์ด์…˜ ํ”„๋กœ์„ธ์„œ
  • ๋” ์ž๋ฐ”, ์• ํ”Œ๋ฆฌ์ผ€์ด์…˜์„ ํ…Œ์ŠคํŠธํ•˜๋Š” ๋‹ค์–‘ํ•œ ๋ฐฉ๋ฒ•
    • JUnit5
    • Mockito
    • ๋„์ปค์™€ ํ…Œ์ŠคํŠธ
    • ์„ฑ๋Šฅ, ์šด์˜์ด์Šˆ, ์•„ํ‚คํ…์ฒ˜ ํ…Œ์ŠคํŠธ
  • ์ดํŽ™ํ‹ฐ๋ธŒ ์ž๋ฐ”
    • item1 - ์ƒ์„ฑ์ž ๋Œ€์‹  ์ •์  ํŒฉํ† ๋ฆฌ ๋ฉ”์†Œ๋“œ๋ฅผ ๊ณ ๋ คํ•˜๋ผ
    • item2 - ์ƒ์„ฑ์ž์— ๋งค๊ฐœ๋ณ€์ˆ˜๊ฐ€ ๋งŽ๋‹ค๋ฉด ๋นŒ๋”๋ฅผ ๊ณ ๋ คํ•˜๋ผ
    • item3 - ์ƒ์„ฑ์ž๋‚˜ ์—ด๊ฑฐํƒ€์ž…์œผ๋กœ ์‹ฑ๊ธ€ํ„ด์ž„์„ ๋ณด์ฆํ•˜๋ผ
    • item4 - ์ธ์Šคํ„ด์Šคํ™”๋ฅผ ๋ง‰๊ธฐ ์œ„ํ•ด์„  private ์ƒ์„ฑ์ž๋ฅผ ์‚ฌ์šฉํ•˜๋ผ
    • item5 - ์ž์›์„ ์ง์ ‘ ๋ช…์‹œํ•˜์ง€ ๋ง๊ณ  ์˜์กด ๊ฐ์ฒด ์ฃผ์ž…์„ ์‚ฌ์šฉํ•˜๋ผ
    • item6 - ๋ถˆํ•„์š”ํ•œ ๊ฐ์ฒด ์ƒ์„ฑ์„ ํ”ผํ•˜๋ผ
    • item7 - ๋‹ค ์“ด ๊ฐ์ฒด ์ฐธ์กฐ๋ฅผ ํ•ด์ œํ•˜๋ผ
    • item8 - finalizer์™€ cleaner ์‚ฌ์šฉ์„ ํ”ผํ•˜๋ผ
    • item9 - try-finally ๋ณด๋‹ค try-with-resources์„ ์‚ฌ์šฉํ•˜๋ผ
    • item10 - equals๋Š” ์ผ๋ฐ˜ ๊ทœ์•ฝ์„ ์ง€์ผœ ์žฌ์ •์˜ํ•˜๋ผ
    • item11 - equals์„ ์žฌ์ •์˜ํ•˜๋ ค๋ฉด hashCode๋„ ์žฌ์ •์˜ํ•˜๋ผ
    • item12 - toString์„ ํ•ญ์ƒ ์žฌ์ •์˜ํ•˜๋ผ
    • item13 - clone ์žฌ์ •์˜๋Š” ์ฃผ์˜ํ•ด์„œ ์ง„ํ–‰ํ•˜๋ผ
    • item14 - Comparable์„ ๊ตฌํ˜„ํ• ์ง€ ๊ณ ๋ฏผํ•˜๋ผ
  • Elastic Search
    • ๊ฐ•์˜ Summary
    • Elastic Summary ๊ฐœ๋… ์ •๋ฆฌ
    • Elastic Summary ์ ์šฉ ์ •๋ฆฌ
  • ํ† ๋น„์˜ ์Šคํ”„๋ง ๊ฐ•์˜
    • ์Šคํ”„๋ง๋ถ€ํŠธ ์‚ดํŽด๋ณด๊ธฐ
    • ๋…๋ฆฝ ์‹คํ–‰ํ˜• ์„œ๋ธ”๋ฆฟ ์• ํ”Œ๋ฆฌ์ผ€์ด์…˜
  • k8s
    • minikube ์„ค์น˜
    • jenkins ์ถ”๊ฐ€
  • Article
    • Choosing the Right MessageBroker
Powered by GitBook
On this page
  • ๋“ฑ๋ก/์ˆ˜์ •/์กฐํšŒ API ๋งŒ๋“ค๊ธฐ
  • ์ˆ˜์ • / ์กฐํšŒ๊ธฐ๋Šฅ

Was this helpful?

  1. ์Šคํ”„๋ง๋ถ€ํŠธ ์ฑ…

Day 4

Day4

๋“ฑ๋ก/์ˆ˜์ •/์กฐํšŒ API ๋งŒ๋“ค๊ธฐ

๐Ÿ‘‰API๋ฅผ ๋งŒ๋“ค๊ธฐ ์œ„ํ•ด ์ด 3๊ฐœ์˜ ํด๋ž˜์Šค๊ฐ€ ํ•„์š”ํ•ฉ๋‹ˆ๋‹ค

  • Request ๋ฐ์ดํ„ฐ๋ฅผ ๋ฐ›์€ DTO

  • API ์š”์ฒญ์„ ๋ฐ›์„ Controller

  • ํŠธ๋žœ์žญ์…˜, ๋„๋ฉ”์ธ ๊ธฐ๋Šฅ ๊ฐ„์˜ ์ˆœ์„œ๋ฅผ ๋ณด์žฅํ•˜๋Š” Service

โœ…service๋Š” ํŠธ๋žœ์žญ์…˜, ๋„๋ฉ”์ธ ๊ฐ„์˜ ์ˆœ์„œ๋ฅผ ๋ณด์žฅ

Web Layer, Service Layer, Repository Layer, Dtos, Domain Model

  • Web Layer

    • ํ”ํžˆ ์‚ฌ์šฉํ•˜๋Š” ์ปจํŠธ๋กค๋Ÿฌ์™€ JSP/Freemarker ๋“ฑ์˜ ๋ทฐ ํ…œํ”Œ๋ฆฟ ์˜์—ญ

    • ์ด์™ธ์—๋„ @Filter, ์ธํ„ฐ์…‰ํ„ฐ, ์ปจํŠธ๋กค๋Ÿฌ ์–ด๋“œ๋ฐ”์ด์Šค(@ControllerAdvice)๋“ฑ ์™ธ๋ถ€ ์š”์ฒญ๊ณผ ์‘๋‹ต์— ๋Œ€ํ•œ ์ „๋ฐ˜์ ์ธ ์˜์—ญ์„ ์ด์•ผ๊ธฐํ•ฉ๋‹ˆ๋‹ค

  • Service Layer

    • @Service์— ์‚ฌ์šฉ๋˜๋Š” ์„œ๋น„์Šค ์˜์—ญ

    • ์ผ๋ฐ˜์ ์œผ๋กœ Controller์™€ Dao์˜ ์ค‘๊ฐ„ ์˜์—ญ์—์„œ ์‚ฌ์šฉ

    • @Transactional์ด ์‚ฌ์šฉ๋˜์–ด์•ผ ํ•˜๋Š” ์˜์—ญ

  • Repository Layer

    • db์™€ ๊ฐ™์ด ๋ฐ์ดํ„ฐ ์ €์žฅ์†Œ์— ์ ‘๊ทผํ•˜๋Š” ์˜์—ญ

    • ๊ธฐ์กด์˜ DAO๋ผ๊ณ  ์ƒ๊ฐํ•˜๋ฉด ๋จ

  • Dtos

    • Dto(Data Transfer Object)๋Š” ๊ณ„์ธต ๊ฐ„์— ๋ฐ์ดํ„ฐ ๊ตํ™˜์„ ์œ„ํ•œ ๊ฐ์ฒด๋ฅผ ์ด์•ผ๊ธฐํ•˜๋ฉฐ

  • Domain Model

    • ๋„๋ฉ”์ธ์ด๋ผ๊ณ  ๋ถˆ๋ฆฌ๋Š” ๊ฐœ๋ฐœ ๋Œ€์ƒ์„ ๋ชจ๋“  ์‚ฌ๋žŒ์ด ๋™์ผํ•œ ๊ด€์ ์—์„œ ์ดํ•ดํ•  ์ˆ˜ ์žˆ๊ณ  ๊ณต์œ ํ•  ์ˆ˜ ์žˆ๋„๋ก ๋‹จ์ˆœํ™” ์‹œํ‚จ ๊ฒƒ

    • @Entity๊ฐ€ ์‚ฌ์šฉ๋œ ์˜์—ญ์€ ๋„๋ฉ”์ธ ๋ชจ๋ธ

    • ๋ฌด์กฐ๊ฑด db์˜ ํ…Œ์ด๋ธ”๊ณผ ๊ด€๊ณ„๊ฐ€ ์žˆ์–ด์•ผ๋งŒ ํ•˜๋Š” ๊ฒƒ์€ ์•„๋‹˜

โœ…web, service, repository, dto, domain์ด 5๊ฐ€์ง€์˜ ๋ ˆ์ด์–ด์—์„œ ๋น„์ง€๋‹ˆ์Šค๋กœ์ง์„ ์ฒ˜๋ฆฌํ•˜๋Š” ๊ณณ์€ Domain

โœ…์„œ๋น„์Šค๋Š” ํŠธ๋žœ์žญ์…˜๊ณผ ๋„๋ฉ”์ธ ๊ฐ„์˜ ์ˆœ์„œ๋งŒ ๋ณด์žฅ

๐Ÿ‘‰์ฝ”๋“œ ์ž‘์„ฑ

/src/main/java/com/kyu/book/springboot/service/posts/PostsService.class

package com.kyu.book.springboot.service.posts;

import com.kyu.book.springboot.domain.posts.PostsRepository;
import com.kyu.book.springboot.web.dto.PostsSaveRequestDto;
import lombok.RequiredArgsConstructor;
import org.springframework.stereotype.Service;

import javax.transaction.Transactional;

@RequiredArgsConstructor
@Service
public class PostsService {
    private final PostsRepository postsRepository;

    @Transactional
    public Long save(PostsSaveRequestDto requestDto){
        return postsRepository.save(requestDto.toEntity()).getId();
    }
}

์Šคํ”„๋ง์—์„œ Bean์„ ์ฃผ์ž…๋ฐ›๋Š” ๋ฐฉ์‹

  • @Autowired

  • setter

  • ์ƒ์„ฑ์ž

โœ… ๊ฐ€์žฅ ๊ถŒ์žฅํ•˜๋Š” ๋ฐฉ์‹ : ์ƒ์„ฑ์ž โ‡’ @RequiredArgsConstructor๋กœ ํ•ด๊ฒฐ

@RequiredArgsConstructor๋Š” final์ด ์„ ์–ธ๋œ ๋ชจ๋“  ํ•„๋“œ๋ฅผ ์ธ์ž๊ฐ’์œผ๋กœ ์ƒ์„ฑํ•˜๋Š” ์ƒ์„ฑ์ž

Controller์™€ Service์—์„œ ์‚ฌ์šฉํ•  Dtoํด๋ž˜์Šค

src/main/java/com/kyu/book/springboot/web/dto/PostsSaveRequestDto.java

package com.kyu.book.springboot.web.dto;

import com.kyu.book.springboot.domain.posts.Posts;
import lombok.Builder;
import lombok.Getter;
import lombok.NoArgsConstructor;

@Getter
@NoArgsConstructor
public class PostsSaveRequestDto {
    private String title;
    private String content;
    private String author;

    @Builder
    public PostsSaveRequestDto(String title, String content, String author){
        this.title = title;
        this.content = content;
        this.author = author;
    }

    public Posts toEntity(){
        return Posts.builder().title(title).content(content).author(author).build();
    }
}

Entityํด๋ž˜์Šค๋Š” db์™€ ๋งž๋‹ฟ์€ ํ•ต์‹ฌ ํด๋ž˜์Šค, Entityํด๋ž˜์Šค๋ฅผ ๊ธฐ์ค€์œผ๋กœ ํ…Œ์ด๋ธ”์ด ์ƒ์„ฑ๋˜๊ณ , ์Šคํ‚ค๋งˆ๊ฐ€ ๋ณ€๊ฒฝ๋จ

โœ… View Layer์™€ DB Layer์˜ ์—ญํ•  ๋ถ„๋ฆฌ๋ฅผ ์ฒ ์ €ํ•˜๊ฒŒ ํ•˜๋Š” ๊ฒƒ์ด ์ข‹์Œ : Controller์—์„œ ๊ฒฐ๊ณผ๊ฐ’์œผ๋กœ ์—ฌ๋Ÿฌ ํ…Œ์ด๋ธ”์„ ์กฐ์ธํ•ด์„œ ์ค˜์•ผํ•  ๊ฒฝ์šฐ๊ฐ€ ๋นˆ๋ฒˆํ•˜๊ธฐ ๋–„๋ฌธ์—

โ‡’Entity ํด๋ž˜์Šค์™€ Controller์—์„œ ์“ธ Dto๋Š” ๋ถ„๋ฆฌํ•ด์„œ ์‚ฌ์šฉํ•˜๋ผ

Entityํด๋ž˜์Šค๋ฅผ ํ…Œ์ŠคํŠธํ•˜๋Š” ํ…Œ์ŠคํŠธ ์ฝ”๋“œ

src/test/java/com/kyu/book/springboot/web/PostsApiControllerTest.java

package com.kyu.book.springboot.web;

import com.kyu.book.springboot.domain.posts.Posts;
import com.kyu.book.springboot.domain.posts.PostsRepository;
import com.kyu.book.springboot.web.dto.PostsSaveRequestDto;
import org.junit.After;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.boot.test.web.client.TestRestTemplate;
import org.springframework.boot.web.server.LocalServerPort;
import org.springframework.http.HttpStatus;
import org.springframework.http.ResponseEntity;
import org.springframework.test.context.junit4.SpringRunner;

import java.util.List;

import static org.assertj.core.api.AssertionsForClassTypes.assertThat;

@RunWith(SpringRunner.class)
@SpringBootTest(webEnvironment = SpringBootTest.WebEnvironment.RANDOM_PORT)
public class PostsApiControllerTest {
    @LocalServerPort
    private int port;

    @Autowired
    private TestRestTemplate restTemplate;

    @Autowired
    private PostsRepository postsRepository;

    @After
    public void tearDown() throws Exception{
        postsRepository.deleteAll();
    }

    @Test
    public void postEnroll() throws Exception{
        String title = "title";
        String content = "content";
        PostsSaveRequestDto requestDto = PostsSaveRequestDto.builder().title(title).content(content).author("author").build();

        String url = "http://localhost:" + port + "/api/v1/posts";

        ResponseEntity<Long> responseEntity = restTemplate.postForEntity(url, requestDto, Long.class);

        assertThat(responseEntity.getStatusCode()).isEqualTo(HttpStatus.OK);
        assertThat(responseEntity.getBody()).isGreaterThan(0L);

        List<Posts> all = postsRepository.findAll();
        assertThat(all.get(0).getTitle()).isEqualTo(title);
        assertThat(all.get(0).getContent()).isEqualTo(content);
    }
}

์—ฌ๊ธฐ์„œ๋Š” @WebMvcTest๋ฅผ ์‚ฌ์šฉํ•˜์ง€ ์•Š์€ ์ด์œ  : ์‚ฌ์šฉํ•˜๊ฒŒ ๋˜๋ฉด JPA๊ธฐ๋Šฅ์ด ์ž‘๋™ํ•˜์ง€ ์•Š์Œ

JPA๊ธฐ๋Šฅ๊นŒ์ง€ ํ•œ ๋ฒˆ์— ํ…Œ์ŠคํŠธํ•˜๊ณ  ์‹ถ์„ ๋•Œ๋Š” @SpringBootTest์™€ @TestRestTemplate์„ ์‚ฌ์šฉํ•˜๋ผ

์ˆ˜์ • / ์กฐํšŒ๊ธฐ๋Šฅ

src/main/java/com/kyu/book/springboot/web/PostsApiController.java

package com.kyu.book.springboot.web;

import com.kyu.book.springboot.service.posts.PostsService;
import com.kyu.book.springboot.web.dto.PostsResponseDto;
import com.kyu.book.springboot.web.dto.PostsSaveRequestDto;
import lombok.RequiredArgsConstructor;
import org.springframework.web.bind.annotation.*;

@RequiredArgsConstructor
@RestController
public class PostsApiController {
    private final PostsService postsService;

    @PostMapping("/api/v1/posts")
    public Long save(@RequestBody PostsSaveRequestDto requestDto){
        return postsService.save(requestDto);
    }

    @PutMapping("/api/v1/posts/{id}")
    public Long update(@PathVariable Long id, @RequestBody PostsUpdateRequestDto requestDto){
        return postsService.update(id, requestDto);
    }

    @GetMapping("/api/v1/posts/{id}")
    public PostsResponseDto findById(@PathVariable long id){
        return postsService.findById(id);
    }
}

src/main/java/com/kyu/book/springboot/web/dto/PostsResponseDto.class

package com.kyu.book.springboot.web.dto;

import com.kyu.book.springboot.domain.posts.Posts;
import lombok.Getter;

@Getter
public class PostsResponseDto {
    private Long id;
    private String title;
    private String content;
    private String author;

    public PostsResponseDto(Posts entity){
        this.id = entity.getId();
        this.title = entity.getTitle();
        this.content = entity.getContent();
        this.author = entity.getAuthor();
    }
}

src/main/java/com/kyu/book/springboot/web/PostsUpdateRequestDto.class

package com.kyu.book.springboot.web.dto;

import lombok.Builder;
import lombok.Getter;
import lombok.NoArgsConstructor;

@Getter
@NoArgsConstructor
public class PostsUpdateRequestDto {
    private String title;
    private String content;

    @Builder
    public PostsUpdateRequestDto(String title, String content){
        this.title = title;
        this.content = content;
    }
}

src/main/java/com/kyu/book/springboot/domain/posts/Posts ์— ์ด๊ฑฐ ์ถ”๊ฐ€

public void update(String title, String content){
    this.title = title;
    this.content = content;
}

src/main/java/com/kyu/book/springboot/service/posts/PostsService ์— ์ด๊ฑฐ ์ถ”๊ฐ€

@Transactional
public Long update(Long id, PostsUpdateRequestDto requestDto){
    Posts posts = postsRepository.findById(id).orElseThrow(() -> new IllegalArgumentException("ํ•ด๋‹น ๊ฒŒ์‹œ๊ธ€์ด ์—†์Šต๋‹ˆ๋‹ค. id="+id));
    posts.update(requestDto.getTitle(), requestDto.getContent());

    return id;
}

public PostsResponseDto findById(Long id){
    Posts entity = postsRepository.findById(id).orElseThrow(() -> new IllegalArgumentException("ํ•ด๋‹น ๊ฒŒ์‹œ๊ธ€์ด ์—†์Šต๋‹ˆ๋‹ค. id="+id));

    return new PostsResponseDto(entity);
}

update ๊ธฐ๋Šฅ์—์„œ db์— ์ฟผ๋ฆฌ๋ฌธ์„ ์•ˆ๋‚ ๋ฆผ โ‡’ JPA์˜ ์˜์†์„ฑ ์ปจํ…์ŠคํŠธ ๋•Œ๋ฌธ์— ํ•„์š” ์—†์Œ

์˜์†์„ฑ ์ปจํ…์ŠคํŠธ : ์—”ํ‹ฐํ‹ฐ๋ฅผ ์˜๊ตฌ ์ €์žฅํ•˜๋Š” ํ™˜๊ฒฝ

ใ„ดJPA์˜ ํ•ต์‹ฌ ๋‚ด์šฉ์€ ์—”ํ‹ฐํ‹ฐ๊ฐ€ ์˜์†์„ฑ ์ปจํ…์ŠคํŠธ์— ํฌํ•จ๋˜์–ด ์žˆ๋ƒ ์•„๋‹ˆ๋ƒ๋กœ ๊ฐˆ๋ฆผ

JPA์˜ ์—”ํ‹ฐํ‹ฐ ๋งค๋‹ˆ์ €๊ฐ€ ํ™œ์„ฑํ™”๋œ ์ƒํƒœ(JPA์‚ฌ์šฉ์‹œ ๊ธฐ๋ณธ ์˜ต์…˜) ์‹œ, ํŠธ๋žœ์žญ์…˜ ์•ˆ์—์„œ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค์—์„œ ๋ฐ์ดํ„ฐ๋ฅผ ๊ฐ€์ ธ์˜ค๋ฉด ์ด ๋ฐ์ดํ„ฐ๋Š” ์˜์†์„ฑ ์ปจํ…์ŠคํŠธ๊ฐ€ ์œ ์ง€๋œ ์ƒํƒœ์ด๋‹ค

์ด ์ƒํƒœ์—์„œ ํ•ด๋‹น ๋ฐ์ดํ„ฐ์˜ ๊ฐ’์„ ๋ณ€๊ฒฝํ•˜๋ฉด ํŠธ๋žœ์žญ์…˜์ด ๋๋‚ ๋•Œ ํ…Œ์ด๋ธ”์— ๋ณ€๊ฒฝ๋ฌธ์„ ๋ฐ˜์˜

์ฆ‰, Entity ๊ฐ์ฒด์˜ ๊ฐ’๋งŒ ๋ณ€๊ฒฝํ•˜๋ฉด ๋ณ„๋„๋กœ Update์ฟผ๋ฆฌ๋ฅผ ๋‚ ๋ฆด ํ•„์š”๊ฐ€ ์—†๋‹ค = ๋”ํ‹ฐ ์ฒดํ‚น

update๋ฅผ ์ถ”๊ฐ€ํ–ˆ์œผ๋‹ˆ ํ…Œ์ŠคํŠธ ์ฝ”๋“œ๋ฅผ ์ž‘์„ฑ

src/test/java/com/kyu/book/springboot/web/PostsApiControllerTest ์— ์ถ”๊ฐ€

@Test
public void postUpdates() throws Exception{
    Posts savedPosts = postsRepository.save(Posts.builder().title("title").content("content").author("author").build());

    Long updateId = savedPosts.getId();
    String expectedTitle = "title2";
    String expectedContent = "content2";

    PostsUpdateRequestDto requestDto = PostsUpdateRequestDto.builder().title(expectedTitle).content(expectedContent).build();

    String url = "http://localhost:" + port + "/api/v1/posts/" + updateId;

    HttpEntity<PostsUpdateRequestDto> requestEntity = new HttpEntity<>(requestDto);

    ResponseEntity<Long> responseEntity = restTemplate.exchange(url, HttpMethod.PUT, requestEntity, Long.class);

    assertThat(responseEntity.getStatusCode()).isEqualTo(HttpStatus.OK);
    assertThat(responseEntity.getBody()).isGreaterThan(0L);

    List<Posts> all = postsRepository.findAll();
    assertThat(all.get(0).getTitle()).isEqualTo(expectedTitle);
    assertThat(all.get(0).getContent()).isEqualTo(expectedContent);
    
}

local์—์„œ๋Š” db๋ฅผ h2๋ฅผ ์‚ฌ์šฉํ•˜๊ณ  ๋ฉ”๋ชจ๋ฆฌ์—์„œ ์‹คํ–‰ํ•˜๊ธฐ ๋•Œ๋ฌธ์— ์ง์ ‘ ์ ‘๊ทผํ•˜๋ ค๋ฉด ์›น ์ฝ˜์†”์„ ์‚ฌ์šฉํ•ด์•ผํ•จ

  1. application-properties์— ๋‹ค์Œ์„ ์ถ”๊ฐ€

    spring.h2.console.enabled=true
  2. JDBC URL ๋ถ€๋ถ„์„ jdbc:h2:mem:testdb ๋กœ ๋ณ€๊ฒฝํ›„, connect๋ฒ„ํŠผ ํด๋ฆญ

  3. insert into posts(author, content, title) values ('author', 'content', 'title'); ์„ ์ง‘์–ด ๋„ฃ๊ณ  run

PreviousDay 3NextDay 5

Last updated 3 years ago

Was this helpful?

main์„ ์‹คํ–‰ํ•œ ํ›„, ๋กœ ์ ‘์†

์šฐ๋ฆฌ๊ฐ€ ์ƒ์„ฑํ•œ ๋กœ ๋“ค์–ด๊ฐ€๋ฉด insertํ•ด๋‘” posts๋“ค์ด ๋‚˜์˜ค๊ฒŒ ๋จ

http://localhost:8080/h2-console
http://localhost:8080/api/v1/posts/1