Mybatis动态SQL之where标签

xml映射文件部分内容:

<select id="selectIfCondition" resultType="com.heiketu.testpackage.pojo.Product"> SELECT prod_id prodId, vend_id vendId, prod_name prodName, prod_desc prodDesc FROM Products <where> <if test="prodId != null and prodId != ''"> AND prod_id = #{prodId} </if> <if test="prodName != null and prodName != ''"> AND prod_name = #{prodName} </if> </where> </select> <select id="selectIfCondition" result