import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
public class ConnAccess {
public static void main(String[] args) {
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
List idList = null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(Exception e){
e.printStackTrace();
}
try{
idList = new ArrayList();
String ur1="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=aaaa.mdb";
conn = DriverManager.getConnection(ur1);
ps= conn.prepareStatement("select * from user");
rs = ps.executeQuery();
while(rs.next()){
String id = (String)rs.getString("id");
System.out.println("--------:"+id);
}
}catch(Exception e){
e.printStackTrace();
}finally{
try{
if(null != rs){
rs.close();
}
if(null != ps){
ps.close();
}
if(null != conn){
conn.close();
}
}catch(Exception e){
e.printStackTrace();
}
}
}
}