java Mybatis pageHelper 分页查询失败

[一剑荒芜]

<resultMap id="BaseResultMap" type="cn.jian.mall.mp.entity.OrderVo">
<!--
WARNING - @mbg.generated
-->
<id column="order_id" jdbcType="BIGINT" property="orderId" />
<result column="shop_id" jdbcType="BIGINT" property="shopId" />
<result column="prod_name" jdbcType="VARCHAR" property="prodName" />
<result column="user_id" jdbcType="VARCHAR" property="userId" />
<result column="addr_order_id" jdbcType="BIGINT" property="addrOrderId" />
<result column="total" jdbcType="DECIMAL" property="total" />
<result column="actual_total" jdbcType="DECIMAL" property="actualTotal" />
<result column="pay_type" jdbcType="INTEGER" property="payType" />
<result column="remarks" jdbcType="VARCHAR" property="remarks" />
<result column="shop_remarks" jdbcType="VARCHAR" property="shopRemarks" />
<result column="status" jdbcType="INTEGER" property="status" />
<result column="dvy_type" jdbcType="TINYINT" property="dvyType" />
<result column="dvy_id" jdbcType="BIGINT" property="dvyId" />
<result column="dvy_flow_id" jdbcType="VARCHAR" property="dvyFlowId" />
<result column="freight_amount" jdbcType="DECIMAL" property="freightAmount" />
<result column="product_nums" jdbcType="INTEGER" property="productNums" />
<result column="create_time" jdbcType="TIMESTAMP" property="createTime" />
<result column="update_time" jdbcType="TIMESTAMP" property="updateTime" />
<result column="pay_time" jdbcType="TIMESTAMP" property="payTime" />
<result column="dvy_time" jdbcType="TIMESTAMP" property="dvyTime" />
<result column="finally_time" jdbcType="TIMESTAMP" property="finallyTime" />
<result column="cancel_time" jdbcType="TIMESTAMP" property="cancelTime" />
<result column="pre_sale_time" jdbcType="TIMESTAMP" property="preSaleTime" />
<result column="is_payed" jdbcType="BIT" property="isPayed" />
<result column="delete_status" jdbcType="INTEGER" property="deleteStatus" />
<result column="refund_status" jdbcType="INTEGER" property="refundStatus" />
<result column="platform_amount" jdbcType="DECIMAL" property="platformAmount" />
<result column="reduce_amount" jdbcType="DECIMAL" property="reduceAmount" />
<result column="order_type" jdbcType="TINYINT" property="orderType" />
<result column="close_type" jdbcType="TINYINT" property="closeType" />
<result column="receiver_name" jdbcType="VARCHAR" property="receiverName" />
<result column="receiver_mobile" jdbcType="VARCHAR" property="receiverMobile" />
<result column="order_number" jdbcType="VARCHAR" property="orderNumber" />

<collection property="orderItems"
ofType="cn.jian.mall.mp.entity.OrderItem"
javaType="java.util.List"
select="getOrderDetails"
column="orderNumber">
<!--<id column="order_item_id" property="orderItemId"></id>-->
<result property="orderItemId" column="order_item_id" />
<result property="orderNumber" jdbcType="VARCHAR" column="order_number" />
<result property="pic" column="pic" />
<result property="price" column="price" />
<result property="prodCount" column="prod_count" />
</collection>
</resultMap>

<select id="getOrderDetails" parameterType="string" resultType="list">
SELECT * FROM tz_order_item WHERE order_number = #{orderNumber}
</select>


<select id="queryOrders" resultMap="BaseResultMap" parameterType="cn.jian.mall.mp.entity.Order">
SELECT * FROM tz_order
<where>
1 = 1
<if test="orderId != null"> and order_id = #{orderId}</if>
<if test="userId != null"> and user_id = #{userId}</if>
</where>
</select>




public class OrderVo implements Serializable {
/**
* 订单ID
*/
@Id
@Column(name = "order_id")
private Long orderId;

/**
* 店铺id
*/
@Column(name = "shop_id")
private Long shopId;

/**
* 产品名称,多个产品将会以逗号隔开
*/
@Column(name = "prod_name")
private String prodName;

/**
* 用户订单地址Id
*/
@Column(name = "addr_order_id")
private Long addrOrderId;

/**
* 订购流水号
*/
@Column(name = "order_number")
private String orderNumber;

private List<OrderItem> orderItems;

}



public class OrderItem implements Serializable {
/**
* 订单项ID
*/
@Id
@Column(name = "order_item_id")
private Long orderItemId;

/**
* 店铺id
*/
@Column(name = "shop_id")
private Long shopId;

/**
* 订单order_number
*/
@Column(name = "order_number")
private String orderNumber;


}