JSON ๊ฒ€์ƒ‰ ๊ฒฐ๊ณผ
4 ๊ฐœ์˜ ๊ฒ€์ƒ‰ ๊ฒฐ๊ณผ๊ฐ€ ์žˆ์Šต๋‹ˆ๋‹ค.

Spring MVC | ๋ฌธ์„œ ์ถœ๋ ฅ ๋ฐฉ๋ฒ• | Spring @ResponseBody | RestController์™€ ํ•œ๊ธ€์ถœ๋ ฅ | Spring์—์„œ JSON ์ถœ๋ ฅ

๋ฌธ์„œ ์ถœ๋ ฅ ๋ฐฉ๋ฒ• 4๊ฐ€์ง€ ์„œ๋ธ”๋ฆฟ ๊ฐ์ฒด๋ฅผ ์–ป์–ด์„œ ๋ฌธ์ž์—ด ์ถœ๋ ฅํ•˜๊ธฐ @ResponsenBody ์„ค์ •์„ ํ†ตํ•œ ๋ฌธ์ž์—ด ์ถœ๋ ฅํ•˜๊ธฐ ResourceViewResolver๋ฅผ ์ด์šฉํ•œ ๋ฌธ์„œ ์ถœ๋ ฅํ•˜๊ธฐ TilesViewResolver๋ฅผ ์ด์šฉํ•œ ๋ฌธ์„œ ์ถœ๋ ฅํ•˜๊ธฐ httpservletresponse๋ฅผ ํ†ตํ•ด ์ถœ๋ ฅํ•˜๊ธฐ response, request๋ฅผ ์„ ์–ธ๋งŒ ํ•˜๋ฉด ํ”„๋ŸฐํŠธ ์ปจํŠธ๋กค๋Ÿฌ๊ฐ€ ๋„˜๊ฒจ์ฃผ์–ด์„œ ์ž…๋ ฅ๊ณผ ์ถœ๋ ฅ์ด ๊ฐ€๋Šฅํ•˜๋‹ค. ViewResolver ์—†์ด ํŽ˜์ด์ง€๋ฅผ ์ค€๋น„ํ•˜์ง€ ์•Š๊ณ  ์ง์ ‘ ์ถœ๋ ฅ ์Šคํ”„๋ง์€ ๋” ๊ฐ„๋‹จํ•œ ๋ฐฉ๋ฒ•์„ ์ œ๊ณตํ•˜๊ณ  ์žˆ๋‹ค. ViewResolver ์—†์ด ๋ฐ”๋กœ ์‚ฌ์šฉ์ž์—๊ฒŒ ๋ณด๋‚ด๋ผ๋Š” Annotation์‚ฌ์šฉ @ResponseBody HomeController.java package com.newlecture.web.controller; import j..

DBMS | JSON ๋ฐ์ดํ„ฐ์™€ ๋Œ€์šฉ๋Ÿ‰ ๋ฐ์ดํ„ฐ ์ €์žฅ | query-12(JSON๋ฐ์ดํ„ฐ ํฌ๋งท).sql

JSON ๋ฐ์ดํ„ฐ์™€ ๋Œ€์šฉ๋Ÿ‰ ๋ฐ์ดํ„ฐ ์ €์žฅ ์›น ํ™˜๊ฒฝ์ด๋‚˜ ๋ชจ๋ฐ”์ผ ์‘์šฉ ํ”„๋กœ๊ทธ๋žจ ๋“ฑ์—์„œ ๋ฐ์ดํ„ฐ๋ฅผ ๊ตํ™˜ํ•˜๊ธฐ ์œ„ํ•ด ๋งŒ๋“  ๊ฐœ๋ฐฉํ˜• ํ‘œ์ค€ ํฌ๋ฉง JSON์œผ๋กœ ์ž‘์„ฑํ•œ ๋ฐ์ดํ„ฐ๋Š” ์†์„ฑ(Key)๊ณผ ๊ฐ’(Value)์˜ ์Œ์œผ๋กœ ๊ตฌ์„ฑ JSON์€ ์ž๋ฐ”์Šคํฌ๋ฆฝํŠธ ์–ธ์–ด์—์„œ ํŒŒ์ƒ๋˜์—ˆ์ง€๋งŒ ํŠน์ •ํ•œ ํ”„๋กœ๊ทธ๋ž˜๋ฐ ์–ธ์–ด์— ์ข…์†๋˜์ง€ ์•Š์€ ๋…๋ฆฝ์ ์ธ ๋ฐ์ดํ„ฐ ํฌ๋ฉง query-12(JSON๋ฐ์ดํ„ฐ ํฌ๋งท).sql -- json (javascript object notation) ๋ฐ์ดํ„ฐ -- ํƒ€ ์–ธ์–ด๋“ค์— ์ข…์†๋˜์ง€ ์•Š๊ณ  ์„œ๋กœ ๊ตํ™˜์„ ํ• ์ˆ˜ ์žˆ๋Š” ๋ฐ์ดํ„ฐ ํฌ๋งทํ˜•ํƒœ use sqldb; select * from user; -- user์—์„œ 100์ด์ƒ ๋˜๋Š” ๋ฐ์ดํ„ฐ๋ฅผ ํ‚ค์™€ ๊ฐ’์˜ ํ˜•ํƒœ์˜ JSON๋ฐ์ดํ„ฐ ํฌ๋ฉงํ˜•ํƒœ๋กœ ๋ณ€ํ™˜ํ•˜๊ณ  ์žˆ๋‹ค. select json_object('username', us..