用java串連access資料庫

     直接連資料庫的時候一定要注意Microsoft Access Driver (*.mdb)中Driver後面的空格，我今天調試的半天才發現這個問題，鬱悶至死~~~~~~~~~~
import java.sql.*;
public class DBConnection
{
public static void main(String args[])
{
try{
//String strurl="jdbc:odbc:driver={Microsoft Access Driver(*.mdb)};DBQ=db.mdb";
String strurl="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=db.mdb";
//String strurl ="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=db.mdb";//此為NO-DSN方式
//String strurl="jdbc:odbc:test";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
System.out.println("before connection");
Connection conn=DriverManager.getConnection(strurl);
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from test");
if(rs.next())
{
System.out.println(rs.getString("id"));
}
}catch(Exception e)
{
System.out.println(e);
}
}
}