mybatis 针对SQL Server 的 主键id生成策略
<insert parameterType="com.hqdl.xiaoyi.bean.SpUser"><selectKey keyProperty="id" resultType="String" order="BEFORE">
select newId()
</selectKey>
insert into sp_user_list (id, name, full_name,
password, category, user_type,
company_id, depart_id, code,
locked, wrong_pwd_count, last_login_time,
lock_reason, create_user_id, create_person_name,
create_time, deleted)
values (#{id,jdbcType=VARCHAR}, #{name,jdbcType=VARCHAR}, #{fullName,jdbcType=VARCHAR},
#{password,jdbcType=VARCHAR}, #{category,jdbcType=VARCHAR}, #{userType,jdbcType=VARCHAR},
#{companyId,jdbcType=VARCHAR}, #{departId,jdbcType=VARCHAR}, #{code,jdbcType=VARCHAR},
#{locked,jdbcType=CHAR}, #{wrongPwdCount,jdbcType=INTEGER}, #{lastLoginTime,jdbcType=VARCHAR},
#{lockReason,jdbcType=VARCHAR}, #{createUserId,jdbcType=VARCHAR}, #{createPersonName,jdbcType=VARCHAR},
#{createTime,jdbcType=VARCHAR}, #{deleted,jdbcType=CHAR})
</insert>
页:
[1]