mybatis_note之动态SQL

动态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>