查詢字段值可能為null
也可能不為null

<select id="select" resultMap="BaseResultMap">select<include refid="Base_List"/>from DIC_BIZ_ITEM_PERFORMANCEWHERE 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>

總結(jié)

以上是生活随笔為你收集整理的Mybatis查询可能为null的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。