Service层
package com.cbb.service;
import java.util.Map;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.springframework.web.multipart.MultipartFile;
import com.cbb.entity.Card;
/**
* 这是一个关于银行卡的业务处理的接口
*
* @author 陈斌斌
* @Date 2022年5月11日 09点25分
*
*/
public interface CardService {
/**
* 下载报表模板
*
* @param response
*/
void downLoadExport(HttpServletResponse response, HttpServletRequest request);
}
实现类imple
import java.io.IOException;
import java.io.InputStream;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.web.multipart.MultipartFile;
import com.cbb.entity.ImportCard;
import com.cbb.mapper.ImportCardMapper;
import com.cbb.service.ImportCardService;
import com.cbb.util.ExcelUtils;
import lombok.RequiredArgsConstructor;
/**
* 这是一个关于批量导入Excel银行卡信息业务处理的实现类,处理业务逻辑
*
* @author 陈斌斌
* @Date 2022年5月11日 09点25分
*
*/
@Service
@RequiredArgsConstructor(onConstructor = @__(@Autowired))
public class ImportCardServiceImple implements ImportCardService {
/**
* 导入银行卡信息Excel文件,读取里面的数据,遍历为数组进行添加
*
* @param file
* @param request
* @param response
* @return
*/
@Override
public List<List<Object>> uploadExcel(MultipartFile file, HttpServletRequest request,
HttpServletResponse response) {
if (file.isEmpty()) {
try {
throw new Exception("文件不存在!");
} catch (Exception e) {
e.printStackTrace();
}
}
InputStream in = null;
try {
in = file.getInputStream();
} catch (IOException e) {
e.printStackTrace();
}
List<List<Object>> listob = null;
try {
listob = new ExcelUtils().getBankListByExcel(in, file.getOriginalFilename());
} catch (Exception e) {
e.printStackTrace();
}
return listob;
}
}
controller控制层
/**
* 下载报表模板
*
* @param response
*/
@RequestMapping("downLoadExportCard")
public void downLoadExport(HttpServletResponse response, HttpServletRequest request) {
cardService.downLoadExport(response, request);
}