mybatis动态sql模版

//动态新增
<insert id="insert" parameterType="映射的实体类路径">
insert into xxx
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="id != null">
id,
</if>
</trim>
values
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="id != null">
#{id},
</if>
</trim>
</insert>

//动态更新
<update id="update" parameterType="映射的实体类路径">
update xxx
<trim prefix="set" suffixOverrides="," suffix="where id = #{id}">
<if test="id != null">
name = #{name},
</if>
</trim>
</update>

//动态查询
<select id="select" resultMap="实体类映射id">
SELECT
t.*
FROM
xxx t
<trim prefix="where" prefixOverrides="AND|OR">
<if test="id != null">
and t.id = #{id}
</if>
</trim>
</select>

//动态删除
<delete id="deleteB" parameterType="映射的实体类路径">
delete from xxx
<trim prefix="where" prefixOverrides="AND|OR">
<if test="id != null">
and t.id = #{id}
</if>
</trim>
</delete>