這篇文章將為大家詳細(xì)講解有關(guān)怎么在jQuery中使用FormData上傳文件,文章內(nèi)容質(zhì)量較高,因此小編分享給大家做個(gè)參考,希望大家閱讀完這篇文章后對(duì)相關(guān)知識(shí)有一定的了解。
堅(jiān)守“ 做人真誠(chéng) · 做事靠譜 · 口碑至上 · 高效敬業(yè) ”的價(jià)值觀,專業(yè)網(wǎng)站建設(shè)服務(wù)10余年為成都玻璃鋼坐凳小微創(chuàng)業(yè)公司專業(yè)提供企業(yè)網(wǎng)站制作營(yíng)銷網(wǎng)站建設(shè)商城網(wǎng)站建設(shè)手機(jī)網(wǎng)站建設(shè)小程序網(wǎng)站建設(shè)網(wǎng)站改版,從內(nèi)容策劃、視覺(jué)設(shè)計(jì)、底層架構(gòu)、網(wǎng)頁(yè)布局、功能開(kāi)發(fā)迭代于一體的高端網(wǎng)站建設(shè)服務(wù)。
jquery是一個(gè)簡(jiǎn)潔而快速的JavaScript庫(kù),它具有獨(dú)特的鏈?zhǔn)秸Z(yǔ)法和短小清晰的多功能接口、高效靈活的css選擇器,并且可對(duì)CSS選擇器進(jìn)行擴(kuò)展、擁有便捷的插件擴(kuò)展機(jī)制和豐富的插件,是繼Prototype之后又一個(gè)優(yōu)秀的JavaScript代碼庫(kù),能夠用于簡(jiǎn)化事件處理、HTML文檔遍歷、Ajax交互和動(dòng)畫,以便快速開(kāi)發(fā)網(wǎng)站。
JQuery 函數(shù)的提交按鈕執(zhí)行的函數(shù)如下:
<script type="text/javascript"> //批量上傳題庫(kù) function fileSubmit() { var questionFile = new FormData(); var fileObj = document.getElementById("questionFile").files[0]; // js 獲取文件對(duì)象,questionFile為文件選擇框的Id questionFile.append("file", fileObj); var teacherId=localStorage.getItem("teacherId"); questionFile.append("teacherId",teacherId); var courseId=localStorage.getItem("courseId"); questionFile.append("courseId",courseId); $.ajax({ async: false, type:"post", url:"/questions/batchUpload", data:questionFile, processData : false, //必須false才會(huì)避開(kāi)jQuery對(duì) formdata 的默認(rèn)處理 contentType : false, //必須false才會(huì)自動(dòng)加上正確的Content-Type success:function (data) { layer.msg("上傳成功"); example.ajax.reload(); } }); } </script>
需要注意的是以下兩點(diǎn):
jQuery 的 ajax 中processData設(shè)置為false (表示不需要對(duì)數(shù)據(jù)做處理)
jQuery 的 ajax 中contentType設(shè)置為false (因?yàn)榍懊嬉呀?jīng)聲明了是‘FormData對(duì)象')
Controller 中的方法如下:
@ApiOperation(value = "批量上傳題庫(kù)") @RequestMapping(value = "/batchUpload",method = RequestMethod.POST) public void batchUploadQuestions(HttpServletRequest request) throws Exception{ Collection<Part> files = request.getParts(); questionsService.batchUploadQuestions(files); }
Service中的方法如下:
//題庫(kù)的批量上傳 @Override public void batchUploadQuestions(Collection<Part> files) throws Exception { Iterator<Part> it = files.iterator(); Part file = it.next(); Workbook workbook = null; if (file.getSubmittedFileName().endsWith("xlsx")) { workbook = new XSSFWorkbook(file.getInputStream()); } else if (file.getSubmittedFileName().endsWith("xls")) { workbook = new HSSFWorkbook(file.getInputStream()); } Cell cell = null; List<Questions> questionsList = new ArrayList<>(); //判斷Excel中有幾張表,目前設(shè)定為一張表 Sheet sheet = workbook.getSheetAt(0);//獲取sheet表 for (int rowIndex = 2; rowIndex <= sheet.getLastRowNum(); rowIndex++) { //獲取到一行 Row row = sheet.getRow(rowIndex); if (row == null) { continue; } Questions questions = new Questions(); List<String> strList = new ArrayList<>(); for (int i = 1; i < row.getLastCellNum(); i++) { //獲取到一列,第一列為序號(hào)不需要存入數(shù)據(jù)庫(kù),所以從1開(kāi)始讀 cell = row.getCell(i); String value = ""; switch (cell.getCellTypeEnum()) { case _NONE: break; case STRING: value = cell.getStringCellValue(); break; case NUMERIC: Pattern points_ptrn = Pattern.compile("0.0+_*[^/s]+"); if (DateUtil.isCellDateFormatted(cell)) {//日期 SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); value = sdf.format(DateUtil.getJavaDate(cell.getNumericCellValue())); } else if ("@".equals(cell.getCellStyle().getDataFormatString()) || "General".equals(cell.getCellStyle().getDataFormatString()) || "0_".equals(cell.getCellStyle().getDataFormatString())) { //文本 or 常規(guī) or 整型數(shù)值 DecimalFormat df = new DecimalFormat("0"); value = df.format(cell.getNumericCellValue()); } else if (points_ptrn.matcher(cell.getCellStyle().getDataFormatString()).matches()) {//正則匹配小數(shù)類型 value = String.valueOf(cell.getNumericCellValue());//直接顯示 } break; default: value = cell.toString(); } if ((i == 2 || i == 3) && value.equals("")) {//此處設(shè)計(jì)不需要讀入的單元格 strList.clear(); break; } strList.add(value); } if (strList.size() == 9) { //對(duì)應(yīng)數(shù)據(jù)庫(kù)屬性進(jìn)行存儲(chǔ) questions.setChapter(strList.get(0)); questions.setSection(strList.get(1)); questions.setType(strList.get(2)); questions.setQuestion(strList.get(3)); questions.setAnswerA(strList.get(4)); questions.setAnswerB(strList.get(5)); questions.setAnswerC(strList.get(6)); questions.setAnswerD(strList.get(7)); questions.setAnswerTrue(strList.get(8)); questionsList.add(questions); } } //將前臺(tái)存進(jìn)的teacherId也當(dāng)做文件進(jìn)行讀取 Part file1 = it.next(); InputStream inputStream = file1.getInputStream(); BufferedReader bufferedReader = new BufferedReader(new InputStreamReader(inputStream)); String line = null; String teacherId = ""; while ((line = bufferedReader.readLine()) != null) { teacherId = line; } //將前臺(tái)傳入的courseId當(dāng)做文件讀取 Part file2 = it.next(); InputStream inputStream1 = file2.getInputStream(); BufferedReader bufferedReader1 = new BufferedReader(new InputStreamReader(inputStream1)); String line1 = null; String courseId = ""; while ((line1 = bufferedReader1.readLine()) != null) { courseId = line1; } batchSaveQuestionList(teacherId, courseId, questionsList); } //SQL 語(yǔ)句拼接后傳入DAO層進(jìn)行數(shù)據(jù)插入 public void batchSaveQuestionList(String teacherId,String courseId,List<Questions> questionsList){ String sql = "replace into questions(questionId,courseId,teacherId,chapter,section,type,question,answerA,answerB,answerC,answerD,answerTrue) values"; for(int i = 0;i<questionsList.size();i++){ String questionId = String.valueOf(System.currentTimeMillis())+i; if(i==0){ sql+="('"+questionId+"','"+courseId+"','"+teacherId+"','"+questionsList.get(i).getChapter()+"','"+questionsList.get(i).getSection() + "','"+questionsList.get(i).getType()+"','"+questionsList.get(i).getQuestion()+ "','"+ questionsList.get(i).getAnswerA() +"','"+questionsList.get(i).getAnswerB()+"','"+questionsList.get(i).getAnswerC()+"','"+questionsList.get(i).getAnswerD() +"','"+questionsList.get(i).getAnswerTrue()+"')"; }else{ sql+=",('"+questionId+"','"+courseId+"','"+teacherId+"','"+questionsList.get(i).getChapter()+"','"+questionsList.get(i).getSection() + "','"+questionsList.get(i).getType()+"','"+questionsList.get(i).getQuestion()+ "','"+ questionsList.get(i).getAnswerA() +"','"+questionsList.get(i).getAnswerB()+"','"+questionsList.get(i).getAnswerC()+"','"+questionsList.get(i).getAnswerD() +"','"+questionsList.get(i).getAnswerTrue()+"')"; } } questionsDao.batchSaveQuestionList(sql); }
DAO層的數(shù)據(jù)插入語(yǔ)句:
@Insert("${sql}") void batchSaveQuestionList(@Param("sql") String sql);
關(guān)于怎么在jQuery中使用FormData上傳文件就分享到這里了,希望以上內(nèi)容可以對(duì)大家有一定的幫助,可以學(xué)到更多知識(shí)。如果覺(jué)得文章不錯(cuò),可以把它分享出去讓更多的人看到。
標(biāo)題名稱:怎么在jQuery中使用FormData上傳文件
分享網(wǎng)址:http://chinadenli.net/article36/pooopg.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián),為您提供虛擬主機(jī)、靜態(tài)網(wǎng)站、網(wǎng)站改版、手機(jī)網(wǎng)站建設(shè)、網(wǎng)站維護(hù)、標(biāo)簽優(yōu)化
聲明:本網(wǎng)站發(fā)布的內(nèi)容(圖片、視頻和文字)以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主,如果涉及侵權(quán)請(qǐng)盡快告知,我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如需處理請(qǐng)聯(lián)系客服。電話:028-86922220;郵箱:631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載,或轉(zhuǎn)載時(shí)需注明來(lái)源: 創(chuàng)新互聯(lián)
網(wǎng)頁(yè)設(shè)計(jì)公司知識(shí)