实现根据传入的数据,生成excel与二维码图片,并压缩在同一目录的zip包下
效果图
实体类1
import lombok.Data;
import java.util.ArrayList;
import java.util.List;
@Data
public class QrCodeArrDto {
private List<DownloadQrCodeDto> qrList = new ArrayList<>();
}
实体类2
@Data
public class DownloadQrCodeDto {
// @ApiModelProperty(value = "下载方式")
// private String sendWays ;
@ApiModelProperty(value = "iccid")
private String iccid ;
@ApiModelProperty(value = "url")
private String url;
}
Controller
@RestController
@RequestMapping("/profileQuery")
public class ProfileQueryController extends BaseController {
@Autowired
private ICardDataService iCardDataService;
@PostMapping("/qrCode")
public void qrCode(HttpServletRequest request,HttpServletResponse response,@RequestBody(required = false) QrCodeArrDto dto) {
iCardDataService.downLoadQrCode(request,response,dto);
}
}
server
public interface ICardDataService {
void downLoadQrCode(HttpServletRequest request, HttpServletResponse response,QrCodeArrDto dto) throws Exception;
}
serverImpl
@Override
public void downLoadQrCode(HttpServletRequest request, HttpServletResponse response, QrCodeArrDto dto) throws Exception{
List<DownloadQrCodeDto> qrList = dto.getQrList();
HSSFWorkbook workbook = OnlyExcelUtil.getNewExcel("qrList", qrList);
OutputStream outputStream = response.getOutputStream();
try {
response.setContentType("application/zip; charset=UTF-8");
//返回客户端浏览器的版本号、类型
String agent = request.getHeader("USER-AGENT");
String downloadName = "QRcodeList.zip";
//针对IE或者以IE为内核的浏览器:
// if (agent.contains("MSIE") || agent.contains("Trident")) {
// downloadName = java.net.URLEncoder.encode(downloadName, "UTF-8");
// } else {
// downloadName = new String(downloadName.getBytes("UTF-8"), "ISO-8859-1");
// }
response.setHeader("Content-disposition", "attachment;filename=" + downloadName);
ZipOutputStream zipOutputStream = new ZipOutputStream(outputStream);
//多个从这里就可遍历了
// --start
//生成excel文件
ZipEntry entry = new ZipEntry("QRcodeList\\LPAList.xls");
zipOutputStream.putNextEntry(entry);
ByteArrayOutputStream byteOutputStream = new ByteArrayOutputStream ();
workbook.write(byteOutputStream);
byteOutputStream.writeTo(zipOutputStream);
// zipOutputStream.write(workbook.getBytes());
workbook.close();
for (int i = 0; i < qrList.size(); i++) {
//二维码
BufferedImage image = QRCodeUtil.generateQrCodeBack(qrList.get(i).getUrl());
ZipEntry zipEntry = new ZipEntry("QRcodeList\\"+qrList.get(i).getIccid()+".png");
zipOutputStream.putNextEntry(zipEntry);
zipOutputStream.write(QRCodeUtils.imageToBytes(image));
byteOutputStream.write(QRCodeUtils.imageToBytes(image));
}
zipOutputStream.closeEntry();
// --end
zipOutputStream.close();
byteOutputStream.close();
} catch (IOException e) {
e.printStackTrace();
}
}
QRCodeUtil
import com.google.zxing.*;
import com.google.zxing.client.j2se.BufferedImageLuminanceSource;
import com.google.zxing.common.BitMatrix;
import com.google.zxing.common.HybridBinarizer;
import com.google.zxing.qrcode.decoder.ErrorCorrectionLevel;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import java.awt.BasicStroke;
import java.awt.Graphics;
import java.awt.Graphics2D;
import java.awt.Image;
import java.awt.Shape;
import java.awt.geom.RoundRectangle2D;
import java.awt.image.BufferedImage;
import java.io.File;
import java.io.OutputStream;
import java.util.Hashtable;
import java.util.Random;
import javax.imageio.ImageIO;
/**
* 二维码工具类
*
*/
@Data
public class QRCodeUtil {
private static final String PATH_IMG = "/Users/guobaohua";
private static final String CHARSET = "utf-8";
private static final String FORMAT = "JPG";
// 二维码尺寸
private static final int QRCODE_SIZE = 300;
// LOGO宽度
private static final int LOGO_WIDTH = 60;
// LOGO高度
private static final int LOGO_HEIGHT = 60;
public static BufferedImage createImage(String content, String logoPath, boolean needCompress) throws Exception {
Hashtable<EncodeHintType, Object> hints = new Hashtable<EncodeHintType, Object>();
hints.put(EncodeHintType.ERROR_CORRECTION, ErrorCorrectionLevel.H);
hints.put(EncodeHintType.CHARACTER_SET, CHARSET);
hints.put(EncodeHintType.MARGIN, 1);
BitMatrix bitMatrix = new MultiFormatWriter().encode(content, BarcodeFormat.QR_CODE, QRCODE_SIZE, QRCODE_SIZE,
hints);
int width = bitMatrix.getWidth();
int height = bitMatrix.getHeight();
BufferedImage image = new BufferedImage(width, height, BufferedImage.TYPE_INT_RGB);
for (int x = 0; x < width; x++) {
for (int y = 0; y < height; y++) {
image.setRGB(x, y, bitMatrix.get(x, y) ? 0xFF000000 : 0xFFFFFFFF);
}
}
if (logoPath == null || "".equals(logoPath)) {
return image;
}
// 插入图片
QRCodeUtil.insertImage(image, logoPath, needCompress);
return image;
}
/**
* 插入LOGO
*
* @param source
* 二维码图片
* @param logoPath
* LOGO图片地址
* @param needCompress
* 是否压缩
* @throws Exception
*/
private static void insertImage(BufferedImage source, String logoPath, boolean needCompress) throws Exception {
File file = new File(logoPath);
if (!file.exists()) {
throw new Exception("logo file not found.");
}
Image src = ImageIO.read(new File(logoPath));
int width = src.getWidth(null);
int height = src.getHeight(null);
if (needCompress) { // 压缩LOGO
if (width > LOGO_WIDTH) {
width = LOGO_WIDTH;
}
if (height > LOGO_HEIGHT) {
height = LOGO_HEIGHT;
}
Image image = src.getScaledInstance(width, height, Image.SCALE_SMOOTH);
BufferedImage tag = new BufferedImage(width, height, BufferedImage.TYPE_INT_RGB);
Graphics g = tag.getGraphics();
g.drawImage(image, 0, 0, null); // 绘制缩小后的图
g.dispose();
src = image;
}
// 插入LOGO
Graphics2D graph = source.createGraphics();
int x = (QRCODE_SIZE - width) / 2;
int y = (QRCODE_SIZE - height) / 2;
graph.drawImage(src, x, y, width, height, null);
Shape shape = new RoundRectangle2D.Float(x, y, width, width, 6, 6);
graph.setStroke(new BasicStroke(3f));
graph.draw(shape);
graph.dispose();
}
/**
* 生成二维码(内嵌LOGO)
* 二维码文件名随机,文件名可能会有重复
*
* @param content
* 内容
* @param logoPath
* LOGO地址
* @param destPath
* 存放目录
* @param needCompress
* 是否压缩LOGO
* @throws Exception
*/
public static String encode(String content, String logoPath, String destPath, boolean needCompress) throws Exception {
BufferedImage image = QRCodeUtil.createImage(content, logoPath, needCompress);
mkdirs(destPath);
String fileName = new Random().nextInt(99999999) + "." + FORMAT.toLowerCase();
ImageIO.write(image, FORMAT, new File(destPath + "/" + fileName));
return fileName;
}
/**
* 生成二维码(内嵌LOGO)
* 调用者指定二维码文件名
*
* @param content
* 内容
* @param logoPath
* LOGO地址
* @param destPath
* 存放目录
* @param fileName
* 二维码文件名
* @param needCompress
* 是否压缩LOGO
* @throws Exception
*/
public static String encode(String content, String logoPath, String destPath, String fileName, boolean needCompress) throws Exception {
BufferedImage image = QRCodeUtil.createImage(content, logoPath, needCompress);
mkdirs(destPath);
fileName = fileName.substring(0, fileName.indexOf(".")>0?fileName.indexOf("."):fileName.length())
+ "." + FORMAT.toLowerCase();
ImageIO.write(image, FORMAT, new File(destPath + "/" + fileName));
return fileName;
}
/**
* 当文件夹不存在时,mkdirs会自动创建多层目录,区别于mkdir.
* (mkdir如果父目录不存在则会抛出异常)
* @param destPath
* 存放目录
*/
public static void mkdirs(String destPath) {
File file = new File(destPath);
if (!file.exists() && !file.isDirectory()) {
file.mkdirs();
}
}
/**
* 生成二维码(内嵌LOGO)
*
* @param content
* 内容
* @param logoPath
* LOGO地址
* @param destPath
* 存储地址
* @throws Exception
*/
public static String encode(String content, String logoPath, String destPath) throws Exception {
return QRCodeUtil.encode(content, logoPath, destPath, false);
}
/**
* 生成二维码
*
* @param content
* 内容
* @param destPath
* 存储地址
* @param needCompress
* 是否压缩LOGO
* @throws Exception
*/
public static String encode(String content, String destPath, boolean needCompress) throws Exception {
return QRCodeUtil.encode(content, null, destPath, needCompress);
}
/**
* 生成二维码
*
* @param content
* 内容
* @param destPath
* 存储地址
* @throws Exception
*/
public static String encode(String content, String destPath) throws Exception {
return QRCodeUtil.encode(content, null, destPath, false);
}
/**
* 生成二维码
*
* @param content
* 内容
* @throws Exception
*/
public static String encode(String content) throws Exception {
return QRCodeUtil.encode(content, null,PATH_IMG ,false);
}
/**
* 生成二维码(内嵌LOGO)
*
* @param content
* 内容
* @param logoPath
* LOGO地址
* @param output
* 输出流
* @param needCompress
* 是否压缩LOGO
* @throws Exception
*/
public static void encode(String content, String logoPath, OutputStream output, boolean needCompress)
throws Exception {
BufferedImage image = QRCodeUtil.createImage(content, logoPath, needCompress);
ImageIO.write(image, FORMAT, output);
}
/**
* 生成二维码
*
* @param content
* 内容
* @param output
* 输出流
* @throws Exception
*/
public static void encode(String content, OutputStream output) throws Exception {
QRCodeUtil.encode(content, null, output, false);
}
/**
* 解析二维码
*
* @param file
* 二维码图片
* @return
* @throws Exception
*/
public static String decode(File file) throws Exception {
BufferedImage image;
image = ImageIO.read(file);
if (image == null) {
return null;
}
BufferedImageLuminanceSource source = new BufferedImageLuminanceSource(image);
BinaryBitmap bitmap = new BinaryBitmap(new HybridBinarizer(source));
Result result;
Hashtable<DecodeHintType, Object> hints = new Hashtable<DecodeHintType, Object>();
hints.put(DecodeHintType.CHARACTER_SET, CHARSET);
result = new MultiFormatReader().decode(bitmap, hints);
String resultStr = result.getText();
return resultStr;
}
/**
* 解析二维码
*
* @param path
* 二维码图片地址
* @return
* @throws Exception
*/
public static String decode(String path) throws Exception {
return QRCodeUtil.decode(new File(path));
}
// public static void main(String[] args) throws Exception {
// String text = "http://www.baidu.com";
// //不含Logo
// //QRCodeUtil.encode(text, null, "e:\\", true);
// //含Logo,不指定二维码图片名
// //QRCodeUtil.encode(text, "e:\\csdn.jpg", "e:\\", true);
// //含Logo,指定二维码图片名
// QRCodeUtil.encode(text, "e:\\csdn.jpg", "e:\\", "qrcode", true);
//
// String decode = QRCodeUtil.decode("e:\\qrcode.jpg");
// System.out.println(decode);
// }
}
OnlyExcelUtil
import com.links.dppo.core.domain.DownloadQrCodeDto;
import org.apache.poi.hssf.usermodel.*;
import org.apache.poi.ss.util.CellRangeAddress;
import java.util.List;
public class OnlyExcelUtil {
public static HSSFWorkbook getNewExcel(String formName, List<DownloadQrCodeDto> fields) {
//新建excel对象
HSSFWorkbook workbook = new HSSFWorkbook();
//新建工作表
HSSFSheet sheet = workbook.createSheet();
// 设置表格默认列宽度为20个字节
sheet.setDefaultColumnWidth((short) 20);
// 生成一个样式
HSSFCellStyle style = workbook.createCellStyle();
// 生成一个字体
HSSFFont font = workbook.createFont();
font.setFontHeightInPoints((short) 12);
//字体应用到当前样式
style.setFont(font);
//创建表格行
HSSFRow row = sheet.createRow(0);
row.createCell(0).setCellValue("iccid");
row.createCell(1).setCellValue("LPA");
// HSSFRow row1 = sheet.createRow(sheet.getLastRowNum() + 1);
//设置列标题行
for (int i = 0; i < fields.size(); i++) {
HSSFRow row1 = sheet.createRow(i + 1);
row1.createCell(0).setCellValue(fields.get(i).getIccid());
row1.createCell(1).setCellValue(fields.get(i).getUrl());
}
return workbook;
}
}