package org.terry.jxls;

import java.io.BufferedInputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.xml.sax.SAXException;

import net.sf.jxls.reader.ReaderBuilder;
import net.sf.jxls.reader.XLSReadStatus;
import net.sf.jxls.reader.XLSReader;

public class ReadExcel {
	private final static String xmlConfig="student.xml";
	public List read(){
		InputStream inputXML = new BufferedInputStream(ReadExcel.class.getResourceAsStream(xmlConfig));
        XLSReader mainReader;
        String path=ReadExcel.class.getResource("/").getPath();
        path=path.substring(1,path.indexOf("/WebRoot")+1)+"WebRoot/Excel/stu.xls";
		try {
			mainReader = ReaderBuilder.buildFromXML(inputXML );
			 InputStream inputXLS = new BufferedInputStream(new FileInputStream(path));
		        Student stu=new Student();
		        List students = new ArrayList();
		        Map beans = new HashMap();
		        beans.put("stu", stu);
		        beans.put("students", students);
		        XLSReadStatus readStatus = mainReader.read(inputXLS, beans);
		        return students;
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SAXException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return null;
	}
	
	public static void main(String[] args) {
		ReadExcel re=new ReadExcel();
		List<Student> list=re.read();
		System.out.println("ID\t  name\t  subject\t  score");
		for(Student stu:list){
			System.out.println(stu.getIdname()+"\t  "+stu.getName()+"\t  "+stu.getSubject()+"\t  "+stu.getScorename());
		}
	}
}