Mybatis的动态语句：代码片段

1. 定义代码片段

　　<sql id="selectall">

    select id,name,email,age from student
</sql>

2. 使用代码片段

<select id="selectSqlPD" resultType="com.bjpowernode.domain.Student">
    <include refid="selectall"></include>
    where id=#{id}
</select>