import java.io.File;
import java.io.FileInputStream;
import java.util.ArrayList;
import java.util.List;
import org.apache.commons.io.FileUtils;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.apache.struts2.ServletActionContext;
import com.opensymphony.xwork2.ActionSupport;
import com.sanqing.dao.SubjectDAO;
import com.sanqing.dao.SubjectDAOImpl;
import com.sanqing.po.Subject;
public class SubjectAddAction extends ActionSupport {
/**
*
*/
private static final long serialVersionUID = 1L;
private File uploadExcel; // 上传的文件
private String uploadExcelFileName; // 上传的文件名
public File getUploadExcel() {
return uploadExcel;
}
public void setUploadExcel(File uploadExcel) {
this.uploadExcel = uploadExcel;
}
public String getUploadExcelFileName() {
return uploadExcelFileName;
}
public void setUploadExcelFileName(String uploadExcelFileName) {
this.uploadExcelFileName = uploadExcelFileName;
}
SubjectDAO subjectDAO = new SubjectDAOImpl();
public String loadExcel() {
String path = "/excel";// 上传路径
String targetDirectory = ServletActionContext.getServletContext()
.getRealPath(path);
// 生成上传的文件对象
File targetFile = new File(targetDirectory, uploadExcelFileName);
// 如果文件已经存在,则删除原文件
if (targetFile.exists()) {
targetFile.delete();
}
// 复制file对象,实现上传
try {
FileUtils.copyFile(uploadExcel, targetFile);
System.out.println("文件上传成功");
} catch (Exception e) {
e.printStackTrace();
}
// 从导入的文件中读取数据
System.out.println(uploadExcelFileName);
loadExcelInfo(uploadExcelFileName);
return SUCCESS;
}
/**
* 把excel表中读出的数据封装成一个List,统一导入数据库
*
* @param uploadExcelFileName
*/