转：mybatis if test 不为空字符串或null

<sql id="public_content">
  	<if test="productId != null and productId !=''" >
        and  a.product_id = #{productId,jdbcType=VARCHAR}
      </if>
      <if test="productDefinId != null" >
        and a.product_defin_id = #{productDefinId,jdbcType=VARCHAR}
      </if>
      <if test="productUid != null and productUid !=''">
        and a.product_uid = #{productUid,jdbcType=VARCHAR}
      </if>
      <if test="productKey != null" >
        and a.product_key = #{productKey,jdbcType=VARCHAR}
      </if>
      <if test="prouuctSecret != null" >
        and a.prouuct_secret = #{prouuctSecret,jdbcType=VARCHAR}
      </if>
      <if test="productPass != null" >
        and a.product_pass = #{productPass,jdbcType=VARCHAR}
      </if>
      <if test="productVisitPass != null" >
        and a.product_visit_pass = #{productVisitPass,jdbcType=VARCHAR}
      </if>
      <if test="createTime != null and createTime !=''" >
        and a.create_time = #{createTime,jdbcType=VARCHAR}
      </if>
      <if test="pageSize != null and pageNum !=null " >      
         ORDER BY a.product_id DESC limit #{pageNum},#{pageSize}
      </if>
  </sql>

注意如果传入的参数是多个对象参数，就不能在test中直接使用对象属性作为判断，要对参数命名，例如：

接口-->ObjectX getByNameAndVersion(@Param("obj1") Object1 obj1,@Param("obj2") Object2 obj2);
select语句--><select id="id" resultMap="baseMap">
select * from xxx 
<where>
	<if test="obj1.name!=null>
		name=#{obj1.name}
	</if>
	<if test="obj2.version!=null">
		version=#{obj2.version}
	</if>
</where>