<cacheModel type="LRU" id="dicCache" readOnly="true" serialize="false" > <flushInterval hours="24"/> <flushOnExecute statement="DictionaryDao.insertDIC"/> <flushOnExecute statement="DictionaryDao.updateDIC"/> <flushOnExecute statement="DictionaryDao.deleteDIC"/> <property name="size" value="1000" /> </cacheModel>
<select id="queryDICsByFilter" parameterClass="java.util.Map" resultClass="dic" cacheModel="dicCache"> select * from bap_datadic <dynamic prepend="where"> <isPropertyAvailable property="dataid"> <isNotNull prepend="AND" property="dataid"> dataid=#dataid# </isNotNull> </isPropertyAvailable> </dynamic> </select>