資源簡介
這是本人實現的比較通用的工具類,希望可以幫助到你們

代碼片段和文件信息
package?com.excel.config;
public?class?ConfigConstant?{
/*
?*?model?的查找編號??id
?*/
public?static?final?String?MODEL_ID?=?“id“;
/*
?*?從Excel?到?Model?轉換的目標?javabean?class
?*/
public?static?final?String?MODEL_CLASS=“class“;
/*
?*?excel?列中對應到javabean中的?javabean屬性名稱
?*/
public?static?final?String?PROPERTY_NAME?=?“name“;
/*
?*?excel中的標標題中的列數?(??取值的時候可以用javabean屬性和對應的列數取值)
?*/
public?static?final?String?PROPERTY_CLOUMN=“cloumn“;
/*
?*?excel?列中對應到javabean中的?excel列標題名稱??(取值的時候可以用?javabean屬性和Excel中的標題對應取值)
?*/
public?static?final?String?PROPERTY_EXCEL_title_NAME?=?“exceltitleName“;
/*
?*?excel中的列數據要被轉換的數據類型
?*/
public?static?final?String?PROPERTY_DATA_TYPE?=?“dataType“;
/*
?*?excel中的數據最大長度
?*/
public?static?final?String?PROPERTY_MAX_LENGTH=“maxLength“;
/*
?*?在excel中沒有列數據需要系統對javabean屬性中的某一個值設置一個動態傳入的值(指所有JavaBean的這個屬性值,都是統一傳入的固定值).設置些屬性必須設置默認值
?*?
?*?他的值設置為?fixity?=?“yes“?默認為?no.
?*/
public?static?final?String?PROPERTY_FIXITY=“fixity“;
/*
?*?在導入excel時有些值在存入系統時使用的值需要轉換
?*?如:一個保管期限的下拉列表中有{永久(Y)長期(C)短期(D)}
?*?系統中存入的只能是?YCD之類的值導入Excel的值卻是永久長期短期這類的值需要轉換.
?*?轉換方式:取到Excel中的具體值加上保管期限前輟從傳入的Map中取值.如?取值長期??C?=?Map.get(“bgqx長期“);?
?*?
?*/
public?static?final?String?PROPERTY_CODE_TABLE_NAME=“codeTableName“;
/*
?*?如果值為空設置的默認值
?*/
public?static?final?String?PROPERTY_DEFAULT=“default“;
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????802??2011-07-26?11:12??newExcel\.classpath
?????文件????????384??2011-07-26?11:12??newExcel\.project
?????文件????????629??2011-07-26?11:12??newExcel\.settings\org.eclipse.jdt.core.prefs
?????文件????????826??2011-07-26?11:12??newExcel\bin\com\excel\config\ConfigConstant.class
?????文件????????878??2011-07-26?11:12??newExcel\bin\com\excel\config\RuturnConfig.class
?????文件???????2036??2011-07-26?11:12??newExcel\bin\com\excel\config\RuturnPropertyParam.class
?????文件????????210??2011-07-26?11:12??newExcel\bin\com\excel\file\Excel.class
?????文件???????7444??2011-07-26?11:12??newExcel\bin\com\excel\file\impl\ExcelImpl.class
?????文件???????1226??2011-07-26?11:12??newExcel\bin\com\excel\main\ImportFile.class
?????文件???????1132??2011-07-26?11:12??newExcel\bin\com\excel\test\DeptModel.class
?????文件???????6658??2011-07-26?11:12??newExcel\bin\com\excel\utils\ExcelReader.class
?????文件???????4357??2011-07-26?11:12??newExcel\bin\com\excel\utils\xm
?????文件????????787??2011-07-26?11:12??newExcel\bin\ImportExcelToModel.xm
?????文件??????22528??2011-07-26?11:12??newExcel\bin\test.xls
?????文件?????261809??2011-07-25?09:28??newExcel\jar\commons-lang-2.4.jar
?????文件??????38015??2011-07-25?10:42??newExcel\jar\commons-logging.jar
?????文件?????313898??2011-07-25?09:28??newExcel\jar\dom4j-1.6.1.jar
?????文件????1675036??2010-10-29?16:40??newExcel\jar\poi-3.7-20101029.jar
?????文件?????264108??2010-10-29?16:40??newExcel\jar\poi-examples-3.7-20101029.jar
?????文件????2143317??2011-07-25?09:28??newExcel\jar\spring-2.5.6.jar
?????文件???????1715??2011-07-26?11:12??newExcel\src\com\excel\config\ConfigConstant.java
?????文件????????487??2011-07-26?11:12??newExcel\src\com\excel\config\RuturnConfig.java
?????文件???????1471??2011-07-26?11:12??newExcel\src\com\excel\config\RuturnPropertyParam.java
?????文件????????202??2011-07-26?11:12??newExcel\src\com\excel\file\Excel.java
?????文件???????5803??2011-07-26?11:12??newExcel\src\com\excel\file\impl\ExcelImpl.java
?????文件????????654??2011-07-26?11:12??newExcel\src\com\excel\main\ImportFile.java
?????文件????????714??2011-07-26?11:12??newExcel\src\com\excel\test\DeptModel.java
?????文件???????5797??2011-07-26?11:12??newExcel\src\com\excel\utils\ExcelReader.java
?????文件???????3268??2011-07-26?11:12??newExcel\src\com\excel\utils\xm
?????文件????????787??2011-07-26?11:12??newExcel\src\ImportExcelToModel.xm
............此處省略25個文件信息
- 上一篇:AI用tpx色卡絕對能用的電子版
- 下一篇:ob
jectSNMP
評論
共有 條評論