使用Java访问Access数据库一般使用JDBC-ODBC桥驱动,驱动是JDK自带的驱动,不用下载即可使用。
(1)、代码如下。
import java.sql.*;
import java.io.*;
class Access{
public static void main(String[] args){
String url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=D://test.mdb";
Connection conn = null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection(url , "" , "");
Statement statement=conn.createStatement();
ResultSet rs=statement.executeQuery("select * from TAttachment");
while(rs.next()){
System.out.println(rs.getString(1));
}
}catch(Exception e){
e.printStackTrace();
}finally{
try{
if(conn!=null)
conn.close();
}catch(Exception e){
e.printStackTrace();
}
}
}//end of main
}
import java.io.*;
class Access{
public static void main(String[] args){
String url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=D://test.mdb";
Connection conn = null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection(url , "" , "");
Statement statement=conn.createStatement();
ResultSet rs=statement.executeQuery("select * from TAttachment");
while(rs.next()){
System.out.println(rs.getString(1));
}
}catch(Exception e){
e.printStackTrace();
}finally{
try{
if(conn!=null)
conn.close();
}catch(Exception e){
e.printStackTrace();
}
}
}//end of main
}