excel表格数据转换成javaBean

package com.bris.config; import java.io.InputStream; import java.util.HashMap; import java.util.Iterator; import java.util.List; import java.util.Map; import org.dom4j.Document; import org.dom4j.DocumentException; import org.dom4j.Element; import org.dom4j.io.SAXReader; /** * * <p> * Description: * </p> * * @Author changkongfei * @Date [2011-8-19] * @Version V1.0 * @修改记录 <pre> * 版本号 修改人 修改时间 修改内容描述 * ---------------------------------------- * V1.0 常孔飞 2010-7-18 * * </pre> */ public class ExcelConfigManager { private String configName = "ExcelToPOJO.xml"; private SAXReader saxReader; private Document doc; private Element root; /** * 构造函数 初始化ExcelConfigManager,读取XML配置文件。 */ public ExcelConfigManager() { InputStream in = Thread.currentThread().getContextClassLoader() .getResourceAsStream(configName); saxReader = new SAXReader(); try { doc = saxReader.read(in); } catch (DocumentException e) { e.printStackTrace(); } root = doc.getRootElement(); } /** * getModelElement 方法描述: 根据modelName取得该类的一个Element * 逻辑描述: 从XMl配置文件的根节点root中遍历比较，取出和modelName相同的子节点 * @param modelName 传入的model名字 * @return 返回该类的一个Element * @since Ver 1.00 */ public Element getModelElement(String modelName) { List list = root.elements(); Element model = null; Element returnModel = null; for (Iterator it = list.iterator(); it.hasNext();) { model = (Element) it.next(); if (model.attributeValue("id").equals(modelName)) { returnModel = model; break; } } return returnModel; } /** * getModel 方法描述: 根据modelName取得该类配置的一个对象 逻辑描述: * @param modelName 传入的model名字 * @param flag 暂时没用 * @return 返回一个配置的model对象 * @since Ver 1.00 */ public ReturnConfig getModel(String modelName, String flag) { Element model = this.getModelElement(modelName); ReturnConfig result = new ReturnConfig(); if (model != null) { result.setClassName(model .attributeValue(XmlConfigConstant.MODEL_CLASS)); result.setPropertyMap(this.getPropertyMap(model)); } return result; } /** * getPropertyMap 方法描述: 取得model的属性列表 逻辑描述: * @param model * @return * @since Ver 1.00 */ public Map<String, PropertyElement> getPropertyMap(Element model) { Map<String, PropertyElement> propertyMap = new HashMap<String, PropertyElement>(); List list = model.elements(); Element property = null; for (Iterator it = list.iterator(); it.hasNext();) { property = (Element) it.next(); PropertyElement modelProperty = new PropertyElement(); modelProperty.setName(property .attributeValue(XmlConfigConstant.PROPERTY_NAME)); modelProperty.setCloumn(property .attributeValue(XmlConfigConstant.PROPERTY_CLOUMN)); modelProperty .setExcelTitleName(property .attributeValue(XmlConfigConstant.PROPERTY_EXCEL_TITLE_NAME)); modelProperty.setDataType(property .attributeValue(XmlConfigConstant.PROPERTY_DATA_TYPE)); propertyMap.put(modelProperty.getExcelTitleName(), modelProperty); } return propertyMap; } // public static void main(String[] args) { // ExcelConfigManager test = new ExcelConfigManager(); // test.getModelElement("student"); // } }