mybatis trim

菜蜗牛很菜

于 2021-03-02 16:54:15 发布

阅读量149

点赞数

分类专栏： mybatis

本文链接：https://blog.csdn.net/weixin_45010894/article/details/114289091

版权

mybatis 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

<insert id="addDataCensusDetail" parameterType="com.rsi.rc.bs.module.censusparamdetail.dao.DataCensusDetail">
        <selectKey resultType="java.lang.Long" order="AFTER" keyProperty="detailId">
            SELECT LAST_INSERT_ID()
        </selectKey>
        insert into bs_data_census_detail_t
        <trim prefix="(" suffix=")" suffixOverrides="," >
            <if test="detailId != null" >
                detail_id,
            </if>
            <if test="censusId != null" >
                census_id,
            </if>
            <if test="sewageId != null" >
                sewage_id,
            </if>
            <if test="workshopId != null" >
                workshop_id,
            </if>
            <if test="deviceId != null" >
                device_id,
            </if>
            <if test="metricId != null" >
                metric_id,
            </if>
            <if test="time != null" >
                time,
            </if>
            <if test="value != null" >
                value,
            </if>
            <if test="averageValue != null" >
                average_value,
            </if>
            <if test="minValue != null" >
                min_value,
            </if>
            <if test="maxValue != null" >
                max_value,
            </if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides="," >
            <if test="detailId != null" >
                #{detailId,jdbcType=BIGINT},
            </if>
            <if test="censusId != null" >
                #{censusId,jdbcType=BIGINT},
            </if>
            <if test="sewageId != null" >
                #{sewageId,jdbcType=BIGINT},
            </if>
            <if test="workshopId != null" >
                #{workshopId,jdbcType=BIGINT},
            </if>
            <if test="deviceId != null" >
                #{deviceId,jdbcType=BIGINT},
            </if>
            <if test="metricId != null" >
                #{metricId,jdbcType=BIGINT},
            </if>
            <if test="time != null" >
                #{time,jdbcType=TIMESTAMP},
            </if>
            <if test="value != null" >
                #{value,jdbcType=DOUBLE},
            </if>
            <if test="averageValue != null" >
                #{averageValue,jdbcType=DOUBLE},
            </if>
            <if test="minValue != null" >
                #{minValue,jdbcType=DOUBLE},
            </if>
            <if test="maxValue != null" >
                #{maxValue,jdbcType=DOUBLE},
            </if>
        </trim>
    </insert>