2020-09-29

**

会员member，订单order列表分页查询时的失误

**

<select id="findByCondition" parameterType="string" resultType="map">

    SELECT o.id,orderDate,orderType,orderStatus,m.name ,m.phoneNumber  FROM t_member m,t_order o
    <where>
        o.member_id = m.id
        <if test="value!=null and value!='' and value.length>0">
         AND (m.phoneNumber=#{value}or m.name=#{value} or  m.fileNumber=#{value})
        GROUP BY o.id
    </if>
    </where>
</select>

将 o.member_id = m.id条件放在if判断语句中造成查询出来的语句包括所有member信息！！！