excel数据导入到oracle poi小例子 java.docVIP

package com.cjh.poi; import java.io.File; import java.io.FileInputStream; import java.io.IOException; import java.io.InputStream; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; /** * excel数据导入到oracle * @author cjh * */ 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); // 得到工作簿 HSSFSheet sheet = rwb.getSheetAt(0); int rsRows = sheet.getLastRowNum()+1;// 获取总行数 String simNumber = ;//每个单元格中的数据 DBconn jdbc=new DBconn(); String str=;//拼接要插入的列 HSSFRow row = sheet.getRow(0); //获取第一行 int rsColumns = row.getPhysicalNumberOfCells();// 列数 for (short j = 0; j rsColumns; j++) { HSSFCell cell = row.getCell(j); simNumber = cell.getStringCellValue(); if(j==rsColumns-1){ //最后一列不用加逗号 str += simNumber ; }else{ str += simNumber+,; } } System.out.println(str); for (short i = 1; i rsRows; i++) { HSSFRow row1 = sheet.getRow(i); //获取行 //拼接sql String sql = insert into +dataTable+(+str+) values(; for (short j = 0; j rsColumns; j++) { HSSFCell cell = row1.getCell(j); simNumber = cell.getStringCellValue(); if(j==rsColumns-1){ sql += + simNumber+ ; }else{ sql +=+ simNumber+,; } } sql += ); jdbc.executeUpdate(sql);//执行sql //查看拼的sql System.out.println(第+(i+1)+行+sql); } jdbc.closeStmt();