Access数据库连接出错处理办法

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"));?

????}?

}