②Excle数据批量导入到Oracle数据库中

（1）POI处理 

对Excel的读取，主要涉及工作薄、工作薄、行数据、单元格等的处理，POI对97-2003和2007+两个版本的处理采用不同的类，如下图所示。 
 

其中： 
a）Workbook、Sheet、Row、Cell等为接口； 
b）HSSFWorkbook、HSSFSheet、HSSFRow、HSSFCell为97-2003版本对应的处理实现类； 

c）XSSFWorkbook、XSSFSheet、XSSFRow、XSSFCell为2007+版本对应的处理实现类； 

（2）实现的例子

import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.List;

import org.apache.log4j.Logger;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
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.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.apache.struts2.convention.annotation.Action;
import org.apache.struts2.convention.annotation.Namespace;
import org.apache.struts2.convention.annotation.ParentPackage;
import org.apache.struts2.convention.annotation.Result;
import org.apache.struts2.json.annotations.JSON;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;

import com.csair.smms.inituserinfo.dto.UserInsert;
import com.csair.smms.inituserinfo.service.InitUserInfoService;
import com.csair.smms.preventive.service.PreventiveInfoService;

@ParentPackage("json-default")
@Namespace("/upload")
@Controller
public class UploadUserAction {
	private static int version2003 = 2003;
	private static int version2007 = 2007;
	private static int version = version2003;

	private File xlsBook;
	private String xlsBookFileName;
	private String xlsBookContentType;

	private static Logger logger = Logger.getLogger(UploadUserAction.class);
	@Autowired
	private InitUserInfoService initUserInfoService;

	@Autowired
	private PreventiveInfoService preventiveInfoService;

	@JSON(serialize = false)
	public File getXlsBook() {
		return xlsBook;
	}

	public void setXlsBook(File xlsBook) {
		this.xlsBook = xlsBook;
	}

	@JSON(serialize = false)
	public String getXlsBookFileName() {
		return xlsBookFileName;
	}

	public void setXlsBookFileName(String xlsBookFileName) {
		this.xlsBookFileName = xlsBookFileName;
	}

	@JSON(serialize = false)
	public String getXlsBookContentType() {
		return xlsBookContentType;
	}

	public void setXlsBookContentType(String xlsBookContentType) {
		this.xlsBookContentType = xlsBookContentType;
	}

        //此方法判别Excel2003和Excel2007
	public void initType() {
		String name = getXlsBookFileName();
		if (name != null) {
			int index = getXlsBookFileName().indexOf(".");
			String suffex = name.substring(index);
			if ("xls".equals(suffex)) {
				version = version2003;
			} else if ("xlsx".equals(suffex)) {
				version = version2007;
			}
		}
	}

    @Action(value = "uploadUser", results = { @Result(type = "json") })
	public String analizeExcel() {
		if (xlsBook != null) {
			initType();
			InputStream is = null;
			List<UserInsert> userList = null;
			try {
				is = new FileInputStream(xlsBook);

				version = (xlsBookFileName.endsWith(".xls") ? version2003
						: version2007);
				if (version == 2003) {// 2003
					POIFSFileSystem fs = new POIFSFileSystem(is);
					HSSFWorkbook wb = new HSSFWorkbook(fs);
					HSSFSheet sheet = wb.getSheetAt(0);
					userList = readUser(sheet);
				} else if (version == 2007) {// 2007
					XSSFWorkbook xwb = new XSSFWorkbook(is);
					XSSFSheet sheet = xwb.getSheetAt(0);
					userList = readUser(sheet);
				}

			} catch (FileNotFoundException e) {

			} catch (IOException e) {

			}
                       // 保存javabean逻辑
                       //自己的逻辑代码

		}
	return com.opensymphony.xwork2.Action.SUCCESS;	
	}

        //此方法为读取表格核心方法
	public List<UserInsert> readUser(Sheet sheet) {
		List<UserInsert> userList = new ArrayList<UserInsert>();

		int rowNum = sheet.getPhysicalNumberOfRows();
		UserInsert ui = null;
		for (int i = 1; i < rowNum; i++) {
			Row row = sheet.getRow(i);
			Cell c = row.getCell(0);
			ui = new UserInsert();
			if (c != null) {
				if (c.getCellType() == Cell.CELL_TYPE_NUMERIC) {
					long id = (long) row.getCell(0).getNumericCellValue();
					ui.setId(id + "");
				} else {
					ui.setId(c.getStringCellValue());
				}

				c = row.getCell(1);
				if (c != null) {
					ui.setName(row.getCell(1).getStringCellValue());
				} else {
					ui.setName("");
				}

				c = row.getCell(2);
				if (c != null) {
					ui.setSex(row.getCell(2).getStringCellValue());
				} else {
					ui.setSex("");
				}

				c = row.getCell(3);
				if (c != null) {
					ui.setBase(row.getCell(3).getStringCellValue());
				} else {
					ui.setBase("");
				}

				c = row.getCell(4);
				if (c != null) {
					ui.setBaseCode(row.getCell(4).getStringCellValue());
				} else {
					ui.setBaseCode("");
				}

				c = row.getCell(5);
				if (c != null) {
					ui.setDepartment(row.getCell(5).getStringCellValue());
				} else {
					ui.setDepartment("");
				}

				c = row.getCell(6);
				if (c != null) {
					ui.setPosition(row.getCell(6).getStringCellValue());
				} else {
					ui.setPosition("");
				}

				c = row.getCell(7);
				if (c != null) {
					ui.setRole(row.getCell(7).getStringCellValue());
				} else {
					ui.setRole("");
				}

				c = row.getCell(8);
				if (c != null) {
					if (c.getCellType() == Cell.CELL_TYPE_NUMERIC) {
						long m = (long) row.getCell(8).getNumericCellValue();
						ui.setMobile(m + "");
					} else {
						ui.setMobile(c.getStringCellValue());
					}
				} else {
					ui.setMobile("");
				}

				c = row.getCell(9);
				if (c != null) {
					if (c.getCellType() == Cell.CELL_TYPE_NUMERIC) {
						long t = (long) row.getCell(9).getNumericCellValue();
						ui.setTelephone(t + "");
					} else {
						ui.setTelephone(c.getStringCellValue());
					}
				} else {
					ui.setTelephone("");
				}

				c = row.getCell(10);
				if (c != null) {
					ui.setEmail(row.getCell(10).getStringCellValue());
				} else {
					ui.setEmail("");
				}
				userList.add(ui);
			}

		}
		return userList;
	}

	public static void main(String[] args) {
		UploadUserAction uua = new UploadUserAction();
		uua.analizeExcel();
		System.out.println("end-----------------");
	}

}

javabeen类：

public class UserInsert implements Serializable{
	
	private static final long serialVersionUID = -796538816605301094L;
	private String id;// 员工号
	private String name;// 姓名
	private String sex;// 性别
	private String base;// 所属基地
	private String baseCode;// 基地三字码
	private String department;// 部门
	private String position;// 职务
	private String role;// 系统角色
	private String mobile;// 手机
	private String telephone;// 办公电话
	private String email;// 邮箱

        //此处省略各属性的setter和getter方法
}

不过要注意的是这里不仅仅要导入poi-3.8-20120326.jar及其以后版本的包，而且要导入 还需要 
   xmlbeans-2.3.0.jar 
   poi-ooxml-schemas-3.8-beta5-20111217.jar 
   dom4j-1.6.1.jar等相关的Jar包

另外，还可以参考这个帖子做更细致的设置：http://cgs1999.iteye.com/blog/1525665