public void downloadExcel(){
HttpServletRequest request = ServletActionContext.getRequest();
HttpServletResponse response=ServletActionContext.getResponse();
BufferedInputStream in = null;
BufferedOutputStream out = null;
try {
response.setContentType("text/html;charset=UTF-8");
request.setCharacterEncoding("UTF-8");
URL url = CommonTouristAction.class.getResource("");
String path = url.getPath().toString().replace("WEB-INF/classes/.*", "");
String path1[] = path.split("WEB-INF/classes/");
path = path1[0] + "model/xls/commonTouristModel.xls";
String fileName =URLEncoder.encode("常用旅客信息导入模板.xls", "UTF-8") ;
File f = new File(path);
response.setContentType("application/x-excel");
response.setCharacterEncoding("UTF-8");
response.setHeader("Content-Disposition", "attachment; filename="+fileName);
response.setHeader("Content-Length",String.valueOf(f.length()));
in = new BufferedInputStream(new FileInputStream(f));
out = new BufferedOutputStream(response.getOutputStream());
byte[] data = new byte[1024];
int len = 0;
while (-1 != (len=in.read(data, 0, data.length))) {
out.write(data, 0, len);
}
} catch (Exception e) {
logger.error("下载模版异常:",e);
} finally {
if (in != null) {
try {
in.close();
} catch (IOException e) {
logger.error("下载模版异常:",e);
}
}
if (out != null) {
try {
out.close();
} catch (IOException e) {
logger.error("下载模版异常:",e);
}
}
}
}
HttpServletRequest request = ServletActionContext.getRequest();
HttpServletResponse response=ServletActionContext.getResponse();
BufferedInputStream in = null;
BufferedOutputStream out = null;
try {
response.setContentType("text/html;charset=UTF-8");
request.setCharacterEncoding("UTF-8");
URL url = CommonTouristAction.class.getResource("");
String path = url.getPath().toString().replace("WEB-INF/classes/.*", "");
String path1[] = path.split("WEB-INF/classes/");
path = path1[0] + "model/xls/commonTouristModel.xls";
String fileName =URLEncoder.encode("常用旅客信息导入模板.xls", "UTF-8") ;
File f = new File(path);
response.setContentType("application/x-excel");
response.setCharacterEncoding("UTF-8");
response.setHeader("Content-Disposition", "attachment; filename="+fileName);
response.setHeader("Content-Length",String.valueOf(f.length()));
in = new BufferedInputStream(new FileInputStream(f));
out = new BufferedOutputStream(response.getOutputStream());
byte[] data = new byte[1024];
int len = 0;
while (-1 != (len=in.read(data, 0, data.length))) {
out.write(data, 0, len);
}
} catch (Exception e) {
logger.error("下载模版异常:",e);
} finally {
if (in != null) {
try {
in.close();
} catch (IOException e) {
logger.error("下载模版异常:",e);
}
}
if (out != null) {
try {
out.close();
} catch (IOException e) {
logger.error("下载模版异常:",e);
}
}
}
}