ibatis 灵活的配置文件

  <select id="selectAllMmsRepairBySth" parameterClass="hashmap" resultMap="mmssampleDataMap">
        <![CDATA[ 
        SELECT
    *
FROM
    mms_sample_datas
WHERE
    mms_sample_datas.mms_id IN (
        SELECT
            mms_sample_datas.mms_id
        FROM
            mms_sample_datas
        INNER JOIN mms_text_datas ON mms_sample_datas.uuid = mms_text_datas.mms_uuid
        AND mms_text_datas.is_repair_audit = 1
        UNION
            SELECT
                mms_sample_datas.mms_id
            FROM
                mms_sample_datas
            INNER JOIN mms_pic_datas ON mms_sample_datas.uuid = mms_pic_datas.mms_uuid
            AND mms_pic_datas.is_repair_audit = 1
    )
         ]]>
        <dynamic prepend="and">
            <isNotEmpty prepend="AND" property="isRepairAudit">
                is_repair_audit  =‘$isRepairAudit$‘
            </isNotEmpty>
            <isNotEmpty prepend="AND" property="storageDateBegin">
                <![CDATA[
            (storage_date >= #storageDateBegin#)
            ]]>
            </isNotEmpty>
            <isNotEmpty prepend="AND" property="storageDateEnd">
                <![CDATA[
            (storage_date <= #storageDateEnd#)
            ]]>
            </isNotEmpty>
            <isNotEmpty prepend="AND" property="autoAuditDateBegin">
                <![CDATA[
            (auto_audit_date >= #autoAuditDateBegin#)
            ]]>
            </isNotEmpty>
            <isNotEmpty prepend="AND" property="autoAuditDateEnd">
                <![CDATA[
            (auto_audit_date <= #autoAuditDateEnd#)
            ]]>
            </isNotEmpty>
            <isNotEmpty prepend="AND" property="confidenceType">
                <![CDATA[
            (confidence_type = #confidenceType#)
            ]]>
            </isNotEmpty>
            <isNotEmpty prepend="AND" property="sampleSource">
                <![CDATA[
            (sample_source = #sampleSource#)
            ]]>
            </isNotEmpty>
            <isNotEmpty prepend="AND" property="sampleType">
                <![CDATA[
            (sample_type = #sampleType#)
            ]]>
            </isNotEmpty>
            <isNotEmpty prepend="AND" property="repeatDateBegin">
                <![CDATA[
            (storage_date >= #repeatDateBegin#)
            ]]>
            </isNotEmpty>
            <isNotEmpty prepend="AND" property="repeatDateEnd">
                <![CDATA[
            (storage_date <= #repeatDateEnd#)
            ]]>
            </isNotEmpty>
            <isNotEmpty prepend="AND" property="sectionRange">
                section_range  =‘$sectionRange$‘
            </isNotEmpty>
            
            <isNotEmpty prepend="AND" property="auditStatus">
                <![CDATA[ audit_status=#auditStatus# ]]>
            </isNotEmpty>
            <isNotEmpty prepend="AND(" property="sampleStudyStatus">
                <![CDATA[ sample_study_status=#sampleStudyStatus# ]]>
            </isNotEmpty>
            <isNotEmpty prepend="AND" property="sampleFileStatus">
                <![CDATA[ sample_file_status=#sampleFileStatus# ]]>
            </isNotEmpty>
            <isNotEmpty prepend="AND" property="sampleTypeStart">
                <![CDATA[
            (repeat_num >= #sampleTypeStart#)
            ]]>
            </isNotEmpty>
            <isNotEmpty prepend="AND" property="sampleTypeEnd">
                <![CDATA[
            (repeat_num <= #sampleTypeEnd#)
            ]]>
            </isNotEmpty>
            <isNotEmpty prepend="AND" property="implTimeStart">
                <![CDATA[
            (impl_time >= #implTimeStart#)
            ]]>
            </isNotEmpty>
            <isNotEmpty prepend="AND" property="implTimeEnd">
                <![CDATA[
            (impl_time <= #implTimeEnd#)
            ]]>
            </isNotEmpty>
            <isNotEmpty prepend="AND" property="auditStatusEd">
                <![CDATA[
            (audit_status is not null)
            ]]>
            </isNotEmpty>
        </dynamic>
        <![CDATA[ 
        
          order by mms_id desc 
          limit #startIndexs#,#pageSizes#
      ]]>
    </select>