java连接Access

 

1. public   static   void  jAccess(){  
2.         String url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=*数据库路径（相对/绝对）*" ;  
3.         try {  
4.             Class.forName("sun.jdbc.odbc.JdbcOdbcDriver" );  
5.             Connection conn = DriverManager.getConnection(url);  
6.               
7.             Statement st=conn.createStatement();  
8.             ResultSet rs=st.executeQuery("sql语句" );  
9.             while (rs.next()){  
10.                 String str=rs.getString(1 ); 
    
11.                 ………………
    
12.                 System.out.println(str);  
13.             }  
14.         }catch (Exception e){  
15.             e.printStackTrace();  
16.         } 
17.     }