MyBatis insert, update NULL ó¸®
MyBatis/iBatis¸¦ »ç¿ëÇÏ´Ùº¸¸é insert/update½Ã nullÀ» ÀÔ·ÂÇØ¾ß ÇÒ ¶§°¡ ÀÖ´Ù.
ÀϹÝÀûÀ¸·Î paramter¸¦ ³Ñ°Ü¼ insert/update¸¦ ¾Æ·¡¿Í °°ÀÌ ÇÑ´Ù°í ÇßÀ»¶§ ÀԷ°ªÀÌ Null ÀÌ µé¾î°¡ ÀÖÀ¸¸é ¿À·ù°¡ ¹ß»ýÇÑ´Ù.
<
insert
id
=
"insQuery"
parameterType
=
"hashmap"
>
INSERT INTO TB_test (idx, memo) VALUES (#{idx}, #{memo})
</
insert
>
<
insert
id
=
"upQuery"
parameterType
=
"hashmap"
>
UPDATE
TB_test
SET
memo = #{memo}
WHERE
idx = #{idx}
</
insert
>
Ãâó: http://fruitdev.tistory.com/46 [°úÀÏ°¡°Ô °³¹ßÀÚ]
À̸¦ ÇØ°áÇϱâ À§Çؼ± ´ÙÀ½°ú °°ÀÌ if¹®À» »ç¿ëÇؼ ó¸®ÇÒ¼öµµ ÀÖÁö¸¸, paramter°¡ ¸¹¾ÆÁö¸é ±²ÀåÈ÷ ³ÀâÇØÁö´Â ´ÜÁ¡ÀÌ ÀÖ´Ù
<
insert
id
=
"insQuery"
parameterType
=
"hashmap"
>
INSERT INTO
TB_test
(
idx
<
if
test
=
"memo != null"
>
, memo
</
if
>
)
VALUES
(
#{idx}
<
if
test
=
"memo != null"
>
, #{memo}
</
if
>
)
</
insert
>
Ãâó: http://fruitdev.tistory.com/46 [°úÀÏ°¡°Ô °³¹ßÀÚ]
if¹®À» »ç¿ëÇϱ⠺¸´Ù´Â jdbcTypeÀ» ÁöÁ¤Çϸé ÈξÀ ´õ ±ò²ûÇÏ°Ô Äڵ带 ÀÛ¼ºÇÒ ¼ö ÀÖ´Ù.
jdbcTypeÀ» ¸í½ÃÇØ ÁáÀ»°æ¿ì ÇØ´ç °ªÀÌ ÀÖÀ¸¸é ÇØ´ç°ªÀ», null ÀÏ°æ¿ì ÀÚµ¿À¸·Î nullÀ» ÀÔ·ÂÇØ ÁØ´Ù.
<
insert
id
=
"insQuery"
parameterType
=
"hashmap"
>
INSERT INTO TB_test (idx, memo) VALUES (#{idx, jdbcType=INTEGER}, #{memo, jdbcType=VARCHAR})
</
insert
>
<
insert
id
=
"upQuery"
parameterType
=
"hashmap"
>
UPDATE
TB_test
SET
memo = #{memo, jdbcType=VARCHAR}
WHERE
idx = #{idx, jdbcType=INTEGER}
</
insert
>
Ãâó: http://fruitdev.tistory.com/46 [°úÀÏ°¡°Ô °³¹ßÀÚ]
jdbcTypeÀ¸·Î ÁöÁ¤°¡´ÉÇѰ͵éÀº ¾Æ·¡¿Í °°À¸´Ï ¾÷¹«¿¡ Âü°íÇÏ¸é µÈ´Ù.
BIT
FLOAT
CHAR
TIMESTAMP
OTHER
UNDEFINED
TINYINT
REAL
VARCHAR
BINARY
BLOB
NVARCHAR
SMALLINT
DOUBLE
LONGVARCHAR
VARBINARY
CLOB
NCHAR
INTEGER
NUMERIC
DATE
LONGVARBINARY
BOOLEAN
NCLOB
BIGINT
DECIMAL
TIME
NULL
CURSOR
Ãâó: http://fruitdev.tistory.com/46 [°úÀÏ°¡°Ô °³¹ßÀÚ]