package com.spark.controller;

import java.util.List;
import java.awt.Menu;
import java.io.File;
import java.io.IOException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;

import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.multipart.MultipartFile;

import com.spark.bean.User;
import com.spark.service.FileUploadService;


@Controller
public class UploadController {
	
	@Resource(name="service")
	private FileUploadService fileUploadService1;
		
	@RequestMapping("/uploadfile")
	public String toUpload(){
		return "upload";
	}
	@RequestMapping("/form")
	public String upload(@RequestParam(value="file",required=false) MultipartFile file,HttpServletRequest request,ModelMap model,Model mod) throws Exception{
		String path=request.getSession().getServletContext().getRealPath("upload");
		//文本路径
		System.out.println(path);
		String fileName=file.getOriginalFilename();
		File targetFile=new File(path,fileName);
		if(!targetFile.exists()){
			targetFile.mkdirs();
		}
	    // 获得上传文件的文件扩展名
	    String subname = fileName.substring(fileName.lastIndexOf(".")+1);
	    System.out.println("文件的扩展名："+subname);
		//保存
		try{
			file.transferTo(targetFile);
			model.addAttribute("fileUrl",request.getSession().getServletContext().getRealPath("upload")+"/"+fileName);
		}catch (Exception e) {
			e.printStackTrace();
		}
		
		String rootpath = path + File.separator + fileName;
		System.out.println(rootpath);
		List<User> excelList = fileUploadService1.readExcel(rootpath);
		for(User user : excelList){
			fileUploadService1.save(user);
		}
		int len = excelList.size();
		System.out.println("集合的大小为："+len);
		
		return "result";
	}

}