modelmanagertest2.java

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

package com.javayjm.excel;

import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import junit.framework.TestCase;

public class ModelManagerTest2 extends TestCase {
	// form 测试
	List formModelList = new ArrayList();

	// map 测试
	List mapModelList = new ArrayList();
	
	// map　成绩
	List mapScoreList = new ArrayList();
	

	protected void setUp() throws Exception {
		super.setUp();
		formModelList = StudentUtils.getStudentFormList();
		mapModelList = StudentUtils.getStudentMapList();
		mapScoreList = StudentUtils.getScoreMapList();
	}

	// 按配制文件输出，不改变列头。 传入form list 输出
	public void testFormConfig() {
		String fileName = "D:\\work\\workspace\\excelfile\\student\\student_FormConfig.xls";
		ModelManager mm = new ModelManager(fileName, "importStudentInfo",
				formModelList);
		mm.getMte().setHeader("高二一班(2008)级学生名单");
		mm.getMte().setRowHeight(500);
		mm.getExcelFile();
	}

	// 改变其中部门或者全部列标题输出文字，传入form list 输出
	public void testFormConfig_title() {
		Map map = new HashMap();
		map.put("className", "班级名称_改变");
		map.put("classCode", "班级编号_改变");
		map.put("studentName", "姓名_改变");
		map.put("sex", "性别_改变");
		map.put("sort", "排序_改变");
		String fileName = "D:\\work\\workspace\\excelfile\\student\\student_FormConfig_title.xls";
		ModelManager mm = new ModelManager(fileName, "importStudentInfo",
				formModelList);
		mm.getMte().setHeader("高二一班(2008)级学生名单");
		mm.getMte().setRowHeight(500);
		mm.getMte().setDynamicTitleMap(map);
		mm.getExcelFile();
	}

	// 按配制文件输出，不改变列头。 传入map list 输出
	public void testMapConfig() {
		String fileName = "D:\\work\\workspace\\excelfile\\student\\student_MapConfig.xls";
		ModelManager mm = new ModelManager(fileName, "importStudentInfo",
				mapModelList);
		mm.getMte().setHeader("高二一班(2008)级学生名单");
		mm.getMte().setRowHeight(500);

		mm.getExcelFile();
	}

	// 改变列标题输出文字，传入Map list 输出
	public void testMapConfig_title() {
		Map map = new HashMap();
		map.put("className", "班级名称_改变");
		map.put("classCode", "班级编号_改变");
		map.put("studentName", "姓名_改变");
		map.put("sex", "性别_改变");
		map.put("sort", "排序_改变");

		String fileName = "D:\\work\\workspace\\excelfile\\student\\student_MapConfig_title.xls";
		ModelManager mm = new ModelManager(fileName, "importStudentInfo",
				mapModelList);
		mm.getMte().setHeader("高二一班(2008)级学生名单");
		mm.getMte().setRowHeight(500);

		mm.getMte().setDynamicTitleMap(map);

		mm.getExcelFile();
	}

	// 按传入列输出，传入 form list 输出
	public void testFormColumn() {
		Map map = new HashMap();
		map.put("className", "班级名称_定义");
		map.put("classCode", "班级编号_定义");
		map.put("studentName", "姓名_定义");
		map.put("sex", "性别_定义");
		map.put("sort", "排序_定义");

		String fileName = "D:\\work\\workspace\\excelfile\\student\\student_FormColumn.xls";
		ModelManager mm = new ModelManager(fileName, "importStudentInfo",
				formModelList);
		mm.getMte().setHeader("高二一班(2008)级学生名单");
		mm.getMte().setRowHeight(500);
		mm.getMte().setDynamicTitle(true);
		mm.getMte().setDynamicTitleMap(map);

		mm.getExcelFile();
	}

	// 按传入列输出，传入 map list 输出
	public void testMapColumn() {
		Map map = new HashMap();
		map.put("className", "班级名称_定义");
		map.put("classCode", "班级编号_定义");
		map.put("studentName", "姓名_定义");
		map.put("sex", "性别_定义");
		map.put("sort", "排序_定义");

		String fileName = "D:\\work\\workspace\\excelfile\\student\\student_MapColumn.xls";
		ModelManager mm = new ModelManager(fileName, "importStudentInfo",
				mapModelList);
		mm.getMte().setHeader("高二一班(2008)级学生名单");
		mm.getMte().setRowHeight(500);

		mm.getMte().setDynamicTitle(true);
		mm.getMte().setDynamicTitleMap(map);

		mm.getExcelFile();
	}

	// 加载模板，按配制文件，传入form list 输出
	public void testFormTemplate() {
		Map paramMap = new HashMap();
		paramMap.put("Year", "2007");
		paramMap.put("Name", "尹景民");
		paramMap.put("Date", "2008-1-23");

		String fileName = "D:\\work\\workspace\\excelfile\\student\\student_FormTemplate.xls";
		ModelManager mm = new ModelManager(fileName, "importStudentInfo",
				formModelList);
		mm.getMte().setHeader("高二一班(2008)级学生名单");
		mm.getMte().setRowHeight(400);

		mm.getMte().setTemplateParam(
				"D:\\work\\workspace\\excelfile\\studentModelTemplate.xls", 3,
				paramMap);
		mm.getExcelFile();
	}

	// 加载模板，按配制文件，传入map list 输出
	public void testMapTemplate() {
		Map paramMap = new HashMap();
		paramMap.put("Year", "2007");
		paramMap.put("Name", "尹景民");
		paramMap.put("Date", "2008-1-23");

		String fileName = "D:\\work\\workspace\\excelfile\\student\\student_MapTemplate.xls";
		ModelManager mm = new ModelManager(fileName, "importStudentInfo",
				mapModelList);
		mm.getMte().setHeader("高二一班(2008)级学生名单");
		mm.getMte().setRowHeight(500);

		mm.getMte().setTemplateParam(
				"D:\\work\\workspace\\excelfile\\studentModelTemplate.xls", 3,
				paramMap);
		mm.getExcelFile();
	}

	// 多 Sheet 输出
	public void testMultipleSheet() {

		// modeltoexcel_Multiple.xls做为模板文件传入时，文件必须存在，必须有足够多的sheet
		String fileName = "D:\\work\\workspace\\excelfile\\student\\student_Multiple.xls";
		ModelManager mm = null;
		mm = new ModelManager(fileName, "importStudentInfo", formModelList);
		mm.getMte().setHeader("高二一班(2008)级学生名单");
		mm.getMte().setRowHeight(500);
		mm.getMte().setSheet(0, "第一");
		mm.getExcelFile();	
		
		Map map = new HashMap();
		map.put("className", "班级名称_改变");
		map.put("classCode", "班级编号_改变");
		map.put("studentName", "姓名_改变");
		map.put("sex", "性别_改变");
		map.put("sort", "排序_改变");
		mm.setModelName_List("importStudentInfo", formModelList);
		mm.getMte().setHeader("高二一班(2008)级学生名单");
		mm.getMte().setRowHeight(500);
		mm.getMte().setDynamicTitleMap(map);
		mm.getMte().setSheet(1, "第二");
		mm.getExcelFile();	
		
		Map paramMap = new HashMap();
		paramMap.put("Year", "2007");
		paramMap.put("Name", "尹景民");
		paramMap.put("Date", "2008-1-23");
		mm.setModelName_List("importStudentInfo", mapModelList);
		mm.getMte().setHeader("高二一班(2008)级学生名单");
		mm.getMte().setRowHeight(500);
		mm.getMte().setTemplateParam("D:\\work\\workspace\\excelfile\\student\\student_Multiple.xls", 3,
				paramMap);
		mm.getMte().setSheet(2, "第三");
		mm.getExcelFile();

	}

	// 设置从每行，第几列开始操作
	public void testRowColumn() {
		ModelManager mm = new ModelManager(
				"D:\\work\\workspace\\excelfile\\student\\student_rowcolumn.xls",
				"importStudentInfo", mapModelList);
		mm.getMte().setHeader("高二一班(2008)级学生名单");
		mm.getMte().setRowHeight(500);

		Map paramMap = new HashMap();
		paramMap.put("Year", "2007");
		paramMap.put("Name", "尹景民");
		paramMap.put("Date", "2008-1-23");
		mm.getMte().setTemplateParam(
				"D:\\work\\workspace\\excelfile\\studentModelTemplate2.xls", 3,
				1, paramMap, false);
		mm.getExcelFile();
	}

	// 设置开始行，开始列操作，多次导出
	public void testMultipleRowColumn() {
		ModelManager mm = new ModelManager(
				"D:\\work\\workspace\\excelfile\\student\\student_Multiplerowcolumn.xls",
				"importStudentInfo", formModelList);		
		mm.getMte().setRowHeight(400);

		Map paramMap = new HashMap();
		paramMap.put("Year", "2007");
		paramMap.put("Name", "尹景民");
		paramMap.put("Date", "2008-1-23");
		mm.getMte().setTemplateParam(
				"D:\\work\\workspace\\excelfile\\studentModelTemplate3.xls", 3,
				1, paramMap, false);
		mm.getExcelFile();
		
		//第二次操作
		mm.setModelName_List("importStudentInfo_score", mapScoreList);
		mm.getMte().setTemplateParam(
				"D:\\work\\workspace\\excelfile\\\\student\\student_Multiplerowcolumn.xls", 3,12,
				paramMap,false);		
		mm.getExcelFile();
	}
	protected void tearDown() throws Exception {
		super.tearDown();
	}
}