技术问答mybatis鎬庝箞鎵归噺鏇存柊鏁版嵁 - 扬州沐宇科技

MyBatis 鍙互閫氳繃鎵归噺鎿嶄綔鏉ユ洿鏂版暟鎹€備笅闈㈡槸涓€涓ず渚嬩唬鐮侊紝灞曠ず濡備綍浣跨敤 MyBatis 杩涜鎵归噺鏇存柊鏁版嵁锛?/p>

棣栧厛锛岄渶瑕佸湪 Mapper XML 鏂囦欢涓畾涔変竴涓壒閲忔洿鏂扮殑 SQL 璇彞锛屽涓嬫墍绀猴細

<update id="batchUpdate" parameterType="java.util.List">
UPDATE table_name SET column1 = #{list[0].column1}, column2 = #{list[0].column2} WHERE id = #{list[0].id}
</update>

鍦?Java 浠ｇ爜涓紝璋冪敤 Mapper 鎺ュ彛涓殑 batchUpdate 鏂规硶锛屼紶鍏ヤ竴涓寘鍚 鏇存柊鏁版嵁鐨?List 鍙傛暟锛屽涓嬫墍绀猴細

List<DataObject> dataList = new ArrayList<>();
// 娣诲姞瑕佹洿鏂扮殑鏁版嵁瀵硅薄鍒?dataList 涓?..
mapper.batchUpdate(dataList);

鍦?Mapper 鎺ュ彛涓紝澹版槑涓€涓悕涓?batchUpdate 鐨勬柟娉曪紝濡備笅鎵€绀猴細

void batchUpdate(List<DataObject> dataList);

閫氳繃浠ヤ笂姝ラ锛屽氨鍙互浣跨敤 MyBatis 瀹炵幇鎵归噺鏇存柊鏁版嵁鐨勫姛鑳戒簡銆?/p>