mybatis 插入语句

来源:互联网 发布:java工程师岗位 编辑:程序博客网 时间:2024/05/01 02:47
<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>

0 0