pom.xmlo依赖:
<!--POI Excel表格导出依赖-->
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>3.17</version>
</dependency>
<!-- 导出PDF使用 -->
<dependency>
<groupId>com.itextpdf</groupId>
<artifactId>itext-asian</artifactId>
<version>5.2.0</version>
</dependency>
<dependency>
<groupId>com.itextpdf</groupId>
<artifactId>itextpdf</artifactId>
<version>5.4.3</version>
</dependency>
因项目原因就不展示效果图了,可自己添加静态数据查看,直接上代码,根据自己需求修改:
import com.itextpdf.text.*;
import com.itextpdf.text.Font;
import com.itextpdf.text.pdf.BaseFont;
import com.itextpdf.text.pdf.PdfPCell;
import com.itextpdf.text.pdf.PdfPTable;
import com.itextpdf.text.pdf.PdfWriter;
import com.open.capacity.common.code.C00;
import com.open.capacity.common.envm.cate.ProjDossierAuthCate;
import com.open.capacity.common.envm.status.MarkStatus;
import com.open.capacity.common.envm.status.ProjDossierAuthorityStatus;
import com.open.capacity.common.envm.status.ProjDossierStatus;
import com.open.capacity.common.envm.status.ProjStatus;
import com.open.capacity.common.exception.controller.ControllerException;
import com.open.capacity.common.exception.service.ServiceException;
import com.open.capacity.common.util.SysUserUtil;
import com.open.capacity.common.web.Result;
import com.open.capacity.project.dao.*;
import com.open.capacity.project.entity.*;
import com.open.capacity.project.feign.ProjFileFeignClient;
import com.open.capacity.project.service.ProjDossierService;
import com.open.capacity.project.util.ProjDataOpLogUtil;
import com.open.capacity.project.util.ProjDataStageLogUtil;
import com.open.capacity.project.util.ZipUtils;
import org.apache.commons.lang3.StringUtils;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.*;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.open.capacity.common.web.PageResult;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import java.io.File;
import java.io.OutputStream;
import java.net.URLEncoder;
import java.sql.Timestamp;
import java.text.SimpleDateFormat;
import java.util.*;
import java.util.List;
import org.apache.commons.collections4.MapUtils;
import org.springframework.transaction.annotation.Propagation;
import org.springframework.transaction.annotation.Transactional;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
@Service
public class ProjDossierServiceImpl implements ProjDossierService {
/**
* 导出档案明细表(pdf)
*
* @param projDataId 项目id
* @param request request
* @param response response
* @return :
* @author : hjk
*/
@Override
public Result dossierInfoImportExcel(Long projDataId, HttpServletRequest request, HttpServletResponse response) {
try {
//其他查询逻辑
//其他查询逻辑
ProjDossierDTO projDossierDTO = projDossierDao.detail(projDataId, ProjDossierStatus.CANCEL.getCode());
if ( projDossierDTO == null){
projDossierDTO = projDossierDao.detailByState(projDataId, ProjDossierStatus.CANCEL.getCode());
if (projDossierDTO == null){
//没有数据的时候返回新对象 - add by gcj 2020-11-16
projDossierDTO = new ProjDossierDTO();
projDossierDTO.setProjDataId( projDataId == null ? null : projDataId.intValue() );
//return Result.failedWith(id, C00.C0003.getCode(),"暂无数据");
} else {
projDossierDTO.setDossierName(null);
projDossierDTO.setTopicCode(null);
}
}
projDossierDTO.setArchive(false);
if (projDossierDTO.getState() != null){
if (projDossierDTO.getState().equals(ProjDossierStatus.YGD.getCode())){
projDossierDTO.setArchive(true);
}
}
String dossierCate = projDossierDao.getDossierCate(projDossierDTO.getDossierCate(), 43);
if (StringUtils.isNotBlank(dossierCate)){
projDossierDTO.setDossierCateName(dossierCate);
}
if (StringUtils.isBlank(projDossierDTO.getDossierName())){
String projName = projDossierDao.getProjName(projDossierDTO.getProjDataId());
projDossierDTO.setProjName(projName);
projDossierDTO.setDossierName(projName);
}
//直接下载,不预览
response.setHeader("Content-Disposition", "attachment; filename="+new String( ("档案卷内明细目录表" + ".pdf").getBytes(),
"iso-8859-1"));
//将数据以流的形式传到浏览器下载
OutputStream os = response.getOutputStream();
//先预先,再选择存放路径
// response.setContentType("application/pdf");
// response.setContentType("application/octet-stream");
// 第一步,创建document对象
Document document = new Document(PageSize.A4.rotate());
PdfWriter.getInstance(document, os);
BaseFont bfChinese = BaseFont.createFont("STSong-Light", "UniGB-UCS2-H", false);
Font FontChinese12 = new Font(bfChinese, 12, Font.NORMAL);
Font FontChinese12Red = new Font(bfChinese, 12, Font.NORMAL, BaseColor.RED);
Font FontChinese12Blue = new Font(bfChinese, 12, Font.NORMAL, BaseColor.BLUE);
Rectangle rectPageSize = new Rectangle(PageSize.A4);