2021-08-04

Base_Column_List(通用查询结果列)的作用

在mybatis中有Base_Column_List

  <!-- 通用查询结果列 -->
    <sql id="Base_Column_List">
        id, last_name, email, gender, age
    </sql>
    <select id="selectEmployee">
       select <include refid="Base_Column_List"/> from employee
    </select>
    <!--等价于  -->
    <select id="selectEmployee">
       select id, last_name, email, gender, age from employee
    </select>

通过引用Base_Column_List的方式来代替id, last_name, email, gender, age