switch-case使用场景实例

示例
获取到不同的key，然后就去创建不同的sheet页面，导入页面不同的数据

    /**
     * 创建写入数据到Sheet
     */
    public void writeSheet()
    {
        int i = 0;
        for (Map.Entry<Integer, List> entry : dataMap.entrySet()) {

            Integer key = entry.getKey();
            switch (key) {
                case 0 :
                    this.clazz = TnMdMaraTemp.class;
                    this.sheetName = "基本视图";
                    createSheet(i, i);
                    i++;
                    break;
                case 1 :
                    this.clazz = TnMdMvkeTemp.class;
                    this.sheetName = "销售视图";
                    createSheet(i, i);
                    i++;
                    break;
                case 2 :
                    this.clazz = TnMdMarcTemp.class;
                    this.sheetName = "工厂视图";
                    createSheet(i, i);
                    i++;
                    break;
                case 3 :
                    this.clazz = TnMdMvkeTemp.class;
                    this.sheetName = "扩充视图-销售视图";
                    createSheet(i, i);
                    i++;
                    break;
                case 4 :
                    this.clazz = TnMdMarcTemp.class;
                    this.sheetName = "扩充视图-工厂视图";
                    createSheet(i, i);
                    i++;
                    break;
                default:
                    break;
            }

            this.list = entry.getValue();
            createExcelField();
            // 产生一行
            Row row = sheet.createRow(rownum);
            int column = 0;
            // 写入各个字段的列头名称
            for (Object[] os : fields)
            {
                Excel excel = (Excel) os[1];
                this.createCell(excel, row, column++);
            }
            if (Type.EXPORT.equals(type))
            {
                fillExcelData(0, row);
                addStatisticsRow();
            }
        }
    }