方式1: $连接符
<select id="selectAll" parameterType="java.lang.String" resultMap="BaseResultMap">
select
<include refid="Base_Column_List" />
from data_role
<where>
<if test="name != null and name !='' " >
name like '%${name}%'
</if>
</where>
</select>
判断是执行还是删除:
ON DUPLICATE KEY UPDATE
<insert id="insertBatch" parameterType="List" >
insert into t_visitor (
count_day,times
)
values
<foreach collection="list" item="item" separator=",">
(
#{item.countDay},
#{item.times}
)
</foreach>
ON DUPLICATE KEY UPDATE
times = VALUES(times)
</insert>