您好,登錄后才能下訂單哦!
本篇內(nèi)容介紹了“ibatis中動態(tài)SQL_update的方法是什么”的有關(guān)知識,在實際案例的操作過程中,不少人都會遇到這樣的困境,接下來就讓小編帶領(lǐng)大家學(xué)習(xí)一下如何處理這些情況吧!希望大家仔細(xì)閱讀,能夠?qū)W有所成!
注意:如果<isNotEmpty>是寫在一行的話,并且是第一個的話
<isNotEmpty property="realName" prepend=","><![CDATA[ REALNAME = #realName# ]]></isNotEmpty>
內(nèi)容注意中間加個空格,不然會出現(xiàn) update role setname=xxx 直接報錯
<update id="updateRole" parameterClass="com.mmblue.model.Role"> <![CDATA[ UPDATE role SET gmt_modified = to_date(#gmtModified#,'yyyy-mm-dd hh34:mi:ss'), modifier = #modifier# ]]> <dynamic> <isNotEmpty property="isDeleted" prepend=","> <![CDATA[ is_deleted = #isDeleted# ]]> </isNotEmpty> <isNotEmpty property="roleCode" prepend=","> <![CDATA[ role_code = #roleCode# ]]> </isNotEmpty> <isNotEmpty property="roleName" prepend=","> <![CDATA[ role_name = #roleName# ]]> </isNotEmpty> <isNotEmpty property="deptId" prepend=","> <![CDATA[ dept_id = #deptId# ]]> </isNotEmpty> </dynamic> <![CDATA[ WHERE id = #id# ]]> </update>
2.再來個全部遍歷的
<update id="updateUser" parameterClass="com.mmblue.domain.User"> UPDATE MYIVR_TUSER <dynamic prepend="SET "> <isNotEmpty property="realName" prepend=","><![CDATA[ REALNAME = #realName# ]]></isNotEmpty> <isNotEmpty property="password" prepend=","><![CDATA[ PASSWORD = #password# ]]></isNotEmpty> <isNotEmpty property="projectId" prepend=","><![CDATA[ PROJECT_ID = #projectId# ]]></isNotEmpty> <isNotEmpty property="isEable" prepend=","><![CDATA[ ISENABLE = #isEable# ]]></isNotEmpty> <isNotEmpty property="createTime" prepend=","><![CDATA[ CREATETIME = #createTime# ]]></isNotEmpty> <isNotEmpty property="name" prepend=","><![CDATA[ USERNAME = #name# ]]></isNotEmpty> <isNotEmpty property="id" prepend=","><![CDATA[ USERID = #id# ]]></isNotEmpty> <isNotEmpty property="isFirstLogin" prepend=","><![CDATA[ ISFIRSTLOGIN = #isFirstLogin# ]]></isNotEmpty> </dynamic> <dynamic prepend="WHERE"> USERID = #id# </dynamic> </update>
“ibatis中動態(tài)SQL_update的方法是什么”的內(nèi)容就介紹到這里了,感謝大家的閱讀。如果想了解更多行業(yè)相關(guān)的知識可以關(guān)注億速云網(wǎng)站,小編將為大家輸出更多高質(zhì)量的實用文章!
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點不代表本網(wǎng)站立場,如果涉及侵權(quán)請聯(lián)系站長郵箱:is@yisu.com進(jìn)行舉報,并提供相關(guān)證據(jù),一經(jīng)查實,將立刻刪除涉嫌侵權(quán)內(nèi)容。