Dev/Java
mybatis
냐옴
2012. 4. 18. 17:05
● ibatis
SELECT *
FROM TB_TEMP
WHERE 1=1
<dynamic>
<isNotNull property="USER_ID">
AND USER_ID = #USER_ID#
</isNotNull>
</dynamic>
● mybatis
SELECT *
FROM TB_TEMP
WHERE 1=1
<if test="USER_ID != null">
AND USER_ID = #{USER_ID}
</if>