java ¶ÁÈ¡excel Îļþ

2010-03-18
package javaEcsl;
import java.io.*;
import java.util.*;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
/** */
/**
* <p>
* Title:
* </p>
* <div>Description: ExcelÊý¾Ýµ¼Èëµ½oracleÊý¾Ý¿âÀà. </div>
* <p>
* Copyright: Copyright (c) 2004
* </p>
* <p>
* Company: Ò×ͨ¼¼ÊõÓÐÏÞ¹«Ë¾
* </p>
*
* @author Allen
* @version 1.0
*/
public class ExcelImportOracle {
/** */
/**
* ÓÃÓÚ·µ»ØÈýάÊý×éµÄArrayList.
*/
private static ArrayList subdata = new ArrayList();
/** */
/**
* ExcelÖеıíÃû.
*/
private static String tablename;
/** */
/**
* ÎļþµÄ·¾¶
*/
private static String filePath;
/** */
/**
* ¸Ã·½·¨ÎªÍê³É¶ÁÈ¡ExcelÖеÄÊý¾Ý²¢½«Êý¾Ý²åÈëµ½¶ÔÓ¦µÄÊý¾Ý¿â±íÖеIJÙ×÷(ÔÚµ÷ÓÃÇ°ÐèÒªÏȵ÷Óà setFilePath(String)Õâ¸ö·½·¨.).
*
* @author Administrator
* @param data:¶ÁÈ¡ExcelÖеÄÊý¾ÝµÄÊý×é.
* @dedivcated:½«¶ÁÈ¡ExcelÖеÄÊý¾Ý²åÈëµ½¶ÔÓ¦µÄÊý¾Ý¿â±íÖÐ. *
*/
public static void ExcelDataImportOracle(String filePath) throws Exception {
try {
ArrayList al = readExcel(filePath);
InsertData(al);
} catch (Exception e) {
e.printStackTrace();
}
}
/** */
/**
* ¶ÁÈ¡ExcelÖеÄÊý¾Ý.½«ÕâЩÊý¾Ý·ÅÈëµ½Ò»¸öÈýάÊý×éÖÐ.
*
* @author Administrator
* @param filePath
* Îļþ·¾¶.
* @dedivcated:¶ÁÈ¡ExcelÖеÄÊý¾Ý½«Ëü·ÅÈëµ½ArrayListÊý×éÖÐ(´ËΪÈýάÊý×é).
*/
public static ArrayList readExcel(String filePath) {
try {
subdata.clear();// ½«¾²Ì¬ArrayListÊý×éÇå¿Õ.(Èç¹û²»Çå¿ÕÔ­Êý¾Ý»á²»¶ÏÀÛ¼Ó)
InputStream is = new FileInputStream(filePath);
Workbook rwb = Workbook.getWorkbook(is);
// Sheet st = rwb.getSheet(0);//ÕâÀïÓÐÁ½ÖÖ·½·¨»ñÈ¡sheet±í,1ΪÃû×Ö£¬¶øΪϱ꣬´Ó0¿ªÊ¼
// Sheet st = rwb.getSheet("Book1");// ExcelÖеÚÒ»Ò³µÄÒ³Ãû³Æ.
Sheet st[] = rwb.getSheets();// µÃµ½ËùÓÐExcelÖÐÒ³µÄÁбí.
for (int a = 0; a < st.length; a++) {
ArrayList alList = new ArrayList();
ArrayList tablenames = new