mybatis mapper.xml中擷取model屬性值 & mybatis模糊查詢 & mybatis動态查詢

YcSuperMarketMember model中包含name 和area 兩個屬性。 xml中不要使用${}   存在sql注入漏洞。
           

<select id="select_by_condition" parameterType="com.yc.budaoweng.model.YcSuperMarketMember" resultMap="BaseResultMap">
  select * from yc_member_supermarket where yc_member_supermarket.area=#{area}
  <if test="name !=null and name!=''">
  	and yc_member_supermarket.name like  CONCAT('%',#{name},'%') 
  </if>