1.传一个集合遍历
select dictval,dictlabel from sys_dict where dictcode='reginsureVO_userType'
and dictval in
<foreach collection="utype" open="(" close=")" separator="," item="dictval" >
#{dictval}
</foreach>
order by
dictorder
2.find_in_set
select dictval,dictlabel from sys_dict where dictcode='reginsureVO_userType'
and find_in_set(dictval,#{utype}) order by
dictorder