mybatis传参数，一个实体一个普通类型

最新推荐文章于 2022-04-20 11:37:49 发布

weixin_34085658

最新推荐文章于 2022-04-20 11:37:49 发布

阅读量488

点赞数

文章标签： java python

原文链接：https://my.oschina.net/u/3796880/blog/3006952

版权

2019独角兽企业重金招聘Python工程师标准>>>

接口函数定义：

List<Fastswitch> selectByExample(@Param("class1") Class1 class1, @Param("on") Byte on);

配置文件中：

<select id="selectByExample" parameterType="map" resultType="java.util.Map">
    SELECT
    f.id, f.old_ruleId, f.new_ruleId, f.field1, f.field2, f.create_time, f.update_time
    from fastSwitch f
    LEFT JOIN rule r
    ON f.old_ruleId=r.id
    where 1=1
    <if test="class1.id != null">
        and f.id = #{class1.id}
    </if>
    <if test="class1.oldRuleid != null">
        and f.old_ruleId = #{class1.oldRuleid,jdbcType=INTEGER}
    </if>
    <if test="class1.newRuleid != null">
        and f.new_ruleId = #{class1.newRuleid,jdbcType=INTEGER}
    </if>
    <if test="class1.field1 != null">
        and f.field1 = #{class1.field1,jdbcType=VARCHAR}
    </if>
    <if test="class1.field2 != null">
        and f.field2 = #{class1.field2,jdbcType=VARCHAR}
    </if>
    <if test="fastswitch.createTime != null">
        and f.create_time = #{fastswitch.createTime,jdbcType=TIMESTAMP}
    </if>
    <if test="class1.updateTime != null">
        and f.update_time = #{class1.updateTime,jdbcType=TIMESTAMP},
    </if>
    AND r.nodata=#{on}
    ORDER BY create_time DESC
</select>

转载于:https://my.oschina.net/u/3796880/blog/3006952