如何通過MyBatis使用xml方式實(shí)現(xiàn)數(shù)據(jù)庫(kù)數(shù)據(jù)交互，where in ()
'()'中是一個(gè)list

<select id="findUsersByRole" resultType="User">
SELECT * FROM user WHERE role IN
<foreach collection="roles" item="role" open="(" separator="," close=")">
#{role}
</foreach>
</select>