fileupload 上传execl文件的一些操作

OABaseReadExeclDataAction .class

包含创建临时文件目录,基本校验，取属性值，处理乱码，基类

这里在上传文件是execl并且需要读取的话，需要把fileitem对象转换成file,处理方式是创建临时目录，用流写入到一个临时

目录中

1. package com.dadi.oa.web.action;
3. import java.io.File;
4. import java.util.HashMap;
5. import java.util.Iterator;
6. import java.util.List;
7. import java.util.Map;
9. import javax.servlet.http.HttpServletRequest;
10. import javax.servlet.http.HttpServletResponse;
12. import org.apache.commons.fileupload.FileItem;
13. import org.apache.commons.fileupload.FileUpload;
14. import org.apache.commons.fileupload.servlet.ServletFileUpload;
15. import org.apache.commons.fileupload.servlet.ServletRequestContext;
16. import org.apache.commons.io.FilenameUtils;
17. import org.apache.commons.logging.Log;
18. import org.apache.commons.logging.LogFactory;
19. import org.apache.struts.action.ActionForm;
20. import org.apache.struts.action.ActionForward;
21. import org.apache.struts.action.ActionMapping;
22. import org.springframework.web.context.WebApplicationContext;
23. import org.springframework.web.context.support.WebApplicationContextUtils;
25. import com.dadi.oa.pojo.Users;
26. import com.dadi.oa.service.ReadExeclDataService;
27. import com.dadi.oa.system.ConstantsUtil;
28. import com.dadi.oa.util.RequestUtil;
29. import com.dadi.oa.util.StringUtil;
30. import com.dadi.oa.util.UploadUtil;
32. /**
33. * 读取execl action基类，处理一些通用操作
34. * @author ao.ouyang
35. *
36. */
37. public class OABaseReadExeclDataAction extends OABaseAction {
38. private Log logger = LogFactory.getLog(this.getClass());
39. protected ReadExeclDataService readExeclDataService;
40. //默认读取execl的临时目录
41. protected String tempReadExeclDir;
42. //封装了form表单属性的集合
43. protected Map<String,String> formFieldItems;
44. protected File readExeclFile;
45. private File tempDirectoryFile;
48. public void setReadExeclDataService(ReadExeclDataService readExeclDataService) {
49. this.readExeclDataService = readExeclDataService;
50. }
53. public void setTempReadExeclDir(String tempReadExeclDir) {
54. this.tempReadExeclDir = tempReadExeclDir;
55. }
58. /**
59. * 初始化临时文件目录
60. */
61. public void initDir(){
62. formFieldItems = new HashMap<String, String>();
63. String nativeWebAppFoldPath =((WebApplicationContext)ConstantsUtil.beanFactory).getServletContext().getRealPath("/");
64. tempDirectoryFile = new File(nativeWebAppFoldPath + tempReadExeclDir);
65. // 文件夹不存在就自动创建
66. if (!tempDirectoryFile.isDirectory()) {
67. tempDirectoryFile.mkdirs();
68. }
69. }
71. @Override
72. protected ActionForward dispatchMethod(ActionMapping mapping,
73. ActionForm form, HttpServletRequest request,
74. HttpServletResponse response, String name) throws Exception {
75. // TODO Auto-generated method stub
76. String resultStr=processFileUpload(request);
77. if(!resultStr.equalsIgnoreCase("success")){
78. request.setAttribute("info",resultStr);
79. request.setAttribute("closepage", "yes");
80. return mapping.findForward("oapromptinfo");
81. }
82. return super.dispatchMethod(mapping, form, request, response, name);
83. }
85. /**
86. * 处理请求文件
87. * @param request
88. * @return
89. */
90. public String processFileUpload(HttpServletRequest request) throws Exception {
91. String resultStr = "success";
92. try {
93. if(!FileUpload.isMultipartContent(new ServletRequestContext(request))){
94. throw new Exception("操作异常，请重新再试！！！");
95. }
96. ServletFileUpload fileUpload = UploadUtil.getFileUploadObject(10);
97. List fileItems = null;
98. FileItem readItem = null;
99. fileItems = fileUpload.parseRequest(request);
100. for (Iterator it = fileItems.iterator(); it.hasNext();) {
101. FileItem item = (FileItem) it.next();
102. if (!item.isFormField()) {
103. readItem = item;
104. }else{
105. formFieldItems.put(item.getFieldName(),item.getString("UTF-8"));
106. }
108. }
109. //校验文件
110. checkExecl(readItem);
111. try {
112. readExeclFile = new File(tempDirectoryFile.getAbsolutePath(), readItem.getName().substring(readItem.getName().lastIndexOf("\\")+1));
113. readItem.write(readExeclFile);
114. readItem.delete();
115. } catch (Exception e) {
116. e.printStackTrace();
117. throw new Exception("文件转换异常，请检查！！！");
118. }
119. } catch (Exception e) {
120. e.printStackTrace();
121. resultStr=e.getMessage();
122. logger.info("================ERROR:OABaseReadExeclDataAction.executeSub()"+e.getMessage());
123. }
124. return resultStr;
125. }
127. /**
128. * 校验文件
129. * @throws Exception
130. */
131. private void checkExecl(FileItem readItem) throws Exception{
132. logger.info("==========OABaseReadExeclDataAction.checkExecl() begin===========");
133. String inputFileName = readItem.getName();
134. long inputFileSize = readItem.getSize();
135. if(StringUtil.isEmptyString(inputFileName)){
136. throw new Exception("系统找不到文件,请确定文件路径！！！");
137. }
138. if(!(inputFileSize > 0)){
139. throw new Exception("系统找不到文件或文件没有内容！！！");
140. }
141. String inputFileExtension = FilenameUtils.getExtension(inputFileName).toLowerCase();
142. if("".equalsIgnoreCase(inputFileExtension)){
143. throw new Exception("文件无后缀名,请选择正确的文件上传！！！");
144. }
145. if("xls,xlsx".indexOf(inputFileExtension)<0){
146. throw new Exception("请上传execl文档格式,格式如：xls,xlxs；请选择正确的文件上传！！！");
147. }
148. logger.info("===========OABaseReadExeclDataAction.checkExecl() end===========");
149. }
157. }