java导出csv格式文件的方法

本文实例为大家分享了java导出csv格式文件的具体代码，供大家参考，具体内容如下

导出csv格式文件的本质是导出以逗号为分隔的文本数据

import java.io.BufferedWriter; 
import java.io.File; 
import java.io.FileInputStream; 
import java.io.FileNotFoundException; 
import java.io.FileOutputStream; 
import java.io.IOException; 
import java.io.InputStream; 
import java.io.OutputStream; 
import java.io.OutputStreamWriter; 
import java.net.URLEncoder; 
import java.util.ArrayList; 
import java.util.Iterator; 
import java.util.linkedHashMap; 
import java.util.List; 
import java.util.Map; 

import javax.servlet.http.HttpServletResponse; 

import com.alibaba.druid.util.StringUtils;
 

 
 
public class CSVUtils { 
 
 
 
 public static String getBOM() {

   byte b[] = {(byte)0xEF, (byte)0xBB, (byte)0xBF};
   return new String(b);
 }
 
  
 @SuppressWarnings("rawtypes") 
 public static File createCSVFile(List exportData, linkedHashMap map, String outPutPath, 
     String fileName) { 
 File csvFile = null; 
 BufferedWriter csvFileOutputStream = null; 
 try { 
  File file = new File(outPutPath); 
  if (!file.exists()) { 
  file.mkdirs(); 
  } 
  //定义文件名格式并创建 
  csvFile =new File(outPutPath+fileName+".csv");
  file.createNewFile(); 
  // UTF-8使正确读取分隔符"," 
  //如果生产文件乱码，windows下用gbk，linux用UTF-8
  csvFileOutputStream = new BufferedWriter(new OutputStreamWriter(new FileOutputStream( 
  csvFile), "UTF-8"), 1024); 
  
  //写入前段字节流，防止乱码
  csvFileOutputStream.write(getBOM());
  // 写入文件头部
  for (Iterator propertyIterator = map.entrySet().iterator(); propertyIterator.hasNext();) { 
  java.util.Map.Entry propertyEntry = (java.util.Map.Entry) propertyIterator.next(); 
  csvFileOutputStream.write((String) propertyEntry.getValue() != null ? (String) propertyEntry.getValue() : "" ); 
  if (propertyIterator.hasNext()) { 
   csvFileOutputStream.write(","); 
  } 
  } 
  csvFileOutputStream.newline(); 
  // 写入文件内容 
  for (Iterator iterator = exportData.iterator(); iterator.hasNext();) { 
   Object row = (Object) iterator.next();
  for (Iterator propertyIterator = map.entrySet().iterator(); propertyIterator 
   .hasNext();) { 
   java.util.Map.Entry propertyEntry = (java.util.Map.Entry) propertyIterator 
   .next(); 
   String str=row!=null?((String)((Map)row).get( propertyEntry.getKey())):"";

   if(StringUtils.isEmpty(str)){
    str="";
   }else{
    str=str.replaceAll(""","""");
    if(str.indexOf(",")>=0){
     str="""+str+""";
    }
   }
   csvFileOutputStream.write(str); 
   if (propertyIterator.hasNext()) { 
   csvFileOutputStream.write(","); 
   } 
  } 
  if (iterator.hasNext()) { 
   csvFileOutputStream.newline(); 
  } 
  } 
  csvFileOutputStream.flush(); 
 } catch (Exception e) { 
  e.printStackTrace(); 
 } finally { 
  try { 
  csvFileOutputStream.close(); 
  } catch (IOException e) { 
  e.printStackTrace(); 
  } 
 } 
 return csvFile; 
 } 
 
 
 @SuppressWarnings("rawtypes")
 public static void exportDataFile(HttpServletResponse response,List exportData, linkedHashMap map, String outPutPath,String fileName) throws IOException{
  File csvFile = null; 
  BufferedWriter csvFileOutputStream = null; 
  try { 
   File file = new File(outPutPath); 
   if (!file.exists()) { 
   file.mkdirs(); 
   } 
   //定义文件名格式并创建 
   csvFile =new File(outPutPath+fileName+".csv");
   if(csvFile.exists()){
    csvFile.delete(); 
   }
   csvFile.createNewFile(); 
   // UTF-8使正确读取分隔符"," 
   //如果生产文件乱码，windows下用gbk，linux用UTF-8
   csvFileOutputStream = new BufferedWriter(new OutputStreamWriter(new FileOutputStream(csvFile), "UTF-8"), 1024); 
   //写入前段字节流，防止乱码
   csvFileOutputStream.write(getBOM());
   // 写入文件头部 
   for (Iterator propertyIterator = map.entrySet().iterator(); propertyIterator.hasNext();) { 
   java.util.Map.Entry propertyEntry = (java.util.Map.Entry) propertyIterator.next(); 
   csvFileOutputStream.write((String) propertyEntry.getValue() != null ? (String) propertyEntry.getValue() : "" ); 
   if (propertyIterator.hasNext()) { 
    csvFileOutputStream.write(","); 
   } 
   } 
   csvFileOutputStream.newline(); 
   // 写入文件内容 
   for (Iterator iterator = exportData.iterator(); iterator.hasNext();) { 
   Object row = (Object) iterator.next(); 
   for (Iterator propertyIterator = map.entrySet().iterator(); propertyIterator 
    .hasNext();) { 
    java.util.Map.Entry propertyEntry = (java.util.Map.Entry) propertyIterator 
    .next(); 
    String str=row!=null?((String)((Map)row).get( propertyEntry.getKey())):"";
    if(StringUtils.isEmpty(str)){
     str="";
    }else{
     str=str.replaceAll(""","""");
     if(str.indexOf(",")>=0){
      str="""+str+""";
     }
    }
    csvFileOutputStream.write(str); 
    if (propertyIterator.hasNext()) { 
    csvFileOutputStream.write(","); 
    } 
   } 
   if (iterator.hasNext()) { 
    csvFileOutputStream.newline(); 
   } 
   } 
   csvFileOutputStream.flush(); 
  } catch (Exception e) { 
   e.printStackTrace(); 
  } finally { 
   try { 
   csvFileOutputStream.close(); 
   } catch (IOException e) { 
   e.printStackTrace(); 
   } 
  } 
  
  
  
  
  InputStream in = null; 
  try { 
   in = new FileInputStream(outPutPath+fileName+".csv"); 
   int len = 0; 
   byte[] buffer = new byte[1024]; 
   
   OutputStream out = response.getOutputStream(); 
   response.reset(); 
   
   response.setContentType("application/csv;charset=UTF-8"); 
   response.setHeader("Content-Disposition","attachment; filename=" + URLEncoder.encode(fileName+".csv", "UTF-8")); 
   response.setCharacterEncoding("UTF-8"); 
   while ((len = in.read(buffer)) > 0) { 
   out.write(new byte[] { (byte) 0xEF, (byte) 0xBB, (byte) 0xBF }); 
   out.write(buffer, 0, len); 
   }
   out.close();
  } catch (FileNotFoundException e) { 
  } finally { 
   if (in != null) { 
   try { 
    in.close(); 
   } catch (Exception e) { 
    throw new RuntimeException(e); 
   } 
   } 
  }
  
 }
 
  
 public static void deleteFiles(String filePath) { 
 File file = new File(filePath); 
 if (file.exists()) { 
  File[] files = file.listFiles(); 
  for (int i = 0; i < files.length; i++) { 
  if (files[i].isFile()) { 
   files[i].delete(); 
  } 
  } 
 } 
 } 
 
  
 public static void deleteFile(String filePath, String fileName) { 
 File file = new File(filePath); 
 if (file.exists()) { 
  File[] files = file.listFiles(); 
  for (int i = 0; i < files.length; i++) { 
  if (files[i].isFile()) { 
   if (files[i].getName().equals(fileName)) { 
   files[i].delete(); 
   return; 
   } 
  } 
  } 
 } 
 } 
 
  
 @SuppressWarnings({ "rawtypes", "unchecked" }) 
 public static void main(String[] args) { 
 List exportData = new ArrayList

以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持考高分网。