九、动态SQL（<sql><include>）

一、 <sql><include>

<sql>用于提取 SQL 语句, <include>用于引用 SQL 语句

<sql id="tb_user">
        id,user,passwd
</sql>

<select id="selIn" resultType="User" parameterType="list">
        select
            <include refid="tb_user"/>
         from tb_user where id in
        <foreach collection="list" open="(" separator=","  close=")" item="item">
            #{item}
        </foreach>
</select>