上传下载-excel导入导出

//上传

//jsp

//action

//spring mvc 上传文件完整示例

@RequestMapping(value = "/importFileTest")

public String importFileTest(@RequestParam(value = "file", required = false) MultipartFile file, HttpServletRequest request, ModelMap model) {

System.out.println("开始");

System.out.println(file);

String path = request.getSession().getServletContext().getRealPath("upload");

String fileName = file.getOriginalFilename();

System.out.println(path);

File targetFile = new File(path, fileName);

if(!targetFile.exists()){

targetFile.mkdirs();

}

//保存

try {

file.transferTo(targetFile);

} catch (Exception e) {

e.printStackTrace();

}

// model.addAttribute("fileUrl", request.getContextPath()+"/upload/"+fileName); model.addAttribute("fileUrl", "/upload/"+fileName);

Map params = new HashMap();

//文件存放路径

String fileUrl = "/upload/"+fileName;

params.put("fileUrl", fileUrl);

//文件标题

String title = fileName;

params.put("title", title);

//获取登录名，转存为发布人

Account loginUser = (Account) request.getSession().getAttribute(Const.SESSION_USER); String publisher = loginUser.getLoginName();

params.put("publisher", publisher);

//发布时间

Date date = new Date();

SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

String addtime = sdf.format(date);

params.put("addtime", addtime);

//获取客户端IP

String remoteAddr = request.getRemoteAddr();

String forwarded = request.getHeader("X-Forwarded-For");

String realIp = request.getHeader("X-Real-IP");

String pip = null;

if (realIp == null) {

if (forwarded == null) {

pip = remoteAddr;

} else {

pip = remoteAddr + "/" + forwarded.split(",")[0];

}

} else {

if (realIp.equals(forwarded)) {

pip = realIp;

} else {

if(forwarded != null){

forwarded = forwarded.split(",")[0];

}

pip = realIp + "/" + forwarded;

}