csv.java

java版源代码,里面包含很多源代码,大家可以看看.

package com.trulytech.mantis.util;

import javax.servlet.http.*;
import java.util.ArrayList;
import com.trulytech.mantis.system.*;
import com.trulytech.mantis.result.*;
import java.io.FileWriter;

/**
 * <p>Title: CSV控制类</p>
 * <p>Description: CSV控制类</p>
 * <p>Copyright: Copyright (c) 2002</p>
 * <p>Company: </p>
 * @author wangxian
 * @version 1.2
 */

public class CSV {

  static final private String CONTENT_TYPE = "text/csv; charset=GBK";

  public CSV() {
  }

  /**
   * 生成CSV文件输出
   * @return String
   * @param Result 结果集
   * @param response 响应 如果是httpservletresponse,则直接输出到response中,如果是string,则输出到文件名为response的文件中
   * @throws Exception 例外
   */
  public static String makeCSV(Object response,
                             com.trulytech.mantis.result.DBResult Result) throws
      Exception {
    //写日志
    logWriter.Info("开始创建CSV信息");

    int i = 0;
    int j = 0;
    java.io.Writer out = null;
    if (response instanceof HttpServletResponse) {


      ( (HttpServletResponse) response).setContentType(CONTENT_TYPE);
      ( (HttpServletResponse) response).setHeader("Content-Disposition",
                                                  " filename=data.csv");

      out = ( (HttpServletResponse) response).getWriter();
    }
    else {
      out = new FileWriter( (String) response);

    }
    StringBuffer buffer = new StringBuffer();
    try {
      int nSize=Result.ResultBuffer.size();
      for (i = 0; i < nSize; i++) {
        ArrayList rec = (ArrayList) Result.ResultBuffer.get(i);
        buffer.delete(0, buffer.length());
        for (j = 0; j < rec.size(); j++) {
          if (j < (rec.size() - 1)) {
            buffer.append( ( (DBColumn) rec.get(j)).Value);
            buffer.append(",");
          }
          else {
            buffer.append( ( (DBColumn) rec.get(j)).Value);

          }
        }
        if (i < (Result.ResultBuffer.size() - 1))
          out.write(buffer.toString() + "\n");
        else
          out.write(buffer.toString());
      }
      return "";
    }
    finally {
      out.flush();
      out.close();
    }

  }
}