参考:连接
xml的写法
<select id="findMoreByalumniUserId" parameterType="int" resultMap="BaseResultMap">
select *
from exchange_news
<foreach close=")" collection="array" item="ids" open="(" separator=",">
</foreach>
</select>
<update id="updateMoreExchangeNews" parameterType="java.util.List">
<foreach collection="list" item="item" index="index">
update exchange_news
set receiver_alumniuser_id=
where 1=1 and exchange_news_id=
</foreach>
</update>
<insert id="bashInsertExchangeNews" parameterType="java.util.List">
insert into exchange_news (exchanger_id, receiver_alumniuser_id, leave_message, create_time, `status`) VALUES
<foreach collection="list" separator="," item="item">
(
</foreach>
</insert>
<delete id="bashDeleteByid" parameterType="java.util.List">
delete from exchange_news where exchange_news_id=
<foreach close=")" collection="list" item="item" open="(" separator=",">
</foreach>
</delete>
dao层
List<ExchangeNews> findMoreByalumniUserId(@Param("ids") Integer[] ids);
int updateMoreExchangeNews(List<ExchangeNews> exchangeNewsList);
int bashInsertExchangeNews(List<ExchangeNews> listNews);
int bashDeleteByid(List<ExchangeNews> newsList);