九、动态SQL(<sql><include>)
时间:2021-07-01 10:21:17
帮助过:42人阅读
<sql id="tb_user">
2 id,user,passwd
3 </sql>
4
5 <select id="selIn" resultType="User" parameterType="list">
6 select
7 <include refid="tb_user"/>
8 from tb_user where id in
9 <foreach collection="list" open="(" separator="," close=")" item="item">
10 #{item}
11 </foreach>
12 </select>
九、动态SQL(<sql><include>)
标签:pass tty 动态sql param lin list where sep style