IBATIS/myBatis
2017.05.22 / 18:07
myBatis ÆĶó¹ÌÅÍ ¹ÙÀεù½Ã ÁÖÀÇÁ¡
ducati
Ãßõ ¼ö 226
¸ÅÇα¸¹®¿¡ ÆĶó¹ÌÅ͸¦ Àü´ÞÇÒ¶§ °ª ±â¹ÝÀ¸·Î Àü´ÞÇÑ ÆĶó¹ÌÅ͸¦ »ç¿ëÇÏ¸é ¾Æ¹«·± ¹®Á¦ ¾øÀÌ Ã³¸®µÈ´Ù.
String parameterName = "value";
session.selectList("com.test.mapper.TestSql", parameterName)
ÀÌ·¸°Ô ÆĶó¹ÌÅ͸¦ ÁÖ°í
<select id="TestSql" parameterType="String" resultType="com.test.mapping.Account">
SELECT *
FROM Account
WHERE AccountName = #{parameterName}
</select>
ÀÌ·¸°Ô ¸ÅÆÛ¸¦ »ç¿ëÇϸé Á¤»óÀûÀ¸·Î 󸮵ȴÙ. ÇÏÁö¸¸ $¸¦ ÀÌ¿ëÇØ ¹ÙÀεùÇÏ´Â °æ¿ì¿¡´Â ¿¡·¯°¡ ¹ß»ýÇÑ´Ù.
<select id="TestSql" parameterType="String" resultType="com.test.mapping.Account">
SELECT *
FROM Account
WHERE ${parameterName} = '°¡³ª´Ù'
</select>
ÀÌ·¸°Ô ÇÏ¸é ¼Ó¼ºÀ» ãÀ» ¼ö ¾ø´Ù¸é¼ ¿À·ù°¡ ¹ß»ýÇÑ´Ù. ÀÌ·¯ÇÑ °æ¿ì¿¡´Â ¹®ÀÚ¿·Î ¹Ù·Î ÆĶó¹ÌÅ͸¦ Àü´ÞÇÏÁö ¾Ê°í map¿¡ ³Ö¾î¼ Àü´ÞÇÑ´Ù.
Map<String, Object> parameters = new HashMap<String, Object>();
parameters.put("parameterName", "value");
session.selectList("com.test.mapper.TestSql", parameterName)
ÀÌ·¸°Ô ÆĶó¹ÌÅ͸¦ Àü´ÞÇϸé
<select id="TestSql" parameterType="String" resultType="com.test.mapping.Account">
SELECT *
FROM Account
WHERE ${parameterName} = '°¡³ª´Ù'
</select>
ÀÌ·¯ÇÑ ±¸¹®µµ Á¤»óÀûÀ¸·Î 󸮵ȴÙ.
$·Î ¹ÙÀεù µÇ´Â°ÇÀº ±×³É ¹®ÀڷΠġȯµÇ°í
#·Î ¹ÙÀεù µÇ´Â°ÇÀº setParameter ·Î ¹ÙÀÎ?? µÇ´Â Â÷ÀÌÀÔ´Ï´Ù.
Ãâó: http://devx.tistory.com/entry/myBatis-ÆĶó¹ÌÅÍ-¹ÙÀεù½Ã-ÁÖÀÇÁ¡ [Meta Developer Story]