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

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


 
        select * from type
        
            
            <if test="id!=null and id!=''">
                and id like '%${id}%'
            if>
            
            <if test="name!=null and name!=''">
                and name like '%${name}%'
            if>
            
            <if test="remake!=null and remake!=''">
                and remake like '%${remake}%'
            if>
        

    

id="list" resultMap="typeResultMap" >
select * from type


test="id!=null and id!=''">
and id like '%${id}%'


test="name!=null and name!=''">
and name like '%${name}%'


test="remake!=null and remake!=''">
and remake like '%${remake}%'