1、<if test="">非空判断
<if test="map.standData != null and map.standData != ''">
and STAND_DATA like '%'||#{map.standData,jdbcType=VARCHAR}||'%'
</if>
2、like oracle拼接
and STAND_DATA like '%'||#{map.standData,jdbcType=VARCHAR}||'%'
3、日期范围条件
ADD_DATE between to_date(#{map.startDate},'yyyy-mm-dd hh24:mi:ss') and to_date(#{map.endDate},'yyyy-mm-dd hh24:mi:ss')
4、分页查询oracle
<select id="selectPage" resultMap="BaseResultMap">
select
<include refid="Base_Column_List" />
from (
select
<include refid="Base_Column_List" />
,ROWNUM as ROWNO
from T_CORE_FIELD_STD
where FIELD_ID = #{fieldId,jdbcType=VARCHAR}
and ROWNUM <= #{rowEnd}
) t
where t.ROWNO >=#{rowStart}
</select>