MyBatis动态SQL标签用法实例详解

  select count(*)  select *  from icp   name like '%$name$%'  path like '%path$%'  area_id = #area_id#  hided = #hided#    limit #_start#, #_size#   

  = #_img_size_ge# ]]> 

  = #_now# ]]> 

   = #_starttime# and createtime < #_endtime# ]]>

  state in ('$_in_state$') 

  (chnameone like '%$chnameone$%' or spellinitial like '%$chnameone$%')  chnametwo like '%$chnametwo$%' 

    code not in (select t.contentcode from cms_ccm_programcontent t where t.contenttype='MZNRLX_MA' and t.programcode = #exprogramcode#)  select * from cms_ccm_material where code in (select t.contentcode from cms_ccm_programcontent t where t.contenttype = 'MZNRLX_MA' and programcode = #value#) order by updatetime desc 

  insert into rulemaster( name, createtime, updatetime, remark ) values ( #name#, now(), now(), #remark# )  select LAST_INSERT_ID()  update rulemaster set name = #name#, updatetime = now(), remark = #remark# where id = #id# 

  select count(a.*)  select a.id        vid, a.img       imgurl, a.img_s     imgfile, b.vfilename vfilename, b.name      name, c.id        sid, c.url       url, c.filename  filename, c.status    status  From secfiles c, juji b, videoinfo a where a.id = b. videoid and b.id = c.segmentid and c.status = 0 order by a.id asc,b.id asc,c.sortnum asc    limit #_start#, #_size#   

  SELECT * from STUDENT_TBL ST   ST.STUDENT_NAME LIKE CONCAT(CONCAT('%', #{studentName}),'%')  AND ST.STUDENT_SEX = #{studentSex} 

  UPDATE STUDENT_TBL   STUDENT_TBL.STUDENT_NAME = #{studentName},  STUDENT_TBL.STUDENT_SEX = #{studentSex},  STUDENT_TBL.STUDENT_BIRTHDAY = #{studentBirthday},  STUDENT_TBL.CLASS_ID = #{classEntity.classID}  WHERE STUDENT_TBL.STUDENT_ID = #{studentID}; 

  SELECT * from STUDENT_TBL ST    ST.STUDENT_NAME LIKE CONCAT(CONCAT('%', #{studentName}),'%')  AND ST.STUDENT_SEX = #{studentSex}  AND ST.STUDENT_BIRTHDAY = #{studentBirthday}  AND ST.CLASS_ID = #{classEntity.classID}