<insert id="add" parameterType="com.tge.mm.pojo.Question">
insert into t_question (
subject,type,difficulty,analysis,analysisVideo,
remark,isClassic,status,reviewStatus,createDate,
userId,companyId,catalogId,courseId
)
values (
#{subject},#{type},#{difficulty},#{analysis},#{analysisVideo},
#{remark},#{isClassic},#{status},#{reviewStatus},#{createDate},
#{userId},#{companyId},#{catalogId},#{courseId}
)
-- 获取自增长的ID
<selectKey keyProperty="id" keyColumn="id" resultType="int" order="AFTER">
select last_insert_id()
</selectKey>
</insert>
获取自增长的ID
最新推荐文章于 2024-04-23 16:28:39 发布