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

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>