接口
public List<Emp> queryByArray(Integer[] empnos);
EmpMapper.xml配置文件
<select id="queryByArray" resultType="emp">
select <include refid="baseColumn"></include> from emp
where empno in
<foreach collection="array" open="(" item="id" separator="," close=")">
#{id}
</foreach>
</select>
测试类
package test;
import java.io.IOException;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.List;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import com.abc.mybatis.domain.Emp;
import com.abc.mybatis.mapper.EmpDao;
public class TestQueryByArray {
public static void main(String[] args) throws IOException {
InputStream is=Resources.getResourceAsStream("mybatis-config.xml");
SqlSessionFactory sessionFactory=new SqlSessionFactoryBuilder().build(is);
SqlSession sqlSession=sessionFactory.openSession();
EmpDao mapper=sqlSession.getMapper(com.abc.mybatis.mapper.EmpDao.class);
Integer[] empnos= {6666,7839};
List<Emp> emps=mapper.queryByArray(empnos);
System.out.println(emps.toString());
}
}