1  <select id="findByCondition02" parameterType="map" resultType="Brand">
 2         select * from tb_brand
 3         <where>
 4             <if test="status!=null">
 5                 status =#{status}
 6             </if>
 7             <if test="companyName!=null">
 8                2.拼接單引號 注意加空格
 9 
10                 and company_name like '%' #{companyName} '%'
11             </if>
12             <if test="brandName!=null">
13                3.拼接雙引號
14                 and brand_name like "%"#{brandName}"%";
15             </if>
16         </where>
17     </select>