?? excelmanager.java
字號:
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 com.javayjm.excel.config.ExcelConfigFactory;
import com.javayjm.excel.config.ExcelConfigManager;
import com.javayjm.excel.file.ExcelToModel;
import com.javayjm.excel.file.impl.ExcelToModelImpl;
public class ExcelManager {
private File excelFile = null;
private String modelName = "";
private Map valueMap = null;
public ExcelManager(String fileName,String modelName,Map valueMap){
this(new File(fileName),modelName,valueMap);
}
public ExcelManager(File fileName,String modelName,Map valueMap){
this.excelFile = fileName;
this.modelName = modelName;
this.valueMap = valueMap;
}
public List getModelList(){
ExcelConfigManager configManager = ExcelConfigFactory.createExcelConfigManger();
ExcelToModel etm = new ExcelToModelImpl(this.excelFile,configManager.getModel(modelName, ""),this.valueMap);
List modelList = etm.getModelList();
return modelList;
}
public static void main(String[] args) {
Map<String, String> map = new HashMap<String, String>();
map.put("deptNo", "1");
map.put("bgqx永久", "Y");
ExcelManager test = new ExcelManager("E:\\workspace\\test.xls","deptModel",map);
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));
}
System.out.println("---------======================--------------------");
ExcelManager test2 = new ExcelManager("E:\\workspace\\test.xls","deptModel",map);
List modelList2 = test2.getModelList();
}
/**
* 配制文件加強,一是可以傳一個固定值到所有Bena中. 配制一個固定值.把固定值在RuturnConfig 單設成一個Map ,配制文件中,對固定值的配制必須有默認值,
* ExcelToModelImpl 實現時,根據Excel列,屬性設置完成后,對Map循環,設置其值.首先從傳參Map中取值,沒有取默認值設置.
* 二是可以配制轉換對應的碼表值.如:excel中傳的值為"長期" 可以配制成 "bgqx長期"做為鍵值 "C" 做為 Bean 設置的值.
*/
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -