{"id":162899,"date":"2020-10-02T09:45:43","date_gmt":"2020-10-02T01:45:43","guid":{"rendered":"http:\/\/4563.org\/?p=162899"},"modified":"2020-10-02T09:45:43","modified_gmt":"2020-10-02T01:45:43","slug":"springboot-%e6%8e%a5%e5%8f%a3%e6%80%8e%e4%b9%88%e4%bc%a0%e6%95%b0%e6%8d%ae%e5%ba%93%e4%b8%ad%e7%9a%84-blob-%e5%9b%be%e7%89%87%e7%bb%99%e5%89%8d%e7%ab%af","status":"publish","type":"post","link":"http:\/\/4563.org\/?p=162899","title":{"rendered":"SpringBoot \u63a5\u53e3\u600e\u4e48\u4f20\u6570\u636e\u5e93\u4e2d\u7684 BLOB \u56fe\u7247\u7ed9\u524d\u7aef"},"content":{"rendered":"<div>\n<div>\n<div>\n<h1>                  SpringBoot \u63a5\u53e3\u600e\u4e48\u4f20\u6570\u636e\u5e93\u4e2d\u7684 BLOB \u56fe\u7247\u7ed9\u524d\u7aef               <\/h1>\n<p> <\/p>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : sandman511 <\/span>  <span><i><\/i> 9<\/span> <\/div>\n<div> <\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<div isfirst=\"1\"> <\/p>\n<p>\u5355\u5f20\u6216\u8005\u591a\u5f20\u7684 \u6c42\u5927\u4f6c\u8bb2\u4e2a\u65b9\u6848 \u73b0\u5728\u662f\u80fd\u4f20 \u4f46\u60f3\u8981\u4e2a\u6700\u4f73\u65b9\u6848\u3002\u3002\u867d\u7136\u6570\u636e\u5e93\u5b58\u56fe\u7247\u5c31\u79bb\u8c31\u3002\u3002\u3002\u3002<\/p>\n<\/p><\/div>\n<div> <b>\u5927\u4f6c\u6709\u8a71\u8aaa<\/b> (<span>26<\/span>)        <\/div>\n<div> <\/div>\n<\/p><\/div>\n<\/p><\/div>\n<ul>\n<li data-pid=\"3483070\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : RedBeanIce <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u90fd springboot \u4e86\uff0c\u6570\u636e\u5e93\u8fd8\u5b58\u56fe\u7247\u7684\u4e8c\u8fdb\u5236\u5417\uff1f                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3483071\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : myCupOfTea <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u6570\u636e\u5e93\u5b58\u56fe\u7247\u786e\u5b9e\u79bb\u8c31                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3483072\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : muskill <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u5b58 base64 \u5462                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3483073\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : lower <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u73b0\u5728\u7684\u65b9\u6848\u662f\u4ec0\u4e48\u6837\u7684\u5462\uff1f                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3483074\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : napsterwu <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             blob \u76f4\u63a5\u5f53\u6210\u6587\u4ef6\u4e0b\u8f7d\u9001\u51fa\u53bb\uff0c\u524d\u7aef\u76f4\u63a5\u7528 img src \u62ff                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3483075\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : monkeyWie <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u63d0\u4f9b\u4e00\u4e2a\u63a5\u53e3\uff0c\u7136\u540e\u4ee5\u5b57\u8282\u6d41\u7684\u65b9\u5f0f\u5199\u51fa\u56fe\u7247\u4e0d\u5c31\u884c\u4e86\u5417\uff0c\u6ce8\u610f\u8bbe\u7f6e\u597d\u6b63\u786e\u7684 Content-Type \u5c31\u884c                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3483076\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : yazinnnn <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u8bf4\u5b9e\u8bdd,\u6570\u636e\u5e93\u5b58\u56fe\u7247\u633a\u626f\u6de1\u7684                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3483077\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : fhsan <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             http body stream                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3483078\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : charten <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u6211\u4ece\u524d\u7aef\u7684\u89d2\u5ea6\u8c08\u4e00\u4e0b\uff0c\u6211\u4eec\u8fd9\u8fb9\u8bf7\u6c42 blob \u5b9e\u9645\u4e0a\u5c31\u662f\u8bf7\u6c42\u4e8c\u8fdb\u5236\u6d41\uff0c\u8ddf\u666e\u901a\u7684\u8bf7\u6c42\u6ca1\u4ec0\u4e48\u533a\u522b\u3002\u4f60\u53ea\u8981\u628a\u56fe\u7247\u7684\u4e8c\u8fdb\u5236\u6570\u636e\u653e\u8fdb body \u5c31\u53ef\u4ee5\u4e86\u3002\u53e6\u5916\uff0c\u5982\u679c\u6709\u8bf7\u6c42\u591a\u5f20\u7684\u60c5\u51b5\uff0c\u53ef\u4ee5\u8ddf\u524d\u7aef\u7ea6\u5b9a\u597d\u4e00\u4e2a\u4e8c\u8fdb\u5236\u683c\u5f0f\uff0c\u6bd4\u5982\u4ee5\u67d0\u4e2a\u5b57\u7b26\uff0c\u6bd4\u5982 0x3b \u4e4b\u7c7b\u7684\u4f5c\u4e3a\u6587\u4ef6\u7684\u5f00\u5934\uff0c\u540e\u9762\u52a0 4 \u4e2a\u5b57\u8282\u7528\u4e8e\u8868\u793a\u56fe\u7247\u7684\u4e8c\u8fdb\u5236\u957f\u5ea6\uff1a<br \/>0x3b 0x00 0x00 0x11 0xff &lt;\u56fe\u7247\u6570\u636e&#8230;.4607 \u4e2a\u5b57\u8282&gt; <br \/>0x3b 0x00 0x00 0x22 0xff &lt;\u56fe\u7247\u6570\u636e&#8230;8959 \u4e2a\u5b57\u8282&gt;<br \/>&#8230;                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3483079\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : securityCoding <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u4e0d\u8981\u5728\u9519\u8bef\u7684\u8def\u4e0a\u8d8a\u8d70\u8d8a\u8fdc , \u6389\u5934\u5427                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3483080\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : wysnylc <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u8c03\u5934,OSS                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3483081\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : justlikemaki <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u654f\u611f\u56fe\u7247\u4f60\u4eec\u4e5f\u5b58 oss \uff1f                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3483082\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : crclz <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @GetMapping(&#8220;{id}&#8221;)<br \/> public ResponseEntity&lt;byte[]&gt; getFile(@PathVariable long id) {<br \/> var blob = blobRepository.findById(id).orElse(null);<br \/> return ResponseEntity.ok()<br \/> .contentType(MediaType.IMAGE_JPEG)<br \/> .body(blob.getData());<br \/> }                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3483083\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : spacebound <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @monkeyWie +1\uff0c\u524d\u7aef\u76f4\u63a5\u4e0d\u7528\u5904\u7406\uff0c\u8c03\u63a5\u53e3\u5c31\u884c\u4e86                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3483084\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : 0x666666 <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u90fd 0202 \u5e74\u4e86\uff0c\u5fae\u670d\u52a1\u90fd\u7528\u4e0a\u4e86\uff0c\u6570\u636e\u5e93\u8fd8\u5b58\u56fe\u7247\uff1f                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3483085\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : tanranran <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             base64                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3483086\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : radiocontroller <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u4e13\u4e1a\u7684\u4e8b\u4ea4\u7ed9\u4e13\u4e1a\u7684\u670d\u52a1                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3483087\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : ztechstack <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             InputStreamResource resource = new InputStreamResource(gridFSDBFile.getInputStream(),<br \/> gridFSDBFile.getFilename());<\/p>\n<p>return (ResponseEntity&lt;Resource&gt;) ResponseEntity<br \/> .ok()<br \/> .header(HttpHeaders.CONTENT_DISPOSITION, &#8220;attachment; filename=&#8221;&#8221; + gridFSDBFile.getFilename() + &#8220;&#8221;&#8221;)<br \/> .contentLength(gridFSDBFile.getLength())<br \/> .contentType(MediaType.APPLICATION_OCTET_STREAM)<br \/> .body(resource);                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3483088\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : ztechstack <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u5982\u679c\u662f byte[], \u53ef\u4ee5\u4f7f\u7528 ByteArrayResource                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3483089\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : zjsxwc <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u8fd8\u4e0d\u5982\u56fe\u7247\u52a0\u5bc6\u540e\u6587\u4ef6\u4fdd\u5b58\u672c\u5730\uff0cmysql \u5b58\u56fe\u7247\u89e3\u5bc6\u5bc6\u7801\uff0c\u9700\u8981\u7684\u65f6\u5019\u901a\u8fc7\u5bc6\u7801\u548c\u52a0\u5bc6\u540e\u7684\u6587\u4ef6\u5f97\u5230\u539f\u56fe\u8fd4\u56de\u7ed9\u5ba2\u6237\u7aef                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3483090\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : hejingyuan199 <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u867d\u7136\u6211\u4e0d\u77e5\u9053\u5982\u4f55\u56de\u7b54\u3002<br \/>\u4f46\u6211\u60f3\u9644\u548c\u4e00\u4e0b\uff0c\u6211\u4e5f\u662f\u628a\u56fe\u7247\u5b58\u6570\u636e\u5e93\u7684\u3002<\/p>\n<p>\u6211\u73b0\u5728\u7684\u9879\u76ee\u662f\u4e2a\u6d4b\u8bd5\u6027\u9879\u76ee\uff0c\u4e0d\u662f\u6b63\u89c4\u4f7f\u7528\u3002<br \/>\u6211\u4eec\u7684\u6570\u636e\u5e93\u4f9b\u6240\u6709\u5f00\u53d1\u4eba\u5458\u540c\u65f6\u4f7f\u7528\u7684\u3002<\/p>\n<p>\u4e0d\u540c\u7684\u5f00\u53d1\u4eba\u5458\u6709\u4e0d\u540c\u7684\u529f\u80fd\uff0c\u529f\u80fd\u4e92\u4e0d\u5e72\u6d89\uff0c\u4f46\u662f\u5171\u7528\u4e00\u4e2a\u6570\u636e\u5e93\u548c\u8868\u3002<br \/>\u5982\u679c\u56fe\u7247\u5b58\u5728\u670d\u52a1\u5668\u672c\u5730\uff0c\u6570\u636e\u5e93\u53ea\u5b58\u56fe\u7247\u540d\u79f0\uff0c\u90a3\u5927\u5bb6\u5404\u81ea\u5728\u6d4b\u8bd5\u65f6\u90fd\u62ff\u4e0d\u5230\u56fe\u7247\u3002<br \/>\u6240\u4ee5\u6211\u628a\u56fe\u7247\u8f6c\u6210 Base64 \u5b57\u7b26\u4e32\u5b58\u8fdb\u6570\u636e\u5e93\u4e86\u3002<br \/>\u8fd8\u6709\u7684\u8868\u91cc\u5b58\u7740 Blob \u7c7b\u578b\u7684\u7528\u6237\u4e0a\u4f20\u7684\u9644\u4ef6\uff08\u6587\u4ef6\u6216\u56fe\u7247\uff09\u3002<\/p>\n<p>\u4e00\u76f4\u770b\u5230\u5927\u5bb6\u8bf4\u5927\u6587\u4ef6\u4e0d\u5e94\u8be5\u5b58\u6570\u636e\u5e93\uff0c<br \/>\u4e5f\u8bb8\u672a\u6765\u8f6c\u4e3a\u751f\u4ea7\u73af\u5883\u65f6\u5019\u518d\u6539\u5427\u3002<\/p>\n<p>\u5982\u679c\u6570\u636e\u5e93\u5b58\u7740 Base64 \u5b57\u7b26\u4e32\uff0c\u5f80\u524d\u7aef\u53d1\u9001\u5e94\u8be5\u6bd4\u8f83\u7b80\u5355\u4e86\u5427\u3002<br \/>Blob \u6211\u770b\u5230\u6211\u4eec\u7684\u8fd9\u8fb9\u7528\u7684\u662f\uff0c<br \/>(\u4ee3\u7801\u98ce\u683c\u5f88\u6e23\uff0c\u968f\u4fbf\u63a5\u53d7 Critics \uff09<\/p>\n<p>\/***** Student Chose One Application*****\/<br \/> @RequestMapping(value=&#8221;\/history\/{ticketNum}&#8221;, method=RequestMethod.GET)<br \/> public String historyApplication(@PathVariable String ticketNum, Model model, HttpServletRequest request) {<br \/> String search = (String) request.getSession().getAttribute(&#8220;searchTicketNum&#8221;);<br \/> Optional&lt;Application&gt; app = applicationService.findApplication(ticketNum);<br \/> if (app.isPresent()) {<br \/> model.addAttribute(&#8220;applicationObj&#8221;, app.get());<br \/> Optional&lt;User&gt; user = AIBTuserdetailsService.findByUserName(app.get().getCreatedBy());<br \/> model.addAttribute(&#8220;userObj&#8221;,user.get());<br \/> model.addAttribute(&#8220;urlTicketNum&#8221;, ticketNum);<\/p>\n<p> model.addAttribute(&#8220;documents&#8221;, applicationService.getDocumentUrl(ticketNum, app.get().getId()));<br \/> &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<br \/> \/\/\u8c03\u7528 blob \u7c7b\u578b\u7684\u6587\u4ef6<\/p>\n<p> model.addAttribute(&#8220;logs&#8221;, applicationService.getAuditLog(app.get().getId()));<br \/> \/\/Optional&lt;Course&gt; course = courseService.findByCourseid(user.get().getCurrentCourseCode());<br \/> \/\/if(course.isPresent()) {<br \/> \/\/ model.addAttribute(&#8220;course&#8221;, course.get().getCourseName());}<br \/> \/\/else {<br \/> \/\/ model.addAttribute(&#8220;course&#8221;, &#8220;Not found&#8221;);<br \/> \/\/}<br \/> }<br \/> model.addAttribute(&#8220;applicationList&#8221;, applicationService.findApplications(search));<br \/> return &#8220;student\/history&#8221;;<br \/> }<\/p>\n<p>In ApplicationService.java<\/p>\n<p>public Map&lt;String, String&gt; getDocumentUrl(String ticketNum, int applicationId) {<br \/> Map&lt;String, String&gt; result = new HashMap&lt;&gt;();<br \/> for (String fileName : documentRepository.findAllFileNameByApplicationId(applicationId)) {<br \/> &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<br \/> \/\/get document out from Database<\/p>\n<p> if (!fileName.isEmpty()) {<br \/> try {<br \/> result.put(fileName, ticketNum + &#8220;\/&#8221; + URLEncoder.encode(fileName, String.valueOf(StandardCharsets.UTF_8)));<br \/> } catch (UnsupportedEncodingException e) {<br \/> e.printStackTrace();<br \/> }<br \/> }<br \/> }<br \/> if (result.isEmpty()) {<br \/> return null;<br \/> } else {<br \/> return result;<br \/> }<br \/> }<\/p>\n<p>In DocumentRepository.java<\/p>\n<p>public interface DocumentRepository extends JpaRepository&lt;Document, Integer&gt; {<br \/> Optional&lt;Document&gt; findByFileNameAndApplicationId(String fileName, int applicationId);<br \/> @Query(value=&#8221;select file_name from document where application_id =:application_id&#8221;, nativeQuery=true)<br \/> List&lt;String&gt; findAllFileNameByApplicationId(@Param(&#8220;application_id&#8221;) int applicationId);<br \/>}<\/p>\n<p>\/\/This is parts of Class Document<\/p>\n<p>@Entity<br \/>@Table(name = &#8220;Document&#8221;)<br \/>public class Document {<br \/> @Id<br \/> @GeneratedValue(strategy = GenerationType.AUTO)<br \/> private int id;<br \/> private int applicationId;<br \/> private String fileName;<br \/> private String fileType;<br \/> @Lob<br \/> private byte[] data;<br \/> &#8230;<br \/>}<\/p>\n<p>\u4ec5\u4f9b\u53c2\u8003<br \/>\u8fd9\u4e2a\u6d41\u7a0b\u4f3c\u4e4e\u5c31\u662f\u524d\u9762\u4e00\u4e9b V \u53cb\u8bf4\u7684\u4ee5\u6587\u4ef6\u4e0b\u8f7d\u65b9\u5f0f\u4f20\u5230\u524d\u7aef\u7684\u3002<\/p>\n<p>\u524d\u7aef\u662f\u8fd9\u6837\u7684\uff1a<br \/>&lt;div class=&#8221;three&#8221;&gt;<br \/> &lt;p&gt;<br \/> &lt;b&gt;Attachment:&lt;\/b&gt;<br \/> &lt;\/p&gt;<br \/> &lt;div class=&#8221;links&#8221;&gt;<br \/> &lt;a target=&#8221;_blank&#8221; th:each=&#8221;element : ${documents}&#8221;<br \/> th:href=&#8221;@{\/student\/downloadFile\/{url}(url=${element.value})}&#8221;&gt;&lt;img th:src=&#8221;@{\/image\/qubiezhen.png}&#8221;&gt;[[${element.key}]]&lt;\/a&gt;<br \/> &lt;\/div&gt;<br \/> &lt;\/div&gt;                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3483091\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : hejingyuan199 <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @hejingyuan199 <\/p>\n<p>\u8865\u4e0a\u6700\u5173\u952e\u7684\u6570\u636e\u4f20\u8f93<\/p>\n<p>@RequestMapping(value=&#8221;\/downloadFile\/{ticketNum}\/{fileName}&#8221;, method=RequestMethod.GET)<br \/> public ResponseEntity&lt;Resource&gt; downloadFile(@PathVariable String ticketNum, @PathVariable String fileName) {<br \/> \/\/ Load file from database<br \/> Optional&lt;Document&gt; doc = applicationService.getDocument(ticketNum, fileName, Boolean.FALSE);<\/p>\n<p> if (doc.isPresent()) {<br \/> return ResponseEntity.ok()<br \/> .contentType(MediaType.parseMediaType(doc.get().getFileType()))<br \/> .header(HttpHeaders.CONTENT_DISPOSITION, &#8220;attachment; filename=&#8221;&#8221; + doc.get().getFileName() + &#8220;&#8221;&#8221;)<br \/> .body(new ByteArrayResource(doc.get().getData()));<br \/> } else {<br \/> return new ResponseEntity&lt;&gt;(HttpStatus.NOT_FOUND);<br \/> }<br \/> }                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3483092\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : bxd5812127 <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u540e\u7aef\u7ed9\u524d\u7aef\u63d0\u4f9b\u4e24\u4e2a\u63a5\u53e3\uff0c\u4e00\u4e2a\u62ff\u6240\u6709\u56fe\u7247\u7684 id\uff0c\u4e00\u4e2a\u6839\u636e id \u62ff\u4e00\u4e2a\u56fe\u7247\uff0c\u524d\u7aef\u6839\u636e id \u6392\u961f\u62ff\u56fe\u7247\u6709\u6ca1\u6709\u641e\u5934\uff0c\u62ff\u5b8c\u4e00\u4e2a\u5728\u62ff\u4e00\u4e2a\u3002                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3483093\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : THESDZ <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             \u540e\u7aef\u5e94\u8be5\u63d0\u4f9b\u7684\u80fd\u529b\u662f &lt;img src=&#8221;url&#8221;\/&gt; \u7684\u8fd9\u4e2a url,\u5185\u90e8\u5b9e\u73b0\u53ef\u4ee5\u76f4\u63a5\u901a\u8fc7 resp \u4f20\u8f93\u6d41                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3483094\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : hyperbin <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @charten \u600e\u4e48\u4fdd\u8bc1\u56fe\u7247\u91cc\u6ca1\u6709 0x3b \uff1f                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li data-pid=\"3483095\" data-uid=\"2\">\n<div>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : charten <\/span>  <\/div>\n<div> <i title=\"\u5f15\u7528\"><\/i>  <span>          <\/span> <\/div>\n<\/p><\/div>\n<div>                                                             @hyperbin \u4e0d\u7528\u4fdd\u8bc1\u5440\uff0c\u53c8\u4e0d\u662f\u62ff 0x3b \u53bb\u5f53\u5206\u5272\u7b26\uff0c0x3b \u53ea\u662f\u4e00\u4e2a\u6807\u8bc6\u7b26\uff0c\u6807\u8bc6\u7b26\u4e00\u4e2a\u5757\u7684\u5f00\u59cb\uff0c\u8fd9\u4e2a\u6807\u8bc6\u7b26\u53ef\u4ee5 0x00 \u5230 0xff \u7684\u4efb\u610f\u4e00\u4e2a\u5b57\u7b26\uff0c\u5173\u952e\u662f\u7d27\u8ddf\u7740\u7684\u540e\u56db\u4f4d\u5b57\u8282\uff0c\u4ee3\u8868\u4e86\u8fd9\u4e2a\u5757\u7684\u957f\u5ea6\uff0c\u4f60\u771f\u6b63\u8981\u62ff\u56fe\u7247\u8981\u901a\u8fc7\u8fd9\u4e2a\u957f\u5ea6\u53bb\u62ff\uff0c\u5c31\u662f slice \u65b9\u6cd5\u3002\u5f53\u7136\u4e5f\u53ef\u4ee5\u6839\u636e\u8fd9\u4e2a\u957f\u5ea6\u8df3\u8fc7\u53bb\u62ff\u4e0b\u4e00\u5f20\u56fe\u7247\u3002psd \u6587\u4ef6\u7684\u4e8c\u8fdb\u5236\u683c\u5f0f\u57fa\u672c\u4e0a\u90fd\u662f\u8fd9\u6837\u7684                                                            <\/div>\n<\/p><\/div>\n<\/li>\n<li>\n","protected":false},"excerpt":{"rendered":"<p>SpringBoot \u63a5\u53e3\u600e\u4e48\u4f20\u6570&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[],"tags":[],"_links":{"self":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/162899"}],"collection":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=162899"}],"version-history":[{"count":0,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/162899\/revisions"}],"wp:attachment":[{"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=162899"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=162899"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=162899"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}