mybatis动态更新及批量动态插入

动态更新

<update id="updateElevator" parameterType="com.diantijiang.saas.data.elevator.Elevator" >
    update dc_elevator
    <set>
      <if test="inspectionCode != null">inspection_code = #{inspectionCode,jdbcType=VARCHAR},</if>
      <if test="brandCode!=null">brand_code = #{brandCode},</if>
      <if test="modelSpecs!=null">model_specs = #{modelSpecs},</if>
      <if test="elevatorType!=null">elevator_type=#{elevatorType},</if>
      <if test="idDistrict!=null">id_district=#{idDistrict},</if>
      <if test="idPropertyCompany!=null">id_property_company=#{idPropertyCompany},</if>
      <if test="idServiceCompany!=null">id_service_company=#{idServiceCompany},</if>
      <if test="idServiceManager!=null">id_service_manager=#{idServiceManager},</if>
      <if test="contractCode!=null">contract_code=#{contractCode},</if>
      <if test="runStatus!=null">run_status=#{runStatus},</if>
      <if test="qrCodeCheck!=null">qr_code_check=#{qrCodeCheck},</if>
      <if test="qrCodeProduct!=null">qr_code_product=#{qrCodeProduct},</if>
      <if test="lastAnnualDate!=null">last_annual_date=#{lastAnnualDate},</if>
      <if test="nextAnnualDate!=null">next_annual_date=#{nextAnnualDate},</if>
      <if test="lastMaintainDate!=null">last_maintain_date=#{lastMaintainDate},</if>
      <if test="nextMaintainDate!=null">next_maintain_date=#{nextMaintainDate},</if>
      <if test="repairTimes!=null">repair_times=#{repairTimes},</if>
      <if test="maintainTimes!=null">maintain_times=#{maintainTimes},</if>
      <if test="accessoriesExchanges!=null">accessories_exchanges=#{accessoriesExchanges},</if>
      <if test="installDate!=null">Install_date=#{installDate},</if>
      <if test="status!=null">status=#{status},</if>
      <if test="createdBy!=null">created_by=#{createdBy},