package test;

import java.io.File;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.ResultSetMetaData;

import java.sql.Statement;

import java.util.Properties;

public class Test {

        /**

     * TODO : 读取文件access

     * 

     * @param filePath

     * @return

     * @throws ClassNotFoundException

     */ 

    public static void readFileACCESS(File mdbFile) { 

        Properties prop = new Properties(); 

        prop.put("charSet", "gb2312"); // 这里是解决中文乱码 

        prop.put("user", ""); 

        prop.put("password", ""); 

        //String url = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=" + mdbFile.

        getAbsolutePath(); 

        String url = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ="+ mdbFile.

        getAbsolutePath(); 

        Statement stmt = null; 

        ResultSet rs = null; 

        String tableName = null; 

        try { 

            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 

            // 连接到mdb文件 

            Connection conn = DriverManager.getConnection(url, prop); 

            ResultSet tables = conn.getMetaData().getTables( 

                    mdbFile.getAbsolutePath(), null, null, 

                    new String[] { "TABLE" }); 

            // 获取第一个表名 

            if (tables.next()) { 

                tableName = tables.getString(3);// getXXX can only be used once 

            } else { 

                return; 

            } 

            stmt = (Statement) conn.createStatement(); 

            // 读取第一个表的内容 

            rs = stmt.executeQuery("select * from " + tableName); 

            ResultSetMetaData data = rs.getMetaData(); 

            while (rs.next()) { 

                for (int i = 1; i <= data.getColumnCount(); i++) { 

                    System.out.print(rs.getString(i) + "    "); 

                } 

                System.out.println(); 

            } 

        } catch (Exception e) { 

            e.printStackTrace(); 

        } 

    } 

  

    public static void main(String[] args) { 

        readFileACCESS(new File("C:\\Users\\Ninemax\\Desktop\\西太区医学索引.mdb")); 

    } 

}