javaWeb poi导入excel文件

 /**
* execl数据格式的转换
* 
* @param cell
* @return
*/
public String publicExcel(Cell cell) {
String value = null;
switch (cell.getCellType()) {
case Cell.CELL_TYPE_NUMERIC:
value = "" + cell.getNumericCellValue();
break;
case Cell.CELL_TYPE_STRING:
value = cell.getStringCellValue();
break;
case Cell.CELL_TYPE_BLANK:
;
break;
default:
}
return value;
}
  
/***
     * 
     * 取得Workbook对象(xls和xlsx对象不同,不过都是Workbook的实现类)
     *   xls:HSSFWorkbook
     *   xlsx：XSSFWorkbook
     * @param filePath
     * @return
     * @throws IOException
     * @author fangke
     */
    private Workbook getWorkbook(String filePath,String fileName) throws IOException {
        Workbook workbook = null;
        InputStream is = new FileInputStream(filePath);
        if (fileName.endsWith("xls")) {
            workbook = new HSSFWorkbook(is);
        } else if (fileName.endsWith("xlsx")) {
            workbook = new XSSFWorkbook(is);
        }
        return workbook;
    }


/**
 * 该方法是利用poi对导入的excel,进去解析读取和写入数据库
 * @param fileName
 * @param filePath
 * @throws Exception
 * @author fangke
 */
  public void importExcel(String fileName, String filePath) throws Exception {
Workbook workbook = getWorkbook(filePath, fileName);
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
Class.forName("oracle.jdbc.OracleDriver");
String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";
Connection conn = DriverManager.getConnection(url, "zj7", "zj7");
conn.setAutoCommit(false);// 取消自动提交
S