如何通过include标签重用mybatis的代码段

2019独角兽企业重金招聘Python工程师标准>>>

1、首先定义一个sql标签，一定要定义唯一id<sql id="Base_Column_List" >name,age</sql> 2、然后通过id引用 <select id="selectAll"> select <include refid="Base_Column_List" /> from student </select>

这个<include refid="Base_Column_List" />会自动把上面的代码贴过来。

例子:

  <sql id="allColumn">  ID   as  id,    SPARTICIPANTBANKNO as sParticipantBankNO,    SPARTICIPANTFULLNAME as sParticipantFullName,    SPHONE as sPhone,    SADDRESS as sAddress   </sql>   

  <select id="queryCNAPSInfoByCondition" resultType="com.pcitc.ebank.query.entity.CNAPSInfo">   

SELECT * FROM (SELECT A.*, ROWNUM RN FROM (

      SELECT  <include refid='allColumn'/>   FROM BASE_BANK_INFO WHERE 1=1  

 <if test="sparticipantbankno != null">      

   AND sparticipantbankno like '%'||#{sparticipantbankno}||'%'  </if>     

  <if test="sparticipantfullname != null">   

     AND sparticipantfullname like '%'||#{sparticipantfullname}||'%'   </if>   ) A 

   WHERE ROWNUM  &lt;= #{endindex})   WHERE RN >= #{startindex}   </select>

转载于:https://my.oschina.net/iioschina/blog/1813940