1     <select id="selectBank2" parameterClass="java.util.Map" resultClass="java.util.HashMap">
 2         select 
 3             BANK_ID as "bankId",BANK_CODE as "bankCode",BANK_KEY as "bankKey",BANK_SHORT_NAME as "bankShortName",BANK_NAME as "bankName",ENABLE as "enable"  
 4         from ams_bank
 5         where 1=1
 6         <isNotEmpty property="bankCode" prepend="and">
 7             BANK_CODE=#bankCode#
 8         </isNotEmpty>
 9         <isNotEmpty property="enable" prepend="and">
10             ENABLE=#enable#
11         </isNotEmpty>
12         order by BANK_ID asc        
13     </select>
1         Map<String, Object> bank2 = new HashMap<String, Object>();
2         bank2.put("bankId", 111111);
3         bank2.put("bankCode", "111111");
4         bank2.put("enable", "1");
5         List<Map<String, Object>> lBanks = getSqlMapClientTemplate().queryForList("AMS_Bank.selectBank2", bank2);