<select id="selectLike_Name" resultClass="com.sunshine.service.dictionary.model.Dictionary">
select dicT.ID id,dicT.PARENTID parentid,dicT.CODE code,dicT.NAME name from(select dic.id,dic.parentid,dic.code,dic.name,ROWNUM RN
from (select t.ID id , t.PARENTID parentid , t.CODE code , t.NAME name from T_DICTIONARY t inner join t_dictionary_kind t2 on t.parentid=t2.id where t2.type=#kind# and t.name like '%$dicname$%') dic
where ROWNUM <=#endR#) dicT where dicT.RN >#startR#
select dicT.ID id,dicT.PARENTID parentid,dicT.CODE code,dicT.NAME name from(select dic.id,dic.parentid,dic.code,dic.name,ROWNUM RN
from (select t.ID id , t.PARENTID parentid , t.CODE code , t.NAME name from T_DICTIONARY t inner join t_dictionary_kind t2 on t.parentid=t2.id where t2.type=#kind# and t.name like '%$dicname$%') dic
where ROWNUM <=#endR#) dicT where dicT.RN >#startR#
</select>
如果是mybatis蓝色部分要写成'%'||#{dicname}||'%',ibatis如蓝色