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

์„ ํ˜ธํ•˜๋Š”๊ฐœ๋ฐœ

[JavaSpringboot] Java SpringBoot Convert Viewer SnakeCase ๋ณ€ํ™˜๊ธฐ - โ“’ burningnow

Java SpringBoot Convert Viewer SnakeCase ๋ณ€ํ™˜๊ธฐ - โ“’ burningnow

์ž๋ฐ” ๊ฐœ๋ฐœ์„ ํ•˜๋Š”๋ฐ...์ž๊พธ DB ์ปฌ๋Ÿผ๋ช…์„ ๋ฐ”๊ฟ€๋•Œ ์˜คํƒ€๋‚˜ ๋‚˜๊ธฐ๋„ ํ•˜๊ณ ,

๋„ˆ๋ฌด ๋งŽ์•„์„œ ๋ณ€ํ™˜ํ•˜๋Š”๋ฐ ์“ธ๋ฐ์—†์ด ์‹œ๊ฐ„์ด ๋งŽ์ด๋“ค์–ด์„œ ํ›„๋‹ค๋‹ฅ~ ๋งŒ๋“ค์–ด๋ดค์Šต๋‹ˆ๋‹ค!

์—…๋ฌดํšจ์œจ ํ–ฅ์ƒ!!!!

 

 

์‚ฌ์šฉ๋ฐฉ๋ฒ•:

1. DBeaver ์—์„œ SQL ์ƒ์„ฑ > SELECT ํด๋ฆญํ•ด์„œ

2. SELECT ์ œ์™ธํ•˜๊ณ  ์ปฌ๋Ÿผ์˜์—ญ๋ถ€ํ„ฐ shift + end ๋ˆŒ๋Ÿฌ์„œ ๋๊นŒ์ง€ ๋ณต์‚ฌ

3. ์•„๋ž˜ ์›๋ณธ ์˜์—ญ์— ๋ถ™์—ฌ๋†“๊ณ , ๋ณ€ํ™˜ ๋ฒ„ํŠผ ๋ˆ„๋ฅด๊ธฐ

3.1. sampleVoName ์ž…๋ ฅ๋ž€์„ ๋ฐ”๊พธ๋ฉด, ๋ฐ˜์˜ํ•ด์„œ ๋ณ€ํ™˜!

MODEL, VO
res ์šฉ๋„ sampleVoName ์ž…๋ ฅ๋ž€:

  • ์›๋ณธ select๊ตฌ๋ฌธ์„ ์•„๋ž˜์นธ์— ๋„ฃ๊ณ , ๋ฒ„ํŠผ ํด๋ฆญ
  • ๋ณ€ํ™˜1 ์˜ˆ) model ์šฉ๋„
  • ๋ณ€ํ™˜2 ์˜ˆ) update ์šฉ๋„
  • ๋ณ€ํ™˜3 ์˜ˆ) vo ์šฉ๋„
  • ๋ณ€ํ™˜4 ์˜ˆ) res ์šฉ๋„
  • ๋ณ€ํ™˜5 ์˜ˆ) res ์šฉ๋„