<select id="query" resultType="map">

        select * from ${tbName}

        <where>

            <foreach item="item" index="index" collection="queryList">

                ${item.logic} ${item.field} ${item.operator}

                <choose>

                    <when test = "item.ftype == 'date'">

                        to_date(#{item.value},'yyyy-mm-dd')

                    </when>

                    <otherwise>

                        #{item.value}

                    </otherwise>

                </choose>

            </foreach>

        </where>

    </select>