mybatis鎬庝箞鎵归噺瀵煎叆鏁版嵁
鍦∕yBatis涓紝鍙互浣跨敤鎵归噺鎻掑叆鏁版嵁鐨勬柟寮忔潵瀹炵幇鎵归噺瀵煎叆鏁版嵁銆備互涓嬫槸涓€绉嶅父鐢ㄧ殑鏂规硶锛?/p>
- 鍒涘缓涓€涓狹apper鎺ュ彛锛屽畾涔変竴涓柟娉曠敤浜庢壒閲忔彃鍏ユ暟鎹細
public interface MyMapper {
void batchInsert(List<MyData> dataList);
}
- 鍦ㄥ搴旂殑Mapper.xml鏂囦欢涓紪鍐欏搴旂殑SQL璇彞锛?/li>
<insert id="batchInsert" parameterType="java.util.List">
insert into my_table (column1, column2, column3) values
<foreach collection="list" item="item" separator=",">
(#{item.column1}, #{item.column2}, #{item.column3})
</foreach>
</insert>
- 鍦ㄤ唬鐮佷腑璋冪敤Mapper鎺ュ彛鐨勬壒閲忔彃鍏ユ柟娉曪細
MyMapper myMapper = sqlSession.getMapper(MyMapper.class);
myMapper.batchInsert(dataList);
鍏朵腑锛宒ataList鏄鎵归噺鎻掑叆鐨勬暟鎹垪琛紝MyData鏄暟鎹璞$殑绫诲瀷锛屽湪SQL璇彞涓娇鐢ㄤ簡foreach鏍囩鏉ュ疄鐜版壒閲忔彃鍏ユ搷浣溿€?/p>
閫氳繃浠ヤ笂姝ラ锛屽氨鍙互瀹炵幇鍦∕yBatis涓壒閲忓鍏ユ暟鎹殑鎿嶄綔銆?/p>
相关问答