์‚ฌ์šฉ๋ฒ• 3

# [JPA] JPQL์˜ ๊ธฐ๋ณธ์  ์ •์˜์™€ ๊ฐ„๋‹จํ•œ ์‚ฌ์šฉ๋ฒ•

์•ž์„œ ํ•œ ๋‚ด์šฉ์—์„œ๋Š” ๊ธฐ๋ณธ์ ์ธ crud์— ๋Œ€ํ•ด ์•Œ๊ฒŒ ๋˜์—ˆ์Šต๋‹ˆ๋‹ค ํ•˜์ง€๋งŒ JPA๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ ์กฐ๊ฑด์„ ๋ถ™์—ฌ ์‚ฌ์šฉํ•  ๊ฒฝ์šฐ ์–ด๋–ป๊ฒŒ ์ง„ํ–‰ํ• ๊นŒ์š”? ์ด๋•Œ JPA์—์„œ ์ œ๊ณตํ•˜๋Š” ์–ธ์–ด๊ฐ€ JPQL์ž…๋‹ˆ๋‹ค. JPQL์ด๋ž€? SQL์„ ์ถ”์ƒํ™”ํ•œ ๊ฐ์ฒด ์ง€ํ–ฅ ์ฟผ๋ฆฌ ์–ธ์–ด๋กœ ํ…Œ์ด๋ธ”์ด ์•„๋‹Œ ๊ฐ์ฒด๋ฅผ ๋Œ€์ƒ์œผ๋กœ ๊ฒ€์ƒ‰ํ•˜๋Š” ๊ฐ์ฒด ์ง€ํ–ฅ ์ฟผ๋ฆฌ ์ž…๋‹ˆ๋‹ค. ์™œ? JPA ๋ฅผ ์‚ฌ์šฉํ•˜๋ฉด ์—”ํ„ฐํ‹ฐ ๊ฐ์ฒด๋ฅผ ์ค‘์‹ฌ์œผ๋กœ ๊ฐœ๋ฐœ์„ ํ•ฉ๋‹ˆ๋‹ค. ์ด๋•Œ ๊ฒ€์ƒ‰ ์ฟผ๋ฆฌ๊ฐ€ ๋ฌธ์ œ๊ฐ€ ๋ฉ๋‹ˆ๋‹ค. ๋ชจ๋“  ๋ฐ์ดํ„ฐ๋ฅผ ๊ฐ์ฒด๋กœ ๋ณ€ํ™˜ํ•ด์„œ ๊ฒ€์ƒ‰ํ•˜๋Š” ๊ฒƒ์€ ๋ถˆ๊ฐ€๋Šฅํ•˜๊ธฐ ๋•Œ๋ฌธ์ž…๋‹ˆ๋‹ค. ๋”ฐ๋ผ์„œ application์ด ํ•„์š”ํ•œ ๋ฐ์ดํ„ฐ๋งŒ DB์—์„œ ๋ถˆ๋Ÿฌ์˜ค๋ ค๋ฉด ๊ฒฐ๊ตญ ๊ฒ€์ƒ‰ ์กฐ๊ฑด์ด ํฌํ•จ๋œ SQL์ด ํ•„์š”ํ•ฉ๋‹ˆ๋‹ค. ํŠน์ง• SQL์„ ์ถ”์ƒํ™”ํ•ด์„œ ํŠน์ • ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค SQL์— ์˜์กดํ•˜์ง€ ์•Š์Šต๋‹ˆ๋‹ค. JPQL์„ ํ•œ๋งˆ๋””๋กœ ์ •์˜ํ•˜๋ฉด ๊ฐ์ฒด ์ง€ํ–ฅ SQL ์ž…๋‹ˆ๋‹ค. SQL๊ณผ..

CS 2021.11.30

[javaScript] ๊ธฐ์กด jQuery์˜ ajax๋ฅผ fetch๋กœ ๋ฐ”๊ฟ” ์‚ฌ์šฉํ•˜๊ธฐ(๊ธฐ์ดˆ)

Before ํ•ญ์ƒ jQuery์˜ ajax๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ ๋น„๋™๊ธฐ ์š”์ฒญ์„ ์ฃผ๊ณ  ๋ฐ›์•˜๋Š”๋ฐ ์š”์ฆ˜์—๋Š” ๋Œ€๋ถ€๋ถ„์˜ ๋ธŒ๋ผ์šฐ์ €์—์„œ fetch()๋ฅผ ์ง€์›ํ•œ๋‹ค๋Š” ๊ธ€์„ ๋ณด์•˜์Šต๋‹ˆ๋‹ค. ๊ทธ๋ž˜์„œ ์ €๋„ ๊ธฐ๋ณธ์— ์‚ฌ์šฉํ•˜๋˜ $.ajax()๋ฅผ fetch๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ ๋ฐ”๊ฟ” ๋ณด๊ธฐ๋กœ ํ•˜์˜€์Šต๋‹ˆ๋‹ค. $.ajax | GET ๊ธฐ์กด ์ฝ”๋“œ $.ajax({ url: getContextPath() +"/restapi/member/memberList" , type: 'get', success: function(res) { console.log("์„ฑ๊ณต"); console.log(res); }, error: function(xhr, error, msg) { console.log(xhr); console.log(error); console.log(msg); ..

[2021_06_23]fullCalendar && GanttChart API

preview Calendar.xml ์ˆ˜์ • script์—์„œ๋Š” String, java ์—์„œ๋Š” ? , xml์—์„œ๋Š” String invalid character, invalid column index ์˜ค๋ฅ˜ why? ๋ณธ์ธ์€ mac์„ ์‚ฌ์šฉ. slack์—์„œ ๋ณด๋‚ด์ค€ ์ฝ”๋“œ๋ฅผ ๊ทธ๋Œ€๋กœ ๋ณต์‚ฌํ•ด์„œ ๋ถ™์—ฌ๋„ฃ์—ˆ์Œ. ‘ ์™€ ' ๊ฒŒ ๋‹ค๋ฅด๊ฒŒ ์ƒ๊ธด๋“ฏ์ด ์„œ๋กœ ๋‹ค๋ฅธ ๋ฌธ์ž์ž„. mybatis์—์„œ ์ œ๋Œ€๋กœ ์ธ์‹์„ ๋ชปํ•จ. ์ง€์šฐ๊ณ  ์ง์ ‘ ์ž‘์„ฑํ•˜๋‹ˆ ์ž˜ ๋จ. json ๊ด€๋ จ ์‚ฌ์ดํŠธ https://www.json.org/json-en.html jsGantt ์‚ฌ์šฉํ•˜๊ธฐ ๊ธฐ๋ณธ sample ์ถœ๋ ฅํ•˜๊ธฐ http://www.basoinsa.online/htdocs/includes/jsgantt/index.html ์ฝ”๋“œ๋ฅผ ์ž…๋ง›์— ๋งž๊ฒŒ ์ˆ˜์ •ํ•ด์„œ ์‚ฌ์šฉ. g.AddTaskItem..

TIL 2021.06.23
728x90
๋ฐ˜์‘ํ˜•