关于mybatis插入(insert)语句返回值问题

   <insert id="insertEdmpClassFile" parameterType="EdmpClassFile">
        insert into edmp_class_file
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="id != null">id,</if>
            <if test="fileName != null and fileName != ''">file_name,</if>
            <if test="typeId != null">type_id,</if>
            <if test="categoryId != null">category_id,</if>
            <if test="categoryIds != null">category_ids,</if>
            <if test="uploadUrl != null">upload_url,</if>
            <if test="createBy != null">create_by,</if>
            <if test="createTime != null">create_time,</if>
            <if test="updateBy != null">update_by,</if>
            <if test="updateTime != null">update_time,</if>
            <if test="remark != null">remark,</if>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="id != null">#{id},</if>
            <if test="fileName != null and fileName != ''">#{fileName},</if>
            <if test="typeId != null">#{typeId},</if>
            <if test="categoryId != null">#{categoryId},</if>
            <if test="categoryIds != null">#{categoryIds},</if>
            <if test="uploadUrl != null">#{uploadUrl},</if>
            <if test="createBy != null">#{createBy},</if>
            <if test="createTime != null">#{createTime},</if>
            <if test="updateBy != null">#{updateBy},</if>
            <if test="updateTime != null">#{updateTime},</if>
            <if test="remark != null">#{remark},</if>
         </trim>
    </insert>

此时返回值为0或1,0为失败,1为成功

 <insert id="insertEdmpsStudentInfo" parameterType="EdmpsStudentInfo" useGeneratedKeys="true" keyProperty="id">
        insert into edmp_student_info
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="name != null and name != ''">name,</if>
            <if test="sex != null">sex,</if>
            <if test="age != null">age,</if>
            <if test="studentType != null">student_type,</if>
            <if test="mobile != null">mobile,</if>
            <if test="idCard != null">id_card,</if>
            <if test="address != null">address,</if>
            <if test="password != null">password,</if>
            <if test="unitId != null">unit_id,</if>
            <if test="unitIds != null">unit_ids,</if>
            <if test="dormitoryId != null">dormitory_id,</if>
            <if test="dormitoryIds != null">dormitory_ids,</if>
            <if test="classId != null">class_id,</if>
            <if test="classIds != null">class_ids,</if>
            <if test="status != null">status,</if>
            <if test="isSignIn != null">is_sign_in,</if>
            <if test="isGraduation != null">is_graduation,</if>
            <if test="lastLoginTime != null">last_login_time,</if>
            <if test="createDate != null">create_date,</if>
            <if test="updateDate != null">update_date,</if>
            <if test="createBy != null">create_by,</if>
            <if test="updateBy != null">update_by,</if>
            <if test="reserveField != null">reserve_field,</if>
            <if test="reserveField1 != null">reserve_field1,</if>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="name != null and name != ''">#{name},</if>
            <if test="sex != null">#{sex},</if>
            <if test="age != null">#{age},</if>
            <if test="studentType != null">#{studentType},</if>
            <if test="mobile != null">#{mobile},</if>
            <if test="idCard != null">#{idCard},</if>
            <if test="address != null">#{address},</if>
            <if test="password != null">#{password},</if>
            <if test="unitId != null">#{unitId},</if>
            <if test="unitIds != null">#{unitIds},</if>
            <if test="dormitoryId != null">#{dormitoryId},</if>
            <if test="dormitoryIds != null">#{dormitoryIds},</if>
            <if test="classId != null">#{classId},</if>
            <if test="classIds != null">#{classIds},</if>
            <if test="status != null">#{status},</if>
            <if test="isSignIn != null">#{isSignIn},</if>
            <if test="isGraduation != null">#{isGraduation},</if>
            <if test="lastLoginTime != null">#{lastLoginTime},</if>
            <if test="createDate != null">#{createDate},</if>
            <if test="updateDate != null">#{updateDate},</if>
            <if test="createBy != null">#{createBy},</if>
            <if test="updateBy != null">#{updateBy},</if>
            <if test="reserveField != null">#{reserveField},</if>
            <if test="reserveField1 != null">#{reserveField1},</if>
         </trim>
         <selectKey resultType="java.lang.Long" keyProperty="id">
             select @@IDENTITY  as id
         </selectKey>

此时会为插入的实体类的ID赋值,获取实体类的ID就是目前插入的主键ID了

  • 0
    点赞
  • 6
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值