package?com.mengdee.manager.controller;

import?java.io.BufferedInputStream;
import?java.io.InputStream;
import?java.io.OutputStream;
import?java.util.ArrayList;
import?java.util.List;

import?javax.servlet.http.HttpServletResponse;
import?javax.servlet.http.HttpSession;

import?org.apache.poi.hssf.usermodel.HSSFCell;
import?org.apache.poi.hssf.usermodel.HSSFCellstyle;
import?org.apache.poi.hssf.usermodel.HSSFFont;
import?org.apache.poi.hssf.usermodel.HSSFRow;
import?org.apache.poi.hssf.usermodel.HSSFSheet;
import?org.apache.poi.hssf.usermodel.HSSFWorkbook;
import?org.apache.poi.hssf.util.HSSFColor;
import?org.apache.poi.poifs.filesystem.POIFSFileSystem;
import?org.apache.poi.ss.usermodel.CellType;
import?org.apache.poi.ss.usermodel.FillPatternType;
import?org.apache.poi.ss.usermodel.Font;
import?org.apache.poi.ss.usermodel.HorizontalAlignment;
import?org.apache.poi.ss.usermodel.VerticalAlignment;
import?org.apache.poi.ss.util.CellRangeAddress;
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.RequestParam;
import?org.springframework.web.multipart.MultipartFile;

import?com.mengdee.manager.domain.User;
import?com.mengdee.manager.service.UserService;

@Controller
@RequestMapping（“/user“）
public?class?UserController?{

	@Autowired
	private?UserService?userService;
	
	@RequestMapping（“/list“）
	public?String?getUserList（）{
		List?userList?=?userService.getUserList（）;
		
		for?（User?user?:?userList）?{
			System.out.println（user）;
		}
		
		return?“index“;
	}
	
	@SuppressWarnings（“resource“）
	@RequestMapping（“/export“）????
????public?void?exportExcel（HttpServletResponse?response?HttpSession?session?String?name）?throws?Exception?{??
		
		String[]?tableHeaders?=?{“id“?“姓名“?“年齡“};?
		
????	HSSFWorkbook?workbook?=?new?HSSFWorkbook（）;
		HSSFSheet?sheet?=?workbook.createSheet（“Sheet1“）;
		HSSFCellstyle?cellstyle?=?workbook.createCellstyle（）;????
		cellstyle.setAlignment（HorizontalAlignment.CENTER）;??
		cellstyle.setVerticalAlignment（VerticalAlignment.CENTER）;
		cellstyle.setFillPattern（FillPatternType.DIAMONDS）;
		cellstyle.setFillForegroundColor（HSSFColor.BLUE.index）;
		cellstyle.setFillBackgroundColor（HSSFColor.LIGHT_YELLOW.index）;
		cellstyle.setBottomBorderColor（HSSFColor.DARK_RED.index）;
		
		
		Font?font?=?workbook.createFont（）;??
		font.setColor（HSSFColor.RED.index）;??
		font.setBold（true）;
		font.setItalic（true）;
		font.setUnderline（HSSFFont.U_SINGLE）;
		cellstyle.setFont（font）;
		
		//?將第一行的三個單元格給合并
		sheet.addMergedRegion（new?CellRangeAddress（0?0?0?2））;
		HSSFRow?row?=?sheet.createRow（0）;
		HSSFCell?beginCell?=?row.createCell（0）;
		beginCell.setCellValue（“通訊錄“）;	
		beginCell.setCellstyle（cellstyle）;
	
		
		row?=?sheet.createRow（1）;
		//?創(chuàng)建表頭
		for?（int?i?=?0;?i?