<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>