<selectid="selectSatellite"parameterType="java.util.Map"resultType="java.util.Map">
select distinct on (satellite) id, satellite from sar_satellite_image_dic
where 1=1
</select>
2. 对于前端的任何 下拉框 都应该写查询,使其动态的变化,传递回来的数据为id。
<selectid="select"parameterType="java.util.Map"resultType="java.util.Map">
select id,image_mode "imageMode" from sar_dic
where 1=1
<iftest="satelliteCode!=null and satelliteCode!=''">
and satellite=#{satelliteCode}
</if></select>