07-MyBatis_sql标签和include标签的使用

来源：互联网发布：数据库介绍ppt 编辑：程序博客网时间：2024/05/24 05:46

1. 源码下载:

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

2. 功能:

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

如:

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

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

3. 使用:

/* <sql id="mySQL">    SELECT o.*, p.*    FROM orders o       JOIN person p ON (p.personId=o.pid)    WHERE o.orderId = 'O_00001'     </sql><select id="selectOrderById2" parameterType="string" resultMap="orderMap">    <include refid="mySQL"/></select>*/  @Test public void testSelectOrderById2() throws Exception {        SqlSession session = sqlSessionFactory.openSession();                Order order = session.selectOne("com.hehe.mybatis.domain.Order.selectOrderById2", "O_00001");        System.out.println(                        order.getId() + "\t" +                        order.getNumber() + "\t" +                        order.getPrice() + "\t" +                        order.getPerson().getId() + "\t" +                        order.getPerson().getName() + "\t" +                        order.getPerson().getAddress() + "\t" +                        order.getPerson().getTel()                );              session.close();    }