mybatis返回结果为List＜Map＜String, Object＞＞的写法

接口方法是这样的：

List<Map<String, Object>> getBackupDbInfoByDbIds(@Param(“dbIds”) List dbIds);

mapper.xml如下：

<sql id="selectDbmBackupConfigLeftBackupInfoVo">
        SELECT
        c.*,
        t.tsm_password,
        t.tsm_nodename,
        t.tsm_mgmtclass,
        t.keep_day,
        t.parallel
        FROM
        `dbm_backup_config` c
        LEFT JOIN dbm_backup_info t ON c.db_id = t.db_id
    </sql>

    <select id="getBackupDbInfoByDbIds" resultType="java.util.Map">
        <include refid="selectDbmBackupConfigLeftBackupInfoVo"/>
        WHERE c.db_id in
        <foreach item="id" collection="dbIds" open="(" separator="," close=")">
            #{id}
        </foreach>
    </select>

总结

1、resultType 定义为 “java.util.Map”
2、返回List<Map<String, Object>> 的好处在于：不用再定义一个实体类对象了。
3、@Param(“dbIds”) List dbIds 表示给当前参数重新命名，方便foreach遍历