接口方法是这样的:
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遍历