<sql>用来封装SQL语句, <include>来调用
<!-- 通用查询结果列 -->
<sql id="Base_Column_List">
id, name, parentId, depPath, enabled, isParent
</sql>
上面是定义一个sql标签,一定要定义唯一id,便于后面使用< include refid=“Base_Column_List”/>调用。(id, name, parentId, depPath, enabled, isParent是要查询的字段)
<!-- 获取所有部门-->
<select id="getAllDepartments" resultMap="DepartmentWithChildren">
select
<include refid="Base_Column_List"/>
from t_department
where parentId = #{parentId}
</select>
然后通过id(Base_Column_List)引用,就可以查询出表t_department中的id, name, parentId, depPath, enabled, isParent的值