java 批量更改

直接上代码

 void batchUpdateSpecificationId(@Param("infos") List infos);
1

        update goods_info
        set specification_id =
        
            when id = #{info.id} then #{info.specificationId}
        
        ,
        specification_name =
        
            when id = #{info.id} then #{info.specificationName}
        
        ,
        min_real_price =
        
            when id = #{info.id} then #{info.minRealPrice}
        
        ,
        min_line_price =
        
            when id = #{info.id} then #{info.minLinePrice}
        
        where id in
        
            ${info.id}
        
    
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26

运行的ｓｑｌ

UPDATE goods_info 
SET specification_id = ( CASE WHEN id = 373 THEN '702' WHEN id = 374 THEN '704' ELSE NULL END ),
specification_name = ( CASE WHEN id = 373 THEN '十全冻干桶 | 400g' WHEN id = 374 THEN '经典混合 | 60支' ELSE NULL END ),
min_real_price = ( CASE WHEN id = 373 THEN 0.01 WHEN id = 374 THEN 0.01 ELSE NULL END ),
min_line_price = ( CASE WHEN id = 373 THEN 130.0 WHEN id = 374 THEN 88.0 ELSE NULL END ) 
WHERE
	id IN ( 373, 374 )
1
2
3
4
5
6
7

这辈子坚持与不坚持都不可怕，怕的是独自走在坚持的道路上。。