Order.java

package cn.elinzhou.mybatisTest.pojo; import java.util.Date; /** * Description: Orders * Author: Elin Zhou * Create: 2015-06-30 00:06 */ public class Orders { // id | user_id | number | createtime | note | private Integer id; private Integer user_id; private String number; private Date createtime; private String note; public Date getCreatetime() { return createtime; } public void setCreatetime(Date createtime) { this.createtime = createtime; } public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } public String getNote() { return note; } public void setNote(String note) { this.note = note; } public String getNumber() { return number; } public void setNumber(String number) { this.number = number; } public Integer getUser_id() { return user_id; } public void setUser_id(Integer user_id) { this.user_id = user_id; } @Override public String toString() { return "Orders{" + "createtime=" + createtime + ", id=" + id + ", user_id=" + user_id + ", number='" + number + '\'' + ", note='" + note + '\'' + '}'; } } 

OrderDetail.java

package cn.elinzhou.mybatisTest.pojo; /** * Description: OrderDetail * Author: Elin Zhou * Create: 2015-06-30 00:08 */ public class OrderDetail { // id | orders_id | items_id | items_num private Integer id; private Integer orders_id; private Integer items_id; private Integer items_num; public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } public Integer getItems_id() { return items_id; } public void setItems_id(Integer items_id) { this.items_id = items_id; } public Integer getItems_num() { return items_num; } public void setItems_num(Integer items_num) { this.items_num = items_num; } public Integer getOrders_id() { return orders_id; } public void setOrders_id(Integer orders_id) { this.orders_id = orders_id; } @Override public String toString() { return "OrderDetail{" + "id=" + id + ", orders_id=" + orders_id + ", items_id=" + items_id + ", items_num=" + items_num + '}'; } } 

POJO由于对应这数据库字段，所以不方便修改，为了方便拓展，添加两个类OrderCustom和OrderDetailCustom，用来包含所需要的POJO对象

OrderCustom.java

package cn.elinzhou.mybatisTest.pojo; /** * Description: OrderDetailCustom * Author: Elin Zhou * Create: 2015-06-30 00:56 */ public class OrderDetailCustom extends OrderDetail { private Items items; public Items getItems() { return items; } public void setItems(Items items) { this.items = items; } @Override public String toString() { return "OrderDetailCustom{" + "items=" + items + '}'; } } 

OrderDetailCustom.java

package cn.elinzhou.mybatisTest.pojo; import java.util.List; /** * Description: OrdersCustrom * Author: Elin Zhou * Create: 2015-06-30 00:35 */ public class OrdersCustrom extends Orders { private List
        
          orderDetails; public List
         
           getOrderDetails() { return orderDetails; } public void setOrderDetails(List
          
            orderDetails) { this.orderDetails = orderDetails; } @Override public String toString() { return "OrdersCustrom{" + "orderDetails=" + orderDetails + '}'; } } 
          
         
        

OrderCustom继承自Order，添加了一个List
OrderDetailCustom继承自OrderDetail,添加了一个Items

本案例只实现订单的获取功能，所以在OrderMapper中只定义个findOrders方法

OrderMapper.java

package cn.elinzhou.mybatisTest.mapper; import cn.elinzhou.mybatisTest.pojo.OrdersCustrom; import java.util.List; /** * Description: OrdersMapper * Author: Elin Zhou * Create: 2015-06-30 00:32 */ public interface OrdersMapper { List
         
           findOrders() throws Exception; }