java web导出csv文件中文乱码问题解决

今天用java web 导出csv文件时,导出的csv文件内容乱码.  之前因为过滤器一直用utf-8,最后在代码中设置ContentType时试了下gbk居然没乱码了. 

猜想大概原因是本地打开的格式为gbk吧.

 

相关代码:

import java.io.IOException;
import java.net.URLEncoder;
import java.util.Date;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.itheima.domain.Sale;
import com.itheima.factory.BasicFactory;
import com.itheima.service.OrderService;

public class SaleListServlet extends HttpServlet {

	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		String fileName = new String(
				("销售榜单_" + new Date().toLocaleString() + ".csv").getBytes("GBK"),
				"ISO-8859-1");
		//下面这段必须放在Writer前,否则还是乱码
		response.setContentType(this.getServletContext().getMimeType(fileName) + ";charset=gbk");
		// response.setContentType("application/csv;charset=gbk");
		// 获取销售榜单
		OrderService service = BasicFactory.getFactory().getInstance(OrderService.class);
		List<Sale> saleList = service.getSaleList();

		// 生成数据
		StringBuffer buffer = new StringBuffer();
		buffer.append("商品id,商品名称,销售数量\r\n");
		for (Sale sale : saleList) {
			buffer.append(sale.getId() + "," + sale.getName() + "," + sale.getSalenum() + "\r\n");
		}
		String str = buffer.toString();
		response.getWriter().write(str);

		// 提供下载

		response.setHeader("Content-disposition", "attachment;filename=" + fileName);

	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		doGet(request, response);

	}

}