ibatis map

最新推荐文章于 2020-12-24 22:10:24 发布

weixin_30480651

最新推荐文章于 2020-12-24 22:10:24 发布

阅读量93

点赞数

文章标签： java

原文链接：http://www.cnblogs.com/yangly/p/6027685.html

版权

 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);

转载于:https://www.cnblogs.com/yangly/p/6027685.html