81,092
社区成员
发帖
与我相关
我的任务
分享
<!-- 插入新话题 返回数据id -->
<insert id="inserttopic" parameterType="map">
insert into topic (
TITLE,
<if test="FOREIGN_KEY != null and FOREIGN_KEY != ''">FOREIGN_KEY,</if>
CREATE_TIME
)values(
#{TITLE},
<if test="FOREIGN_KEY != null and FOREIGN_KEY != ''">#{FOREIGN_KEY},</if>
now()
)
<selectKey resultType="long" keyProperty="ID" >
SELECT @@IDENTITY AS ID
</selectKey>
</insert>