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

jpql๊ธฐ์ดˆ1

[JPA] ๊ฐ์ฒด์ง€ํ–ฅ ์ฟผ๋ฆฌ ์–ธ์–ด - ๊ธฐ๋ณธ๋ฌธ๋ฒ• (1) JPQL Java Persistence Query Language ๊ฐ์ฒด์ง€ํ–ฅ ์ฟผ๋ฆฌ ์–ธ์–ด. ํ…Œ์ด๋ธ” ๋Œ€์ƒX ์—”ํ‹ฐํ‹ฐ ๊ฐ์ฒด๋ฅผ ๋Œ€์ƒO ์œผ๋กœ ์ฟผ๋ฆฌ SQL์„ ์ถ”์„ฑํ™”ํ•˜๋ฏ€๋กœ ํŠน์ • ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค SQL์— ์˜์กดํ•˜์ง€ ์•Š์Œ ๊ฒฐ๊ตญ SQL๋กœ ๋ณ€ํ™˜ JPQL ๋ฌธ๋ฒ• select m from Member as m where m.age > 14 ์—”ํ‹ฐํ‹ฐ์™€ ์†์„ฑ์€ ๋Œ€์†Œ๋ฌธ์ž ๊ตฌ๋ถ„ํ•จ O(Memeber, age ๊ฐ์ฒด๊ฐ€ ๊ฐ€์ง„ ๊ฒƒ๊ณผ ๋Œ€์†Œ๋ฌธ์ž ๋™์ผํ•ด์•ผ) JPQL ํ‚ค์›Œ๋“œ๋Š” ๋Œ€์†Œ๋ฌธ์ž ๊ตฌ๋ถ„ํ•˜์ง€ ์•Š์Œ(SELECT select FROM from WHERE where) ์—”ํ‹ฐํ‹ฐ ์ด๋ฆ„์„ ์‚ฌ์šฉํ•œ๋‹ค(ํ…Œ์ด๋ธ” ์ด๋ฆ„์ด ์•„๋‹˜) ๋ณ„์นญ์ด ํ•„์ˆ˜ m (as๋Š” ์ƒ๋žต ๊ฐ€๋Šฅํ•˜์ง€๋งŒ ๊ฐ€๊ธ‰์  ์“ฐ๋ฉด ์ข‹์Œ) ์ง‘ํ•ฉ, ์ •๋ ฌ ๋“ฑ ํ•จ์ˆ˜ ๊ฐ€๋Šฅ (COUNT, SUM, AVG, MAX, GROUP BY, ORDER.. 2023. 11. 26.

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