GBDT vs XGBoost vs 随机森林:3 种集成模型在药物活性预测中的 R² 对比
2026/7/7 23:40:35
作为软件工程专业大二学生,暑期独立开发"Word图片一键转存系统"的初衷源于两个痛点:
| 组件 | 技术选型 | 决策依据 |
|---|---|---|
| 前端框架 | Vue2-cli | 学校课程已系统学习,社区生态成熟,适合快速原型开发 |
| 富文本编辑器 | wangEditor | 轻量级(核心包仅200KB),支持自定义图片上传钩子,与Vue2兼容性良好 |
| 后端语言 | PHP | 阿里云ECS服务器预装LAMP环境,可直接部署,且PHP对文件流处理效率较高 |
| 数据库 | MySQL | 与PHP天然适配,支持BLOB类型存储二进制图片,但考虑性能最终采用文件系统存储 |
| 服务器 | 阿里云ECS | 学生优惠套餐(1核2G 1Mbps带宽),提供安全组、RDS等企业级功能 |
通过分析知乎专栏《一次性提取word文件中的图片》和微信公众平台《Word图片如何批量转存?》,确定两种技术路线:
word/media/目录提取图片另存为HTML功能,图片会保存在生成的文件夹中技术验证:
在本地使用Node.js编写测试脚本:
constfs=require('fs');constAdmZip=require('adm-zip');functionextractFromZip(docxPath){constzip=newAdmZip(docxPath);constmediaEntries=zip.getEntries().filter(entry=>entry.entryName.startsWith('word/media/'));returnmediaEntries.map(entry=>zip.readFile(entry));}参考wangEditor官方文档和CSDN博客《wangEditor的使用》,实现核心配置:
// editor.config.jsimport{createEditor,createToolbar}from'@wangeditor/editor'exportdefault{initEditor(domId){consteditorConfig={placeholder:'请上传Word文档...',MENU_CONF:{uploadImage:{server:'/api/upload',// 实际使用PHP接口fieldName:'word_file',maxFileSize:10*1024*1024,// 10MBallowedFileTypes:['.docx'],customInsert(res,editor){// 解析PHP返回的图片URL数组consturls=res.data.map(img=>``)editor.cmd.do('insertHTML',urls.join(''))}}}}returncreateEditor({selector:`#${domId}`,config:editorConfig,mode:'default'})}}asynchandleUpload(file){constformData=newFormData()formData.append('word_file',file)try{constres=awaitaxios.post('/api/parse',formData,{headers:{'Content-Type':'multipart/form-data'}})this.editor.cmd.do('insertHTML',res.data.map(url=>``).join(''))}catch(e){this.$message.error('解析失败:'+e.message)}}参考阿里云部署教程搭建PHP环境后,编写核心处理逻辑:
// api/parse.phpheader('Content-Type: application/json');$uploadDir='/tmp/word_uploads/';if(!file_exists($uploadDir))mkdir($uploadDir,0777,true);$fileName=uniqid().'.docx';$filePath=$uploadDir.$fileName;if(move_uploaded_file($_FILES['word_file']['tmp_name'],$filePath)){$zip=newZipArchive();if($zip->open($filePath)===TRUE){$images=[];for($i=0;$i<$zip->numFiles;$i++){$entry=$zip->getNameIndex($i);if(preg_match('/^word\/media\/image\d+\.(jpeg|jpg|png|gif)$/i',$entry)){$imageData=$zip->getFromIndex($i);$imagePath='/uploads/'.uniqid().'.'.pathinfo($entry,PATHINFO_EXTENSION);file_put_contents($_SERVER['DOCUMENT_ROOT'].$imagePath,$imageData);$images[]=$imagePath;}}$zip->close();unlink($filePath);// 删除临时文件echojson_encode(['code'=>0,'data'=>$images]);}else{echojson_encode(['code'=>500,'msg'=>'文件解压失败']);}}else{echojson_encode(['code'=>400,'msg'=>'文件上传失败']);}采用MySQL存储图片元信息(实际存储路径):
CREATETABLE`word_images`(`id`int(11)NOTNULLAUTO_INCREMENT,`original_filename`varchar(255)NOTNULL,`storage_path`varchar(512)NOTNULL,`upload_time`datetimeDEFAULTCURRENT_TIMESTAMP,`doc_id`varchar(64)DEFAULTNULLCOMMENT'关联文档ID',PRIMARYKEY(`id`),KEY`idx_doc_id`(`doc_id`))ENGINE=InnoDBDEFAULTCHARSET=utf8mb4;问题:当上传超过50MB的Word文件时,PHP脚本因内存不足终止
解决方案:
memory_limit = 256M upload_max_filesize = 100M post_max_size = 100M问题:提取的图片顺序与Word文档中的排版不一致
解决方案:
[Content_Types].xml获取图片索引顺序// 按文件名数字排序(如image1.jpg, image2.jpg...)usort($images,function($a,$b){preg_match('/image(\d+)/',basename($a),$matchesA);preg_match('/image(\d+)/',basename($b),$matchesB);return$matchesA[1]-$matchesB[1];});docx4j的Java实现参考,但因环境限制最终采用PHP方案Apache POI的XWPF组件,为后续Java版本开发预留接口在阿里云1核2G环境下测试:
| 并发数 | 平均响应时间 | 成功率 |
|---|---|---|
| 10 | 1.2s | 100% |
| 50 | 3.8s | 92% |
| 100 | 8.5s | 78% |
优化措施:
开发感悟:
这个项目让我深刻体会到:
(附:项目GitHub仓库地址及在线演示链接)
安装jquery
npm install jqueryimportEfrom'wangeditor'const{$,BtnMenu,DropListMenu,PanelMenu,DropList,Panel,Tooltip}=Eimport{WordPaster}from'../../static/WordPaster/js/w'import{zyCapture}from'../../static/zyCapture/z'import{zyOffice}from'../../static/zyOffice/js/o'//zyCapture ButtonclasszyCaptureBtnextendsBtnMenu{constructor(editor){const$elem=E.$(`<div class="w-e-menu">`)super($elem,editor)}clickHandler(){window.zyCapture.setEditor(this.editor).Capture();}tryChangeActive(){this.active()}}//zyOffice ButtonclassimportWordBtnextendsBtnMenu{constructor(editor){const$elem=E.$(`<div class="w-e-menu">`)super($elem,editor)}clickHandler(){window.zyOffice.SetEditor(this.editor).api.openDoc();}tryChangeActive(){this.active()}}//zyOffice ButtonclassexportWordBtnextendsBtnMenu{constructor(editor){const$elem=E.$(`<div class="w-e-menu">`)super($elem,editor)}clickHandler(){window.zyOffice.SetEditor(this.editor).api.exportWord();}tryChangeActive(){this.active()}}//zyOffice ButtonclassimportPdfBtnextendsBtnMenu{constructor(editor){const$elem=E.$(`<div class="w-e-menu">`)super($elem,editor)}clickHandler(){window.zyOffice.SetEditor(this.editor).api.openPdf();}tryChangeActive(){this.active()}}//WordPaster ButtonclassWordPasterBtnextendsBtnMenu{constructor(editor){const$elem=E.$(`<div class="w-e-menu">`)super($elem,editor)}clickHandler(){WordPaster.getInstance().SetEditor(this.editor).Paste();}tryChangeActive(){this.active()}}//wordImport ButtonclassWordImportBtnextendsBtnMenu{constructor(editor){const$elem=E.$(`<div class="w-e-menu">`)super($elem,editor)}clickHandler(){WordPaster.getInstance().SetEditor(this.editor).importWord();}tryChangeActive(){this.active()}}//excelImport ButtonclassExcelImportBtnextendsBtnMenu{constructor(editor){const$elem=E.$(`<div class="w-e-menu">`)super($elem,editor)}clickHandler(){WordPaster.getInstance().SetEditor(this.editor).importExcel();}tryChangeActive(){this.active()}}//ppt paster ButtonclassPPTImportBtnextendsBtnMenu{constructor(editor){const$elem=E.$(`<div class="w-e-menu">`)super($elem,editor)}clickHandler(){WordPaster.getInstance().SetEditor(this.editor).importPPT();}tryChangeActive(){this.active()}}//pdf paster ButtonclassPDFImportBtnextendsBtnMenu{constructor(editor){const$elem=E.$(`<div class="w-e-menu">`)super($elem,editor)}clickHandler(){WordPaster.getInstance().SetEditor(this.editor);WordPaster.getInstance().ImportPDF();}tryChangeActive(){this.active()}}//importWordToImg ButtonclassImportWordToImgBtnextendsBtnMenu{constructor(editor){const$elem=E.$(`<div class="w-e-menu">`)super($elem,editor)}clickHandler(){WordPaster.getInstance().SetEditor(this.editor).importWordToImg();}tryChangeActive(){this.active()}}//network paster ButtonclassNetImportBtnextendsBtnMenu{constructor(editor){const$elem=E.$(`<div class="w-e-menu">`)super($elem,editor)}clickHandler(){WordPaster.getInstance().SetEditor(this.editor);WordPaster.getInstance().UploadNetImg();}tryChangeActive(){this.active()}}exportdefault{name:'HelloWorld',data(){return{msg:'Welcome to Your Vue.js App'}},mounted(){vareditor=newE('#editor');WordPaster.getInstance({//上传接口:http://www.ncmem.com/doc/view.aspx?id=d88b60a2b0204af1ba62fa66288203edPostUrl:"http://localhost:8891/upload.aspx",License2:"",//为图片地址增加域名:http://www.ncmem.com/doc/view.aspx?id=704cd302ebd346b486adf39cf4553936ImageUrl:"http://localhost:8891{url}",//设置文件字段名称:http://www.ncmem.com/doc/view.aspx?id=c3ad06c2ae31454cb418ceb2b8da7c45FileFieldName:"file",//提取图片地址:http://www.ncmem.com/doc/view.aspx?id=07e3f323d22d4571ad213441ab8530d1ImageMatch:''});zyCapture.getInstance({config:{PostUrl:"http://localhost:8891/upload.aspx",License2:'',FileFieldName:"file",Fields:{uname:"test"},ImageUrl:'http://localhost:8891{url}'}})// zyoffice,// 使用前请在服务端部署zyoffice,// http://www.ncmem.com/doc/view.aspx?id=82170058de824b5c86e2e666e5be319czyOffice.getInstance({word:'http://localhost:13710/zyoffice/word/convert',wordExport:'http://localhost:13710/zyoffice/word/export',pdf:'http://localhost:13710/zyoffice/pdf/upload'})// 注册菜单E.registerMenu("zyCaptureBtn",zyCaptureBtn)E.registerMenu("WordPasterBtn",WordPasterBtn)E.registerMenu("ImportWordToImgBtn",ImportWordToImgBtn)E.registerMenu("NetImportBtn",NetImportBtn)E.registerMenu("WordImportBtn",WordImportBtn)E.registerMenu("ExcelImportBtn",ExcelImportBtn)E.registerMenu("PPTImportBtn",PPTImportBtn)E.registerMenu("PDFImportBtn",PDFImportBtn)E.registerMenu("importWordBtn",importWordBtn)E.registerMenu("exportWordBtn",exportWordBtn)E.registerMenu("importPdfBtn",importPdfBtn)//挂载粘贴事件editor.txt.eventHooks.pasteEvents.length=0;editor.txt.eventHooks.pasteEvents.push(function(){WordPaster.getInstance().SetEditor(editor).Paste();e.preventDefault();});editor.create();varedt2=newE('#editor2');//挂载粘贴事件edt2.txt.eventHooks.pasteEvents.length=0;edt2.txt.eventHooks.pasteEvents.push(function(){WordPaster.getInstance().SetEditor(edt2).Paste();e.preventDefault();return;});edt2.create();}}h1,h2{font-weight:normal;}ul{list-style-type:none;padding:0;}li{display:inline-block;margin:010px;}a{color:#42b983;}测试前请配置图片上传接口并测试成功
接口测试
接口返回JSON格式参考
components:{Editor,Toolbar},data(){return{editor:null,html:'dd',toolbarConfig:{insertKeys:{index:0,keys:['zycapture','wordpaster','pptimport','pdfimport','netimg','importword','exportword','importpdf']}},editorConfig:{placeholder:''},mode:'default'// or 'simple'}},一键粘贴Word内容,自动上传Word中的图片,保留文字样式。
一键导入Word文件,并将Word文件转换成图片上传到服务器中。
一键导入PDF文件,并将PDF转换成图片上传到服务器中。
一键导入PPT文件,并将PPT转换成图片上传到服务器中。
一键自动上传网络图片,自动下载远程服务器图片,自动上传远程服务器图片
点击下载完整示例