数据导入

/**
  *  用户导入
  */
   public String toinput()
 {
      List<CoupeOrganizer> affordList=new ArrayList<CoupeOrganizer>();
   try {            
    System.out.println("路径名：：：："+fileName);
             FileInputStream fis = new FileInputStream(new File(fileName));   
             System.out.println("路径：：：："+fis);
             Workbook rwb = Workbook.getWorkbook(fis);  
             Sheet rs = rwb.getSheet(0);            
             int rows = rs.getRows();            
             int columns=rs.getColumns();            
             System.out.println(columns);            
              for (int i = 2; i < rows; i++) {                
          
               boolean notblank=false;
               for(int k=1;k<20;k++){
                notblank=notblank || rs.getCell(k, i).getContents().trim()!="";
               }
                  if(notblank )     //屏蔽空数据
                  {
                   CoupeOrganizer c=new CoupeOrganizer(); 
                       c.setDlzh(rs.getCell(1, i).getContents().trim());
                       c.setDlmm(rs.getCell(1, i).getContents().trim());   //2为区县  不需要字段
                       c.setJbdmc(rs.getCell(3, i).getContents().trim());
                       
                       c.setTxdz(rs.getCell(4, i).getContents().trim());
                       c.setYb(rs.getCell(5, i).getContents().trim());
                       c.setFzrxm(rs.getCell(6, i).getContents().trim());
                       c.setFzrzw(rs.getCell(7, i).getContents().trim());
                       c.setFzrlxfs(rs.getCell(8, i).getContents().trim());
                   
                       c.setLxrxm(rs.getCell(9, i).getContents().trim());
                      c.setLxrzw(rs.getCell(10, i).getContents().trim());
                      c.setLxrsj(rs.getCell(11, i).getContents().trim());
                      c.setLxrbgdh(rs.getCell(12, i).getContents().trim());
                      c.setLxrcz(rs.getCell(13, i).getContents().trim());
                       c.setLxrlxfs(rs.getCell(14, i).getContents().trim());     
                      c.setHcmc(rs.getCell(15, i).getContents().trim());
                      c.setHcdz(rs.getCell(16, i).getContents().trim());
                      c.setHcdh(rs.getCell(17, i).getContents().trim());
                      c.setDdgjxl(rs.getCell(19, i).getContents().trim());
              
                      c.setSfyx(0);
               
              affordList.add(c);
            
                  }
             }         
          } catch (FileNotFoundException e) {            
              // TODO Auto-generated catch block            
              e.printStackTrace();        
          } catch (BiffException e) {            
           // TODO Auto-generated catch block            
          
            e.printStackTrace();        
          } catch (IOException e) {            
           // TODO Auto-generated catch block      
            e.printStackTrace();        
         }

          for (CoupeOrganizer cp:affordList) {
            coupeorganizerMng.saveOrUpdate(cp);
    }
          addActionMessage("导入成功! ");
      return  organizerlist();   //跳转的列表
 }