studentutils.java

J2EE项目开发Excel数据导入导出操作组件源代码（附带说明文档）

package com.javayjm.excel;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

public class StudentUtils {
	 
	public static List getStudentFormList(){
		Map codeMap = new HashMap();
		codeMap.put("sex男", "M");
		codeMap.put("sex女", "F");
		ExcelManager test = new ExcelManager(
				"D:\\work\\workspace\\excelfile\\student.xls",
				"importStudentInfo", codeMap);
		
		List modelList = test.getModelList();
		return modelList;
	}
	
	public static List getStudentMapList(){
		Map codeMap = new HashMap();
		codeMap.put("sex男", "M");
		codeMap.put("sex女", "F");
		ExcelManager test = new ExcelManager(
				"D:\\work\\workspace\\excelfile\\student.xls",
				"importStudentInfo_map", codeMap);
		test.getEtm().setSheet(1);
		List modelList = test.getModelList();
		return modelList;
	}
	public static List getScoreMapList(){
		Map codeMap = new HashMap();
		codeMap.put("sex男", "M");
		codeMap.put("sex女", "F");
		ExcelManager test = new ExcelManager(
				"D:\\work\\workspace\\excelfile\\student.xls",
				"importStudentInfo_score", codeMap);
		test.getEtm().setSheet(4);
		List modelList = test.getModelList();
		return modelList;
	}
}