<update id="updateDataCensusDetail" parameterType="com.rsi.rc.bs.module.censusparamdetail.dao.DataCensusDetail">
update bs_data_census_detail_t
<set >
<if test="sewageId != null" >
sewage_id = #{sewageId,jdbcType=BIGINT},
</if>
<if test="workshopId != null" >
workshop_id = #{workshopId,jdbcType=BIGINT},
</if>
<if test="deviceId != null" >
device_id = #{deviceId,jdbcType=BIGINT},
</if>
<if test="metricId != null" >
metric_id = #{metricId,jdbcType=BIGINT},
</if>
<if test="time != null" >
time = #{time,jdbcType=TIMESTAMP},
</if>
<if test="value != null" >
value = #{value,jdbcType=DOUBLE},
</if>
<if test="averageValue != null" >
value = #{averageValue,jdbcType=DOUBLE},
</if>
<if test="minValue != null" >
value = #{value,jdbcType=DOUBLE},
</if>
<if test="maxValue != null" >
value = #{value,jdbcType=DOUBLE},
</if>
</set>
where detail_id = #{detailId,jdbcType=BIGINT}
</update>
相关文章
- 01-23No valid Maven installation found. Either set the home directory in the configuration dialog or set
- 01-23Swift学习-Tuple、Dictionary、Set
- 01-23mybatis学习(五)(动态mybatis(多条件查询))
- 01-23ORM简介 && MyBatis和Hibernate的不同 && 动态代理简单实现Mybatis基本使用
- 01-23mybatis__使用#,$传入多个参数 && 返回数据 && 主键回写
- 01-23Mybatis接口与映射文件
- 01-23MyBatis-返回List类型参数。
- 01-23启动PL/SQL Developer 报字符编码不一致错误 Database character set (AL32UTF8) and Client character set (ZHS16GBK) are different. Character set conversion may cause unexpected results. Note: you can set the client
- 01-23MyBatis学习笔记
- 01-23Mybatis批量插入