Java 导出 CSV详解编程语言

package com.cib.cap4j.cfn.util; 
 
import java.io.BufferedWriter; 
import java.io.File; 
import java.io.FileOutputStream; 
import java.io.IOException; 
import java.io.OutputStreamWriter; 
import java.util.List; 
 
/** 
 *  
 * CSV文件导出工具类 
 *  
 * Created on 2014-08-07 
 * @author  
 * @reviewer  
 */ 
public class CSVUtils { 
 
    /** 
     * CSV文件生成方法 
     * @param head 
     * @param dataList 
     * @param outPutPath 
     * @param filename 
     * @return 
     */ 
    public static File createCSVFile(List<Object> head, List<List<Object>> dataList, 
            String outPutPath, String filename) { 
 
        File csvFile = null; 
        BufferedWriter csvWtriter = null; 
        try { 
            csvFile = new File(outPutPath + File.separator + filename + ".csv"); 
            File parent = csvFile.getParentFile(); 
            if (parent != null && !parent.exists()) { 
                parent.mkdirs(); 
            } 
            csvFile.createNewFile(); 
 
            // GB2312使正确读取分隔符"," 
            csvWtriter = new BufferedWriter(new OutputStreamWriter(new FileOutputStream( 
                    csvFile), "GB2312"), 1024); 
            // 写入文件头部 
            writeRow(head, csvWtriter); 
 
            // 写入文件内容 
            for (List<Object> row : dataList) { 
                writeRow(row, csvWtriter); 
            } 
            csvWtriter.flush(); 
        } catch (Exception e) { 
            e.printStackTrace(); 
        } finally { 
            try { 
                csvWtriter.close(); 
            } catch (IOException e) { 
                e.printStackTrace(); 
            } 
        } 
        return csvFile; 
    } 
 
    /** 
     * 写一行数据方法 
     * @param row 
     * @param csvWriter 
     * @throws IOException 
     */ 
    private static void writeRow(List<Object> row, BufferedWriter csvWriter) throws IOException { 
        // 写入文件头部 
        for (Object data : row) { 
            StringBuffer sb = new StringBuffer(); 
            String rowStr = sb.append("/"").append(data).append("/",").toString(); 
            csvWriter.write(rowStr); 
        } 
        csvWriter.newLine(); 
    } 
}

public @ResponseBody void exportExcel(HttpServletRequest request, HttpServletResponse response, KhxxCxVO vo) throws IOException{ 
File csvFile = createCSVFile(request,vo); 
BufferedInputStream bis = null; 
BufferedOutputStream bos = null; 
response.setHeader("Content-disposition", "attachment; filename=" + URLEncoder.encode(csvFile.getName(), "UTF-8")); 
response.setHeader("Content-Length", String.valueOf(csvFile.length())); 
bis = new BufferedInputStream(new FileInputStream(csvFile)); 
bos = new BufferedOutputStream(response.getOutputStream()); 
byte[] buff = new byte[2048]; 
while (true) { 
int bytesRead; 
if (-1 == (bytesRead = bis.read(buff, 0, buff.length))) break; 
bos.write(buff, 0, bytesRead); 
} 
bis.close(); 
bos.close(); 
} 
public File createCSVFile(HttpServletRequest request,KhxxCxVO vo){ 
vo.setKhxm(StringUtil.formatDbLikeValue(vo.getKhxm())); 
String yybh = ContextUtil.getLoginUser().getUserId(); 
String cur_ssjg = ContextUtil.getLoginUser().getUserUnit(); 
String unitPath = ContextUtil.getLoginUser().getUnitPath(); 
IPStaffVO staff = ipStaffService.findStaffByKey(yybh); 
String yhlx = staff.getYhlx(); 
if((!cur_ssjg.equals(unitPath)) && yhlx.equals("2")){ 
vo.setCur_path(StringUtil.formatDbLeftLikeValue(unitPath.trim())); 
}else if(yhlx.equals("1")){ 
vo.setCur_ssjg(cur_ssjg.trim()); 
} 
// 设置表格头 
Object[] head = {"客户姓名", "证件类型", "证件号码", "银行账号", "理财账号", "客户类型", "风险等级", "归属状况", "归属机构", "客户经理", "营销比例(%)" }; 
List<Object> headList = Arrays.asList(head); 
List<KhxxCxVO> list = iKhxxCxService.findAllInfos(vo, Integer.MAX_VALUE, 0); 
// 码表取出证件类型 
Map<String, String> zjlx_map = new HashMap<String, String>(); 
List<IPCodeInfoVO> zjlx_list = directoryService.findInfoListByTypeCode("zjlx", null); 
if ((zjlx_list != null) && (zjlx_list.size() > 0)){ 
for (Iterator i$ = zjlx_list.iterator(); i$.hasNext(); ) {  
IPCodeInfoVO ipci_vo = (IPCodeInfoVO)i$.next(); 
zjlx_map.put(ipci_vo.getMblxbh(), ipci_vo.getMbtmz()); 
} 
} 
Map<String, String> khlx_map = new HashMap<String, String>(); 
List<IPCodeInfoVO> khlx_list = directoryService.findInfoListByTypeCode("khlx", null); 
if ((khlx_list != null) && (khlx_list.size() > 0)){ 
for (Iterator i$ = khlx_list.iterator(); i$.hasNext(); ) {  
IPCodeInfoVO ipci_vo = (IPCodeInfoVO)i$.next(); 
khlx_map.put(ipci_vo.getMblxbh(), ipci_vo.getMbtmz()); 
} 
} 
Map<String, String> fxdj_map = new HashMap<String, String>(); 
List<IPCodeInfoVO> fxdj_list = directoryService.findInfoListByTypeCode("fxdj", null); 
if ((fxdj_list != null) && (fxdj_list.size() > 0)){ 
for (Iterator i$ = fxdj_list.iterator(); i$.hasNext(); ) {  
IPCodeInfoVO ipci_vo = (IPCodeInfoVO)i$.next(); 
fxdj_map.put(ipci_vo.getMblxbh(), ipci_vo.getMbtmz()); 
} 
} 
Map<String, String> gszk_map = new HashMap<String, String>(); 
List<IPCodeInfoVO> gszk_list = directoryService.findInfoListByTypeCode("gszk", null); 
if ((gszk_list != null) && (gszk_list.size() > 0)){ 
for (Iterator i$ = gszk_list.iterator(); i$.hasNext(); ) {  
IPCodeInfoVO ipci_vo = (IPCodeInfoVO)i$.next(); 
gszk_map.put(ipci_vo.getMblxbh(), ipci_vo.getMbtmz()); 
} 
} 
// 设置数据 
List<List<Object>> dataList = new ArrayList<List<Object>>(); 
List<Object> rowList = null; 
for (int i = 0; i < list.size(); i++) { 
rowList = new ArrayList<Object>(); 
KhxxCxVO kc_vo = list.get(i); 
//rowList.add(i + 1); 
                rowList.add(kc_vo.getKhxm()); 
rowList.add(StringUtil.nullToSpace(zjlx_map.get(kc_vo.getZjlx().trim()))); 
//                String zjhm= kc_vo.getZjhm(); 
//                System.out.println("zjhm----------"+zjhm); 
//                DecimalFormat df = new DecimalFormat("#");//转换成整型 
//                String zjhm_2 = df.format(zjhm); 
//                System.out.println("zjhm2----------"+zjhm_2); 
//                String zjhm_str = String.format("%.0f",kc_vo.getZjhm()); 
//                System.out.println("zjhmstr----------"+zjhm_str); 
                 
rowList.add(kc_vo.getZjhm()); 
rowList.add(kc_vo.getZhdh()); 
rowList.add(kc_vo.getLczh()); 
rowList.add(StringUtil.nullToSpace(khlx_map.get(kc_vo.getKhlx().trim()))); 
rowList.add(StringUtil.nullToSpace(fxdj_map.get(kc_vo.getFxdj().trim()))); 
rowList.add(StringUtil.nullToSpace(gszk_map.get(kc_vo.getGszk().trim()))); 
rowList.add(kc_vo.getGsjgmc()); 
rowList.add(kc_vo.getGsjl()); 
rowList.add(kc_vo.getYxbl()); 
//String cjsj = DateTimeUtil.formatDateTime(kc_vo.getCjsj()); 
//rowList.add(cjsj); 
                dataList.add(rowList); 
} 
// 导出文件路径 
String downloadFilePath = "C:" + File.separator + "cap4j" + File.separator + "download" + File.separator; 
IPCodeInfoVO codeInfoVO = directoryService.findInfoByTypeCodeAndInfoCode( 
CFNConstants.PLATFORM_CONFIG, CFNConstants.PLATFORM_CONFIG_DOWNLOAD_PATH); 
if (codeInfoVO != null && !StringUtils.isEmpty(codeInfoVO.getMbtmz())) { 
downloadFilePath = codeInfoVO.getMbtmz(); 
} 
//            String downloadFilePath = request.getSession().getServletContext().getRealPath("/exportload"); 
// 导出文件名称 
String datetimeStr = DateTimeUtil.formatDate(new Date(), "yyyyMMddHHmmss"); 
String fileName = "客户列表_" + datetimeStr; 
//            String fileName = ""; 
//            try { 
//                fileName = URLDecoder.decode("khxxCx_list","utf-8"); 
//            } catch (Exception e) { 
//                e.printStackTrace(); 
//            } 
// 导出CSV文件 
File csvFile = CSVUtils.createCSVFile(headList, dataList, downloadFilePath, fileName); 
return csvFile; 
}

// Excel导出 
function exportExcel(e) { 
// csv导出 
var params = ""; 
params += "khxm=" + $J.getbyName("khxm").getValue(); 
params += "&zjlx=" + $J.getbyName("zjlx").getValue(); 
params += "&zjhm=" + $J.getbyName("zjhm").getValue(); 
params += "&sjhm=" + $J.getbyName("sjhm").getValue(); 
params += "&khlx=" + $J.getbyName("khlx").getValue(); 
params += "&fxdj=" + $J.getbyName("fxdj").getValue(); 
params += "&zhdh=" + $J.getbyName("zhdh").getValue(); 
params += "&lczh=" + $J.getbyName("lczh").getValue(); 
params += "&gsjg=" + $J.getbyName("gsjg").getValue(); 
params += "&gsjl=" + $J.getbyName("gsjl").getValue(); 
params += "&gszk=" + $J.getbyName("gszk").getValue(); 
params += "&yxbl=" + $J.getbyName("yxbl").getValue(); 
window.location = "<%= request.getContextPath() %>/khxxCx/exportExcel.do?" + params; 
}