ibatis中动态SQL_update

最新推荐文章于 2022-03-02 17:29:54 发布

babyck

最新推荐文章于 2022-03-02 17:29:54 发布

阅读量450

点赞数

CC 4.0 BY-SA版权

分类专栏： ibaits2.X 高级应用文章标签： SQL iBATIS XML

本文链接：https://blog.youkuaiyun.com/babyck/article/details/83802191

ibaits2.X 高级应用专栏收录该内容

7 篇文章

订阅专栏

如何知道上一篇的动态INSERT的话，动态UPDATE就很简单了，直接上XML

注意：如果<isNotEmpty>是写在一行的话，并且是第一个的话

内容注意中间加个空格，不然会出现 update role setname=xxx 直接报错

<update id="updateRole" parameterClass="com.mmblue.model.Role">
	<![CDATA[
		UPDATE role
		SET
			gmt_modified = to_date(#gmtModified#,'yyyy-mm-dd hh24: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>