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(); } } }}?