IBATIS/myBatis
2022.05.02 / 15:58
¸¶À̹ÙƼ½º¸¦ ÀÌ¿ëÇÏ¿© ÆäÀÌ¡ ó¸®Çϱâ
ÄÚÄÚ·Î
Ãßõ ¼ö 135
MyBatis - ÆäÀÌ¡ ó¸®
MyBatis 2019. 2. 17. 23:22
¸¶À̹ÙƼ½º¸¦ ÀÌ¿ëÇÏ¿© ÆäÀÌ¡ ó¸®Çϱâ
RowBounds ¸¦ ÀÌ¿ëÇÏ¿© ó¸®ÇÏ°Ô µÈ´Ù.RowBounds row = new RowBounds(offset , limit);
RowBounds °´Ã¼´Â À§¿Í °°ÀÌ ¼±¾ðÇÏ¿©¼ »ç¿ëÇÑ´Ù.
offset °ú limit °ªÀ» ³Ö¾îÁÖ°Ô µÈ´Ù.
offsetÀº µ¥ÀÌÅ͸¦ °¡Á®¿À´Â ½ÃÀÛÁ¡¿¡¼ ¾ó¸¶³ª ¶³¾îÁø µ¥ÀÌÅÍÀÎÁö¸¦ ÀǹÌÇϸç
limitÀº ¸î °³ÀÇ °ªÀ» °¡Á®¿ÃÁö¸¦ ÀǹÌÇÑ´Ù.
RowBounds row = new RowBounds(offset , limit);
List<Map<String, String>> list = session.selectList("emp.searchEmpList", null, row);
select ¸Þ¼Òµå·Î µ¿ÀÏÇÏ°Ô µ¥ÀÌÅ͸¦ °¡Á®¿À¸ç
3¹ø° ¸Å°³º¯¼öÀÇ À§Ä¡¿¡ RowBounds °´Ã¼°¡ µé¾î°£´Ù.
ÆĶó¹ÌÅÍ °ªÀÌ ¾øÀ» °æ¿ì¿¡´Â nullÀ» ³Ö¾îÁÖ°Ô µÈ´Ù.
<select id="searchEmpList" resultMap="searchVo">
SELECT * FROM KH.EMPLOYEE
</select>
mapper¿¡¼´Â ÆäÀÌ¡ 󸮸¦ ÇÏÁö ¾ÊÀ» °æ¿ì¿Í °°ÀÌ Äõ¸®¹®¸¸ ÀÛ¼ºÇØÁÖ¸é µÈ´Ù.
Ãâó: https://sinna94.tistory.com/entry/MyBatis-ÆäÀÌ¡-ó¸®?category=696828 [Chungs]