根据条件查询 查询语句条件参数一定要判空

//根据条件查询 查询语句条件参数一定要判空，判断null空和字符串空 不判空会出现奇怪的问题，查出来的不是根据条件查到的结果


 <select id="list" resultMap="typeResultMap" >
        select * from type
        <where>
            <!--id-->
            <if test="id!=null and id!=''">
                and id like '%${id}%'
            </if>
            <!--ISBN-->
            <if test="name!=null and name!=''">
                and name like '%${name}%'
            </if>
            <!--书名-->
            <if test="remake!=null and remake!=''">
                and remake like '%${remake}%'
            </if>
        </where>

    </select>

 

<select id="list" resultMap="typeResultMap" >
select * from type
<where>
<!--id-->
<if test="id!=null and id!=''">
and id like '%${id}%'
</if>
<!--ISBN-->
<if test="name!=null and name!=''">
and name like '%${name}%'
</if>
<!--书名-->
<if test="remake!=null and remake!=''">
and remake like '%${remake}%'
</if>
</where>

</select>