modelmanagertest.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 com.javayjm.test.model.DeptModel;

import junit.framework.TestCase;

/*＊
 * 公　司：
 * 文件名：ModelManagerTest.java
 * 作　者：YJM - yinjingmin
 * 邮　箱：[e-mail]
 * 版本号：1.0
 * 时　间：2008-3-8 下午01:36:42
 */

public class ModelManagerTest extends TestCase {
    //form　测试
    List formModelList = new ArrayList(); 
    //map 测试
    List mapModelList =  new ArrayList();
    
    protected void setUp() throws Exception {
        super.setUp();        
        //　form　测试
        for(int i=0;i<68;i++){
          DeptModel dept = new DeptModel();
          dept.setDeptName("总部");
          dept.setDeptCode("A10" + i);
          dept.setDeptNo(i);
          dept.setReceiveFileName("12345678");
          dept.setSendFileName("交南发");
          formModelList.add(dept);
        }
        //map 测试
        for(int i=0;i<68;i++){
            Map m = new HashMap();
            m.put("deptName", "总部");
            m.put("deptCode", "A10"+i);
            m.put("receiveFileName", "1234567");
            m.put("deptNo", i);
            m.put("sendFileName", "市工商发");
            mapModelList.add(m);
        }
    }
    //按配制文件输出，不改变列头。　传入form　list 输出
    public void testFormConfig(){
        String fileName = "D:\\work\\workspace\\excelfile\\modeltoexcel_FormConfig.xls";
        ModelManager mm = null;
        try {
            mm = new ModelManager(new FileOutputStream(new File(fileName)),"deptModel",formModelList);
        } catch (FileNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        mm.getMte().setHeader("部门发文简称（2007）");
        mm.getMte().setRowHeight(500);
        mm.getExcelFile();
    }
    //改变其中部门或者全部列标题输出文字，传入form list 输出
    public void testFormConfig_title(){
        Map map = new HashMap();
        map.put("deptName", "部门名称_改变");
        map.put("deptCode", "部门编号_改变");
        map.put("deptNo", "排序_改变"); 
        String fileName = "D:\\work\\workspace\\excelfile\\modeltoexcel_FormConfig_title.xls";
        ModelManager mm = new ModelManager(fileName,"deptModel",formModelList);
        mm.getMte().setHeader("部门发文简称（2007）");
        mm.getMte().setRowHeight(500);
        mm.getMte().setDynamicTitleMap(map);
        mm.getExcelFile();
    }
    //按配制文件输出，不改变列头。　传入map　list 输出
    public void testMapConfig(){
        String fileName = "D:\\work\\workspace\\excelfile\\modeltoexcel_MapConfig.xls";
        ModelManager mm = new ModelManager(fileName,"deptModel",mapModelList);
        mm.getMte().setHeader("部门发文简称（2007）");
        mm.getMte().setRowHeight(500);
        
        mm.getExcelFile();
    }
//  改变列标题输出文字，传入Map list 输出
    public void testMapConfig_title(){
        Map map = new HashMap();
        map.put("deptName", "部门名称_改变");
        map.put("deptCode", "部门编号_改变");
        map.put("deptNo", "排序_改变"); 
        
        String fileName ="D:\\work\\workspace\\excelfile\\modeltoexcel_MapConfig_title.xls";
        ModelManager mm = new ModelManager(fileName,"deptModel",mapModelList);
        mm.getMte().setHeader("部门发文简称（2007）");
        mm.getMte().setRowHeight(500);
        
        mm.getMte().setDynamicTitleMap(map);
        
        mm.getExcelFile();
    }
    
    //按传入列输出，传入 form list 输出
    public void testFormColumn(){
        Map map = new HashMap();
        map.put("deptName", "部门名称_改变");
        map.put("deptCode", "部门编号_改变");
        map.put("deptNo", "排序_改变");  
        
        String fileName ="D:\\work\\workspace\\excelfile\\modeltoexcel_FormColumn.xls";
        ModelManager mm = new ModelManager(fileName,"deptModel",formModelList);
        mm.getMte().setHeader("部门发文简称（2007）");
        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("deptName", "部门名称_改变");
        map.put("deptCode", "部门编号_改变");
        map.put("deptNo", "排序_改变");  
        
        String fileName ="D:\\work\\workspace\\excelfile\\modeltoexcel_MapColumn.xls";
        ModelManager mm = new ModelManager(fileName,"deptModel",mapModelList);
        mm.getMte().setHeader("部门发文简称（2007）");
        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("Name", "尹景民");
        paramMap.put("Date", "2008-1-23");
        
        String fileName ="D:\\work\\workspace\\excelfile\\modeltoexcel_FormTemplate.xls";
        ModelManager mm = new ModelManager(fileName,"deptModel",formModelList);
        mm.getMte().setHeader("部门发文简称（2007）");
        mm.getMte().setRowHeight(500);
        
        mm.getMte().setTemplateParam("D:\\work\\workspace\\excelfile\\deptModelTemplate.xls", 3, paramMap);        
        mm.getExcelFile();
    }
    //加载模板，按配制文件，传入map list 输出
    public void testMapTemplate(){
        Map paramMap = new HashMap();
        paramMap.put("Name", "尹景民");
        paramMap.put("Date", "2008-1-23");
        
        String fileName ="D:\\work\\workspace\\excelfile\\modeltoexcel_MapTemplate.xls";
        ModelManager mm = new ModelManager(fileName,"deptModel",mapModelList);
        mm.getMte().setHeader("部门发文简称（2007）");
        mm.getMte().setRowHeight(500);
        
        mm.getMte().setTemplateParam("D:\\work\\workspace\\excelfile\\deptModelTemplate.xls", 3, paramMap);        
        mm.getExcelFile();
    }
    
    //多 Sheet 输出
    public void testMultiple(){
        
        //modeltoexcel_Multiple.xls做为模板文件传入时，文件必须存在，必须有足够多的sheet
        String fileName = "D:\\work\\workspace\\excelfile\\modeltoexcel_Multiple.xls";
        ModelManager mm = null;
        
        mm = new ModelManager(fileName,"deptModel",formModelList);
        
        mm.getMte().setHeader("部门发文简称（2007）");
        mm.getMte().setRowHeight(500);
        mm.getMte().setSheet(0, "第一");
        mm.getExcelFile();
        
        
//      String fileName = "D:\\work\\workspace\\excelfile\\modeltoexcel_FormConfig_title.xls";
        //ModelManager mm = new ModelManager(fileName,"deptModel",formModelList);
        Map map = new HashMap();
        map.put("deptName", "部门名称_改变");
        map.put("deptCode", "部门编号_改变");
        map.put("deptNo", "排序_改变"); 
        
        mm.setModelName_List("deptModel",formModelList);
        mm.getMte().setHeader("部门发文简称（2007）");
        mm.getMte().setRowHeight(500);
        mm.getMte().setDynamicTitleMap(map);
        
        mm.getMte().setSheet(1, "第二");
        mm.getExcelFile();
        
        //ModelManager mm = new ModelManager(fileName,"deptModel",mapModelList);
        Map paramMap = new HashMap();
        paramMap.put("Name", "尹景民");
        paramMap.put("Date", "2008-1-23");
        mm.setModelName_List("deptModel",mapModelList);
        mm.getMte().setHeader("部门发文简称（2007）");
        mm.getMte().setRowHeight(500);
        
        mm.getMte().setTemplateParam("D:\\work\\workspace\\excelfile\\modeltoexcel_Multiple.xls", 3, paramMap); 
        mm.getMte().setSheet(3, "");
        mm.getExcelFile();
        
    }
    //设置从每行，第几列开始操作
    public void testRowColumn(){
        ModelManager mm = new ModelManager("D:\\work\\workspace\\excelfile\\modeltoexcel_rowcolumn.xls","deptModel",mapModelList);
        mm.getMte().setHeader("部门发文简称（2007）");
        mm.getMte().setRowHeight(500);
        
        Map paramMap = new HashMap();
        paramMap.put("Name", "尹景民");
        paramMap.put("Date", "2008-1-23");
        
        //mm.getMte().setTemplateParam("D:\\work\\workspace\\excelfile\\deptModelTemplate.xls", 3, paramMap);
        mm.getMte().setTemplateParam("D:\\work\\workspace\\excelfile\\deptModelTemplate.xls", 3,2, paramMap,false);
        mm.getExcelFile();
    }
    protected void tearDown() throws Exception {
        super.tearDown();
    }

}