chaixw007
chaixw007
2017-08-17 10:47

mybatis sql中查询获取不到值

  • select
  • mybatis
  • sql


select brt.rtid,brtc.categoryname,brt.templatename,brt.templatesql,brt.templatetitle,brt.templatesumcolumns,brt.empcreatecode,brt.empcreatename,brt.createtime,brt.empmodifycode,brt.empmodifyname,brt.modifytime,brt.isenable,brt.counter
from bi_reports_template brt left join bi_reports_template_category brtc on brt.rtcid=brtc.rtcid where 1=1

and brt.templateName = #{templatename,jdbcType=VARCHAR}

order by brt.rtid

sql如上,
and brt.templateName = #{templatename,jdbcType=VARCHAR}

获取不到templatename值什么原因哦???

  • 点赞
  • 回答
  • 收藏
  • 复制链接分享

1条回答