.xml文件中mysql的一些常用标签

select 标签

<select id="queryByParams" parameterType="map" resultMap="getMap">
select * from demoTable <include refid="queryParams"></include>
</select>

delete 标签

<delete id="delete" parameterType="int">
delete
from demoTable 
where Id = #{id}
</delete>

update 标签

<update id="update">
update demoTable set param=0 where 1=1
</update>

sql 标签 一般可用于通用的sql语句 共同使用

<sql id="queryParams">
<where>
<if test="id != null">
AND ID=#{id,jdbcType=BIGINT}
</if>
</where>
</sql>

include标签 配合sql标签使用

select * from demoTable <include refid="queryParams"></include>

foreach标签 collection中内容为遍历的集合

SELECT
*
FROM
demoTable 
WHERE
ID IN
<foreach item="item" collection="ids" index="index" open="(" separator="," close=")">
#{item}
</foreach>