67,512
社区成员
发帖
与我相关
我的任务
分享
<insert id="insert" parameterType="org.learn.baseframe.entity.SysUser" useGeneratedKeys="true" keyProperty="id">
insert into t_sys_user (su_username, su_password, su_name, su_sex)
values (#{username,jdbcType=NVARCHAR}, #{password,jdbcType=NVARCHAR}, #{name,jdbcType=NVARCHAR},
#{sex,jdbcType=NVARCHAR})
</insert>
<insert id="insert" parameterType="org.learn.baseframe.entity.SysUser">
<selectKey resultType="java.lang.Long" keyProperty="id" order="AFTER" >
insert into t_sys_user (su_username, su_password, su_name, su_sex)
values (#{username,jdbcType=NVARCHAR}, #{password,jdbcType=NVARCHAR}, #{name,jdbcType=NVARCHAR}, #{sex,jdbcType=NVARCHAR})
SELECT SCOPE_IDENTITY()
</selectKey>
</insert>
<insert id="insert" parameterType="org.learn.baseframe.entity.SysUser">
<selectKey resultType="java.lang.Long" keyProperty="id" order="AFTER" >
SELECT SCOPE_IDENTITY()
</selectKey>
insert into t_sys_user (su_username, su_password, su_name,su_sex)
values (#{username,jdbcType=NVARCHAR}, #{password,jdbcType=NVARCHAR}, #{name,jdbcType=NVARCHAR},
#{sex,jdbcType=NVARCHAR})
</insert>