对象存储cos 下载csv

最新推荐文章于 2023-05-24 17:39:06 发布

x1321362731

最新推荐文章于 2023-05-24 17:39:06 发布

阅读量1.3k

点赞数

文章标签：腾讯云cos 对象存储cos ssm 整合对象存储cos ssm csv下载

本文链接：https://blog.csdn.net/x1321362731/article/details/79454999

版权

pom.xml

		<cos.sdk.version>2.0.1</cos.sdk.version>
		<cos.api.version>5.2.4</cos.api.version>
		<commons-beanutils.version>1.9.3</commons-beanutils.version>
		<commons-lang3.version>3.3.2</commons-lang3.version>
		<commons-io.version>1.3.2</commons-io.version>
		<commons-net.version>3.3</commons-net.version>
                <commons-fileupload.version>1.3.1</commons-fileupload.version>

工具类：

package com.custom.common.utils;

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.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.LinkedHashMap;
import java.util.List;
import java.util.Map;

import javax.servlet.http.HttpServletResponse;

import org.apache.commons.beanutils.BeanUtils;

import com.qcloud.cos.COSClient;
import com.qcloud.cos.ClientConfig;
import com.qcloud.cos.auth.BasicCOSCredentials;
import com.qcloud.cos.auth.COSCredentials;
import com.qcloud.cos.exception.CosClientException;
import com.qcloud.cos.exception.CosServiceException;
import com.qcloud.cos.model.PutObjectRequest;
import com.qcloud.cos.model.PutObjectResult;
import com.qcloud.cos.region.Region;

/**
 * 文件操作
 */
public class CSV {

	/**
	 * 生成为CVS文件
	 *
	 * @param exportData
	 *            源数据List
	 * @param map
	 *            csv文件的列表头map
	 * @param outPutPath
	 *            文件路径
	 * @param fileName
	 *            文件名称
	 * @return
	 */
	@SuppressWarnings("rawtypes")
	public static File createCSVFile(List<Map<String, String>> exportData, LinkedHashMap<String, String> map,
			String outPutPath, String fileName) {
		File csvFile = null;
		BufferedWriter csvFileOutputStream = null;
		try {
			File file = new File(outPutPath);
			if (!file.exists()) {
				file.mkdir();
			}
			// 定义文件名格式并创建
			csvFile = File.createTempFile(fileName, ".csv", new File(outPutPath));
			// System.out.println("csvFile：" + csvFile);
			// UTF-8使正确读取分隔符","
			csvFileOutputStream = new BufferedWriter(new OutputStreamWriter(new FileOutputStream(csvFile), "GBK"),
					1024);

			// System.out.println("csvFileOutputStream：" + csvFileOutputStream);
			// ----------------------------------------------------------------
			// 竖着排列标题
            // 写入文件头部
            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() : "" + "");
                csvFileOutputStream.write(",");
                for (Iterator<Map<String, String>> iterator = exportData.iterator(); iterator.hasNext();) {
                    Object row = iterator.next();
                    csvFileOutputStream.write((String) BeanUtils.getProperty(row, (String) propertyEntry.getKey()));
                    if (iterator.hasNext()) {
                        csvFileOutputStream.newLine();
                    }
                    csvFileOutputStream.flush();
                }

                csvFileOutputStream.newLine();
            }
			// ---------------------------------------------------------------
			// 横着排列标题
			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<Map<String, String>> iterator = exportData.iterator(); iterator.hasNext();) {
				Object row = iterator.next();
				for (Iterator propertyIterator = map.entrySet().iterator(); propertyIterator.hasNext();) {
					java.util.Map.Entry propertyEntry = (java.util.Map.Entry) propertyIterator.next();
					csvFileOutputStream.write(BeanUtils.getProperty(row, (String) propertyEntry.getKey()));
					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;
	}

	/**
	 * 下载文件
	 *
	 * @param response
	 * @param csvFilePath
	 *            文件路径
	 * @param fileName
	 *            文件名称
	 * @throws IOException
	 */

	public static void exportFile(HttpServletResponse response, String csvFilePath, String fileName)
			throws IOException {
		response.setContentType("application/csv;charset=UTF-8");
		response.setHeader("Content-Disposition", "attachment; filename=" + URLEncoder.encode(fileName, "UTF-8"));

		InputStream in = null;
		try {
			in = new FileInputStream(csvFilePath);
			int len = 0;
			byte[] buffer = new byte[1024];
			response.setCharacterEncoding("UTF-8");
			OutputStream out = response.getOutputStream();
			while ((len = in.read(buffer)) > 0) {
				out.write(new byte[] { (byte) 0xEF, (byte) 0xBB, (byte) 0xBF });
				out.write(buffer, 0, len);
			}
		} catch (FileNotFoundException e) {
			System.out.println(e);
		} finally {
			if (in != null) {
				try {
					in.close();
				} catch (Exception e) {
					throw new RuntimeException(e);
				}
			}
		}
	}

	/**
	 * 删除该目录filePath下的所有文件
	 *
	 * @param filePath
	 *            文件目录路径
	 */
	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();
				}
			}
		}
	}

	/**
	 * 删除单个文件
	 *
	 * @param filePath
	 *            文件目录路径
	 * @param fileName
	 *            文件名称
	 */
	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;
					}
				}
			}
		}
	}

	static Connection conn = null;
	static PreparedStatement pst = null;
	static ResultSet rs = null;
	static String sql;
	static String sql2;

	public static void connData(String url, String username, String password) {
		String driver = "com.mysql.jdbc.Driver";
		try {
			Class.forName(driver);

			conn = (Connection) DriverManager.getConnection(url, username, password);
			if (!conn.isClosed())
				System.out.println("Succeeded connecting to the Database!");
			else
				System.out.println("Failure connecting to the Database!");

		} catch (Exception e) {
			e.printStackTrace();
		}

	}

	@SuppressWarnings({ "rawtypes", "unchecked" })
	public static String createCSVfile(String startdate, String enddate) throws Exception {

		List exportData = new ArrayList();
		LinkedHashMap<String, String> datamMap = null;

		Date creatdate = new Date();
		SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

		connData("jdbc:mysql://", "root", "");

		sql = "select logistics.id,logistics.logisticscompany,logistics.logisticssheetid,logistics.createtime,logistics.sender,ordersummary.customerid from logistics join ordersummary on ordersummary.customid=logistics.customid and (logistics.createtime >= '"
				+ startdate + "' and logistics.createtime <= '" + enddate + " 11:59:59 PM')";
		sql2 = "select * from ordersummary where customid='12dc123456000012'";
		System.out.println(sql2);
		System.out.println(sql);

		try {

			pst = (PreparedStatement) conn.prepareStatement(sql);
			rs = pst.executeQuery();

		} catch (Exception e) {
			e.printStackTrace();
		}
		while (rs.next()) {

			datamMap = new LinkedHashMap<String, String>();
			datamMap.put("1", rs.getString("id"));
			datamMap.put("2", rs.getString("logisticscompany") != null ? rs.getString("logisticscompany") : "");
			datamMap.put("3", rs.getString("logisticssheetid") != null ? rs.getString("logisticssheetid") : "");
			creatdate = rs.getTimestamp("createtime");
			datamMap.put("4", sdf.format(creatdate));
			datamMap.put("5", rs.getString("sender") != null ? rs.getString("sender") : "");
			datamMap.put("6", rs.getString("customerid") != null ? rs.getString("customerid") : "");

			exportData.add(datamMap);

		}
		LinkedHashMap<String, String> map = new LinkedHashMap<String, String>();
		map.put("1", "ID");
		map.put("2", "物流公司");
		map.put("3", "物流单号");
		map.put("4", "发货时间");
		map.put("5", "发货人");
		map.put("6", "顾客淘宝号");
		map.put("7", "顾客淘");
		String path = "D:/";
		String fileName = "物流表";
		File file = CSV.createCSVFile(exportData, map, path, fileName);
		String fileName2 = file.getName();
		// System.out.println("文件名称：" + fileName2);
                //腾讯云cos的一些信息
		String bucketName = "";
		String secretId = "";
		String secretKey = "";

		COSCredentials cred = new BasicCOSCredentials(secretId, secretKey);

		ClientConfig clientConfig = new ClientConfig(new Region("ap-chengdu"));
		COSClient cosclient = new COSClient(cred, clientConfig);

		File localFile = new File(path + fileName2);

		String key = "/CSV/" + fileName2;

		PutObjectRequest putObjectRequest = new PutObjectRequest(bucketName, key, localFile);
		try {
			PutObjectResult putObjectResult = cosclient.putObject(putObjectRequest);

			String etag = putObjectResult.getETag();
			System.out.println(etag);
		} catch (CosServiceException e) {
			e.printStackTrace();
		} catch (CosClientException e) {
			e.printStackTrace();
		}

		cosclient.shutdown();
		String returnurl = "http://" + bucketName + ".coscd.myqcloud.com" + key;
		// deleteFile(path, fileName2);
		return returnurl;

	}

	// @SuppressWarnings({ "rawtypes", "unchecked" })
	// public static String getCSV(Ordersummary list, Logistics
	// selectByLogistics, Designpattern designpattern)
	// throws Exception {
	//
	// String patternmemo = designpattern.getPatternmemo();
	// List exportData = new ArrayList();
	// LinkedHashMap<String, String> datamMap = new LinkedHashMap<String,
	// String>();
	// LinkedHashMap<String, String> map = new LinkedHashMap<String, String>();
	// map.put("1", "收货人姓名");
	// map.put("2", "收货人详细地址");
	// map.put("3", "电话");
	// map.put("4", "总价");
	// map.put("5", "产品编号");
	// map.put("6", "订单编号");
	// map.put("7", "下单日期");
	// map.put("8", "出货日期");
	// map.put("9", "产品名称");
	// map.put("10", "数量");
	// map.put("11", "尺寸");
	// map.put("12", "材料");
	// map.put("13", "电镀");
	// map.put("14", "工艺");
	// map.put("15", "厚度");
	// map.put("16", "背模");
	// map.put("17", "背字");
	// map.put("18", "配件");
	// map.put("19", "镶边");
	// map.put("20", "抛光");
	// map.put("21", "其他");
	// map.put("22", "设计备注");
	// map.put("23", "包装");
	// map.put("24", "订单状况");
	// map.put("25", "设计师");
	// map.put("26", "模具师");
	// map.put("27", "金工车间");
	// map.put("28", "抛光车间");
	// map.put("29", "焊针车间");
	// map.put("30", "上色车间");
	// map.put("31", "包装员");
	// map.put("32", "厂长审核");
	// map.put("33", "刻模不晚于");
	// map.put("34", "打胚不晚于");
	// map.put("35", "抛光不晚于");
	// map.put("36", "电镀不晚于");
	// map.put("37", "上色不晚于");
	// map.put("38", "镭射不晚于");
	// map.put("39", "包装不晚于");
	// map.put("40", "出货不晚于");
	// map.put("41", "注意事项");
	//
	// datamMap.put("1", selectByLogistics.getRecipient() != null ?
	// selectByLogistics.getRecipient() : "");
	// datamMap.put("2",
	// selectByLogistics.getLogisticsaddress1() != null ?
	// selectByLogistics.getLogisticsaddress1() : "");
	// datamMap.put("3", selectByLogistics.getRecipienttele() != null ?
	// selectByLogistics.getRecipienttele() : "");
	// Long finalprice = list.getFinalprice();
	// datamMap.put("4", "" + 2 + "");
	// datamMap.put("5", "");
	// datamMap.put("6", list.getOrderid() != null ? list.getOrderid() : "");
	// datamMap.put("7", list.getPaytime() != null ? list.getPaytime() : "");
	// datamMap.put("8", "" + (list.getDeadline() != null ? list.getDeadline() :
	// "") + "");
	// datamMap.put("9", list.getGoodsname() != null ? list.getGoodsname() :
	// "");
	// datamMap.put("10", "" + (list.getNumber() != null ? list.getNumber() :
	// "") + "");
	// datamMap.put("11", "" + list.getLength() + "*" + list.getWidth() + "*" +
	// list.getHeight() + "");
	// datamMap.put("12", list.getTexturename() != null ? list.getTexturename()
	// : "");
	// datamMap.put("13", list.getColor() != null ? list.getColor() : "");
	// datamMap.put("14", list.getTechnology() != null ? list.getTechnology() :
	// "");
	// datamMap.put("15", "" + (list.getHeight() != null ? list.getHeight() :
	// "") + "");
	// datamMap.put("16", "");
	// datamMap.put("17", "");
	// datamMap.put("18", list.getAccessoriesname() != null ?
	// list.getAccessoriesname() : "");
	// datamMap.put("19", "");
	// datamMap.put("20", "");
	// datamMap.put("21", "");
	// datamMap.put("22", patternmemo != null ? patternmemo : "");
	// datamMap.put("23", "");
	// datamMap.put("24", "");
	// datamMap.put("25", "");
	// datamMap.put("26", "");
	// datamMap.put("27", "");
	// datamMap.put("28", "");
	// datamMap.put("29", "");
	// datamMap.put("30", "");
	// datamMap.put("31", "");
	// datamMap.put("32", "");
	// datamMap.put("33", "");
	// datamMap.put("34", "");
	// datamMap.put("35", "");
	// datamMap.put("36", "");
	// datamMap.put("37", "");
	// datamMap.put("38", "");
	// datamMap.put("39", "");
	// datamMap.put("40", "");
	// datamMap.put("41", list.getMemo() != null ? list.getMemo() : "");
	// exportData.add(datamMap);
	// String path = "D:/";
	// String fileName = "订单信息表";
	// File file = CSV.createCSVFile(exportData, map, path, fileName);
	// String fileName2 = file.getName();
	//
	// String bucketName = "";
	// String secretId = "";
	// String secretKey = "";
	//
	// COSCredentials cred = new BasicCOSCredentials(secretId, secretKey);
	//
	// ClientConfig clientConfig = new ClientConfig(new Region("ap-chengdu"));
	// COSClient cosclient = new COSClient(cred, clientConfig);
	//
	// File localFile = new File(path + fileName2);
	//
	// String key = "/CSV/" + fileName2;
	//
	// PutObjectRequest putObjectRequest = new PutObjectRequest(bucketName, key,
	// localFile);
	// try {
	// PutObjectResult putObjectResult = cosclient.putObject(putObjectRequest);
	//
	// String etag = putObjectResult.getETag();
	// System.out.println(etag);
	// } catch (CosServiceException e) {
	// e.printStackTrace();
	// } catch (CosClientException e) {
	// e.printStackTrace();
	// }
	//
	// cosclient.shutdown();
	// String returnurl = "http://" + bucketName + ".coscd.myqcloud.com" + key;
	// // deleteFile(path, fileName2);
	// return returnurl;
	// }

	public static void main(String[] args) throws Exception {
		// Ordersummary list = new Ordersummary();
		// list.setLength(12D);
		// list.setWidth(11D);
		// list.setHeight(10D);
		// Logistics selectByLogistics = new Logistics();
		// selectByLogistics.setRecipient("xxx");
		// selectByLogistics.setLogisticsaddress1("sssss");
		// selectByLogistics.setRecipienttele("123");
		// String custopmid = "123";
		// Designpattern designpattern = new Designpattern();
		// String getCSVURL = getCSV(list, selectByLogistics, designpattern);

		String getCSVURL = createCSVfile("2018-2-1", "2018-2-3");
		System.out.println(getCSVURL);

	}

}

service层：

package com.custom.order.serviceimpl;

import java.io.File;
import java.util.ArrayList;
import java.util.LinkedHashMap;
import java.util.List;
import java.util.Map;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.stereotype.Service;

import com.custom.bean.Designpattern;
import com.custom.bean.DesignpatternExample;
import com.custom.bean.Logistics;
import com.custom.bean.Ordersummary;
import com.custom.common.utils.CSV;
import com.custom.mapper.DesignpatternMapper;
import com.custom.order.service.DownCSVService;
import com.qcloud.cos.COSClient;
import com.qcloud.cos.ClientConfig;
import com.qcloud.cos.auth.BasicCOSCredentials;
import com.qcloud.cos.auth.COSCredentials;
import com.qcloud.cos.exception.CosClientException;
import com.qcloud.cos.exception.CosServiceException;
import com.qcloud.cos.model.PutObjectRequest;
import com.qcloud.cos.model.PutObjectResult;
import com.qcloud.cos.region.Region;

@Service
public class DownCSVServiceImpl implements DownCSVService {
	@Value("${weight}")
	private Double weight;// 权重
	@Autowired
	private DesignpatternMapper designpatternMapper;// 设计表mapper

	public String getCSV(Ordersummary list, Logistics selectByLogistics, Designpattern designpattern) throws Exception {

		String patternmemo = designpattern.getPatternmemo();
		List<Map<String, String>> exportData = new ArrayList<Map<String, String>>();
		LinkedHashMap<String, String> datamMap = new LinkedHashMap<String, String>();
		LinkedHashMap<String, String> map = new LinkedHashMap<String, String>();
		map.put("1", "收货人姓名");
		map.put("2", "收货人详细地址");
		map.put("3", "电话");
		map.put("4", "总价");
		map.put("5", "产品编号");
		map.put("6", "订单编号");
		map.put("7", "下单日期");
		map.put("8", "出货日期");
		map.put("9", "产品名称");
		map.put("10", "数量");
		map.put("11", "尺寸");
		map.put("12", "材料");
		map.put("13", "电镀");
		map.put("14", "工艺");
		map.put("15", "厚度");
		map.put("16", "背模");
		map.put("17", "背字");
		map.put("18", "配件");
		map.put("19", "镶边");
		map.put("20", "抛光");
		map.put("21", "其他");
		map.put("22", "设计备注");
		map.put("23", "包装");
		map.put("24", "订单状况");
		map.put("25", "设计师");
		map.put("26", "模具师");
		map.put("27", "金工车间");
		map.put("28", "抛光车间");
		map.put("29", "焊针车间");
		map.put("30", "上色车间");
		map.put("31", "包装员");
		map.put("32", "厂长审核");
		map.put("33", "刻模不晚于");
		map.put("34", "打胚不晚于");
		map.put("35", "抛光不晚于");
		map.put("36", "电镀不晚于");
		map.put("37", "上色不晚于");
		map.put("38", "镭射不晚于");
		map.put("39", "包装不晚于");
		map.put("40", "出货不晚于");
		map.put("41", "注意事项");

		datamMap.put("1", selectByLogistics.getRecipient() != null ? selectByLogistics.getRecipient() : "");
		String state = selectByLogistics.getState();
		String province = selectByLogistics.getProvince();
		String city = selectByLogistics.getCity();
		String county = selectByLogistics.getCounty();
		String logisticsaddress1 = selectByLogistics.getLogisticsaddress1();
		String str;
		str = state + " " + province + " " + city + " " + county + " " + logisticsaddress1;
		datamMap.put("2", str);
		datamMap.put("3", selectByLogistics.getRecipienttele() != null ? selectByLogistics.getRecipienttele() : "");
		Long finalprice = list.getFinalprice();
		datamMap.put("4", "" + (finalprice / weight) + "");
		datamMap.put("5", "");
		datamMap.put("6", list.getOrderid() != null ? list.getOrderid() : "");
		datamMap.put("7", list.getPaytime() != null ? list.getPaytime() : "");
		datamMap.put("8", "" + (list.getDeadline() != null ? list.getDeadline() : "") + "");
		datamMap.put("9", list.getGoodsclass() != null ? list.getGoodsclass() : "");
		datamMap.put("10", "" + (list.getNumber() != null ? list.getNumber() : "") + "");
		datamMap.put("11", "" + list.getLength() + "*" + list.getWidth() + "*" + list.getHeight() + "");
		datamMap.put("12", list.getTexturename() != null ? list.getTexturename() : "");
		datamMap.put("13", list.getColor() != null ? list.getColor() : "");
		datamMap.put("14", list.getTechnology() != null ? list.getTechnology() : "");
		datamMap.put("15", "" + (list.getHeight() != null ? list.getHeight() : "") + "");
		datamMap.put("16", "");
		datamMap.put("17", "");
		datamMap.put("18", list.getAccessoriesname() != null ? list.getAccessoriesname() : "");
		datamMap.put("19", "");
		datamMap.put("20", "");
		datamMap.put("21", "");
		datamMap.put("22", patternmemo != null ? patternmemo : "");
		datamMap.put("23", "");
		datamMap.put("24", "");
		datamMap.put("25", "");
		datamMap.put("26", "");
		datamMap.put("27", "");
		datamMap.put("28", "");
		datamMap.put("29", "");
		datamMap.put("30", "");
		datamMap.put("31", "");
		datamMap.put("32", "");
		datamMap.put("33", "");
		datamMap.put("34", "");
		datamMap.put("35", "");
		datamMap.put("36", "");
		datamMap.put("37", "");
		datamMap.put("38", "");
		datamMap.put("39", "");
		datamMap.put("40", "");
		datamMap.put("41", list.getMemo() != null ? list.getMemo() : "");
		exportData.add(datamMap);
		String path = "D:/";
		String fileName = "订单信息表";
		File file = CSV.createCSVFile(exportData, map, path, fileName);
		String fileName2 = file.getName();

		String bucketName = "";
		String secretId = "";
		String secretKey = "";

		COSCredentials cred = new BasicCOSCredentials(secretId, secretKey);

		ClientConfig clientConfig = new ClientConfig(new Region("ap-chengdu"));
		COSClient cosclient = new COSClient(cred, clientConfig);

		File localFile = new File(path + fileName2);

		String key = "/CSV/" + fileName2;

		PutObjectRequest putObjectRequest = new PutObjectRequest(bucketName, key, localFile);
		try {
			PutObjectResult putObjectResult = cosclient.putObject(putObjectRequest);

			String etag = putObjectResult.getETag();
			System.out.println(etag);
		} catch (CosServiceException e) {
			e.printStackTrace();
		} catch (CosClientException e) {
			e.printStackTrace();
		}

		cosclient.shutdown();
		String returnurl = "http://" + bucketName + ".coscd.myqcloud.com" + key;
		// deleteFile(path, fileName2);
		return returnurl;
	}

	@Override
	public List<Designpattern> selectBycustomid(String customid) {

		DesignpatternExample example = new DesignpatternExample();
		example.createCriteria().andCustomidEqualTo(customid).andFeedbackstatusEqualTo(2);
		List<Designpattern> selectByExample = designpatternMapper.selectByExample(example);
		return selectByExample;
	}

}

web层：

package com.custom.order.controller;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

import com.alibaba.fastjson.JSONObject;
import com.custom.bean.Designpattern;
import com.custom.bean.Logistics;
import com.custom.bean.Ordersummary;
import com.custom.manager.service.LogisticsInformationService;
import com.custom.order.service.DownCSVService;

@Controller
public class DownCsv {
	@Autowired
	private LogisticsInformationService informationService;
	@Autowired
	private DownCSVService downCSVService;

	@RequestMapping("/order/downcsv.do")
	@ResponseBody
	public JSONObject downcsv(String customid) throws Exception {
		JSONObject json = new JSONObject();
		Ordersummary ordersummary = null;
		Logistics logistic = null;
		Designpattern design = null;
		List<Ordersummary> list = informationService.selectByCustomid(customid);
		List<Logistics> logistics = informationService.selectByLogistics(customid);
		List<Designpattern> designpattern = downCSVService.selectBycustomid(customid);
		if (list != null && list.size() > 0) {
			ordersummary = list.get(0);
		} else {
			Map<String, String> map = new HashMap<>();
			map.put("code", "1");
			map.put("msg", "此订单不存在于订单表。");
			json.put("status", map);
			return json;
		}
		if (logistics != null && logistics.size() > 0) {
			logistic = logistics.get(0);
		} else {

			Map<String, String> map = new HashMap<>();
			map.put("code", "2");
			map.put("msg", "此订单没有物流信息。");
			json.put("status", map);
			return json;
		}
		if (designpattern != null && designpattern.size() > 0) {
			design = designpattern.get(0);
		} else {
			Map<String, String> map = new HashMap<>();
			map.put("code", "3");
			map.put("msg", "此订单没有设计。");
			json.put("status", map);
			return json;
		}

		String csv = downCSVService.getCSV(ordersummary, logistic, design);
		if (!"".equals(csv) && csv.length() > 0) {
			Map<String, String> map = new HashMap<>();
			map.put("code", "0");
			map.put("msg", "获取csv地址成功。");
			map.put("addRess", csv);
			json.put("status", map);
			return json;
		} else {
			Map<String, String> map = new HashMap<>();
			map.put("code", "0");
			map.put("msg", "获取csv地址失败。");
			json.put("status", map);
			return json;
		}
	}
}

x1321362731

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
对象存储cos 下载csv

pom.xml &lt;cos.sdk.version&gt;2.0.1&lt;/cos.sdk.version&gt; &lt;cos.api.version&gt;5.2.4&lt;/cos.api.version&gt; &lt;commons-beanutils.version&gt;1.9.3&lt;/commons-beanutils.version&gt; &lt;...
复制链接

扫一扫