ibatis xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd" >
<sqlMap namespace="Navigation">
<select id="getProductLineNodes" parameterClass="java.lang.String"
resultClass="java.util.HashMap">
<![CDATA[
select item_id, item_name from v_sup_navi_productline where nls_lang=#nlsLang#
]]>
</select>
<select id="getProductFamilyNodes" parameterClass="java.util.Map"
resultClass="java.util.HashMap">
<![CDATA[
select item_id, item_name from sup_dict_item t where t.parent_item_id=#itemId# and
t.nls_lang=#nlsLang# and t.item_id in
(select f.product_family from sup_kc_family_info f where f.web_site_lang=#nlsLang# )
]]>
</select>
<select id="getKBdocIDList" parameterClass="java.util.Map"
resultClass="java.lang.String">
<![CDATA[
select distinct web_doc_id from v_sup_navi_doclist
]]>
<dynamic prepend="where">
<isNotEmpty prepend="AND" property="webSiteLang">
<![CDATA[
web_site_lang = #webSiteLang#
]]>
</isNotEmpty>
<isNotEmpty prepend="AND" property="productFamily">
<![CDATA[
product_family = #productFamily#
]]>
</isNotEmpty>
<isNotEmpty prepend="AND" property="product">
<![CDATA[
product = #product#
]]>
</isNotEmpty>
<isNotEmpty prepend="AND" property="class1">
<![CDATA[
class1 = #class1#
]]>
</isNotEmpty>
<isNotEmpty prepend="AND" property="materialType">
<![CDATA[
material_type in $materialType$
]]>
</isNotEmpty>
<isNotEmpty prepend="AND" property="securityLevel">
<![CDATA[
security_level in $securityLevel$
]]>
</isNotEmpty>
<isNotEmpty prepend="AND" property="isHedexDocType">
<![CDATA[
ishedexdoctype = #isHedexDocType#
]]>
</isNotEmpty>
</dynamic>
<![CDATA[
order by web_doc_id desc
]]>
</select>
</sqlMap>