java xls导入

public Object importExcel(HttpServletRequest request, String dateTime){

String fileName = null;
JSONObject json = new JSONObject();
ManageCostDaoImpl dao = new ManageCostDaoImpl();

try {
// 重命名上传后的文件名
fileName = request.getServletContext().getRealPath("/download/tmp") + File.separator;
//获得工程对象转换
DiskFileItemFactory fac = new DiskFileItemFactory();
        ServletFileUpload upload = new ServletFileUpload(fac);
        Iterator<FileItem> fi = upload.parseRequest(request).iterator();
        while(fi.hasNext()) {
        FileItem item = fi.next();
        if(!item.isFormField()) {
        String name = Calendar.getInstance().getTime().getTime()+"."+item.getName().split("\\.")[1];
        File saveFile = new File(fileName + name);
        item.write(saveFile);
       
        // excel转成javaBean
    List<String> fieldList = new ArrayList<String>();
    for(int i=1; i<=40; i++){
    fieldList.add("column" + i);
    }
    //获得所有的Excel中的数据
    List<ImportExcelBean> beanList = XLSUtils.excelToList(fileName + name, fieldList, ImportExcelBean.class, null, 1);
    //获得表头
    ImportExcelBean title = beanList.get(0);
    //移除表头
    beanList.remove(0);
   
   
    List<ZhkmfyzcBean> zhList = new ArrayList<ZhkmfyzcBean>();
    Map<String, String> map = dao.getDeptCode();
    for(ImportExcelBean bean : beanList){
    for(int i=4; i<=40; i++){
    String deptName = BeanUtils.getProperty(title, "column" + i);
    String deptCode = getDeptCode(map, deptName);
    String value = BeanUtils.getProperty(bean, "column" + i);
    if(ColumnBuildUtils.reduce(value, "0") == 0){
    continue  ;
    }
    ZhkmfyzcBean zhbean = new ZhkmfyzcBean();
    zhbean.setOrg(deptCode);
    zhbean.setKmh(bean.getColumn2());
    zhbean.setJe(value);
    zhList.add(zhbean);
    }
   
    }
   
    // 更新排序
    //dao.updateSort(beanList);
    dao.importExcel(zhList, dateTime);
   
    // 返回状态
    json.put("status", "1");
    json.put("msg", "Excel导入成功！");
        }
        }
} catch (Exception e) {
json.put("status", "0");
json.put("msg", "Excel导入失败！");
e.printStackTrace();
}
return json;
}



//获得部门编号
public String getDeptCode(Map<String, String> map, String name){
for (Map.Entry<String, String> entry : map.entrySet()) { 
if(entry.getKey().indexOf(name) > -1) {//匹配是否有有就返回值
return entry.getValue();
}
}
return "";
}

[color=red][/color]