struts2 上传 excel 的 csv 文件

jsp

<s:form action="uploadaction" method="post" enctype="multipart/form-data" >

   <s:file label="上传" theme="simple" name="execl"/>

   <s:submit value="上传"/>

</s:form>

action

package com.baishiji.action.taskmenu;

import java.io.File;
import java.util.List;

import org.apache.struts2.ServletActionContext;

import com.baishiji.bean.CaseInfo;
import com.opensymphony.xwork2.ActionSupport;

public class ImportCSAction  extends ActionSupport{
private	File excel;

	@Override
	public String execute() throws Exception {
		System.out.print(excel);
		 // 将客户端的文件上传到服务端  
         String desPath = ServletActionContext.getServletContext().getRealPath(  
                 "/temp");  
      System.out.print(desPath);
		List<String>   list =   CSVUtils.importCsv(excel);
		for(int i=0;i<list.size();i++){
			System.out.println(list.get(i));
		}
		return "result";
	}

	public File getExcel() {
		return excel;
	}

	public void setExcel(File excel) {
		this.excel = excel;
	}




	
	
}

CSVUtils

package com.baishiji.action.taskmenu;


import java.io.BufferedReader;
import java.io.BufferedWriter;
import java.io.File;
import java.io.FileOutputStream;
import java.io.FileReader;
import java.io.IOException;
import java.io.OutputStreamWriter;
import java.util.ArrayList;
import java.util.List;

/**   
 * CSV操作(导出和导入)
 *
 * @author  
 * @version  
 */
public class CSVUtils {
    
    /**
     * 导出
     * 
     * @param file csv文件(路径+文件名)，csv文件不存在会自动创建
     * @param dataList 数据
     * @return
     */
    public static boolean exportCsv(File file, List<String> dataList){
        boolean isSucess=false;
        
        FileOutputStream out=null;
        OutputStreamWriter osw=null;
        BufferedWriter bw=null;
        try {
            out = new FileOutputStream(file);
            osw = new OutputStreamWriter(out);
            bw =new BufferedWriter(osw);
            if(dataList!=null && !dataList.isEmpty()){
                for(String data : dataList){
                    bw.append(data).append("\r");
                }
            }
            isSucess=true;
        } catch (Exception e) {
            isSucess=false;
        }finally{
            if(bw!=null){
                try {
                    bw.close();
                    bw=null;
                } catch (IOException e) {
                    e.printStackTrace();
                } 
            }
            if(osw!=null){
                try {
                    osw.close();
                    osw=null;
                } catch (IOException e) {
                    e.printStackTrace();
                } 
            }
            if(out!=null){
                try {
                    out.close();
                    out=null;
                } catch (IOException e) {
                    e.printStackTrace();
                } 
            }
        }
        
        return isSucess;
    }
    
    /**
     * 导入
     * 
     * @param file csv文件(路径+文件)
     * @return
     */
    public static List<String> importCsv(File file){
        List<String> dataList=new ArrayList<String>();
        
        BufferedReader br=null;
        try { 
            br = new BufferedReader(new FileReader(file));
            String line = ""; 
            while ((line = br.readLine()) != null) { 
                dataList.add(line);
            }
        }catch (Exception e) {
        }finally{
            if(br!=null){
                try {
                    br.close();
                    br=null;
                } catch (IOException e) {
                    e.printStackTrace();
                }
            }
        }
 
        return dataList;
    }
}