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

package com.cjh.jxl; import java.io.File; import java.io.IOException; import jxl.Cell; import jxl.Sheet; import jxl.Workbook; import jxl.read.biff.BiffException; /** * excel数据导入到oracle * @author cjh * 2013-07-18 */ public class Test_jxl { public static void main(String[] args) throws Exception { Test_jxl in = new Test_jxl(); in.insert(F:/重复税号.xls,TEST_JXL); } /** * * @param path * 要解析的excel文件路径 * @param dataTable * 要写入到数据库中的表名 * @throws BiffException * @throws IOException */ public void insert(String path,String dataTable) throws BiffException, IOException { File file = new File(path); // 创建新的Excel 工作簿 Workbook rwb = null; rwb = Workbook.getWorkbook(file); // 得到工作簿中索引从0开始 Sheet sheet = rwb.getSheets()[0]; int rsColumns = sheet.getColumns();//总 列数 int rsRows = sheet.getRows();// 总行数 String simNumber = ;//每个单元格中的数据 DBconn jdbc=new DBconn(); String str=;//取excel中第一行得到要插入的列 for (int j = 0; j rsColumns; j++) { Cell cell = sheet.getCell(j, 0); simNumber = cell.getContents(); if(j==rsColumns-1){ str += simNumber ; }else{ str += simNumber+,; } } System.out.println(str); for (int i = 1; i rsRows; i++) { String sql = insert into +dataTable+(+str+) values(;//拼接sql for (int j = 0; j rsColumns; j++) { Cell cell = sheet.getCell(j, i); simNumber = cell.getContents(); if(j==rsColumns-1){ sql += + simNumber+ ; }else{ sql +=+ simNumber+,; } } sql += ); jdbc.executeUpdate(sql);//执行sql //输出sql System.out.println(第+(i+1)+行+sql); } jdbc.closeStmt(); jdbc.closeConnection(); } } ----------------------------连接数据库------------------------------- package com.cjh.jxl; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; /** * Oracle数据库连接 * * @author cjh */ public class