ibatis使用in查询的几种XML写法

1.传入参数是数组

?
??????????? select *
??????????? from UserInfo
??????????? where userId in
???????????????
??????????????????? #[]#
???????????????
???????

 string[] arrays = new string[] { "1", "2", "3" }; 
 Reader.QueryForList("Ibatisnet.dao.Test", strValue ); 

2.使用上面的数组还可以使用对象中数组方式，写法有点区别

 
            select * 
            from UserInfo 
            where userId in 
                 
                    ?#ArrValue[]#?
                 
         

		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
        
			 
                 ui.id in ($userids$)