/*
* Copyright 2016-2021 the original author.All rights reserved.
* Kingstar(honeysoft@126.com)
* The license,see the LICENSE file.
*/
package org.teasoft.exam.justtest;
import java.util.List;
import org.teasoft.bee.osql.SuidRich;
import org.teasoft.beex.poi.ExcelReader;
import org.teasoft.honey.osql.core.BeeFactory;
import org.teasoft.honey.util.SuidHelper;
/**
* @author Kingstar
* @since 1.9
*/
public class ImportExcelTest {
public static void main(String[] args) throws Exception {
String fullPath = "D:\\test.xlsx";
String[] checkTitles = { "序号", "班级", "姓名", "离深时间 ", "目的地", "离深交通工具", "返深时间", "返深交通工具", "家长联系电话" };
List<String[]> list = ExcelReader.checkAndReadExcel(fullPath, checkTitles, 1); //标题在第1行.(从0开始的.)
String fieldNames = "orderno,,name,leftdate,target,vehicle1,comedate,vehicle2,mobileno"; //每列对应的字段名
if (list != null) {
List<LeftszInfo> listLeftszInfo = SuidHelper.parseToEntity(list, 2, list.size() - 2, fieldNames, new LeftszInfo());
SuidRich suidRich = BeeFactory.getHoneyFactory().getSuidRich();
suidRich.insert(listLeftszInfo);
}
}
}
就是如此简单. 还可以检测excel模板是否正常.
读取最简单的就一行代码: List<String[]> list = ExcelReader.readExcel("D:\\test-dataType.xlsx");
1) 定义好期待的列标题,用于检测.
2) 检测通过后,返回excel数据.
3)将excel指定行的数据,导致到DB, 一般要排除标题行. 还可以排除最后的统计行.
这里借助强大的ORM Bee工具,简化了与数据库的操作.
Excel:
最后的统计行,不需要导入.
DB:
源码地址:
https://gitee.com/automvc/bee-exam