ssm整合中使用pageinfo插件的分页数据位移问题记录

<!--  查询员工同时带部门信息 -->

    <!-- <select id="selectByExampleWithDept"

       parameterType="com.atguigu.crud.bean.EmployeeExample"

       resultMap="WithDeptResultMap">

       select

       <if test="distinct">

           distinct

       </if>

       <include refid="WithDept_Column_List" />

       FROM tbl_emp e

       LEFT JOIN tbl_dept d ON e.d_id=d.dept_id

       <if test="_parameter != null">

           <include refid="Example_Where_Clause" />

       </if>

       <if test="orderByClause != null">

           order by ${orderByClause}

       </if>

    </select> -->

<!--  查询员工同时带部门信息 并根据emp_id排序 asc -->

    <select id="selectByExampleWithDept"

       parameterType="com.atguigu.crud.bean.EmployeeExample"

       resultMap="WithDeptResultMap">

       select

       <include refid="WithDept_Column_List" />

       FROM tbl_emp e

       LEFT JOIN tbl_dept d ON e.d_id=d.dept_id

       <if test="_parameter != null">

           <include refid="Example_Where_Clause" />

       </if>

           order by e.emp_id

    </select>