mybatis 插入语句_mybatis插入语句-优快云博客

本文链接：https://blog.youkuaiyun.com/sdzhangshulong/article/details/50687940

本文介绍了一个使用MyBatis实现的动态SQL插入案例，展示了如何根据对象属性的非空状态来动态构造SQL语句。该方法允许插入的数据项可以根据实际提供的参数智能地调整SQL字段，避免了因字段为空而导致的SQL语法错误。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

<insert id="saveConstru" parameterType="com.zehin.vpaas.base.domain.SyfBuild">
		
		<selectKey resultType="java.lang.Integer" order="BEFORE" keyProperty="BuildId">
				SELECT SEQUENCE_1.NEXTVAL FROM DUAL
		</selectKey>
		insert into SFY_SHELTER
		<trim prefix="(" suffix=")" suffixOverrides=",">
			<if test="buildProjName != null"> BUILD_PROJ_NAME,</if>
			<if test="buildConsStage != null"> BUILD_CONS_STAGE,	</if>
			<if test="branchOffice != null"> BRANCH_OFFICE,	</if>
			<if test="totalUnit != null"> TOTAL_UNIT,	</if>
			<if test="branchUnit != null"> BRANCH_UNIT,	</if>
			<if test="supervisorUnit != null"> SUPERSISOR_UNIT,	</if>
			<if test="consStaff != null"> CONS_STAFF,	</if>
			<if test="consStaffTel != null"> CONS_STAFF_TEL,	</if>
			<if test="orgId != null"> ORG_ID,	</if>
			<if test="totalUnitFile != null"> TOTAL_UNIT_FILE,	</if>
			<if test="branchUnitFile != null"> BRANCH_UNIT_FILE,	</if>
			<if test="supervisorUnitFile != null"> SUPERVISOR_UNIT_FILE,	</if>
		</trim>
		<trim prefix=" values(" suffix=")" suffixOverrides=",">
			<if test="buildProjName != null">#{buildProjName,jdbcType=VARCHAR},</if>
			<if test="buildConsStage != null"> #{buildConsStage,jdbcType=VARCHAR},	</if>
			<if test="branchOffice != null"> #{branchOffice,jdbcType=VARCHAR},	</if>
			<if test="totalUnit != null"> #{totalUnit,jdbcType=VARCHAR},	</if>
			<if test="branchUnit != null"> #{branchUnit,jdbcType=VARCHAR},</if>
			<if test="supervisorUnit != null"> #{supervisorUnit,jdbcType=VARCHAR},	</if>
			<if test="consStaff != null"> #{consStaff,jdbcType=VARCHAR},	</if>
			<if test="consStaffTel != null"> #{consStaffTel,jdbcType=VARCHAR},	</if>
			<if test="orgId != null"> #{orgId,jdbcType=VARCHAR},	</if>
			<if test="totalUnitFile != null"> #{totalUnitFile,jdbcType=VARCHAR},	</if>
			<if test="branchUnitFile != null"> #{branchUnitFile,jdbcType=VARCHAR},	</if>
			<if test="supervisorUnitFile != null"> #{supervisorUnitFile,jdbcType=VARCHAR},	</if>
		</trim>

		
	</insert>