1.传入参数是数组
<select id="Test" resultClass="dto">
select *
from UserInfo
where userId in
<iterate open="(" close=")" conjunction="," >
#[]#
</iterate>
</select>
2.in 后面的数据,使用string传入 ,但是记住如果是:请使用$ $,而不是# #
<select id="queryAllUserinfo" parameterClass="dto"
resultClass="dto">
SELECT
u.USERID,
ui.id,
u.USERNAME,
u.ACCOUNT,
u.SEX,
ui.specialty,
ui.address,
ui.idnumber,
ui.school,
ui.nation,
ui.political_landscape,
ui.phone,
ui.email,
ui.qq,
ui.job_category,
ui.stu_class,
ui.create_tm,
ui.modify_tm
FROM
eauser u,
TB_USER_INFO ui
WHERE
u.ACCOUNT = ui.ACCOUNT
<dynamic>
<isNotEmpty prepend="AND" property="userids">
ui.id in ($userids$)
</isNotEmpty>
</dynamic>
</select>