//linkaccess.java:不配置ODBC數據源，用JDBC-ODBC橋連接Access數據庫
import java.sql.*;

class linkaccess{
	public static void main (String args[]) throws Exception{
		Connection    con;          
		Statement    stmt;          
		try{      
		       //Load  JDBC  driver  
		       Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");      
		       //注意DBQ的寫法      
		       String url    =    "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=C:\\jdk1.3.1\\javaprograms\\jdbc.mdb"; 
		       con    =    DriverManager.getConnection(url,"sa",""); 
		       stmt    =    con.createStatement();          
		       String    query    =    "select * from userInfo where name = 'bi'";          
		       ResultSet    rs    =    stmt.executeQuery(query);      
		       while    (    rs.next()    )      
		       {    
		       	System.out.print("connecting is ok" );      
		       }    
		       //close db
		      try{ 
			if(!con.isClosed())
			con.close();
		       }catch(SQLException err){
			System.err.println(err.toString());
		       }  
		}      
		catch(    Exception    e    ){      
		       e.printStackTrace();  
		} 
	}   
}