一個用戶對應多個訂單 **在User.java這個類中添加這個** **一個User對應多個Order** ~~~ // 附加對象List private List<Orders> ordersList; public List<Orders> getOrdersList() { return ordersList; } public void setOrdersList(List<Orders> ordersList) { this.ordersList = ordersList; } ~~~ 配置文件中寫 ~~~ <!-- // 一對多關聯 public List<User> selectUserList(); --> <resultMap type="pojo.User" id="user"> <id column="user_id" property="id" /> <result column="username" property="username" /> <!-- 一對多 --> <collection property="ordersList" ofType="pojo.Orders"> <id column="id" property="id" /> <result column="number" property="number" /> </collection> </resultMap> <select id="selectUserList" resultMap="user"> select o.id,o.user_id,o.number,o.createtime,u.username from user u left join orders o on o.user_id = u.id </select> ~~~ ~~~ <!-- collection是用于建立一對多中集合屬性的對應關系 ofType 用于指定集合元素的數據類型 --> ~~~ 測試 ~~~ // 加載核心配置文件 String resource = "SqlMapConfig.xml"; InputStream in = Resources.getResourceAsStream(resource); // 創建SqlSessionFactory SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(in); // 創建SqlSession SqlSession sqlSession = sqlSessionFactory.openSession(); // SqlSession幫我生成一個實現類 OrderMapper mapper = sqlSession.getMapper(OrderMapper.class); List<User> selectOrderList = mapper.selectUserList(); for (User users : selectOrderList) { System.out.println(users); System.out.println(users.getOrdersList()); } ~~~