ibatis动态SQL标签用法.docx

iBatis动态SQL标签用法1、动态SQL片段通过SQL片段达到代码复用select count(*)select *from icpname like %$name$%path like %path$%area_id = #area_id#hided = #hided#limit #_start#, #_size#2、数字范围查询所传参数名称是捏造所得，非数据库字段，比如_img_size_ge、_img_size_lt字段= #_img_size_ge#!CDATAimg_size多次使用一个参数也是允许的= #_now# !CDATAcloseplantime3、时间范围查询= #_starttime#and createtime4、in查询state in ($_in_state$)5、like查询(chnameone like %$chnameone$% or spellinitial like %$chnameone$%)chnametwo like %$chnametwo$%6、or条件!CDATAt.finished in (10,19) and t.failure7、where子查询code not in(select t.contentcodefrom cms_ccm_programcontent twhere t.contenttype=MZNRLX_MAand gramcode = #exprogramcode#)select *from cms_ccm_materialwhere code in(select t.contentcodefrom cms_ccm_programcontent twhere t.contenttype = MZNRLX_MAand programcode = #value#)order by updatetime desc9、函数的使用insert into rulemaster(name,createtime,updatetime,remark) values (#name#,now(),now(),#remark#)select LAST_INSERT_ID()update rulemaster setname = #name#,updatetime = now(),remark = #remark#where id = #id#10、map结果集select count(a.*)select a.idvid,a.img imgurl,a.img_s imgfile,b.vfilename vfilename,name,c.idsid,c.url url,c.filenamefilename,c.statusstatusFrom secfiles c, juji b, videoinfo awherea.id = b. videoidand b.id = c.segmentidand c.status