静态 <sql id="factoryColumns">factory_index,factory_id,system_name,model_num,model_id</sql> <select id="listAllInfoByFactoryId" resultMap="factoryResultMap" parameterType="Integer"> select <include refid="factoryColumns"/> from tb2_factory where factory_id = #{factoryId} </select> 动态 <sql id="userColumns"> ${alias}.id,${alias}.password </sql> <select id="findUserById" parameterType="String" resultType="User"> select <include refid="userColumns"><property name="alias" value="u"/></include> from sysuser u where id=#{id} </select>