package com.cdel.portal.stage.appointment.util;
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.io.PrintWriter;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import javax.servlet.http.HttpServletResponse;
import com.cdel.portal.stage.appointment.entity.AppointmentSign;
import com.cdel.portal.stage.appointment.entity.MemberAccTicket;
/**
* csv 导出工具类
* @author zhangheng
* @date 2017年7月7日下午1:27:07
*/
public class CSVUtils {
/**
* 导出签到信息
* @date 2017年7月7日下午1:27:07
* @param response
* @param courseOrders
*/
public static void exportCvs(HttpServletResponse response ,List<AppointmentSign> appointmentSigns){
try {
response.reset();
response.setContentType("application/csv;charset=GBK");
response.setHeader("Content-Disposition",
"attachment;filename=Sign.csv");
response.setCharacterEncoding("GBK");
PrintWriter out = response.getWriter();
out.print("姓名,联系电话,听课城市,签到时间 \r");
for (AppointmentSign appointmentSign:appointmentSigns) {
Date createDate =appointmentSign.getAppointmentTime();
String date ="";
if(createDate!=null){
SimpleDateFormat sdf =new SimpleDateFormat("yyyy-MM-dd");
date =sdf.format(createDate);
}
String str = "\t"+appointmentSign.getUserName()+" ,"
+"\t"+appointmentSign.getPhone()+" ,"
+"\t"+appointmentSign.getCityName()+" ,"
+"\t"+date;
str = str.replace("null", "");
out.print(str+"\r");
}
out.flush();
out.close();
} catch (Exception e) {
e.printStackTrace();
}
}
public static void exportCvs1(HttpServletResponse response ,List<MemberAccTicket> memberAccTickets){
try {
response.reset();
response.setContentType("application/csv;charset=GBK");
response.setHeader("Content-Disposition",
"attachment;filename=AppointMent.csv");
response.setCharacterEncoding("GBK");
PrintWriter out = response.getWriter();
out.print("姓名,联系电话,听课城市,签到时间 \r");
for (MemberAccTicket memberAccTicket:memberAccTickets) {
Date createDate =memberAccTicket.getCreateDate();
String date ="";
if(createDate!=null){
SimpleDateFormat sdf =new SimpleDateFormat("yyyy-MM-dd");
date =sdf.format(createDate);
}
String str = "\t"+memberAccTicket.getUserName()+" ,"
+"\t"+memberAccTicket.getMobile()+" ,"
+"\t"+memberAccTicket.getCityName()+" ,"
+"\t"+date;
str = str.replace("null", "");
out.print(str+"\r");
}
out.flush();
out.close();
} catch (Exception e) {
e.printStackTrace();
}
}
public static void exportCvs2(HttpServletResponse response ,List<MemberAccTicket> memberAccTickets){
try {
response.reset();
response.setContentType("application/csv;charset=GBK");
response.setHeader("Content-Disposition",
"attachment;filename=AppointMent.csv");
response.setCharacterEncoding("GBK");
PrintWriter out = response.getWriter();
out.print("姓名,联系电话,听课城市,QQ,签到时间 \r");
for (MemberAccTicket memberAccTicket:memberAccTickets) {
Date createDate =memberAccTicket.getCreateDate();
String date ="";
if(createDate!=null){
SimpleDateFormat sdf =new SimpleDateFormat("yyyy-MM-dd");
date =sdf.format(createDate);
}
String str = "\t"+memberAccTicket.getUserName()+" ,"
+"\t"+memberAccTicket.getMobile()+" ,"
+"\t"+memberAccTicket.getCityName()+" ,"
+"\t"+memberAccTicket.getEmail()+" ,"
+"\t"+date;
str = str.replace("null", "");
out.print(str+"\r");
}
out.flush();
out.close();
} catch (Exception e) {
e.printStackTrace();
}
}
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;
}
}
CSV导出使用实例
最新推荐文章于 2021-05-07 18:57:38 发布