package nc.xyzq.uuib.bean;   
 
/**  
 * ClassName:UserRoleBean 
 * @author   lizm   
 * @since    JDK 1.6  
 *        
 */ 
public class UserRoleBean { 
     
    private String userCode ; 
    private String roleid; 
    private String isflag; 
     
    public String getUserCode() { 
        return userCode; 
    } 
    public void setUserCode(String userCode) { 
        this.userCode = userCode; 
    } 
    public String getRoleid() { 
        return roleid; 
    } 
    public void setRoleid(String roleid) { 
        this.roleid = roleid; 
    } 
    public String getIsflag() { 
        return isflag; 
    } 
    public void setIsflag(String isflag) { 
        this.isflag = isflag; 
    } 
     
} 
 

package nc.xyzq.client; 
 
import java.io.File; 
import java.io.FileInputStream; 
import java.util.ArrayList; 
import java.util.List; 
import java.util.logging.Logger; 
 
import nc.xyzq.pub.Pub; 
import nc.xyzq.uuib.service.impl.UserRoleBean; 
import org.apache.poi.hssf.usermodel.HSSFWorkbook; 
import org.apache.poi.ss.usermodel.Cell; 
import org.apache.poi.ss.usermodel.Row; 
import org.apache.poi.ss.usermodel.Sheet; 
import org.apache.poi.ss.usermodel.Workbook; 
import org.apache.poi.xssf.usermodel.XSSFWorkbook; 
 
 
/**  
 * ClassName:Client  
 * Function: TODO 
 * Reason:   TODO  
 * Date:     2018年11月20日 下午15:59:31  
 * @author   lizm   
 * @since    JDK 1.6  
 *        
 */ 
public class Client { 
     
    private static final Logger logger = (Logger) Logger.getLogger(Client.class.getName()); 
     
    private List<UserRoleBean> getInfoFromExcle(){ 
        List<UserRoleBean> list = new ArrayList(); 
        //excel文件路径 
        String excelPath = Pub.getPropertiesValue("relationship", "path");//读取配置文件，例如 D://data/relationship.xls 
        try { 
            //String encoding = "GBK"; 
            File excel = new File(excelPath); 
            if (excel.isFile() && excel.exists()) {   //判断文件是否存在 
                String[] split = excel.getName().split("//.");  //.是特殊字符，需要转义！！！！！ 
                Workbook wb; 
                //根据文件后缀（xls/xlsx）进行判断 
                if ( "xls".equals(split[1])){ 
                    FileInputStream fis = new FileInputStream(excel);   //文件流对象 
                    wb = new HSSFWorkbook(fis); 
                } 
                /** 
                else if ("xlsx".equals(split[1])){ 
                    FileInputStream  fis = new FileInputStream(excel);   
                    wb = new XSSFWorkbook(fis); 
                } 
                */ 
                else { 
                    //System.out.println("文件类型错误!"); 
                    logger.info("文件类型错误!"); 
                    return list; 
                } 
 
                //开始解析 
                Sheet sheet = wb.getSheetAt(0);     //读取sheet 0 
                int firstRowIndex = sheet.getFirstRowNum()+1;   //第一行是列名，所以不读 
                int lastRowIndex = sheet.getLastRowNum(); 
                //System.out.println("firstRowIndex: "+firstRowIndex); 
                logger.info("firstRowIndex: "+firstRowIndex); 
                //System.out.println("lastRowIndex: "+lastRowIndex); 
                logger.info("lastRowIndex: "+lastRowIndex); 
                //System.out.println("执行进行中......"); 
                logger.info("执行进行中......"); 
                 
                //遍历行 
                for(int rIndex = firstRowIndex; rIndex <= lastRowIndex; rIndex++) {    
                    //System.out.println("rIndex: " + rIndex); 
                    Row row = sheet.getRow(rIndex); 
                    if (row != null) { 
                        //行中第一个值所在的列序号 
                        int firstCellIndex = row.getFirstCellNum(); 
                        //行中最后一个值所在的列序号 
                        int lastCellIndex = row.getLastCellNum(); 
                        UserRoleBean userRoleBean = new UserRoleBean(); 
                        //遍历列 
                        //for (int cIndex = firstCellIndex; cIndex < lastCellIndex; cIndex++) {  
                        for (int cIndex = 0; cIndex < 3; cIndex++) { 
                            Cell cell = row.getCell(cIndex); 
                            if (cell != null) { 
                                //将表格内容强制转换为字符型 
                                cell.setCellType(Cell.CELL_TYPE_STRING); 
                                //System.out.println(cell.toString()); 
                                if(cIndex == 0){ 
                                    userRoleBean.setUserCode(cell.toString()); 
                                }else if(cIndex == 1){ 
                                    userRoleBean.setRoleid(cell.toString()); 
                                }else if(cIndex == 2){ 
                                    userRoleBean.setIsflag(cell.toString()); 
                                } 
                            } 
                        } 
                        if(!("".equals(userRoleBean.getUserCode())) && !("".equals(userRoleBean.getRoleid()))){ 
                            //System.out.println(">>>0000000>>:"+userRoleBean.getRoleid()); 
                            list.add(userRoleBean); 
                        } 
                    } 
                } 
            } else { 
                //System.out.println("找不到指定的文件"); 
                logger.info("找不到指定的文件"); 
            } 
        } catch (Exception e) { 
            e.printStackTrace(); 
        } 
        return list; 
    } 
     
    public static void main(String[] args) { 
        List<UserRoleBean> list = new ArrayList(); 
        Client client = new Client(); 
        list = client.getInfoFromExcle(); 
    } 
}