批量更新sql寫法

sql語句寫法

UPDATE uke_hwork_upload set teacher_name = case id  
when 787513 then '張衡璇' when 866956 then '田璐' end where id in (787513,866956)
           

資料量多一點的：

UPDATE uke_hwork_upload set teacher_name = case teacher_id when 0 then '學堂' 
when 923198 then '安卓1' when 1325974524 then '張娟12' when 1326311601 then '張化學'
when 1326311603 then '張化2' when 1326312334 then '白麗娜45' 
when 1326312413 then 'ziming班主任' when 1326312431 then '洪燕班主任' 
when 1326312443 then '洪燕班主任2' when 1326312444 then '洪燕班主任3' 
when 1326312454 then '周啟信班主任' when 1326312487 then '自動化測試班主任'
when 1326312490 then '張班2' when 1326313005 then '白麗娜1' when 1326313012 then '麗麗白'
when 1326313616 then '孫繼班主任數學' when 1326347790 then '班主任1号' 
when 1326358624 then '000002' when 1326397477 then '班主任1011' 
when 1326397662 then '班主任1012' when 1326397669 then '班主任1013' 
when 1426325507 then '越前前的班主任' when 1426409574 then '15300000006' 
when 1426549759 then '金牌老師4' when 1426549759 then '學堂'
end where  teacher_id in ( 1325974937 , 0 , 1325974524 , 1326313616 , 
1326312431 , 1326311601 , 1326313012 , 1326312334 , 1326312443 , 
1326312490 , 1326312487 , 1326313005 , 1326312413 , 923198 , 
1326311603 , 5001914586 , 1326312444 , 1326312454 , 5001914524 , 
32326319149 , 32326319216 , 32326319215 , 32326319323 , 32326319547 , 
1326347790 , 1326397477 , 1426325426 , 1426325507 , 1326358624 , 
1326397662 , 1426325420 , 1426549759 , 1426683043 , 1326397669 , 
1426409574 , 1426798396 , 1426723061 , 1426794045 ) 
and correct_time < '2019-12-01' and correct_time > '2019-11-01' 

           

mybatis中寫法

<update id="updateTeacherNameByTeacherId">
        UPDATE uke_hwork_upload set teacher_name =
        <foreach collection="idNameVoList" item="idName" index="index" separator=" " 
        		 open="case teacher_id" close="end">
            when #{idName.tutorId} then #{idName.tutorName}
        </foreach>
        where teacher_id in (
        <foreach collection="teacherIdList" item="teacherId" separator=",">
            #{teacherId}
        </foreach>
        )
        and correct_time &lt; #{endDate}
        and correct_time &gt; #{startDate}
    </update>


1:  idNameVoList是  List<TutorIdNameVo> idNameVoList 的集合
	 @Data
	 public class TutorIdNameVo {
	    //班主任id
	    private Long tutorId;
	    //班主任姓名
	    private String tutorName;
	 }