查询字段值可能为null
也可能不为null
<select id="select" resultMap="BaseResultMap">
select
<include refid="Base_List"/>
from DIC_BIZ_ITEM_PERFORMANCE
WHERE 1=1
<choose>
<when test="sampleBizModelId !=null and sampleBizModelId !=''">
AND SAMPLE_BIZ_MODEL_ID=#{sampleBizModelId}
</when>
<otherwise>
AND SAMPLE_BIZ_MODEL_ID IS NULL
</otherwise>
</choose>
<choose>
<when test="laboratoryId !=null and laboratoryId !=''">
AND LABORATORY_ID=#{laboratoryId}
</when>
<otherwise>
AND LABORATORY_ID IS NULL
</otherwise>
</choose>
<choose>
<when test="sampleModelId !=null and sampleModelId !=''">
AND SAMPLE_MODEL_ID=#{sampleModelId}
</when>
<otherwise>
AND SAMPLE_MODEL_ID IS NULL
</otherwise>
</choose>
<choose>
<when test="assayBizItemId !=null and assayBizItemId !=''">
AND ASSAY_BIZ_ITEM_ID=#{assayBizItemId}
</when>
<otherwise>
AND ASSAY_BIZ_ITEM_ID IS NULL
</otherwise>
</choose>
</select>