本文主要是介绍项目知识点总结-住房图片信息添加-Excel导出,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!
(1)住房信息添加
Controller:
@RequestMapping("/add")public String add(Home home, Model model) throws IOException{String sqlPath = null;//定义文件保存的本地路径String localPath="D:\\AnZhuang\\Java项目\\选题\\Xin-XiangMu\\Hotel_Manage-master\\src\\main\\webapp\\upload\\";//定义 文件名String filename=null;if(!home.getFile().isEmpty()){//生成uuid作为文件名称String uuid = UUID.randomUUID().toString().replaceAll("-","");//获得文件类型(可以判断如果不是图片,禁止上传)String contentType=home.getFile().getContentType();//获得文件后缀名String suffixName=contentType.substring(contentType.indexOf("/")+1);//得到 文件名filename=uuid+"."+suffixName;System.out.println(filename+"图片名字");//文件保存路径home.getFile().transferTo(new File(localPath+filename));}//把图片的相对路径保存至数据库sqlPath = "/upload/"+filename;System.out.println(sqlPath);home.setImg(sqlPath);homeService.addHome(home);model.addAttribute("home",home);return ("redirect:/home/list");}
Service
Dao
(2)Excel文件导出
页面跳转:
导出
Controller:
@RequestMapping("/home")public void excel_home(HttpServletResponse response )throws IOException {response.setCharacterEncoding("UTF-8");List<Home> homeList=homeService.queryAllHome();//创建excel文件HSSFWorkbook wb = new HSSFWorkbook();//创建sheet页HSSFSheet sheet = wb.createSheet("房间信息");//创建标题行HSSFRow titleRow = sheet.createRow(0);titleRow.createCell(0).setCellValue("编号");titleRow.createCell(1).setCellValue("房间号");titleRow.createCell(2).setCellValue("房间类型");titleRow.createCell(3).setCellValue("价格");titleRow.createCell(4).setCellValue("状态");titleRow.createCell(5).setCellValue("描述");for(Home home:homeList){HSSFRow dataRow = sheet.createRow(sheet.getLastRowNum()+1);dataRow.createCell(0).setCellValue(home.getId());dataRow.createCell(1).setCellValue(home.getNum());dataRow.createCell(2).setCellValue(home.getH_Type());dataRow.createCell(3).setCellValue(home.getPrice());dataRow.createCell(4).setCellValue(home.getState());dataRow.createCell(5).setCellValue(home.getText());}// 设置下载时客户端Excel的名称response.setContentType("application/octet-stream;charset=utf-8");response.setHeader("Content-Disposition", "attachment;filename="+ new String("房间信息表".getBytes(),"iso-8859-1") + ".xls");OutputStream ouputStream = response.getOutputStream();wb.write(ouputStream);ouputStream.flush();ouputStream.close();}
Service:
Dao
(3)前端定时器
!(function run(wait){if(wait <= 0) {location.href = "/jump/index";}else{wait--;setTimeout(function(){document.getElementById("wait").innerHTML = wait;run(wait);},1000);}})(3);
这篇关于项目知识点总结-住房图片信息添加-Excel导出的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!