package?oaec.controller;

import?java.io.File;
import?java.util.List;
import?java.util.UUID;

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

import?oaec.entity.User;
import?oaec.service.UserService;
import?oaec.util.BulkImportUtil;

import?org.json.JSONobject;
import?org.springframework.beans.factory.annotation.Autowired;
import?org.springframework.stereotype.Controller;
import?org.springframework.ui.Model;
import?org.springframework.web.bind.annotation.RequestMapping;
import?org.springframework.web.bind.annotation.RequestParam;
import?org.springframework.web.multipart.commons.CommonsMultipartFile;

@Controller
@RequestMapping（“/user“）
public?class?UserController?{
	@Autowired
	private?UserService?userService;
	@Autowired
	private?BulkImportUtil?bulkImportUtil;
	@RequestMapping（“/bulkimport“）
	public?void?bulkimport（HttpServletRequest?requestHttpServletResponse?response@RequestParam（“ff“）?CommonsMultipartFile??ff）?throws?Exception{
		response.setContentType（“text/html“）;
		System.out.println（“上傳的文件為:“+ff.getOriginalFilename（））;
		String?fileName=ff.getOriginalFilename（）;
		String?realName=fileName.substring（fileName.lastIndexOf（“/“）+1）;
		String?realPath=request.getRealPath（“/upload“）;
		String?lastName=realPath+“/“+UUID.randomUUID（）+“-“+realName;
		File?f=new?File（lastName）;
		//如果不存在此文件夾，則創建
		if?（!f.isDirectory（））?{
			f.mkdirs（）;
		}
		ff.transferTo（f）;
		//解析excel文件
		List?users=bulkImportUtil.analysisXLS（requestlastName）;
		JSONobject?obj=new?JSONobject（）;
		boolean?result=false;
		for（User?user:users）{
			result=userService.addUser（user）;
		}
		if（result）{
			obj.put（“msg“?“導入成功！“）;
		}else{
			obj.put（“msg“?“導入失敗！“）;
		}
		System.out.println（“obj:“+obj.toString（））;
		response.getWriter（）.print（obj.toString（））;
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????1360??2018-05-03?16:25??ssm_bulkimport\.classpath

?????文件???????1547??2018-05-03?15:55??ssm_bulkimport\.project

?????文件????????522??2017-02-28?14:13??ssm_bulkimport\.settings\.jsdtscope

?????文件?????????79??2018-05-03?15:55??ssm_bulkimport\.settings\com.genuitec.eclipse.migration.prefs

?????文件?????????89??2017-03-07?16:05??ssm_bulkimport\.settings\com.genuitec.jboss.ide.eclipse.xdoclet.run.prefs

?????文件?????????57??2018-05-03?17:41??ssm_bulkimport\.settings\org.eclipse.core.resources.prefs

?????文件????????670??2018-05-07?10:23??ssm_bulkimport\.settings\org.eclipse.jdt.core.prefs

?????文件????????106??2017-03-07?16:05??ssm_bulkimport\.settings\org.eclipse.ltk.core.refactoring.prefs

?????文件????????576??2017-03-07?16:05??ssm_bulkimport\.settings\org.eclipse.wst.common.component

?????文件????????172??2018-05-03?15:55??ssm_bulkimport\.settings\org.eclipse.wst.common.project.facet.core.prefs.xml

?????文件????????462??2018-05-03?15:55??ssm_bulkimport\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2017-02-28?14:13??ssm_bulkimport\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2017-02-28?14:13??ssm_bulkimport\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件?????????87??2017-03-07?16:05??ssm_bulkimport\.settings\org.eclipse.wst.ws.service.policy.prefs

?????文件????????154??2018-05-03?16:00??ssm_bulkimport\conf\db.properties

?????文件????????464??2017-02-28?16:21??ssm_bulkimport\conf\SqlMapConfig.xml

?????文件???????2606??2017-03-07?14:44??ssm_bulkimport\conf\ssm-servlet.xml

?????文件???????1942??2017-03-07?16:03??ssm_bulkimport\src\oaec\controller\UserController.java

?????文件???????1670??2017-03-07?15:32??ssm_bulkimport\src\oaec\entity\User.java

?????文件????????140??2017-03-07?16:03??ssm_bulkimport\src\oaec\mapper\UserMapper.java

?????文件????????457??2017-03-07?16:03??ssm_bulkimport\src\oaec\mapper\UserMapper.xml

?????文件????????473??2017-03-07?16:03??ssm_bulkimport\src\oaec\service\impl\UserServiceImpl.java

?????文件????????142??2017-03-07?16:03??ssm_bulkimport\src\oaec\service\UserService.java

?????文件???????4244??2017-03-07?16:09??ssm_bulkimport\src\oaec\util\BulkImportUtil.java

?????文件???????1940??2017-03-07?16:07??ssm_bulkimport\WebRoot\excelimport.jsp

?????文件???????7395??2017-03-07?14:25??ssm_bulkimport\WebRoot\js\ajaxfileupload.js

?????文件?????247351??2017-02-08?14:24??ssm_bulkimport\WebRoot\js\jquery-2.1.1.js

?????文件?????????39??2017-02-28?14:13??ssm_bulkimport\WebRoot\meta-INF\MANIFEST.MF

?????文件????????154??2018-05-03?16:00??ssm_bulkimport\WebRoot\WEB-INF\classes\db.properties

?????文件???????3873??2018-05-07?10:23??ssm_bulkimport\WebRoot\WEB-INF\classes\oaec\controller\UserController.class

............此處省略81個文件信息