java poi 读取excel 导入oracle的例子,EXCEL数据导入到ORACLE POI小例子 JAVA

package com.cjh.poi;

import java.io.File;

import java.io.FileInputStream;

import java.io.IOException;

import java.io.InputStream;

import http://www.doczj.com/doc/6ca7fbc5c0c708a1284ac850ad02de80d4d80685.htmlermodel.HSSFCell;

import http://www.doczj.com/doc/6ca7fbc5c0c708a1284ac850ad02de80d4d80685.htmlermodel.HSSFRow;

import http://www.doczj.com/doc/6ca7fbc5c0c708a1284ac850ad02de80d4d80685.htmlermodel.HSSFSheet;

import http://www.doczj.com/doc/6ca7fbc5c0c708a1284ac850ad02de80d4d80685.htmlermodel.HSSFWorkbook;

/**

*excel数据导入到oracle

*@author cjh

*20130718

*/

public class Test_poi{

public static void main(String[]args)throws Exception{

Test_poi in=new Test_poi();

in.insert("F:/重复税号.xls","TEST_JXL");

}

/**

*

*@param path

*要解析的excel文件路径

*@param dataTable

*要写入到数据库中的表名

*@throws BiffException

*@throws IOException

*/

public void insert(String path,String dataTable)throws IOException,IOException{ File file=new File(path);

HSSFWorkbook rwb=null;

//创建输入流

InputStream is=new FileInputStream(path);

rwb=new HSSFWorkbook(is);