首先你得解析excle,再封装实体,赋值对应的字段,存入数据库,类似下面的这个:
public static void readExcel(String filePath){
Products products = new Products();
SqlSession sqlSession = MybatisSqlSessionFactory.getSession();
ProductsMapper productsMapper = sqlSession.getMapper(ProductsMapper.class);
Map<Integer, String> map1 = FileUtil.readfile(filePath, null);
for(int i=0 ; i < map1.size(); i++) {
//获取工作表
Workbook workbook = ExcelUtil.reWorkbook(map1.get(i));
//获取sheet个数
int shNum = ExcelUtil.reExcelSheet(workbook);
for (int num = 0; num < shNum; num++) {
//获取行数
int rowNum = ExcelUtil.reExcelSheetRowNum(workbook, num);
if(rowNum != 0)
{
for (int rnum = 0; rnum <= rowNum; rnum++) {
//获取列数
int cellNum = ExcelUtil.reExcelSheetCellNum(workbook, num, rnum);
if(cellNum != 0)
{
String value = ExcelUtil.reExcelValue(workbook, num, rnum, 0, false);
products.setProductcode(value);
products.setActivestatus("1");
int code = productsMapper.updateByProductCode(products);
sqlSession.commit();
if(code != 0)
{
logger.info("读取Excel的行数为{},更新数据条数为{}",rnum,code);
}
}
}
}
}
logger.info("读取Excel完成");
}
}