java 连接 Excel 数据库

/**
 * 
 */
package com.user.util;

import java.io.UnsupportedEncodingException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

/**
 * @author Li Shuchao
 * 2013-8-9 下午02:48:54 2013
 */
public class TestExcelConnection {
	private static String driverName = "sun.jdbc.odbc.JdbcOdbcDriver";
	 private static String dbURL = "jdbc:odbc:driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=D:\\importDemo.xlsx"; // 不设置数据源
	// private static String dbURL="jdbc:odbc:ExcelTest"; //数据源连接方式 DSN：ExcelTest

	 private static Connection dbConn = null;

	 /**
	  * @param args  importDemo.xlsx
	 * @throws UnsupportedEncodingException 
	  */
	 public static void main(String[] args) throws UnsupportedEncodingException
	 {

	  try
	  {
	   Class.forName(driverName);
	   dbConn = DriverManager.getConnection(dbURL, "", "");
	   Statement smt = dbConn.createStatement();
	   ResultSet set = smt.executeQuery("select * from [sheet1$]");
	  int i =0;
	   while (set.next())
	   {
		System.out.print(i + "\t") ; 
		String str1 = new String(set.getBytes(1),"gbk"); //set.getString(1);
		String str2 = new String(set.getBytes(2),"gbk");
		String str3 = new String(set.getBytes(3),"gbk");
		if (str1 != null){
			 System.out.print( str1 + "\t");//new String(str1.getBytes("ISO-8859-1") ,"gbk") + "\t") ; 
		}
	   
		if (str2 != null){
			 System.out.print( str2 + "\t") ; 
		}
		
		if (str3 != null){
			 System.out.println( str3 + "\t") ; 
		}

	    i ++;
	   }
	  } catch (ClassNotFoundException e)
	  {
	   e.printStackTrace();
	  } catch (SQLException e)
	  {
	   e.printStackTrace();
	  } finally
	  {
	   try
	   {
	    dbConn.close();
	   } catch (SQLException e)
	   {
	    e.printStackTrace();
	   }
	  }
	 }
}