Java连接Excel数据库示例

import java.sql.*;

public class ExcelConnectionTest
{
 private static String driverName = "sun.jdbc.odbc.JdbcOdbcDriver";
 private static String dbURL = "jdbc:odbc:driver={Microsoft Excel Driver (*.xls)};DBQ=D://Test.xls"; // 不设置数据源
// private static String dbURL="jdbc:odbc:ExcelTest"; //数据源连接方式 DSN：ExcelTest

 private static Connection dbConn = null;

 /**
  * @param args
  */
 public static void main(String[] args)
 {

  try
  {
   Class.forName(driverName);
   dbConn = DriverManager.getConnection(dbURL, "", "");
   Statement smt = dbConn.createStatement();
   ResultSet set = smt.executeQuery("select * from [sheet1$]");
   while (set.next())
   {
    System.out.print(set.getString(1) + "/t");
    System.out.print(set.getString(2) + "/t");
    System.out.println(set.getString(3));
   }
  } catch (ClassNotFoundException e)
  {
   e.printStackTrace();
  } catch (SQLException e)
  {
   e.printStackTrace();
  } finally
  {
   try
   {
    dbConn.close();
   } catch (SQLException e)
   {
    e.printStackTrace();
   }
  }

 }
}