1、代码

<sql id="Base_Column_List" >
        collegeID, collegeName
</sql> 
 
<select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Long" >
       select 
        <include refid="Base_Column_List" />
        from t_notification_template
       where id = #{id,jdbcType=BIGINT}
 </select>
1
2
3
4
5
6
7
8
9
10

2、解释

• 引入sql片段，简化代码结构。