<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了
更多推荐
关于mybatis插入(insert)语句返回值问题
发布评论