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>