mybatis--数据流入（根据接收参数拼接sql）--(choose、otherwise)、foreach、if实现dao的逻辑

参考：https://blog.csdn.net/weixin_38192427/article/details/121443045

https://blog.csdn.net/qiaohao0206/article/details/125055987

案例演示
sql:

        SELECT * FROM `t_course_try_report_student`
        
            
                
                
                    `status`= #{intId}
                
                
            
            
                where student_id = 39
            
        

    

testDTO

package com.pptutor.analytic.model.dto;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import lombok.experimental.Accessors;

import java.util.List;

@Data
@AllArgsConstructor
@NoArgsConstructor
@Accessors(chain = true)
public class TestDTO {

    private List intList;

}

dao

List test(TestDTO testDTO);

结果：