public class User {
private int id;
private String name;//用户名
private String sex;//性别
private Date birthday;//生日
private String address;//地址
//一对多,一个用户可能存在多个订单
private List<Order> orders;
}
public interface OrderMapper {
//命名空间 绑定此接口
public Order findOrderById(Integer id);
// 获取所有的数据
public List<Order> findOrderAll();
//一对一的查询
public List<Order> findOrderAndUser();
//一对一的查询第二中方式
public List<Orders> findOrderAndUser2();
//一对多的查询
public List<User> findUserOrder();
}
4测试方法
@Test
public void findUserOrder() {
//创建SqlSessionFactory
//创建SqlSession
SqlSession sqlSession = sqlSessionFactory.openSession();
//SqlSEssion帮我生成一个实现类 (给接口)
OrderMapper orderMapper = sqlSession.getMapper(OrderMapper.class);
List<User> users = orderMapper.findUserOrder();
for (User user : users) {
System.out.println(user);
for (Order order : user.getOrders()) {
System.out.println(order);
}
}
}
1.domain实体类public class User { private int id; private String name;//用户名 private String sex;//性别 private Date birthday;//生日 private String address;//地址 //一对多,一个用户可能存在多个订单 private List order