<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>
1234567891011121314151617181920212223242526272829注意如果传入的参数是多个对象参数，就不能在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> 1234567891011
