Package com.sishuok.es.showcase.excel.entity

Examples of com.sishuok.es.showcase.excel.entity.ExcelData

117
118
119
120
121
122
123
124
125
126
127
128
129
130
     * 如果主键冲突 覆盖，否则新增
     * @param dataList
     */
    public void doBatchSave(final List<ExcelData> dataList) {
        for(ExcelData data : dataList) {
            ExcelData dbData = findOne(data.getId());
            if(dbData == null) {
                getExcelDataRepository().save(data.getId(), data.getContent());
            } else {
                dbData.setContent(data.getContent());
                update(dbData);
            }
        }
    }
View Full Code Here
161
162
163
164
165
166
167
168
169
170
171
172
173
                totalSize++;

                String line = iterator.nextLine();
                String[] dataArray = StringUtils.split(line, separator);

                ExcelData data = new ExcelData();
                data.setId(Long.valueOf(dataArray[0]));
                data.setContent(dataArray[1]);
                dataList.add(data);

                if (totalSize % batchSize == 0) {
                    try {
                        proxy.doBatchSave(dataList);
View Full Code Here
59
60
61
62
63
64
65
66
67
68
69
70
71
        if ("row".equals(name)) {//如果是行开始 清空cell数据 重来
            if (rowNumber == 1) {
                return;
            }
            ExcelData data = new ExcelData();
            data.setId(Double.valueOf(currentCellData.get(0)).longValue());
            data.setContent(currentCellData.get(1));
            dataList.add(data);

            totalSize++;

            if (totalSize % batchSize == 0) {
View Full Code Here
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
                    if(numrec.getRow() == 0) {
                        //第一行 跳过
                        break;
                    } else if(numrec.getColumn() == 0) { //第一列
                        current = new ExcelData();
                        current.setId(Double.valueOf(numrec.getValue()).longValue());
                    } else if(numrec.getColumn() == 1) {//第二列
                        current.setContent(String.valueOf(Double.valueOf(numrec.getValue()).longValue()));
                        add(current);
                    }
                    break;

                } else if(record instanceof LabelSSTRecord) {
                    //解析一个String类型的单元格值（存储在SSTRecord）
                    LabelSSTRecord lrec = (LabelSSTRecord) record;

                    if(lrec.getRow() == 0) {
                        //第一行 跳过
                        break;
                    } else if(lrec.getColumn() == 0) { //第一列
                        current = new ExcelData();
                        String value = sstrec.getString(lrec.getSSTIndex()).getString();
                        current.setId(Double.valueOf(value).longValue());
                    } else if(lrec.getColumn() == 1) {//第二列
                        String value = sstrec.getString(lrec.getSSTIndex()).getString();
                        current.setContent(value);
View Full Code Here
TOP

Related Classes of com.sishuok.es.showcase.excel.entity.ExcelData

  • com.sishuok.es.showcase.excel.service.Excel2003ImportListener
  • com.sishuok.es.showcase.excel.service.Excel2007ImportSheetHandler
  • com.sishuok.es.showcase.excel.service.ExcelDataService
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.