2007-10-24

菜鸟日记之 ibatis 模糊查询 单引号

关键字: ibatis 模糊查询 单引号

<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中的写法， 用这个可以模糊查询单引号了。

 

评论
发表评论

您还没有登录，请登录后发表评论

protti
搜索本博客
存档
最新评论