package com.chen.controller;

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

import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;

import com.chen.util.ExcelUtil;

/**
 * 
 * @author chenguoji
 * @qq  375136957
 */
@Controller
public class ExcelController {

	/**
	 * 跳转页面
	 * 
	 * @return
	 */
	@RequestMapping("/toExcel")
	public String toExcel() {

		return "excel";
	}

	/**
	 * 导出Excel 并下载
	 */
	@RequestMapping("/exportExcel")
	public void exportExcel(HttpServletRequest request,HttpServletResponse response) {
		String fileName = "students.xls";
		// 得到保存文件的保存目录
		String savePath = request.getServletContext().getRealPath("/excel");
		// 创建excel
		ExcelUtil.createExcel(savePath,fileName);
		//下载
		ExcelUtil.exportFile(request, response, savePath, fileName);
		
	}

}