<select id="selectRulesDyn" parameterClass="Rule" resultMap="RuleResult">
select ID as id, FGMC as fgmc, JG as jg, ZG as zg, NH as nh, WH as wh, FBSJ as fbsj, FGNR as fgnr, FGWJMC as fgwjmc, FGWJLX as fgwjlx, ZTC as ztc, LRR as lrr, LRSJ as lrsj, BZ as bz from TYGZPT_FG
<dynamic prepend="where">
<isNotEmpty prepend="and" property="fgmc">(FGMC like '%'||#fgmc#||'%')</isNotEmpty>
这是我在xml中的写法, 用这个可以模糊查询单引号了。