<select id="methodname" resultMap="对应的class"
parameterType="输入参数类型 java.util.Map/String/Integer">
select
<include refid="选择标签" />
from tbname
where id =
#{saleOrder.customerId}
<trim>
<if test="saleOrder.status!=null and saleOrder.status!=''">
and status= #{saleOrder.status}
</if>
</trim>
order by created_at desc
limit #{startIndex,jdbcType=INTEGER},#{max,jdbcType=INTEGER}
</select>
parameterType="输入参数类型 java.util.Map/String/Integer">
select
<include refid="选择标签" />
from tbname
where id =
#{saleOrder.customerId}
<trim>
<if test="saleOrder.status!=null and saleOrder.status!=''">
and status= #{saleOrder.status}
</if>
</trim>
order by created_at desc
limit #{startIndex,jdbcType=INTEGER},#{max,jdbcType=INTEGER}
</select>