package com.pl.dcloud.controller;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.dom4j.DocumentException;
import org.springframework.stereotype.Controller;
import org.springframework.util.StringUtils;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import com.pl.dcloud.model.Member;
import com.pl.dcloud.model.Quote;
import com.pl.dcloud.service.QuoteService;
import com.pl.dcloud.xmlParse.XmltoExcelUtil;
/**
* @author ycw
* mySQL导出Excel
*/
@Controller
@RequestMapping(value="/quote")
public class QuoteDbToExcelController extends ControllerImpl {
@Resource
private QuoteService quoteService;
@ResponseBody
@RequestMapping(value="/quoteToExcel",produces="text/plain;charset=UTF-8")
public void export(HttpServletRequest request, HttpServletResponse response) {
Map<String, Object> map = new HashMap<String, Object>();
Member member = getMember(request);
if (!StringUtils.isEmpty(member)) {
map.put("companyId",member.getOrgId());
}else{
map.put("companyId",1);
}
//得到报价列表
List<Quote> quoteList = quoteService.getList(map);
//列表转Excel
quoteService.getQuoteToExcel(quoteList,response);
}
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.dom4j.DocumentException;
import org.springframework.stereotype.Controller;
import org.springframework.util.StringUtils;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import com.pl.dcloud.model.Member;
import com.pl.dcloud.model.Quote;
import com.pl.dcloud.service.QuoteService;
import com.pl.dcloud.xmlParse.XmltoExcelUtil;
/**
* @author ycw
* mySQL导出Excel
*/
@Controller
@RequestMapping(value="/quote")
public class QuoteDbToExcelController extends ControllerImpl {
@Resource
private QuoteService quoteService;
@ResponseBody
@RequestMapping(value="/quoteToExcel",produces="text/plain;charset=UTF-8")
public void export(HttpServletRequest request, HttpServletResponse response) {
Map<String, Object> map = new HashMap<String, Object>();
Member member = getMember(request);
if (!StringUtils.isEmpty(member)) {
map.put("companyId",member.getOrgId());
}else{
map.put("companyId",1);
}
//得到报价列表
List<Quote> quoteList = quoteService.getList(map);
//列表转Excel
quoteService.getQuoteToExcel(quoteList,response);
}
}
package com.pl.dcloud.service.impl;
import java.io.BufferedOutputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.OutputStream;
import java.util.Iterator;
import java.util.List;
import javax.servlet.http.HttpServletResponse;
import org.apache.poi.hssf.usermodel.HSSFRichTextString;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apach