myBatis關於不允許空值屬性的查詢__mybatis

資料庫中id屬性為主鍵，不允許為空白值

<select id="getUser"            resultType="com.hundsun.zdr.Stu">        SELECT * FROM Stu WHERE TRUE        <if test="id!=0">            and id = #{id}        </if>        <if test="name!=null">            and name like CONCAT('%',#{name},'%')        </if>        <if test="birthday!=null">            AND birthday like CONCAT('%',#{birthday},'%')        </if>        <if test="sex!=null">            AND sex like CONCAT(#{sex},'%')        </if>        <if test="address!=null">            AND address like CONCAT('%',#{address},'%')        </if>        <if test="teacher!=null">            AND teacher like CONCAT('%',#{teacher},'%')        </if>    </select>

myBatis中id要通過0來判斷而不能使用null

<if test="id!=0">            and id = #{id}        </if>

如果寫成這樣

<if test="id!=null">            and id = #{id}        </if>

查詢的時候保證id的值不可為空才能正常的查詢到值

這個問題很困擾我