下载
/* 导出excel文件 */
@RequestMapping(value = "exportexcel" )
@ResponseBody
public ModelAndView exportExcel(Integer ownerId , Integer disinfoId , Date bookingDateFrom , Date bookingDateTo) throws IOException{
ModelAndView mav = new ModelAndView();
response.setHeader("Content-Disposition", "attachment; filename=\"" + sdf.format(new Date()) + ".xlsx");
response.setContentType("application/octet-stream; charset=UTF-8");
orderService.exportOrdersForExcel(ownerId, disinfoId, bookingDateFrom, bookingDateTo ,
super.response.getOutputStream()); //将输出流传递到方法
return mav ;
}
上传
springmvc.xml
<bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
<property name="maxUploadSize" value="10240000"/>
</bean>
@RequestMapping(value = "addfile")
public String upload(HttpServletRequest request,
@RequestParam("fileUpload") MultipartFile fileUpload)
throws Exception {
if (!fileUpload.isEmpty()
&& !checkFile(fileUpload.getOriginalFilename())) {
String dirPath = "D:/myimg";
File dirFile = new File(dirPath);
if (!dirFile.exists()) {
dirFile.mkdirs();
}
File uploadFile = new File(dirFile,
fileUpload.getOriginalFilename());
InputStream is = fileUpload.getInputStream();
FileOutputStream fos = new FileOutputStream(uploadFile);
byte[] tmp = new byte[1024];
int len = -1;
while ((len = is.read(tmp)) != -1) {
fos.write(tmp, 0, len);
}
is.close();
fos.flush();
fos.close();
System.out.println("文件上传从成功:" + uploadFile.getParent());
}
return "redirect:/admin/addcolumn.htm";
}