java连接excel数据库_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();

}

}

}

}

Excel文件名为Test.xls;