接了個(gè)變態(tài)需求:生成 Excel + PDF 導(dǎo)出,用 Java 怎么實(shí)現(xiàn)?
點(diǎn)擊關(guān)注公眾號(hào)，Java干貨 及時(shí)送達(dá) ??
來源：cnblogs.com/Tom-shushu/p/14279357.html
- 一、序言
-
二、Java實(shí)現(xiàn)PDF的生成和數(shù)據(jù)動(dòng)態(tài)插入、導(dǎo)出功能
- 1、第一步：PDF制作模板
- 2、代碼的編寫（假定我們實(shí)體類什么的都已經(jīng)編寫完成、數(shù)據(jù)通過前端傳入獲取、模板位置在E盤根目錄下名字為：車輛維修審批單.pdf）
- 3.測(cè)試
-
二、Java實(shí)現(xiàn)Excel生成和數(shù)據(jù)插入、導(dǎo)出
- 1.表頭對(duì)應(yīng)實(shí)體類ExportYqfkdj.java：
- b.Service層
- c.Controller層
- d.測(cè)試
一、序言
Excel、PDF的導(dǎo)出、導(dǎo)入是我們工作中經(jīng)常遇到的一個(gè)問題，剛好今天公司業(yè)務(wù)遇到了這個(gè)問題，順便記個(gè)筆記以防下次遇到相同的問題而束手無策。
公司有這么兩個(gè)需求：
需求一、給了一個(gè)表單，讓把查出來的數(shù)據(jù)組裝到表單中并且提供以PDF格式的下載功能。
需求二、將數(shù)據(jù)查出來以Excel表格的形式下載下來。
二、Java實(shí)現(xiàn)PDF的生成和數(shù)據(jù)動(dòng)態(tài)插入、導(dǎo)出功能
1、第一步：PDF制作模板
因?yàn)镻DF常用的軟件不讓支持編輯，我們就先使用WPS以Word的形式進(jìn)行編輯制作出與客戶需求一樣的樣式，然后直接另存為 .pdf 的形式如下圖所示：
a.Word里面制作模板
b.更改名字為 .pdf形式
c.這時(shí)需要用到一個(gè)叫：Adobe Acrobat DC的軟件（可以白嫖7天^_^），具體操作如下：
用Adobe Acrobat DC打開我們剛才改過名字的PDF文件，點(diǎn)擊右下角的“更多工具”按鈕
到下面這個(gè)頁面再點(diǎn)擊“準(zhǔn)備表單”按鈕
d.接下來就需要詳細(xì)的配置你的數(shù)據(jù)源了
數(shù)據(jù)源即：你代碼中實(shí)體類中對(duì)應(yīng)的數(shù)據(jù)（注意字段一定要一一對(duì)應(yīng)），配置完畢就可以保存進(jìn)行下面的代碼編寫工作了。
2、代碼的編寫（假定我們實(shí)體類什么的都已經(jīng)編寫完成、數(shù)據(jù)通過前端傳入獲取、模板位置在E盤根目錄下名字為：車輛維修審批單.pdf）
導(dǎo)入jar包：
<!--?PDF導(dǎo)出-->
<!--?https://mvnrepository.com/artifact/com.itextpdf/itextpdf?-->
<dependency>
????<groupId>com.itextpdf</groupId>
????<artifactId>itextpdf</artifactId>
????<version>5.5.13</version>
</dependency>
實(shí)現(xiàn)生成PDF、數(shù)據(jù)插入、導(dǎo)出
????????@RegisterToSMP(serviceDisplay?=?"預(yù)覽頁面PDF下載")
????????@RequestMapping(value?=?"/DM/gwclwxsq/qygl/exportPDF$m=query.service",method?=RequestMethod.POST)
????????public?String?exportPdf(@RequestBody?GwclwxsqBean?gwclwxsqBean?,?HttpServletResponse?response)?throws?UnsupportedEncodingException?{
????????????//?1.指定解析器
????????????System.setProperty("javax.xml.parsers.DocumentBuilderFactory",
????????????????????"com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderFactoryImpl");
????????????String?filename="車輛維修審批單.pdf";
????????????String?path="e:/";
????????????response.setContentType("application/pdf");
????????????response.setHeader("Content-Disposition",?"attachment;fileName="
????????????????????+?URLEncoder.encode(filename,?"UTF-8"));
????????????OutputStream?os?=?null;
????????????PdfStamper?ps?=?null;
????????????PdfReader?reader?=?null;
????????????try?{
????????????????os?=?response.getOutputStream();
????????????????//?2?讀入pdf表單
????????????????reader?=?new?PdfReader(path+?"/"+filename);
????????????????//?3?根據(jù)表單生成一個(gè)新的pdf
????????????????ps?=?new?PdfStamper(reader,?os);
????????????????//?4?獲取pdf表單
????????????????AcroFields?form?=?ps.getAcroFields();
????????????????// 5給表單添加中文字體?這里采用系統(tǒng)字體。不設(shè)置的話，中文可能無法顯示
????????????????BaseFont?bf?=?BaseFont.createFont("C:/WINDOWS/Fonts/SIMSUN.TTC,1",
??????????????????????????????BaseFont.IDENTITY_H,?BaseFont.EMBEDDED);
????????????????form.addSubstitutionFont(bf);
????????????????//?6查詢數(shù)據(jù)================================================
????????????????Map<String,?String>?data?=?new?HashMap<String,?String>();
??????????????????????data.put("commitTime",?gwclwxsqBean.getCommitTime());
??????????????????????data.put("driver",?gwclwxsqBean.getDriver());
??????????????????????data.put("carId",?gwclwxsqBean.getCarId());
??????????????????????data.put("carType",?gwclwxsqBean.getCarType());
??????????????????????data.put("repairAddress",?gwclwxsqBean.getRepairAddress());
??????????????????????data.put("repairCost",gwclwxsqBean.getRepairCost());
??????????????????????data.put("project",?gwclwxsqBean.getProject());
??????????????????????data.put("fwbzzxfzrYj",?gwclwxsqBean.getFwbzzxfzrYj());
??????????????????????data.put("fgldspYj",?gwclwxsqBean.getFgldspYj());
??????????????????????data.put("remarks",?gwclwxsqBean.getRemarks());
?????????????????//?7遍歷data?給pdf表單表格賦值
????????????????for?(String?key?:?data.keySet())?{
????????????????????form.setField(key,data.get(key).toString());
????????????????}
????????????????ps.setFormFlattening(true);
????????????????log.info("*******************PDF導(dǎo)出成功***********************");
????????????}?catch?(Exception?e)?{
??????????log.error("*******************PDF導(dǎo)出失敗***********************");
????????????????e.printStackTrace();
????????????}?finally?{
????????????????try?{
????????????????????ps.close();
????????????????????reader.close();
????????????????????os.close();
????????????????}?catch?(Exception?e)?{
????????????????????e.printStackTrace();
????????????????}
????????????}
????????????return?null;
????????}
3.測(cè)試
二、Java實(shí)現(xiàn)Excel生成和數(shù)據(jù)插入、導(dǎo)出
這個(gè)比較簡(jiǎn)單，直接上代碼（假定你的實(shí)體類、查詢什么的都已經(jīng)寫好）注意：實(shí)體類一個(gè)是你自己的數(shù)據(jù)實(shí)體類還有一個(gè)是你導(dǎo)出時(shí)表格中對(duì)應(yīng)的實(shí)體類
我們以一個(gè)真實(shí)的公司業(yè)務(wù)來舉個(gè)例子（一個(gè)統(tǒng)計(jì)疫情登記人員信息的Excel導(dǎo)出功能）
1.表頭對(duì)應(yīng)實(shí)體類ExportYqfkdj.java：
import?lombok.Data;
/**
?*?description:
?*?@author:?zhouhong
?*?@version:?V1.0.0
?*?@date:?2021年1月14日?下午3:05:54
?*/
@Data
public?class?ExportYqfkdj?{
????/**
?????*?序號(hào)
?????*/
????private?Integer?xuhao;
????/**
?????*?姓名
?????*/
????private?String?xingming;
????/**
?????*?證件號(hào)碼
?????*/
????private?String?zjhm;
????/**
?????*?聯(lián)系電話
?????*/
????private?String?lxdh;
????/**
?????*?申請(qǐng)人工作單位
?????*/
????private?String?sqrGzdw;
????/**
?????*?是否接觸過疑似病例
?????*/
????private?String?sfjcgysbl;
????/**
?????*?當(dāng)前是否與居家隔離人員同住
?????*/
????private?String?sfyjjglrytz;
????/**
?????*?當(dāng)前狀態(tài)
?????*/
????private?String?dqzt;
????/**
?????*?當(dāng)前健康狀態(tài)
?????*/
????private?String?dqjkzt;
????/**
?????*?當(dāng)前體溫
?????*/
????private?String?dqtw;
????/**
?????*?當(dāng)前所在地址
?????*/
????private?String?dqszdz;
????/**
?????*?當(dāng)前居住地址
?????*/
????private?String?dqjzdz;
????/**
?????*?提交時(shí)間
?????*?*/
????private?String?tjsj;
}
b.Service層
????/**
?????*?導(dǎo)出
?????*?@param?yqfkdjBean
?????*?@author?zhouhong
?????*?@return
?????*?@throws?Exception
?????*/
????@Transactional(rollbackFor?=?{?Exception.class?})
????public?DataResult?exporYqfkdj(YqfkdjBean?yqfkdjBean)?throws?Exception?{
????????DataResult?result?=?new?DataResult();
????????List<ExportYqfkdj>?list?=?new?ArrayList<ExportYqfkdj>();
????????try?{
????????????/*?查詢導(dǎo)出信息?*/
????????????result?=?getYqfkMhCXQuery(yqfkdjBean);
????????????SimpleDateFormat?df?=?new?SimpleDateFormat("yyyyMMddhhmmssSSS");
????????????for?(int?i?=?0;?i?<?result.getTotalcount();?i++)?{
????????????????ExportYqfkdj?dmKhfwdcDtjlZxDto?=?new?ExportYqfkdj();
????????????????dmKhfwdcDtjlZxDto?=?ObjectUtil.parsePojo(result.getResults().get(i),?ExportYqfkdj.class);
????????????????dmKhfwdcDtjlZxDto.setXuhao(i?+?1);
????????????????list.add(dmKhfwdcDtjlZxDto);
????????????}
????????????String?filepath?=?"D:/疫情防控信息"?+?df.format(new?Date())?+?".xlsx";
????????????if?(System.getProperty(YqfkdjUtils.Wjdz.NAME).toLowerCase().startsWith(YqfkdjUtils.Wjdz.LI)
????????????????????||?System.getProperty(YqfkdjUtils.Wjdz.NAME).toLowerCase().startsWith(YqfkdjUtils.Wjdz.LIN))?{
????????????????filepath?=?"/home/Tomcat/temp/"?+?df.format(new?Date())?+?".xlsx";
????????????}
????????????EasyExcel.write(filepath,?ExportYqfkdj.class).head(head()).sheet().doWrite(list);
????????????result.setResults(list);
????????????result.setSuccess(true);
????????????result.setMsg(filepath);
????????}?catch?(Exception?e)?{
????????????result.setSuccess(false);
????????????result.setMsg(YqfkdjUtils.Cytx.DCSB);
????????????e.printStackTrace();
????????????throw?e;
????????}
????????return?result;
????}
????/**
?????*?疫情防控信息導(dǎo)出表頭
?????*?@author?zhouhong
?????*?@return?List<List<String>>
?????*/
????private?List<List<String>>?head()?{
????????List<List<String>>?list?=?new?ArrayList<List<String>>();
????????List<String>?head0?=?new?ArrayList<String>();
????????head0.add("序號(hào)");
????????List<String>?head1?=?new?ArrayList<String>();
????????head1.add("姓名");
????????List<String>?head2?=?new?ArrayList<String>();
????????head2.add("證件號(hào)碼");
????????List<String>?head3?=?new?ArrayList<String>();
????????head3.add("聯(lián)系電話");
????????List<String>?head4?=?new?ArrayList<String>();
????????head4.add("工作所在單位");
????????List<String>?head5?=?new?ArrayList<String>();
????????head5.add("是否接觸疑似病例");
????????List<String>?head6?=?new?ArrayList<String>();
????????head6.add("是否與隔離人員同住");
????????List<String>?head7?=?new?ArrayList<String>();
????????head7.add("當(dāng)前狀態(tài)");
????????List<String>?head8?=?new?ArrayList<String>();
????????head8.add("當(dāng)前健康狀態(tài)");
????????List<String>?head9?=?new?ArrayList<String>();
????????head9.add("體溫(°C)");
????????List<String>?head10?=?new?ArrayList<String>();
????????head10.add("當(dāng)前所在地址");
????????List<String>?head11?=?new?ArrayList<String>();
????????head11.add("當(dāng)前居住地址");
????????List<String>?head12?=?new?ArrayList<String>();
????????head12.add("提交時(shí)間");
????????list.add(head0);
????????list.add(head1);
????????list.add(head2);
????????list.add(head3);
????????list.add(head4);
????????list.add(head5);
????????list.add(head6);
????????list.add(head7);
????????list.add(head8);
????????list.add(head9);
????????list.add(head10);
????????list.add(head11);
????????list.add(head12);
????????return?list;
????}
c.Controller層
????@RegisterToSMP(serviceDisplay?=?"疫情防控查詢導(dǎo)出")
????@RequestMapping(value?=?"/DM/yqfkdj/gr/yqfkdjdc$m=export.service",?method?=?RequestMethod.POST)
????public?void?exportKhfxxx(@RequestBody?YqfkdjBean?yqfkdjBean,?HttpServletResponse?resp)?throws?Exception?{
????????DataResult?result?=?new?DataResult();
????????try?{
????????????SimpleDateFormat?df?=?new?SimpleDateFormat("yyyyMMddhhmmssSSS");
????????????result?=?yqfkdjService.exporYqfkdj(yqfkdjBean);
????????????String?filepath?=?result.getMsg().replace("\"",?"");
????????????File?file?=?new?File(filepath);
????????????String?filename?=?"疫情防控信息"?+?df.format(new?Date())?+?".xlsx";
????????????InputStream?fis?=?new?BufferedInputStream(new?FileInputStream(filepath));
????????????byte[]?buffer?=?new?byte[fis.available()];
????????????fis.read(buffer);
????????????fis.close();
????????????resp.reset();
????????????resp.setHeader("Content-Disposition",
????????????????????"attachment;filename="?+?new?String(filename.replaceAll("?",?"").getBytes("gbk")));
????????????resp.setHeader("Content-Length",?""?+?file.length());
????????????OutputStream?os?=?new?BufferedOutputStream(resp.getOutputStream());
????????????resp.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
????????????//?輸出文件
????????????os.write(buffer);
????????????os.flush();
????????????os.close();
????????}?catch?(Exception?e)?{
????????????e.printStackTrace();
????????????log.info(YqfkdjUtils.Cytx.DCSB);
????????????throw?e;
????????}
????}
d.測(cè)試
已經(jīng)全部完成PDF和Excel的生成、插入、導(dǎo)出功能。
1.?面試官: 美團(tuán)外賣的分庫分表怎么設(shè)計(jì)？
2.?魔改xxl-job，徹底告別手動(dòng)配置任務(wù)！
3.?架構(gòu)師如何高效的學(xué)習(xí)技術(shù)？
最近面試BAT，整理一份面試資料 《Java面試BATJ通關(guān)手冊(cè)》 ，覆蓋了Java核心技術(shù)、JVM、Java并發(fā)、SSM、微服務(wù)、數(shù)據(jù)庫、數(shù)據(jù)結(jié)構(gòu)等等。
獲取方式：點(diǎn)“ 在看 ”，關(guān)注公眾號(hào)并回復(fù)? Java ?領(lǐng)取，更多內(nèi)容陸續(xù)奉上。
PS：因公眾號(hào)平臺(tái)更改了推送規(guī)則，如果不想錯(cuò)過內(nèi)容，記得讀完點(diǎn)一下 “在看” ，加個(gè) “星標(biāo)” ，這樣每次新文章推送才會(huì)第一時(shí)間出現(xiàn)在你的訂閱列表里。
點(diǎn)“在看”支持小哈呀，謝謝啦
評(píng)論
圖片
表情