public List<Asset> findUpAssetsByIds(List<Long> ids)
throws PortalMSException
{
Map<String, List<Long>> map = new HashMap<String, List<Long>>();
map.put("ids", ids);
return (List<Asset>)this.getSqlMapClientTemplate()
.queryForList("Asset.findUpAssetsByIds", map);
throws PortalMSException
{
Map<String, List<Long>> map = new HashMap<String, List<Long>>();
map.put("ids", ids);
return (List<Asset>)this.getSqlMapClientTemplate()
.queryForList("Asset.findUpAssetsByIds", map);
}
<select id="Asset.findUpAssetsByIds" parameterClass="java.util.HashMap" resultMap="AssetResult3">
SELECT cp.resource_id,
cp.column_id
FROM t_res_cloumn_map cp
<isNotEmpty property="ids">
WHERE cp.id IN
<iterate conjunction="," open="(" close=")" property="ids">
#ids[]#
</iterate>
</isNotEmpty>
<isEmpty property="ids">
where 1 != 1
</isEmpty>
</select>