๋กœ์ผ“๐Ÿพ
article thumbnail
[MyBatis] ๋งˆ์ด๋ฐ”ํ‹ฐ์Šค selectOne๊ณผ selectList
... 2021. 1. 7. 21:26

๋งˆ์ด๋ฐ”ํ‹ฐ์Šค์—์„œ ์ œ๊ณตํ•˜๋Š” SqlSession ํด๋ž˜์Šค์—์„œ๋Š” CRUD๋ฅผ ์œ„ํ•œ ๋‹ค์–‘ํ•œ ๋ฉ”์„œ๋“œ๋ฅผ ์ œ๊ณตํ•ฉ๋‹ˆ๋‹ค. ๋Œ€ํ‘œ์ ์ธ select ๊ด€๋ จ ๋ฉ”์„œ๋“œ๋Š” ์•„๋ž˜ ํ…Œ์ด๋ธ”๊ณผ ๊ฐ™์Šต๋‹ˆ๋‹ค. ๋ฉ”์„œ๋“œ ๊ธฐ๋Šฅ List selectList(query_id) id์— ๋Œ€ํ•œ select๋ฌธ์„ ์‹คํ–‰ํ•œ ํ›„ ๋ ˆ์ฝ”๋“œ๋ฅผ List๋กœ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค. List selectList(query_id, '์กฐ๊ฑด') id์— ๋Œ€ํ•œ select๋ฌธ์„ ์‹คํ–‰ํ•˜๋ฉด์„œ ์กฐ๊ฑด(์ฟผ๋ฆฌ๋ฌธ์—์„œ ์‚ฌ์šฉํ•  ์ธ์ž)๋ฅผ ์ „๋‹ฌํ•ฉ๋‹ˆ๋‹ค. T selectOne(query_id) id์— ๋Œ€ํ•œ select๋ฌธ์„ ์‹คํ–‰ํ•œ ํ›„ ํ•œ๊ฐœ์˜ ๋ ˆ์ฝ”๋“œ๋ฅผ ์ง€์ •ํ•œ ํƒ€์ž…์œผ๋กœ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค. T selectOne(query_id, '์กฐ๊ฑด') id์— ๋Œ€ํ•œ select๋ฌธ์„ ์‹คํ–‰ํ•˜๋ฉด์„œ ์กฐ๊ฑด(์ฟผ๋ฆฌ๋ฌธ์—์„œ ์‚ฌ์šฉํ•  ์ธ์ž)๋ฅผ ์ „๋‹ฌํ•ฉ๋‹ˆ๋‹ค. ์—ญ์‹œ ์ดํ•ดํ•˜๋Š”๋ฐ ์˜ˆ์‹œ๋ฅผ..

profile on loading

Loading...