Mybatis处理List参数

￡神魔★判官ぃ 2024-04-17 23:16 70阅读 0赞

#### 前言： ####

本篇博客仅仅作为笔录，避免每次网络搜索

#### 前期准备: ####

1.  sql :

CREATE TABLE `tb_student` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `name` varchar(255) COLLATE utf8_bin NOT NULL,
      `age` int(11) NOT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;
    
    INSERT INTO `work`.`tb_student` (`id`, `name`, `age`) VALUES ('25', ' Ben ', '23');
    INSERT INTO `work`.`tb_student` (`id`, `name`, `age`) VALUES ('26', 'Jack', '24');
    INSERT INTO `work`.`tb_student` (`id`, `name`, `age`) VALUES ('27', 'Tom', '24');
    INSERT INTO `work`.`tb_student` (`id`, `name`, `age`) VALUES ('28', 'Jerry', '19');
    INSERT INTO `work`.`tb_student` (`id`, `name`, `age`) VALUES ('29', 'Lilian', '18');

1.  实体类 StudentInfo：

public class StudentInfo {
    
        private Integer id;
    
        private String name;
    
        private Integer age;
        
        // 省略 get、set 方法
    }

#### 示例： ####

1.  通过 两种不同数据类型的List 不同查询：

StudentDao :

/**
         * 通过年龄和名称查询结果
         * @param ages
         * @param name
         * @return
         */
        List<StudentInfo> getListByAgesAndName(@Param("ages") List<Integer> ages, @Param("name") String name);
        
      /**
         * 通过年龄【实体中获取】和名称查询结果
         * @param studentInfos
         * @param name
         * @return
         */
        List<StudentInfo> getListByStudentInfoAndName(@Param("studentInfos") List<StudentInfo> studentInfos, @Param("name") String name);

StudentMapper.xml

<select id="getListByAgesAndName"  resultType="com.morning.all.entity.StudentInfo">
            select * from  tb_student
            where name like CONCAT('%',#{name},'%')
            and age in
            <foreach collection="ages" item="age" index="index" open="(" close=")" separator=",">
                #{age}
            </foreach>
        </select>
    
        
        <select id="getListByStudentInfoAndName"  resultType="com.morning.all.entity.StudentInfo">
            select * from  tb_student
            where name like CONCAT('%',#{name},'%')
            and age in
            <foreach collection="studentInfos" item="studentInfo" index="index" open="(" close=")" separator=",">
                #{studentInfo.age}
            </foreach>
        </select>

### 以上就是关于Mybatis List传参以及使用！ ###