MyBatis条件查询配置
sql id="query_competition_where">
<if test="yzwx_competition!=null">
<if test="yzwx_competition.cId != null and yzwx_competition.cId != ''">
<![CDATA[AND cId LIKE CONCAT('%', #{yzwx_competition.cId,jdbcType=VARCHAR},'%')]]>
</if>
<if test="yzwx_competition.orgId != null and yzwx_competition.orgId != ''">
<![CDATA[AND orgId LIKE CONCAT('%', #{yzwx_competition.orgId,jdbcType=VARCHAR},'%')]]>
</if>
<if test="yzwx_competition.eventName != null and yzwx_competition.eventName != ''">
<![CDATA[AND eventName LIKE CONCAT('%', #{yzwx_competition.eventName,jdbcType=VARCHAR},'%')]]>
</if>
<if test="yzwx_competition.eventLevel != null and yzwx_competition.eventLevel != ''">
<![CDATA[AND eventLevel LIKE CONCAT('%', #{yzwx_competition.eventLevel,jdbcType=VARCHAR},'%')]]>
</if>
</if>
</sql>
<if test="yzwx_competition!=null">
<if test="yzwx_competition.cId != null and yzwx_competition.cId != ''">
<![CDATA[AND cId LIKE CONCAT('%', #{yzwx_competition.cId,jdbcType=VARCHAR},'%')]]>
</if>
<if test="yzwx_competition.orgId != null and yzwx_competition.orgId != ''">
<![CDATA[AND orgId LIKE CONCAT('%', #{yzwx_competition.orgId,jdbcType=VARCHAR},'%')]]>
</if>
<if test="yzwx_competition.eventName != null and yzwx_competition.eventName != ''">
<![CDATA[AND eventName LIKE CONCAT('%', #{yzwx_competition.eventName,jdbcType=VARCHAR},'%')]]>
</if>
<if test="yzwx_competition.eventLevel != null and yzwx_competition.eventLevel != ''">
<![CDATA[AND eventLevel LIKE CONCAT('%', #{yzwx_competition.eventLevel,jdbcType=VARCHAR},'%')]]>
</if>
</if>
</sql>
扫一扫
4909
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
