- & gt;
JavaType="Java. Util. List", "
Select="getOrderDetails"
The column="orderNumber" & gt;
- & gt;
SELECT * FROM tz_order_item WHERE order_number=# {orderNumber}
SELECT * FROM tz_order
1=1
Public class OrderVo implements Serializable {
/* *
* order ID
*/
@ Id
@ the Column (name="order_id")
private Long orderId;
/* *
* store id
*/
@ the Column (name="shop_id")
Private Long shopId;
/* *
* product name, multiple products will be separated with a comma
*/
@ the Column (name="prod_name")
Private String prodName;
/* *
* user Id order address
*/
@ the Column (name="addr_order_id")
Private Long addrOrderId;
/* *
* order serial number
*/
@ the Column (name="order_number")
private String orderNumber;
Private List
}
Public class OrderItem implements Serializable {
/* *
* order item ID
*/
@ Id
@ the Column (name="order_item_id")
Private Long orderItemId;
/* *
* store id
*/
@ the Column (name="shop_id")
Private Long shopId;
/* *
nullnullnullnullnullnullnullnullnull