uploadexcelfiletodb.java

来自「struts2+spring2.0+hibernate3.2与acegi 1.0」· Java 代码 · 共 52 行

package com.test.action.user;

import java.io.File;
import java.io.FileInputStream;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;

import com.opensymphony.xwork2.ActionSupport;
import com.test.service.UserService;

public class UploadExcelFileToDB extends ActionSupport {

	private File excelFile;
	private UserService userService;

	public File getExcelFile() {
		return excelFile;
	}

	public void setExcelFile(File excelFile) {
		this.excelFile = excelFile;
	}

	@Override
	public String execute() throws Exception {
		// TODO Auto-generated method stub
		System.out.println("UploadExcelFileToDB_startRemote");
		
		HSSFWorkbook workBook = new HSSFWorkbook(new FileInputStream(excelFile));
		
		System.out.println("UploadExcelFileToDB_middleRemote");
		
		userService.upLoadAsExcel(workBook);
		
		System.out.println("UploadExcelFileToDB_endRemote");
		
		return SUCCESS;
	}

	public UserService getUserService() {
		return userService;
	}

	public void setUserService(UserService userService) {
		this.userService = userService;
	}
	
	
	
	
}