¸¶À̹ÙƼ½º·Î µ¥ÀÌÅ͸¦ »ðÀÔÇÏ´Â ¹æ¹ýµé
¸¶À̹ÙƼ½º·Î µ¥ÀÌÅ͸¦ »ðÀÔÇÏ´Â ¹æ¹ýµé
1. °íÁ¤µÈ °ª ³Ö±â
ÆĶó¹ÌÅ͸¦ °¡ÁöÁö ¾Ê´Â sql ÀÇ °æ¿ìÀÌ´Ù.
<insert id="insertStudent">
INSERT INTO STUDENT VALUES(SEQ_STUDENT.NEXTVAL, 'µÑ¸®', '01012345678', 'ABCD@NAVER.COM', '°æ±âµµ ¼º³²½Ã', DEFAULT)
</insert>
º¯ÇÏ´Â °ªÀÌ ¾øÀÌ ¸Å¹ø °°Àº °ªÀÌ µé¾î°¡°Ô µÈ´Ù.
2. ÆĶó¹ÌÅ͸¦ ÀÌ¿ëÇÏ¿© ³Ö±â
ÆĶó¹ÌÅÍ´Â #{º¯¼ö À̸§} À¸·Î »ç¿ëÇÑ´Ù.
<insert id="insertStudent" parameterType="string">
INSERT INTO STUDENT VALUES(SEQ_STUDENT.NEXTVAL, #{name}, '01043215698', 'ABC@NAVER.COM', '¼¿ï½Ã', DEFAULT)
</insert>
À̹ø¿¡´Â À̸§ °ªÀ» ÆĶó¹ÌÅÍ·Î ¹Þ¾Æ¼ µ¥ÀÌÅ͸¦ »ðÀÔÇÏ´Â ÄÚµåÀÌ´Ù.
insert ű׿¡¼ ÆĶó¹ÌÅÍ¿¡ µé¾î°¡´Â º¯¼ö ŸÀÔÀ» parameterType¿¡ ³Ö¾îÁØ´Ù.
¸¶À̹ÙƼ½º ¿Í ÀÚ¹ÙÀÇ Å¸ÀÔÀ» ºñ±³ÇÑ Ç¥ÀÌ´Ù.
ÀÚ¹Ù ÀÚ·áÇüÀ¸·Î´Â String °ªÀÌ µé¾î°¬±â ¶§¹®¿¡ parameterType¿¡´Â ¸¶À̹ÙƼ½º ŸÀÔÀ¸·Î stringÀ» Àû¾îÁÖ¾ú´Ù.
dao¿¡¼´Â int result = session.insert("mybatis.insertName", name);
ÀÌ·¸°Ô ½áÁÖ¾ú´Ù.
String °ªÀÎ nameÀ» insert¸Þ¼ÒµåÀÇ µÎ¹ø° ¸Å°³º¯¼ö·Î ³Ö¾îÁØ´Ù.
ÆĶó¹ÌÅ͸¦ »ç¿ëÇÏ´Â ¹æ¹ýÀº PreparedStatment ¸¦ »ç¿ëÇÏ´Â ¹æ¹ý°ú ºñ½ÁÇÏ´Ù.
3. °´Ã¼ ³Ö±â
<insert id="enrollStudent" parameterType="com.mybatis.model.vo.Student">
INSERT INTO STUDENT VALUES(SEQ_STUDENT.NEXTVAL, #{studentName}, #{studentTel}, #{studentEmail}, #{studentAddress}, DEFAULT)
</insert>
insert ¹®ÀÇ values¿¡´Â °´Ã¼ÀÇ ¼Ó¼º À̸§À» ÆĶó¹ÌÅÍ·Î ³Ö¾îÁØ´Ù.
°´Ã¼¸¦ ³ÖÀ» ¶§´Â parameterType¿¡ ÆÐÅ°Áö °æ·Î±îÁö ´Ù ½áÁÖ¾î¾ß ÇÑ´Ù.
ÆÐÅ°Áö °æ·Î¸¦ ¾²Áö ¾ÊÀ¸·Á¸é ´ÙÀ½°ú °°ÀÌ mybatis-config.xml¸¦ ¼öÁ¤ÇÏ¸é µÈ´Ù.
<typeAliases>
<typeAlias type="com.mybatis.model.vo.Student" alias="student"/>
</typeAliases>
typeAlias ű×ÀÇ type ¼Ó¼º¿¡´Â ÆÐÅ°Áö¸¦ Æ÷ÇÔÇÑ Å¬·¡½º À̸§À» ¾²°í alias¿¡´Â ±× Ŭ·¡½º¸¦ »ç¿ëÇϱâ À§ÇÑ º°ÄªÀ» Àû¾îÁØ´Ù.
configuation ű״ À§ÀÇ À̹ÌÁö¿Í °°Àº ±¸Á¶¸¦ °®´Â´Ù.
µû¶ó¼ typeAliases ű׸¦ ³ÖÀ» ¶§´Â Àú ±¸Á¶¿¡ ¸Â°Ô ³Ö¾îÁÖ¾î¾ß ÇÑ´Ù.
typeAliases ű׸¦ ³Ö¾îÁØ ÈÄ¿¡´Â
<insert id="enrollStudent" parameterType="student">
INSERT INTO STUDENT VALUES(SEQ_STUDENT.NEXTVAL, #{studentName}, #{studentTel}, #{studentEmail}, #{studentAddress}, DEFAULT)
</insert>
parameterTypeÀ» student ·Î ÀûÀ» ¼ö ÀÖ´Ù.
Ãâó: https://sinna94.tistory.com/entry/MyBatis-µ¥ÀÌÅ͸¦-»ðÀÔÇÏ´Â-¹æ¹ýµé?category=696828 [Chungs]