MyBatis_sql标签和include标签的使用

1. 源码下载:

    参看06-MyBatis_关联映射之多对一的下载

2. 功能:

    

    <sql>封装SQL语句, <include>调用

   如:

<sql id="columns">
             id, name, address
</sql>

<select ....>
select  <include refid="columns"/> from user
</select>

3. 使用:

[java]  view plain  copy

 print ?

1. /*  
2. <sql id="mySQL"> 
3.     SELECT o.*, p.* 
4.     FROM orders o  
5.       JOIN person p ON (p.personId=o.pid) 
6.     WHERE o.orderId = 'O_00001'      
7. </sql> 
8.  
9. <select id="selectOrderById2" parameterType="string" resultMap="orderMap"> 
10.     <include refid="mySQL"/> 
11. </select> 
12. */  @Test public void testSelectOrderById2() throws Exception {  
13.         SqlSession session = sqlSessionFactory.openSession();  
14.           
15.         Order order = session.selectOne("com.hehe.mybatis.domain.Order.selectOrderById2", "O_00001");  
16.         System.out.println(  
17.                         order.getId() + "\t" +  
18.                         order.getNumber() + "\t" +  
19.                         order.getPrice() + "\t" +  
20.                         order.getPerson().getId() + "\t" +  
21.                         order.getPerson().getName() + "\t" +  
22.                         order.getPerson().getAddress() + "\t" +  
23.                         order.getPerson().getTel()  
24.                 );        
25.         session.close();  
26.     }