ibatis sqlMap 接受map参数和缓存

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" "http://www.ibatis.com/dtd/sql-map-2.dtd">

<sqlMap namespace="SettleAccountsDao">
        <!-- 缓存部分 -->
	<cacheModel id="settleAccounts-cache" type="LRU">
	<flushInterval minutes="10" />
	<property name="size" value="1000" />
	</cacheModel>
	
	<select id="SettleAccounts-SelectByOrderSourceTypeId" parameterClass="java.util.Map" resultMap="SettleAccounts-Rusult" cacheModel="settleAccounts-cache">
	<![CDATA[
		select 
		k3code,
		settle_accounts_id,
		order_source_type_id,
		order_source_type_name,
		settle_accounts_drp_id,
		settle_accounts_type,
		dealer_name,
		cc_user_id,
		last_cc_user_id,
		create_time,
		last_time,
		vid
		from CRM_SETTLE_ACCOUNTS 
		where order_source_type_id = #orderSourceTypeId# and 
		settle_accounts_drp_id = #settleAccountsDrpId#
	]]>
	</select>
</sqlMap>

 java 代码调用部分：

public List<SettleAccounts> findSettleaccountsByOrderSourceTypeId(Map paramMap){
		return getSqlMapClientTemplate().queryForList("SettleAccountsDao.SettleAccounts-SelectByOrderSourceTypeId", paramMap);
	}

 注意，此处java代码调用时是开启了命名空间的。useStatementNamespaces="true"。