excelmanagertest.java

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

package com.javayjm.excel;

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

import org.apache.commons.lang.builder.ToStringBuilder;

import junit.framework.TestCase;

/*＊
 * 公　司：
 * 文件名：ExcelManagerTest.java
 * 作　者：YJM - yinjingmin
 * 邮　箱：[e-mail]
 * 版本号：1.0
 * 时　间：2008-3-8 上午10:44:35
 */

public class ExcelManagerTest extends TestCase {

	private Map codeMap = new HashMap();
	protected void setUp() throws Exception {
		super.setUp();
		codeMap.put("sex男", "M");
		codeMap.put("sex女", "F");
	}
	public void testReadConfig_Form() {
		ExcelManager test = new ExcelManager(
				"D:\\work\\workspace\\excelfile\\student.xls",
				"importStudentInfo", codeMap);
		
		List modelList = test.getModelList();
		//
		for (int i = 0; i < modelList.size(); i++) {
			Object obj = modelList.get(i);
			System.out.println("--" + obj.getClass().getSimpleName());
			System.out.println("--" + ToStringBuilder.reflectionToString(obj));
		}
		// 如果Class配制成HashMap，下面可以测试。
		for (int i = 0; i < modelList.size(); i++) {
			Object oo = modelList.get(i);
			if (oo instanceof Map) {
				Map obj = (Map) oo;
				System.out.println("--" + obj.getClass().getSimpleName());
				System.out.println("--"
						+ ToStringBuilder.reflectionToString(obj.keySet()
								.toArray()));
				System.out.println("--"
						+ ToStringBuilder.reflectionToString(obj.entrySet()
								.toArray()));
			}
		}
	}

	public void testReadConfig_Form_sheet() {
		ExcelManager test = new ExcelManager(
				"D:\\work\\workspace\\excelfile\\student.xls",
				"importStudentInfo", codeMap);
		test.getEtm().setSheet(1);
		List modelList = test.getModelList();
		//
		for (int i = 0; i < modelList.size(); i++) {
			Object obj = modelList.get(i);
			System.out.println("--" + obj.getClass().getSimpleName());
			System.out.println("--" + ToStringBuilder.reflectionToString(obj));
		}
		// 如果Class配制成HashMap，下面可以测试。
		for (int i = 0; i < modelList.size(); i++) {
			Object oo = modelList.get(i);
			if (oo instanceof Map) {
				Map obj = (Map) oo;
				System.out.println("--" + obj.getClass().getSimpleName());
				System.out.println("--"
						+ ToStringBuilder.reflectionToString(obj.keySet()
								.toArray()));
				System.out.println("--"
						+ ToStringBuilder.reflectionToString(obj.entrySet()
								.toArray()));
			}
		}
	}

	public void testReadConfig_map() {
		ExcelManager test = new ExcelManager(
				"D:\\work\\workspace\\excelfile\\student.xls",
				"importStudentInfo_map", codeMap);
		List modelList = test.getModelList();
		//
		for (int i = 0; i < modelList.size(); i++) {
			Object obj = modelList.get(i);
			System.out.println("--" + obj.getClass().getSimpleName());
			System.out.println("--" + ToStringBuilder.reflectionToString(obj));
		}
		// 如果Class配制成HashMap，下面可以测试。
		for (int i = 0; i < modelList.size(); i++) {
			Object oo = modelList.get(i);
			if (oo instanceof Map) {
				Map obj = (Map) oo;
				System.out.println("--" + obj.getClass().getSimpleName());
				System.out.println("--"
						+ ToStringBuilder.reflectionToString(obj.keySet()
								.toArray()));
				System.out.println("--"
						+ ToStringBuilder.reflectionToString(obj.entrySet()
								.toArray()));
			}
		}
	}

	public void testReadConfig_map_sheet() {
		ExcelManager test = new ExcelManager(
				"D:\\work\\workspace\\excelfile\\student.xls",
				"importStudentInfo_map", codeMap);
		test.getEtm().setSheet(1);
		List modelList = test.getModelList();
		//
		for (int i = 0; i < modelList.size(); i++) {
			Object obj = modelList.get(i);
			System.out.println("--" + obj.getClass().getSimpleName());
			System.out.println("--" + ToStringBuilder.reflectionToString(obj));
		}
		// 如果Class配制成HashMap，下面可以测试。
		for (int i = 0; i < modelList.size(); i++) {
			Object oo = modelList.get(i);
			if (oo instanceof Map) {
				Map obj = (Map) oo;
				System.out.println("--" + obj.getClass().getSimpleName());
				System.out.println("--"
						+ ToStringBuilder.reflectionToString(obj.keySet()
								.toArray()));
				System.out.println("--"
						+ ToStringBuilder.reflectionToString(obj.entrySet()
								.toArray()));
			}
		}
	}

	public void testReadConfig_Form_export_file() {
		ExcelManager test = new ExcelManager(
				"D:\\work\\workspace\\excelfile\\student.xls",
				"importStudentInfo", codeMap);
		test.getEtm().setSheet(2);
		List modelList = test.getModelList();
		
		//
		for (int i = 0; i < modelList.size(); i++) {
			Object obj = modelList.get(i);
			System.out.println("--" + obj.getClass().getSimpleName());
			System.out.println("--" + ToStringBuilder.reflectionToString(obj));
		}
		// 如果Class配制成HashMap，下面可以测试。
		for (int i = 0; i < modelList.size(); i++) {
			Object oo = modelList.get(i);
			if (oo instanceof Map) {
				Map obj = (Map) oo;
				System.out.println("--" + obj.getClass().getSimpleName());
				System.out.println("--"
						+ ToStringBuilder.reflectionToString(obj.keySet()
								.toArray()));
				System.out.println("--"
						+ ToStringBuilder.reflectionToString(obj.entrySet()
								.toArray()));
			}
		}
		//test.getExcelFile(modelList);		
		test.getSucessExcelFile(modelList);
		//test.getErrorExcelFile(modelList);
	}
	protected void tearDown() throws Exception {
		super.tearDown();
	}
}