Mybatis 多表操作

Mybatis的多表操作主要使用了resultMap标签，来处理来自不同数据库表的信息。

示例：

    
        
        
        
        
        
            
            
            
            
        
    

    
        SELECT *,o.id oid,o.name oname FROM USER u,orders o WHERe u.id=o.uid
    

    
        
        
        
        
        

        
        
            
            
            
        
    

    
         SELECT *,o.id oid,u.name uname FROM orders o,user u WHERe o.uid=u.id
    

@Test
    public void test1() throws IOException {
        InputStream resourceAsStream = Resources.getResourceAsStream("V/sqlMapConfig.xml");
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);
        SqlSession sqlSession = sqlSessionFactory.openSession();

        OrderMapper mapper = sqlSession.getMapper(OrderMapper.class);
        List orderList = mapper.findAll();
        for (order order : orderList) {
            System.out.println(order);
        }

        sqlSession.close();
    }

    @Test
    public void test2() throws IOException {
        InputStream resourceAsStream = Resources.getResourceAsStream("V/sqlMapConfig.xml");
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);
        SqlSession sqlSession = sqlSessionFactory.openSession();

        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        List userList = mapper.findAll();
        for (User user : userList) {
            System.out.println(user);
        }

        sqlSession.close();
    }