Oracle 字串函式

<select id="queryPage" parameterType="java.util.Map" resultMap="DoorPo">

SELECT 

t.controllersn as CONTROLLERSN,

<include refid="join_columns"/> 

FROM TB_DOOR_CONTROLLER t

LEFT JOIN TB_DOOR_DOOR d ON t.CONTROLLERSN=d.controllerid

<where>

            instr(d.DOORENABLED,  '1') &gt; 0

<if test="@Ognl@isNotEmpty(controllerid)">

                  and t.CONTROLLERSN=#{controllerid}

</if>

<if test="@Ognl@isNotEmpty(zoneid)">

                  and t.zoneid=#{zoneid}

</if>

</where>

</select>