ibatis 插入数据返回主键写法

最新推荐文章于 2023-06-01 10:03:00 发布

yingmu3630

最新推荐文章于 2023-06-01 10:03:00 发布

阅读量198

点赞数

CC 4.0 BY-SA版权

分类专栏： SSIH 文章标签： java

本文链接：https://blog.youkuaiyun.com/yingmu3630/article/details/84474676

SSIH 专栏收录该内容

31 篇文章

订阅专栏

本文介绍了一个使用MyBatis实现的动态SQL插入语句的例子。该例子展示了如何通过MyBatis的标签进行条件判断来决定是否将某些字段加入到SQL语句中。具体包括了如何使用<selectKey>标签获取序列值以及<isNotNull>标签根据字段是否为空来决定是否添加到SQL语句中。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

<insert id="USER_INFO.insertSelective" parameterClass="com.model.UserInfo" >
[align=center][color=red] <selectKey resultClass="java.lang.Long" keyProperty="uiId">
SELECT USER_INFO_SEQ.nextval AS CAD_ID FROM DUAL
</selectKey>[/color][/align] insert into USER_INFO
<dynamic prepend="(" >
<isNotNull prepend="," property="uiId" >
UI_ID
</isNotNull>
<isNotNull prepend="," property="mobile" >
MOBILE
</isNotNull>
<isNotNull prepend="," property="password" >
PASSWORD
</isNotNull>
<isNotNull prepend="," property="state" >
STATE
</isNotNull>
<isNotNull prepend="," property="question" >
QUESTION
</isNotNull>
<isNotNull prepend="," property="answer" >
ANSWER
</isNotNull>
<isNotNull prepend="," property="createTime" >
CREATE_TIME
</isNotNull>
<isNotNull prepend="," property="updateTime" >
UPDATE_TIME
</isNotNull>
<isNotNull prepend="," property="demo" >
DEMO
</isNotNull>
)
</dynamic>
values
<dynamic prepend="(" >
<isNotNull prepend="," property="uiId" >
<![CDATA[ #uiId# ]]>
</isNotNull>
<isNotNull prepend="," property="mobile" >
<![CDATA[ #mobile# ]]>
</isNotNull>
<isNotNull prepend="," property="password" >
<![CDATA[ #password# ]]>
</isNotNull>
<isNotNull prepend="," property="state" >
<![CDATA[ #state# ]]>
</isNotNull>
<isNotNull prepend="," property="question" >
<![CDATA[ #question# ]]>
</isNotNull>
<isNotNull prepend="," property="answer" >
<![CDATA[ #answer# ]]>
</isNotNull>
<isNotNull prepend="," property="createTime" >
<![CDATA[ #createTime# ]]>
</isNotNull>
<isNotNull prepend="," property="updateTime" >
<![CDATA[ #updateTime# ]]>
</isNotNull>
<isNotNull prepend="," property="demo" >
<![CDATA[ #demo# ]]>
</isNotNull>
)
</dynamic>
</insert>