在網上找了很久，特別是批量插入，很久都沒有找到，終于最后一不小心就搞出來了。所以想寫個隨筆保存下來，一方面想提高自己的總結能力，一方面為了結識有相同興趣的朋友（第一篇博客我的天納??）
/**
* 批量插入用戶
*/
@Insert("<script>" +
"insert into t_notice_user(notice_id,user_id) values" +
"<foreach collection='noticeUserEntityList' separator=',' item='s'>" +
"(#{s.noticeId},#{s.userId})"+
"</foreach>"+
"</script>")
Integer insertList(@Param("noticeUserEntityList") List<MngNoticeUserEntity> noticeUserEntityList);
/**
* 批量修改
*/
@Update("<script>" +
"<foreach collection='mngNoticeEntityList' index='index' item='item' open='' separator=';' close=''>" +
"update t_notice set status=1 where id=" +
"#{item.id}" +
"</foreach>" +
"</script>")
Integer releaseTasks(@Param("mngNoticeEntityList") List<MngNoticeEntity> mngNoticeEntityList)
/**
* 動態修改
*/
@Update("<script> " +
"update t_notice " +
"<set> " +
"<if test='null!=userId'>user_id=#{userId},</if>"+
"<if test='null!=receiveUser'>receive_user=#{receiveUser},</if>"+
"<if test='null!=title'>title=#{title},</if>"+
"<if test='null!=noticeWay'>notice_way=#{noticeWay},</if>"+
"<if test='null!=content'>content=#{content},</if>"+
"<if test='null!=releaseTime'>release_time=#{releaseTime},</if>"+
"<if test='null!=topFlag'>top_flag=#{topFlag},</if>"+
"<if test='null!=importantFlag'>important_flag=#{importantFlag},</if>"+
"</set>"+
"where id=#{id} and status=0"+
"</script> ")
Integer update(MngNoticeEntity mngNoticeEntity);
/**
* 條件查詢
*/
@Select("<script>" +
"select"+MngNoticeMapper.SQL+"from t_notice" +
"<where>" +
"<if test='startDate!=null'> and release_time>=#{startDate}</if>" +
"<if test='endDate!=null'> and release_time<=0#{endDate}</if>" +
"<if test='isView!=null'> and isView=#{isView}</if>" +
"<if test='title!=null'> and title=#{title}</if>" +
"</where>" +
"and status=1 and notice_type=1" +
"order by tag desc" +
"</script>")
浙公網安備 33010602011771號