List
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
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)