javaweb上传excel
javaweb上传下载excel实例
代码片段和文件信息
属性 大小 日期 时间 名称
----------- --------- ---------- ----- ----
目录 0 2016-12-30 10:38 javaWebExcel
目录 0 2016-12-30 10:38 javaWebExcelexcel
文件 838 2016-10-18 14:33 javaWebExcelexcel.classpath
文件 1038 2015-04-16 14:52 javaWebExcelexcel.project
目录 0 2016-12-30 10:38 javaWebExcelexcel.settings
文件 503 2015-04-16 14:52 javaWebExcelexcel.settings.jsdtscope
文件 364 2016-10-18 14:33 javaWebExcelexcel.settingsorg.eclipse.jdt.core.prefs
文件 467 2015-04-16 14:52 javaWebExcelexcel.settingsorg.eclipse.wst.common.component
文件 345 2015-04-16 14:52 javaWebExcelexcel.settingsorg.eclipse.wst.common.project.facet.core.xml
文件 49 2015-04-16 14:52 javaWebExcelexcel.settingsorg.eclipse.wst.jsdt.ui.superType.container
文件 6 2015-04-16 14:52 javaWebExcelexcel.settingsorg.eclipse.wst.jsdt.ui.superType.name
目录 0 2016-12-30 10:38 javaWebExcelexceluild
目录 0 2016-12-30 10:38 javaWebExcelexceluildclasses
目录 0 2016-12-30 10:38 javaWebExcelexceluildclassescom
目录 0 2016-12-30 10:38 javaWebExcelexceluildclassescomhzys
目录 0 2016-12-30 10:38 javaWebExcelexceluildclassescomhzysexcel
目录 0 2016-12-30 10:38 javaWebExcelexceluildclassescomhzysexcelaction
文件 8548 2016-10-24 16:09 javaWebExcelexceluildclassescomhzysexcelactionUserAction.class
目录 0 2016-12-30 10:38 javaWebExcelexceluildclassescomhzysexceldao
目录 0 2016-12-30 10:38 javaWebExcelexceluildclassescomhzysexceldaoentity
文件 1183 2016-10-24 16:09 javaWebExcelexceluildclassescomhzysexceldaoentityUserinfo.class
目录 0 2016-12-30 10:38 javaWebExcelexceluildclassescomhzysexceldaomapper
文件 427 2016-10-24 16:09 javaWebExcelexceluildclassescomhzysexceldaomapperUserMapper.class
文件 1443 2015-04-16 14:52 javaWebExcelexceluildclassescomhzysexceldaomapperUserMapper.xml
目录 0 2016-12-30 10:38 javaWebExcelexceluildclassescomhzysexcelservice
文件 303 2016-10-24 16:09 javaWebExcelexceluildclassescomhzysexcelserviceIUserService.class
目录 0 2016-12-30 10:38 javaWebExcelexceluildclassescomhzysexcelservicespring
文件 1156 2016-10-24 16:09 javaWebExcelexceluildclassescomhzysexcelservicespringUserService.class
目录 0 2016-12-30 10:38 javaWebExcelexcelsrc
目录 0 2016-12-30 10:38 javaWebExcelexcelsrccom
目录 0 2016-12-30 10:38 javaWebExcelexcelsrccomhzys
............此处省略118个文件信息
package com.hzys.excel.action;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;
import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import net.sf.json.JSONArray;
import org.apache.commons.io.FileUtils;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellstyle;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.struts2.ServletActionContext;
import org.apache.struts2.convention.annotation.Action;
import org.apache.struts2.convention.annotation.Namespace;
import org.apache.struts2.convention.annotation.ParentPackage;
import org.springframework.context.annotation.Scope;
import org.springframework.stereotype.Controller;
import com.hzys.excel.dao.entity.Userinfo;
import com.hzys.excel.service.IUserService;
import com.opensymphony.xwork2.ActionSupport;
@Controller(“userAction“)
@ParentPackage(“struts-default“)
@Namespace(““)
@Scope(“prototype“)
@Action(“userAction“)
public class UserAction extends ActionSupport {
/**
*
*/
private static final long serialVersionUID = 1L;
@Resource(name=“userService“)
private IUserService userService;
private Userinfo userinfo;
public String xlsFileName;;
public File xls;
public String docContentType;
public File getXls() {
return xls;
}
public void setXls(File xls) {
this.xls = xls;
}
public String getDocContentType() {
return docContentType;
}
public void setDocContentType(String docContentType) {
this.docContentType = docContentType;
}
public Userinfo getUserinfo() {
return userinfo;
}
public void setUserinfo(Userinfo userinfo) {
this.userinfo = userinfo;
}
public String getXlsFileName() {
return xlsFileName;
}
public void setXlsFileName(String xlsFileName) {
this.xlsFileName = xlsFileName;
}
/*
* 查询所有
*/
public String queryall() throws IOException{
HttpServletResponse response=ServletActionContext.getResponse();
response.setContentType(“text/html;charset=utf-8“);
try {
List userlist=userService.queryall();
JSONArray newlist=JSONArray.fromobject(userlist);
response.getWriter().write(newlist.toString());
} catch (Exception e) {
response.getWriter().write(“error“);
}
return null;
}
/*
* 读取excel
*/
public String read() throws Exception IOException{
HttpServletResponse response=ServletActionContext.getResponse();
HttpServletRequest request=ServletActionContext.getRequest();
//获得文件上传的上传目录
String filepath=ServletActionContext.getServletContext().getRealPath(“/filelib“);
//保存文件的文件名称
System.out.println(“文件名字:“+this.getXlsFileName());
String f
属性 大小 日期 时间 名称
----------- --------- ---------- ----- ----
目录 0 2016-12-30 10:38 javaWebExcel
目录 0 2016-12-30 10:38 javaWebExcelexcel
文件 838 2016-10-18 14:33 javaWebExcelexcel.classpath
文件 1038 2015-04-16 14:52 javaWebExcelexcel.project
目录 0 2016-12-30 10:38 javaWebExcelexcel.settings
文件 503 2015-04-16 14:52 javaWebExcelexcel.settings.jsdtscope
文件 364 2016-10-18 14:33 javaWebExcelexcel.settingsorg.eclipse.jdt.core.prefs
文件 467 2015-04-16 14:52 javaWebExcelexcel.settingsorg.eclipse.wst.common.component
文件 345 2015-04-16 14:52 javaWebExcelexcel.settingsorg.eclipse.wst.common.project.facet.core.xm
文件 49 2015-04-16 14:52 javaWebExcelexcel.settingsorg.eclipse.wst.jsdt.ui.superType.container
文件 6 2015-04-16 14:52 javaWebExcelexcel.settingsorg.eclipse.wst.jsdt.ui.superType.name
目录 0 2016-12-30 10:38 javaWebExcelexceluild
目录 0 2016-12-30 10:38 javaWebExcelexceluildclasses
目录 0 2016-12-30 10:38 javaWebExcelexceluildclassescom
目录 0 2016-12-30 10:38 javaWebExcelexceluildclassescomhzys
目录 0 2016-12-30 10:38 javaWebExcelexceluildclassescomhzysexcel
目录 0 2016-12-30 10:38 javaWebExcelexceluildclassescomhzysexcelaction
文件 8548 2016-10-24 16:09 javaWebExcelexceluildclassescomhzysexcelactionUserAction.class
目录 0 2016-12-30 10:38 javaWebExcelexceluildclassescomhzysexceldao
目录 0 2016-12-30 10:38 javaWebExcelexceluildclassescomhzysexceldaoentity
文件 1183 2016-10-24 16:09 javaWebExcelexceluildclassescomhzysexceldaoentityUserinfo.class
目录 0 2016-12-30 10:38 javaWebExcelexceluildclassescomhzysexceldaomapper
文件 427 2016-10-24 16:09 javaWebExcelexceluildclassescomhzysexceldaomapperUserMapper.class
文件 1443 2015-04-16 14:52 javaWebExcelexceluildclassescomhzysexceldaomapperUserMapper.xm
目录 0 2016-12-30 10:38 javaWebExcelexceluildclassescomhzysexcelservice
文件 303 2016-10-24 16:09 javaWebExcelexceluildclassescomhzysexcelserviceIUserService.class
目录 0 2016-12-30 10:38 javaWebExcelexceluildclassescomhzysexcelservicespring
文件 1156 2016-10-24 16:09 javaWebExcelexceluildclassescomhzysexcelservicespringUserService.class
目录 0 2016-12-30 10:38 javaWebExcelexcelsrc
目录 0 2016-12-30 10:38 javaWebExcelexcelsrccom
目录 0 2016-12-30 10:38 javaWebExcelexcelsrccomhzys
............此处省略118个文件信息
版权声明:本文内容由互联网用户自发贡献,该文观点仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容, 请发送邮件举报,一经查实,本站将立刻删除。
评论列表(条)