动态insert 例句:
<insert id="addNews" parameterType="com.kqkj.entity.KuqiNews">
INSERT INTO kuqi_news
(news_title,news_time,news_content,news_type,news_detalis)
VALUES
<trim prefix="(" suffixOverrides="," suffix=")">
<if test="news_title != null and news_title != '' " >#{news_title},</if>
<if test="news_time != null and news_time != '' " >#{news_time},</if>
<if test="news_content != null and news_content != '' " >#{news_content},</if>
<if test="news_type != null and news_type != '' " >#{news_type},</if>
<if test="news_detalis != null and news_detalis != '' " >#{news_detalis},</if>
</trim>
</insert>
动态update 例句:
<update id="updateNews" parameterType="com.kqkj.entity.KuqiNews">
UPDATE kuqi_news
<!-- 后缀增加逗号 -->
<trim prefix="set" suffixOverrides=",">
<if test="news_title != null and news_title != '' " >news_title=#{news_title},</if>
<if test="news_time != null and news_time != '' " >news_time=#{news_time},</if>
<if test="news_content != null and news_content != '' " >news_content=#{news_content},</if>
<if test="news_author != null and news_author != '' " >news_author=#{news_author},</if>
<if test="news_type != null and news_type != '' " >news_type=#{news_type},</if>
<if test="news_detalis != null and news_detalis != '' " >news_detalis=#{news_detalis},</if>
</trim>
WHERE id=#{id}
</update>