package?com.bank.controller;

import?java.io.IOException;
import?java.util.List;

import?javax.annotation.Resource;
import?javax.servlet.http.HttpServletResponse;

import?org.springframework.stereotype.Controller;
import?org.springframework.web.bind.annotation.RequestMapping;
import?org.springframework.web.bind.annotation.RequestMethod;
import?org.springframework.web.bind.annotation.RequestParam;
import?org.springframework.web.multipart.MultipartFile;

import?com.bank.entity.Computer;
import?com.bank.service.PoiService;

@Controller??
@RequestMapping（“/report“）?
public?class?PoiController?{

	@Resource（name?=?“poiService“）??
????private?PoiService?service;??
??
????/**?
?????*?跳轉到主頁.?
?????*/??
????@RequestMapping（value?=?““?method?=?RequestMethod.GET）??
????public?String?getIndex（）?{??
????????
????????return?“report“;??
????}??
??
????/**?
?????*?導出excel報表?
?????*/??
????@RequestMapping（value?=?“/export“?method?=?RequestMethod.GET）??
????public?void?getXLS（HttpServletResponse?response）?{??
????????service.exportXLS（response）;??
????}??
??
????/**?
?????*?讀取excel報表?
?????*/??
????@RequestMapping（value?=?“/read“?method?=?RequestMethod.POST）??
????public?String?getReadReport（@RequestParam?MultipartFile?file）??
????????????throws?IOException?{??
????????List?list?=?service.readReport（file.getInputStream（））;??
????????service.insertComputer（list）;??
????????return?“enter/addedReport“;??
??
????}??
}

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

?????文件???????5863??2012-04-28?09:15??test1\.classpath

?????文件????????287??2012-05-01?09:52??test1\.mymetadata

?????文件???????1411??2012-04-27?22:20??test1\.project

?????文件????????500??2012-04-25?18:24??test1\.settings\.jsdtscope

?????文件????????330??2012-04-25?18:24??test1\.settings\org.eclipse.jdt.core.prefs

?????文件?????????49??2012-04-25?18:24??test1\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2012-04-25?18:24??test1\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件????????678??2012-04-25?18:25??test1\src\applicationContext.xml

?????文件???????1512??2012-05-01?10:58??test1\src\com\bank\controller\PoiController.java

?????文件???????5590??2012-04-25?22:57??test1\src\com\bank\dao\baseDao.java

?????文件???????2515??2012-04-25?22:57??test1\src\com\bank\dao\Page.java

?????文件???????1335??2012-04-27?23:01??test1\src\com\bank\dao\PoiDao.java

?????文件???????1030??2012-04-27?22:31??test1\src\com\bank\entity\Computer.java

?????文件???????6579??2012-04-28?18:28??test1\src\com\bank\service\PoiService.java

?????文件????????391??2012-04-27?23:53??test1\src\com\bank\util\DateUtils.java

?????文件???????2511??2012-04-28?09:11??test1\src\com\bank\util\FillComputerManager.java

?????文件???????4519??2012-04-28?09:14??test1\src\com\bank\util\Layouter.java

?????文件????????703??2012-04-28?09:19??test1\src\com\bank\util\Writer.java

?????文件????????337??2012-04-27?22:23??test1\src\jdbc.properties

?????文件????????214??2012-04-25?18:25??test1\src\log4j.properties

?????文件???????2076??2012-04-27?23:05??test1\src\spring-dao.xml

?????文件???????1961??2012-04-25?18:39??test1\src\spring-service.xml

?????文件???????1233??2012-04-28?18:10??test1\src\springMVC.xml

?????文件????????210??2012-04-28?10:33??test1\WebRoot\index.jsp

?????文件?????????36??2012-04-25?18:24??test1\WebRoot\meta-INF\MANIFEST.MF

?????文件????????678??2012-04-25?18:25??test1\WebRoot\WEB-INF\classes\applicationContext.xml

?????文件???????1917??2012-05-02?10:14??test1\WebRoot\WEB-INF\classes\com\bank\controller\PoiController.class

?????文件???????6259??2012-05-02?10:14??test1\WebRoot\WEB-INF\classes\com\bank\dao\baseDao.class

?????文件???????1640??2012-05-02?10:14??test1\WebRoot\WEB-INF\classes\com\bank\dao\Page.class

?????文件???????2121??2012-05-02?10:14??test1\WebRoot\WEB-INF\classes\com\bank\dao\PoiDao.class

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